Subject | Re: [Firebird-Java] RE: Exception in preparestatement |
---|---|
Author | Luca Lafranchi |
Post date | 2004-03-31T09:41:44Z |
Hi :)
"where aspect_num between ? and ?"
doesn't sound like a right syntax to me.
Try
"where aspect_num>=? and aspect_num<=?"
Ciao
Luca
>I may be wrong, but
> String sql = "Select distinct(universal_id), max(descr) descr from
> aspect where aspect_num between ? and ? and secondary_only=0 group by
> universal_id order by descr";
>
"where aspect_num between ? and ?"
doesn't sound like a right syntax to me.
Try
"where aspect_num>=? and aspect_num<=?"
Ciao
Luca