Active Record & Bind Variables

[eluser]Relexx[/eluser]
Does Active record use bind variables, or does it generate full text sql every time?

[eluser]TheFuzzy0ne[/eluser]
The SQL is generated dynamically, otherwise there would be empty WHERE/LIKE/JOIN (etc) clauses, which would cause a database error.

[eluser]Relexx[/eluser]
yes but is it generated as

Code:

select * from emp where emp_id = ?

then ? passed in at execution time or

Code:

select * from emp where emp_id = 1

[eluser]Colin Williams[/eluser]
Not sure all database drivers support bind variables. You could probably build bind variable queries with AR, but it's not going to do it automatically.