(boo) RE5 Maximum DBI query length?


Pathologically Eclectic Rubbish Lister
	PerlMonks

by boo_radley (Parson)

on May 07, 2001 at 21:55 UTC ( [id://78583]=note: print w/replies, xml )

Need Help??

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?

Comment on (boo) RE5 Maximum DBI query length? Select or Download Code

Replies are listed 'Best First'.
Re: (boo) RE5 Maximum DBI query length? by Merlin83 (Novice) on May 07, 2001 at 22:01 UTC
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]
An idea : SQL by boo_radley (Parson) on May 07, 2001 at 22:02 UTC
Hmm. You may need this book.	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://78583]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others contemplating the Monastery: (4)

As of 2024-04-19 15:58 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found