On Thursday, March 29, 2012 at 04:46:35 PM, Bruce Johnson wrote:
> Can't mix placeholder styles (:foo/?) at /usr/local/lib64/perl5/DBD/Oracle.pm
> line 329., referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
>
> I thought this is the code fragment producing this error:
>
[snip]
>
> Also, the line number in the error is from Oracle.pm, how do I find out what
> line in my program caused this?
>
DBI->trace(9) is your friend for all things debugging.
Is this new code or something that is acting differently?
Also, you might save a little typing by passing {RaiseError=>1} to connect :-)
I just looked at the code again, and I suspect that :1...:n is being
translated into '?' placeholders internally, which would give you the mixed
placeholders :1 :2 :name.
-r
