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
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:
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
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-
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,
5 matches
Mail list logo