You could simply try the following modification:

WHERE cmtclaim =: claimn and
timestamp(cmtdate,cmttime) <= timestamp(:datein, :timein)

It seems that the statement isn't being parsed correctly--i.e., you have
no parameter markers so EGL/JDBC (or whatever driver you're using) is
parsing the statement incorrectly. Try inserting a space before the
second host variable. Either that or your solution of defining your own
timestamp variable and using it in place of the two host variables.

Just a thought.

egl-i-bounces@xxxxxxxxxxxx wrote on 03/13/2009 01:00:03 PM:

date: Thu, 12 Mar 2009 19:21:12 -0400
from: "tim" <tim2006@xxxxxxxxxxx>
subject: [EGL-i] sql help

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


WHERE cmtclaim =: claimn and

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


Im getting message:

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

any suggestions?

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].