Subject Re: [Firebird-Java] RE: Exception in preparestatement
Author Luca Lafranchi
Hi :)

>
> 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";
>


I may be wrong, but
"where aspect_num between ? and ?"
doesn't sound like a right syntax to me.
Try
"where aspect_num>=? and aspect_num<=?"

Ciao
Luca