[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] From-Thru Dates

Try quote marks around your date

Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352
(The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. If you 
are not the intended recipient of this message you are hereby notified that any 
use, review, retransmission, dissemination, distribution, reproduction or any 
action taken in reliance upon this message is prohibited. If you received this 
in error, please contact the sender and delete the material from any computer. 
Any views expressed in this message are those of the individual sender and may 
not necessarily reflect the views of the company.)



-----Original Message-----
From: sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org
[mailto:sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org]On Behalf Of
radhika reddy
Sent: Friday, September 10, 2004 10:57 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] From-Thru Dates


Thanks but i am getting the following error:-


SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 2:
   ORA-00904: "SEP": invalid identifier


In the select statement:

j.action_dt between 05-SEP-1988 and
      10-SEP-2004 ORDER BY J.EMPLID

Error on line 240:
   (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.


why is it so? do i have to change the format of j.action_dt. but it's 
working fine when i am giving the expression itself as j.action_dt between 
{Datein-Prefix}$FromDate{Datein-Suffix} and 
{Datein-Prefix}$ThruDate{Datein-Suffix}. but i am getting this error when i 
am using dyanamic variable.

Thanks,
Radhika

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users