in reply to
Re: Maximum DBI query length?
in thread Maximum DBI query length?
Very well. Here's the code that prepares the query....
my $sthQuery = $dbh->prepare('SELECT contact.forename, contact.surname
+, business.occupation, acn.position, contact.city, contact.country AS
+ forename, surname, occupation, position, city, country WHERE cont
+act.ruid=business.ruid AND contact.ruid=acn.ruid AND forename LIKE ?
+AND surname LIKE ? AND occupation LIKE ? AND position LIKE ? AND city
+ LIKE ? AND country LIKE ?')
or die "Couldn't prepare query: " . $dbh->errstr;
And here's the page (it's a CGI script) that makes me think it's being chopped off...
Couldn't execute query: You have an error in your SQL syntax near 'WHE
+RE contact.ruid=business.ruid AND contact.ruid=acn.ruid AND forename
+LIKE 'jo' at line 1 at /home/httpd/cgi-bin/basicsearch.cgi line 71.
For help, please send mail to the webmaster (dan@timmy), giving this e
+rror message and the time and date of the error.