On Mar 29, 2012, at 1:58 PM, Bill Ward wrote:
> Try not using numbers for the placeholder names?
>
That worked...
my $sq_res_pend = "insert into reservations_pend (pid, email, cn, purpose,
reserver_affstring) values(:A,:B,:C,:D,:E) returning reservations_pend_id into
:NEWID";
my $csr_res_pend = $lda->prepare($sq_res_pend) or die $DBI::errstr;
$csr_res_pend->bind_param(':A',$res_pid) or die $DBI::errstr;
$csr_res_pend->bind_param(':B',$res_email) or die $DBI::errstr;
$csr_res_pend->bind_param(':C',$res_name) or die $DBI::errstr;
$csr_res_pend->bind_param(':D',$res_purp) or die $DBI::errstr;
$csr_res_pend->bind_param(':E',$res_affil) or die $DBI::errstr;
$csr_res_pend->bind_param_inout(":NEWID",\$new_res_id, 25) or die $DBI::errstr;
$csr_res_pend->execute();
Got right through.
Is this a bug or a rule I'm not aware of?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
