|
Posted by Richard Morton on 12/19/05 17:46
Hi,
I am struggling to get data out of Access via ODBC.
It's a really simple db (single table).
When I do a really simple query (select * from table)
odbc_prepare
odbc_execute
I can then get out the field names via
odbc_field_names
but I can't get to any _data_....
num_rows returns -1
also if I try to add conditions to the query it fails i.e.
select * from table where TimeStamp>="2005/12/18 16:00:01" AND
TimeStamp<="2005/12/19 16:00:00" ORDER BY TableRowID desc
Warning: odbc_execute(): SQL error: [Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 3., SQL state 07001 in SQLExecute
in c:\apache group\apache\htdocs\wmmc\db_access_class.inc on line 60
Help please! Thanks!
Richard
Navigation:
[Reply to this message]
|