Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: Re: Maximum DBI query length?

by le (Friar)
on May 07, 2001 at 17:48 UTC ( [id://78579]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


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

The bug is not in DBD::mysql, but in your SQL: there's no FROM.

Replies are listed 'Best First'.
Re: Re: Re: Re: Maximum DBI query length?
by Merlin83 (Novice) on May 07, 2001 at 17:49 UTC
    Oops, I thought the 'table.column' notation obviated the need for that. What should I be putting for the SQL query then?
[reply]
      SELECT [columns] FROM [tables] WHERE [condition].

      [download]
[reply]
[d/l]
      nope, you need to list out each of the tables.. 
      SELECT contact.field1, contact.field2, business.field1, acn.field1 
FROM contact, business, acn
WHERE ... (Etc.)

      [download]
      or you can assign aliases 
      SELECT c.field1, c.field2, b.field1, a.field1 
FROM contact c, business b, acn a
WHERE ... (Etc.)

      [download]

      OK?

[reply]
[d/l]
[select]
        Fantastic, thanks. I've had to take out the AS thing, since I don't know where in the statement it goes, but I'm back to a working script that doesn't produce any results.

        Thanks again.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://78579]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.