RE: parameter issues in DBD:Oracle
[email protected] ("Bobak, Mark")
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
One solution is here: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425 -----Original Message----- From: Bruce Johnson [mailto:[email protected]] Sent: Friday, March 26, 2010 2:13 PM Cc: dbi Mailing List Subject: Re: parameter issues in DBD:Oracle 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