pstmt.setString(colidx++ , availablity);
pstmt.setString(colidx++ , availablity);
In order to bind every column even if the value is the same. Seems to me like it's normal behavior, but like I said, I'm new to OJB and am not 100% sure of it.
R
On Monday, January 27, 2003, at 04:46 PM, Goncalo Luiz wrote:
Hi.
I've been using OJB for a while and I got to the following error:
if you have an OQL query like:
query = "select form article where id=$1 and color=$2 and avaliable = $3 and
otherProperty =$3"
and then you bind your variables like:
query.bind (id);
query.bind (color);
query.bind (avaliability);
you get a runtime error.
I was expecting that the Java variable "avaliability" was binded to $3 and
used on both conditions.
The solution is : bind the variable "avaliability" twice.
Is this a known issue ?
Regards,
Goncalo Luiz. IST. Portugal.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>