[wajeeh_r]

hello all members!


i have a form in which client is required to input general info. name, e-mail etc. now what i want is to insert the date and time in the memberInfo table can some one write here the insert query for this. DB is in MS Access

there is a name, email, date, time column in the memberInfo table on the form i'm just taking the I/P of name and email so what will be the insert query


strSQL= "INSERT INTO tblComments(Name, Comments) VALUES ('"&request.form("name")&"', '"&request.form("email")&"')"

what to add for date and time


waiting for replies...............

[pezdspncr]

well.... the function "date" will give you the current system date and the function "time" will give you the current system time.

So it should look like the following..
strSQL= "INSERT INTO tblComments(Name, Comments, date, time) VALUES ('"&request.form("name")&"', '"&request.form("email")&"', '"&date&"', '"&time&"')"