I have the following code
$cat1;
if ($cat1){
my $cat1="%$category%";
}
else {
$cat1="$category";
}
$row=$dbh->prepare("SELECT contact_id,first_name,last_name,organisation
FROM tb_contacts WHERE (organisation ILIKE ? OR last_name ILIKE ?) OR
contact_id = ?");
$cat1;
print $cat1;
$row->bind_param(1,$cat1);
$row->bind_param(2,$cat1);
$row->bind_param(3,$cat1);
$row->execute();
this fails with
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"ford" at /home/www/cgi-bin/con_role_add_sel2_org.pl line 33., referer:
http://localhost/cgi-bin/con_role_add_sel1.pl
It only fails if I have both the name and int WHERE Criteria - in psql
it works fine
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
