I am not seeing all of your code, however one thing that I am finding out
with Oracle and CF is that it likes you to use the DateFormat function.
I have been using '#DateFormat(endDate,"dd-mmm-yy")#' as such:
Select * from tblMei where ship_date > '#DateFormat(endDate,"dd-mmm-yy")#';
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:58 PM
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
