Help! Inserting Date Data Types

[Jonid]

How Do i insert Date Data into Sql Server DB Using ADO objects???
i tried this but it didnt work

sql = "insert into table(datetimefield) values("
sql = sql & "'" & datevariable & "')"

cnn.execute sql
-----------------------------------------

error message i get is :
error converting datetime from char string

i tired useing now() function instead of datavariable for testing but i get the same message

any ideas???

 

[dcusick]

Try putting the variable in #'s, instead of an apostrophe.
sql = sql & "#" & datevariable & "#)"

This should work... Good luck.

Doug

 

[Jonid]

i get an error when i use #datevar#

im using this code in a VB Component not asp. there might be some diffs.

 

[GlennBSI]

Sounds like your datetime variable isn't really one.

Try this:

sql = "insert into table(datetimefield) values("
sql = sql & "'" & CDate(datevariable) & "')"

Note also that "#" delimeters are for Access databases whereas "'" (single quotes, like you have it) are used for SQL Server

 

[Jonid]

It Doesnt Seem To Work
any ways it works if i use command object and then assign date.

here is a sample


dim cm as new adodb.command
cm.commandtext = "insert into table values(?)"
cm.refresh
cm(0) = datevariable
cm.execute