Basic SQL database question

[David Bovill]

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.