Where to write INSERT query in ASP?????

[star111792]

hi,
i have just started learning ASP. i m doing database connectivity in ASP. my problem is with the insert query.
i have a page "form.asp" for taking input from user. after entering data when user clicks the next button, page "display.asp" have to be displayed. i m using POST method with my form. now i m confused where to write the insert query??? either in form.asp or display.asp??? or there should be an intermediate page between these two pages that contains only the insert query???? i m really confused and want some help.
thanks

[jhardman]

I would definitely put it in display.asp (before writing any data to the web page). There is nothing logically wrong with putting it in a script between the two pages, and I've even done it successfully all on one page, but that involves a big if...else statement:

if request.form("name") = "" then
   'data hasn't been submitted, so show form
else
   'data has been submitted, so update db
   'afterwards do the display
end if

I guess it's kind of up to you, but I think the easiest is on display.asp

Jared

[star111792]

thanks a lot !!!!!!!!!!!!!

but one more question.....
i am using an autonumber field in my MS access databse as primary key. how can i add values in that field using ASP. if i m not giving any value for that field, it is giving an error message.

[jhardman]

thanks a lot !!!!!!!!!!!!!

but one more question.....
i am using an autonumber field in my MS access databse as primary key. how can i add values in that field using ASP. if i m not giving any value for that field, it is giving an error message.

hmm. That's odd. I thought if you used an autonumber you just had to ignore that field when updating. Let me give it a think.

I know I simulated an autonumber once by finding the highest number in the table then adding one.

Jared