Subject | Re: [Firebird-Java] RE: Exception in preparestatement |
---|---|
Author | Niki Ivanchev |
Post date | 2004-03-31T10:01:54Z |
Luca is right, the error is
arithmetic exception, numeric overflow, or string truncation
Luca Lafranchi wrote:
arithmetic exception, numeric overflow, or string truncation
Luca Lafranchi wrote:
>Hi :)[Non-text portions of this message have been removed]
>
>
>
>>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
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>