Forum Moderators: open

Message Too Old, No Replies

ASP/SQL Statement Syntax Problem

         

Outtatheblue

4:52 pm on Dec 18, 2001 (gmt 0)



I'm a newbie ASP developer needing some help. Can you spot any ASP syntax problems with the following code?

sqlStatement="INSERT INTO ApplicationForm(date) VALUES ('" & frmDate & "')"

Set recordSet = connectionToDatabase.Execute(sqlStatement)

ralnikov

2:10 pm on Dec 19, 2001 (gmt 0)

10+ Year Member



datetime format may vary from system to system (locale, etc...)
i'm prefer the following format:
yyyy-mm-dd mm:hh:ss

e.g.

strDT = "2001-12-19 17:10"
Conn.Execute("INERT INTO .... VALUES('" & strDT & "')")

Outtatheblue

3:05 pm on Dec 19, 2001 (gmt 0)



Thanks!