Use Sysdate for oracle not datepart if I remember datepart is mssql.
-----Original Message-----
From: Francis, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 4:59 PM
To: CF-Talk
Subject: Datepart question
I have the following query:
<cfquery name="callist" datasource="ncc" blockfactor="50">
select id, priority, category, projectname, developer, description,
comments, estcompdate
from devproject
where estcompdate neq 'none'
AND status is null
OR status='none'
and datepart(mm, estcompdate)='#month#'
union
select id, newicon, updicon, projectname, developer, projectdescription,
status, comments
from calendar
where status='Closed'
and impact <> 'No'
and developer in (select lastname from tbldevlogon where mgr='K')
and datepart(mm, lastupdate)='#month#'
</cfquery>
It worked just fine until I added the "datepart" section. Now it's
returning :
Oracle Error Code = 920
ORA-00920: invalid relational operator
Am I missing something? Please help!!!
TIA,
Jennifer Francis
AT&T Wireless
Training Development & Design
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists