help inserting current date into db

[PushCode]

I'm trying to insert the current date into the db with the following code, but it's showing up as 1/1/1900 in the db.

I know I can just set the default value in the db to today's date, but I need to do this with CF.

Anyone see what I'm doing wrong?

<cfset today = DateFormat(Now(),&quot;mm/dd/yy&quot>

<cfquery name=&quot;insert&quot; datasource=&quot;#ds#&quot;>
INSERT INTO sri_contact(blah1, blah2, date_sent)
VALUES(#blah1#, #blah2#, #today#)
</cfquery>

 

[stevebooth]

We need to know what database you're using in order to reply appropriately...

 

[ecobb]

Since you said that it's showing up as &quot;1/1/1900&quot;, I assume that you're using SQL Server. That's what it defaults to for dates if one is not supplied.

If you are using SQL Server, try using <cfqueryparam> when you pass the date:

<cfquery name=&quot;insert&quot; datasource=&quot;#ds#&quot;>
  INSERT INTO sri_contact(blah1, blah2, date_sent)
  VALUES(#blah1#, #blah2#, <cfqueryparam value=&quot;#today#&quot; cfsqltype=&quot;CF_SQL_DATE>
</cfquery>

Hope This Helps!

Ecobb

&quot;My work is a game, a very serious game.&quot; - M.C. Escher

 

[PushCode]

It is SQL SERVER 2000

Turns out, surrounding the #today# variable in single quotes solves the problem.

Insert...
Values(..., '#today#')

Thanks for the help anyway.