Re: [libdbi-users] cannot get int from second table in a query

2008-07-02 Thread Markus Hoenicka
Daniel Moreno writes: > Markus, > I'm new using libdbi so we didn't talk before so I want to say good job > to you and all the people that made it possible. > Why thank you. A fair share of all praise should always go to David Parker and Mark Tobenkin who started the project with an exce

Re: [libdbi-users] cannot get int from second table in a query

2008-07-02 Thread Daniel Moreno
Markus, I'm new using libdbi so we didn't talk before so I want to say good job to you and all the people that made it possible. Thanks. Daniel.- On Wed, Jul 2, 2008 at 9:56 AM, Markus Hoenicka < [EMAIL PROTECTED]> wrote: > Quoting Daniel Moreno <[EMAIL PROTECTED]>: > > > Markus, > >

Re: [libdbi-users] cannot get int from second table in a query

2008-07-02 Thread Markus Hoenicka
Quoting Daniel Moreno <[EMAIL PROTECTED]>: > Markus, > We could add queries like these to the tests or if is a known issue > should be documented that didn't work with sqlite3 driver. > I absolutely agree. I have always tried in the past to use bug reports as an excuse to add yet another t

Re: [libdbi-users] cannot get int from second table in a query

2008-07-02 Thread Daniel Moreno
Markus, We could add queries like these to the tests or if is a known issue should be documented that didn't work with sqlite3 driver. Daniel.- On Wed, Jul 2, 2008 at 6:04 AM, Markus Hoenicka < [EMAIL PROTECTED]> wrote: > Quoting Kris <[EMAIL PROTECTED]>: > > > I am currently trying to fix

Re: [libdbi-users] cannot get int from second table in a query

2008-07-02 Thread Markus Hoenicka
Quoting Kris <[EMAIL PROTECTED]>: > I am currently trying to fix the find_result_field_types function so > that it can work with aliases as well as multiple table selects without > the table prefix (e.g. select * from one,two). I'll see if I can use > anything from daniels "dirty patch" on the cv

Re: [libdbi-users] cannot get int from second table in a query

2008-07-01 Thread Daniel Moreno
Hi all, I was trying to find out why occur this error and I agree that is a problem with sqlite3 driver trying too guess the field types. I found the following problems: 1) the first example fails because while searching fieldname "a" match the a in "tableone" and not the fieldname. Trying t

[libdbi-users] cannot get int from second table in a query

2008-07-01 Thread Markus Hoenicka
Kris Groves writes: > Hi List, > > I'm seeing strange behavior here : > > This is a sqlite/sqlite3 driver problem, not a generic libdbi problem. The sqlite driver has to guess the column types from the "CREATE TABLE" statement that was used to build the tables involved in a query. The reas

Re: [libdbi-users] cannot get int from second table in a query

2008-07-01 Thread Kris Groves
Furthermore, if i do a select on a single table with an alias, such as : "select a as aaa from one" the fieldtype of aaa is string and get_int returns 0... -- Kris Groves Project Manager / Software Engineer mm-lab GmbH Phone: +49 7154 827 323 Stammhei

[libdbi-users] cannot get int from second table in a query

2008-07-01 Thread Kris Groves
Hi List, I'm seeing strange behavior here : I create a database with 2 tables each with two fields. These fields are INT. I run a select * on the first table, and use dbi_result_get_int to retreive the values, and dbi_result_get_field_type to see the field types... no problem, everything is