Re: sql help

Joe,

I was looking as examples in the egl manual and it seems to put a colon
before the variable name. If I remove the " timestamp(cmtdate,cmttime) <=
timestamp(:datein,:timein)

" from the where clause it works fine.

hmmmm

-----Original Message-----
From: egl-i-bounces@xxxxxxxxxxxx [mailto:egl-i-bounces@xxxxxxxxxxxx] On
Behalf Of Joe Pluta
Sent: Thursday, March 12, 2009 8:50 PM
To: EGL on and around the IBM i
Subject: Re: [EGL-i] sql help

Too busy to do much else than a shot in the dark, Tim, but how about this:

WHERE cmtclaim =: claimn and

Is it really supposed to be =:? Or is it this:

WHERE cmtclaim = :claimn and


Joe

Im trying to do the following, but it doesn't seem to like it



get comment with #sql{

select cmtclaim, cmtdate, cmttime, cmtcomm, cmtuser, cmtprior, cmttype

from NTFILES.CLMNOTESL2

WHERE cmtclaim =: claimn and

timestamp(cmtdate,cmttime) <= timestamp(:datein,:timein)

};



Im getting message:



java.rmi.RemoteException: EGL0504E GET: [SQL0418] Use of parameter marker
not valid.[sqlstate:42610][sqlcode:-418]





any suggestions?