Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Re: Re: Maximum DBI query length?

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


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 21:49 UTC
    Oops, I thought the 'table.column' notation obviated the need for that. What should I be putting for the SQL query then?
      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.)
      or you can assign aliases
      SELECT c.field1, c.field2, b.field1, a.field1 FROM contact c, business b, acn a WHERE ... (Etc.)

      OK?

        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.

      SELECT [columns] FROM [tables] WHERE [condition].

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2022-12-04 18:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?