Always, always, always use <CFQUERYPARAM>. Especially when passing Date types to Oracle. It will make your code more secure, and your life easier.
<cfqueryparam value="#MonthStart#" cf_sql_type="cf_sql_date"> Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 11:01 AM To: CF-Newbie Subject: RE: HELP (ASAP!!) When I use the following in query: WHERE dateJoined BETWEEN #DateFormat(MonthStart,"mm/dd/yyyy")# AND #DateFormat(MonthEnd,"mm/dd/yyyy")# I get the following error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected DATE got NUMBER >Shouldn't have to remove the timestamp- DateFormat() will take a >Datetime object. What's the error, and are you receiving the error with >the code as written, or when you pass a different datetime object than >the Now() function? > >Matt Osbun >Web Developer >Health Systems, International > > >-----Original Message----- >From: Torrent Girl [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 19, 2005 9:49 AM >To: CF-Newbie >Subject: RE: HELP (ASAP!!) > > >THANKS! that worked > > >How do I remove the time stamp? > >I get an error when i add dateformat. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation & Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
