On Fri, 26 Mar 2010 14:32:52 -0400, Bobak, Mark wrote:
>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.
There's a special feature in DBIx::Simple to tackle this exact case.
Lo
On 2010-03-26 11:13:14 -0700, Bruce Johnson wrote:
> On Mar 26, 2010, at 11:01 AM, Bruce Johnson wrote:
>> Does the DBD enclose all parameters in ''s?
Not really. It passes the parameters separately from the query.
>> Am I actually trying to execute:
>>
>> select reserved_id, reserver, purpose,
One solution is here:
http://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:210612357425
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, March 26, 2010 2:13 PM
Cc: dbi Mailing List
Subject: Re: parameter issues in DBD:Oracle
On Mar
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 answ
You cannot pack a comma separated list into a single ?, because they
will be wrapped together in one set of quotes.
Use multiple ? in your 'in()' clause, and send each item individually
into execute().
allan
On Fri, Mar 26, 2010 at 2:01 PM, Bruce Johnson
wrote:
> I'm trying the following:
>
> $s