symbols around Variables for sql statement

[jasonhuibers]

Classic ASP
SQL Server 2008

Which symbols do I use around each data type for my variables:
Dates
Strings
Numbers

varCreateDate = now() this gives me 1900-01-01 in the db!!!

sql_insert = "insert into CCExpenseTable (CreateDate,CreatedBy) values (" & varCreateDate & ", '" & varCreatedBy & "')"

 

[ChrisHirst]

strings = ' (single quote)

numbers nothing

Why not use the NOW function of SQL Server for the time stamp?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum