Re: [libdbi-devel] dbi_result_get_int_idx

[Holger H. <oz...@me...>]

Am Freitag, den 15.04.2011, 20:51 +0200 schrieb Holger Hetterich:
> Hi all,
> 
> I am using the pgsql driver, and run a query for a field "length" in a
> table called "read". Field 'length' has been declared as "integer" in
> postgresql.
> 
> This is what I run through libdbi:
> "select SUM(length) of read;"
> 

sorry that is "select SUM(length) FROM read;

> I suppose the result will be integer also. So I do:
> dbi_result_get_field_type_idx(data,1);
> and the result is 1. AFAIK that's integer.
> 
> Now I do:
> int rr;
> rr = dbi_result_get_int_idx(data,1);
> 
> and it'll be 0. Which is wrong of course.
> 
> Calling the same query on postgresql's console is some 200.000 bytes.
> 
> Calling the dbi error function after this call gives:
> "-7: The requested variable type does not match what libdbi thinks it
> should be"
> 
> If I read strings through libdbi, all is fine, so I am wondering what is
> wrong here.
> 
> Holger
> 
> 
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload 
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve 
> application availability and disaster protection. Learn more about boosting 
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> libdbi-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libdbi-devel