OK, scratch my last this indeed has changed... http://search.cpan.org/~timb/DBI-1.616/DBI.pm#finish
Carl Furst o/~ What a difference a byte makes... o/~ -----Original Message----- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Friday, February 18, 2011 3:07 PM Cc: DBI Users List (dbi-users@perl.org) Subject: Re: One of us can't count.... No, this is done as: $csr=$dbh->prepare($sql) then as $csr->execute(@parms) inside of a loop. On Feb 18, 2011, at 12:33 PM, Bill Ward wrote: > You're probably calling do($sql, @args) when you should call do($sql, undef, > @args) > > On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson < > john...@pharmacy.arizona.edu> wrote: > >> I'm getting the following error: (some data has been change to protect the >> bystanders.) >> >> DBD::Oracle::st execute failed: called with 18 bind variables when 19 are >> needed [for Statement "insert into edsbase >> (cn,emplId,employeeType,employeeTitle,employeeStatus,employeeTotalAnnualRate ,sn,givenName,netid,mail,employeeBldgName,employeeBldgNum,employeeCity,emplo yeeFTE,employeePhone,employeePoBox,employeeRoomNum,employeeState,employeeZip ) >> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) >> " with ParamValues: :p1='Werner S Noname', :p10='some@here', :p11='COLL OF >> PHARMAC', :p12='00207', :p13='TUCSON', :p14='0', :p15='5205114411', :p16='PO >> BOX 210207', :p17='344', :p18='AZ', :p19='85721-0207', :p2='111111111', >> :p3='N', :p4='nosal', :p5='A', :p6='0', :p7='Zimmt', :p8='Werner S', >> :p9='wsz'] at ./edsload.pl line 97, <DATA> line 532. >> >> I've counted three times: I have 19 fields in the db, 19 '?'s, and 19 param >> values being passed, why am I getting this error? >> >> >> >> -- >> Bruce Johnson >> University of Arizona >> College of Pharmacy >> Information Technology Group >> >> Institutions do not have opinions, merely customs >> >> >> > > > -- > Check out my LEGO blog at http://www.brickpile.com/ > View my photos at http://flickr.com/photos/billward/ > Follow me at http://twitter.com/williamward -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
smime.p7s
Description: S/MIME cryptographic signature
********************************************************** MLB.com: Where Baseball is Always On