Gossamer Forum
Home : General : Perl Programming :

execute failed: Unknown column

Quote Reply
execute failed: Unknown column
I have tried umpteen versions of the script below and always get moroless the same error message can any one tell me which direction I should look for the mistake before the variable it sends in the message or after the end of the code it sends back oris it the actual piece of code shown in the message. Whatever I can not get it to work and would love some help please. The line 17 always comes up and is always $query->finish(); which makes sense when it cannot do it!

[Wed Jan 07 13:05:08 2004] [error] [client 127.0.0.1] Premature end of script headers: Guide_delete.pl
[Wed Jan 07 13:05:08 2004] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Unknown column 'Guide.CD00304' in 'where clause' at C:/Program Files/Apache Group/Apache2/cgi-bin/Guide_delete.pl line 15.
[Wed Jan 07 13:05:08 2004] [error] [client 127.0.0.1] Can't call method "disconnect" on an undefined value at C:/Program Files/Apache Group/Apache2/cgi-bin/Guide_delete.pl line 17.

#!c:\perl\bin\perl.exe
use CGI ":standard";
@fieldname = ("Code","Name","Family");
$table ="Guide";
$Code=param("Code");
$Name=param("Name");
$Family=param("Family");
open (OUTFILE, ">>Guide_delete.txt")or die "could not open Guide_delete.txt for writing\n";
print OUTFILE "$Code $Name $Family \n";
close (OUTFILE);
use DBI;
$DBH= DBI->connect("DBI:mysql:Guide")or die "\n ($DBI::err) : $DBI::errstr\n";
my $query = $DBH ->prepare(qq{delete from Guide where Guide.Code like Guide.$Code
});
$query->execute();
$query->finish();
$DBI->disconnect();

#!c:\perl\bin\perl.exe
use CGI ":standard";
@fieldname = ("Code","Name","Family");
$table ="Guide";
$Code=param("Code");
$Name=param("Name");
$Family=param("Family");
open (OUTFILE, ">>Guide_delete.txt")or die "could not open Guide_delete.txt for writing\n";
print OUTFILE "$Code $Name $Family \n";
close (OUTFILE);
use DBI;
$DBH= DBI->connect("DBI:mysql:Guide")or die "\n ($DBI::err) : $DBI::errstr\n";
my $query = $DBH ->prepare(qq{delete from Guide where Guide.Code like $Code AND Guide.Name like $Name AND Guide.Family like $Family
});
$query->execute();
$query->finish();
$DBI->disconnect();
Subject Author Views Date
Thread execute failed: Unknown column Silver Machine 12632 Jan 7, 2004, 5:42 AM
Thread Re: [Silver Machine] execute failed: Unknown column
Chaz 12419 Jan 7, 2004, 11:25 AM
Thread Re: [Chaz] execute failed: Unknown column
Silver Machine 12424 Jan 8, 2004, 5:37 AM
Post Re: [Silver Machine] execute failed: Unknown column
Silver Machine 12408 Jan 8, 2004, 10:38 AM