displaying the date

[isaac2004]

hello i am creating a dynamic page with database access that acts as an
online store. i have a sql statement that needs the date and time of
the order to send an invoice to a user.

here is my code to insert the new values into the database

strInsertSQL = "INSERT INTO tblOrders (strEmail, ISBN, dtOrderDate) " &
_
"VALUES ('" & strEmail & "', '" & strISBN & "', ?
'")"


i dont know what value to input where the ? is thanks for the help

 

[lbolognini]

hello i am creating a dynamic page with database access that acts as an
online store. i have a sql statement that needs the date and time of
the order to send an invoice to a user.

In VBScript Now() could do the job, otherwise just tell the database to
put whatever function the db provides you to catch the current datetime
as the default value so you can keep it out of your sql statement.

Lorenzo