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