Originally posted by Sainudheen Mydeen:
Hi
Just for a discussion
Will this work? Is this a good approach? Please correct me.
----------------
Sainudheen
Originally posted by Ravi Tiruvaipati:
Gregg,
The getFetchSize() did return 1 even when there are no records for the query. Anyway I used count(*) to get the count and it works fine.
thanks
ravi
Originally posted by Ravi Tiruvaipati:
Gregg,
I already tried rs.next() as mentioned in the code, but suprisingly rs.next() return true even when there are no records for the sql. I couldn't get around it and I had left with only choice of count(*).
thanks for suggestions.
regards
ravi
Consider Paul's rocket mass heater. |