database question

[rogerholmes]

is there a limit on Qt's mysql driver as to how many columns it will work with or is there ANY limit on the mysql driver ?

this syntax returns -1
QSqlQuery query("SELECT * FROM artistdates" );


this syntax returns correct
QSqlQuery query("SELECT * FROM users" );

these tables are in the SAME database.

i copy the select statements to mysql browser and both work as expected. the only thing i can think of is column count (artistdates has 92 cols, 8500 records) .

this syntax returns correctly !!!
QSqlQuery query("SELECT startdate, code, city FROM artistdates" );:crying:





:confused:

[rogerholmes]

I found it ....

IT is Decimal fields. !!! apparently the driver cant work with them is this possible??