RE: cfqueryparam and dates

2003-03-19 Thread Matthew Walker
How about cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDateTime(f_date)# ? -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 March 2003 1:31 p.m. To: CF-Talk Subject: cfqueryparam and dates Any idea why this line of code would work: dateCreated

Re: cfqueryparam and dates

2003-03-19 Thread Cedric Villat
I've tried that as well as with the sqltype with CF_SQL_TIMESTAMP and wrap it in CreateODBCDateTime. Any other ideas? This seems to happen on CF5 but not with CFMX. Cedric How about cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDateTime(f_date)# ? -Original Message- From:

RE: CFQUERYPARAM and dates

2002-03-15 Thread Conrad Classen
Check the cfsqltype value you are using (CF_SQL_TIMESTAMP rather than CF_SQL_DATE) cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#CreateODBCDate(Now())#/ Is is not better to just use the SQL getdate() function instead? (You are wanting the current Date/Time) i.e. UPDATE dbo.tblXYZ SET

RE: CFQUERYPARAM and dates

2002-03-14 Thread Garza, Jeff
Try using cfsqltype=CF_SQL_TIMESTAMP with a value of CreateODBCDate(now()). This should work properly. Doesn't make much sense does it? G HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message-

RE: CFQUERYPARAM and dates

2002-03-14 Thread Ramin Surya
Bryan, I use cf_sql_varchar most of the time and always works. here is a great article on cfqueryparam. Also works for sql server http://www.macromedia.com/v1/handlers/index.cfm?id=17324method=full -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday,