Example query:

SELECT id,ISNULL(data) FROM....
or
SELECT id,data IS NULL FROM....
or
SELECT id,CASE WHEN data IS NULL THEN 0 ELSE 1 END AS is_data_null FROM....

dbi_result_get_int_idx(result,2);

Gives me an error:
-7: The requested variable type does not match what libdbi thinks it 
should be

I'm pretty sure the last two queries are ANSI SQL.

Any ideas how I can retrieve the result of those queries?



Vikram.



------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users

Reply via email to