Just been checking out odbc. The notion of simply being able to upload
an Access file seemed cool, but writing the queries is far from
straightforward . Firstly there is the reserved word problem. It
appears you can't have a field name called 'name'. Oh...that one kept
me busy for a while.
Then there is odbc_num_rows() . Returns the number of rows right? Nope,
returns -1 for a select query.
And finally, no LIMIT so you have to run a nested select statement to
get a range of results.
All of which made something very simple, rather complicated.
So, to my question. Are there any other quirks I should know about?
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
an Access file seemed cool, but writing the queries is far from
straightforward . Firstly there is the reserved word problem. It
appears you can't have a field name called 'name'. Oh...that one kept
me busy for a while.
Then there is odbc_num_rows() . Returns the number of rows right? Nope,
returns -1 for a select query.
And finally, no LIMIT so you have to run a nested select statement to
get a range of results.
All of which made something very simple, rather complicated.
So, to my question. Are there any other quirks I should know about?
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/