in reply to Re: Maximum DBI query length?
in thread Maximum DBI query length?
Very well. Here's the code that prepares the query....
And here's the page (it's a CGI script) that makes me think it's being chopped off...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;
Software error: 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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Re: Maximum DBI query length?
by le (Friar) on May 07, 2001 at 21:48 UTC | |
by Merlin83 (Novice) on May 07, 2001 at 21:49 UTC | |
by boo_radley (Parson) on May 07, 2001 at 21:55 UTC | |
by Merlin83 (Novice) on May 07, 2001 at 22:01 UTC | |
by boo_radley (Parson) on May 07, 2001 at 22:02 UTC | |
by le (Friar) on May 07, 2001 at 21:52 UTC | |
Re: Re: Re: Maximum DBI query length?
by turnstep (Parson) on May 07, 2001 at 22:41 UTC | |
Re: Re: Re: Maximum DBI query length?
by KM (Priest) on May 07, 2001 at 21:54 UTC |
In Section
Seekers of Perl Wisdom