On 18 Jan 2006, at 00:01, Trevor DeVore wrote:
Whenever you see a :1 (or :2, :3) in a query it is using binding.
Take a look at the last parameter description in the docs for
revQueryDatabase and read the "Comments" section. I don't think
the docs refer to this as binding but that is one name for what
they are doing.
OK - will look at these more closely...
That is very possible. I haven't done any testing with PostGreSQL
so the the quoting of columns may not be correct. If you (or
anyone else wants to provide that info I can easily update the
library.
I have doen some more raw SQL using Trevor's library:
It seems that PostGreSql statements do not like quoted SQL values, so:
SELECT * FROM 'roles' WHERE id = '-1'
does not work, while
SELECT * FROM roles WHERE id = -1
does.
Hope this helps.
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
