On Mar 26, 2010, at 11:01 AM, Bruce Johnson wrote:
Does the DBD enclose all parameters in ''s?
Am I actually trying to execute:
select reserved_id, reserver, purpose, to_char(starttime, 'HH:MI'),
to_char(stoptime, 'HH:MI') from reservedroomtest where roomid in
('105, 106, 110')
To answer my own question, yes it does appear to be that way.
If I put the clause inline in the SQL (as 'in($rlist)' ) rather than
as a parameter (as 'in(?)' ), it works as expected (or at least it
does when I fix my most common datetime conversion error: "MM ==
Months, MI== Minutes, yah idjit Johnson!")
Is there a way to pass an unquoted list as a parameter? I can't do it
as 'in(?,?,?,?)' etc, because the number of list elements varies from
execution to execution.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
