Re: spammer on dbi-users

2010-03-26 Thread Wm Mussatto
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

RE: spammer on dbi-users

2010-03-26 Thread Will Rutherdale (rutherw)
> -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

RE: spammer on dbi-users

2010-03-26 Thread Wm Mussatto
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

parameter issues in DBD:Oracle

2010-03-26 Thread Bruce Johnson
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_

Re: parameter issues in DBD:Oracle

2010-03-26 Thread m. allan noah
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

Re: parameter issues in DBD:Oracle

2010-03-26 Thread Bruce Johnson
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

RE: parameter issues in DBD:Oracle

2010-03-26 Thread Bobak, Mark
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