when all else fails try putting single quotes around the var '#enddate#'
Or prior to using it in the query run the CreateODBCDate() function, just to
make sure it's in a format that is right. Otherwise it should work just
fine.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
The Coca-Cola name in China was first read as "Kekoukela", meaning "Bite the
wax tadpole" or "female horse stuffed with wax", depending on the dialect.
Coke then researched 40,000 characters to find a phonetic equivalent "kokou
kole", translating into "happiness in the mouth."
-----Original Message-----
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 10:58 AM
To: CF-Talk
Subject: DateAdd in CF and Date Field in Oracle...
Does anyone use DateAdd in ColdFusion before and tell me why I can not use
the return
value from DateAdd to compare with date field in a table?
My problem is:
----------------------------------------------------------------------------
<cfset endDate = DateAdd('d', 2, '#mon[1]#') >
and it does print out endDate as date, however,
when I use this return endDate to query a table with date type field, it
always
say Error Code 907 ( missing right parathise..),
Select * from tblMei where #endDate# < ship_date;
Thanks.
Mei
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
