Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Re: Re: Maximum DBI query length?

by turnstep (Parson)
on May 07, 2001 at 22:41 UTC ( #78598=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Maximum DBI query length?
in thread Maximum DBI query length?

As an aside (yes, I know the SQL is missing a FROM clause) that particular SQL statement is not really that long. Once you start programming a bit more, SQL statements 10x as long as that can become the norm. I highly recommend you start developing a better style to handle the SQL (for aesthetic, as well as other reasons). Try putting the SQL in a variable and then stick that variable into the prepare, like this:

my $CONTACT_SQL = " SELECT C.forename, C.surname, B.occupation, A.position, C.city, C.country AS forename, surname, occupation, position, city, cou +ntry FROM ACN A, BUSINESS B, CONTACTS C WHERE C.ruid=B.ruid AND C.ruid=A.ruid AND forename LIKE ? AND surname LIKE ? AND occupation LIKE ? AND position LIKE ? AND city LIKE ? AND country LIKE ?"; my $sthQuery = $dbh->prepare($CONTACT_SQL) or die "Couldn't prepare query: $DBI::errstr";


Comment on Re: Re: Re: Maximum DBI query length?
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://78598]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (18)
As of 2015-07-28 15:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (257 votes), past polls