Hi,
I was just testing a program I'm making that uses libdbi. My test was
with an sqlite database.
I came across the following problem:
When a query contains a newline (\n) instead of space on certain
positions dbi_result_get_field_type_idx always returns DBI_TYPE_STRING.
An example of such query:
"SELECT def.*\nFROM def\nLEFT JOIN def_derivation ON
def_derivation.child=def.id\nWHERE def_derivation.parent"
Avoiding newlines and using space instead works around the issue.
However, a newline in an SQL query should be treated as any other
whitespace and the behaviour should not be different.
Regards
Brecht Sanders
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users
