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
I'm trying the following:
$sqcollision = "select reserved_id, reserver, purpose,
to_char(starttime, 'HH:MI'), to_char(stoptime, 'HH:MI') from
reservedroomtest where roomid in (?) and ((to_date(?, 'MM/DD/
HH24:MM') <= starttime and to_date(?, 'MM/DD/ HH24:MM') >=
starttime) or (to_
On Fri, March 26, 2010 07:30, Will Rutherdale (rutherw) wrote:
>> -Original Message-
>> From: Wm Mussatto [mailto:mussa...@csz.com]
>> Sent: 26 March 2010 10:21
>> To: dbi-users@perl.org
>> Subject: Re: spammer on dbi-users
>>
>> It might be more effective if you wrote to the SEC. It is a
> -Original Message-
> From: Wm Mussatto [mailto:mussa...@csz.com]
> Sent: 26 March 2010 10:21
> To: dbi-users@perl.org
> Subject: Re: spammer on dbi-users
>
> It might be more effective if you wrote to the SEC. It is a form of
> security fraud after all at bottom.
SEC deals with securit
On Thu, March 25, 2010 12:24, Jared Still wrote:
> On Thu, Mar 25, 2010 at 11:21 AM, Darren Duncan
> wrote:
>
>> Another option is to moderate the list, maybe by putting all new
>> subscribers on moderation by default and then taking them off after
>> their
>> first post, or something. I seem to r