Re: Re: Re: Maximum DBI query length?

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?	[reply]
(boo) RE5 Maximum DBI query length? by boo_radley (Parson) on May 07, 2001 at 21:55 UTC
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]
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
Re: Re: Re: Re: Re: Maximum DBI query length? by le (Friar) on May 07, 2001 at 21:52 UTC
`SELECT [columns] FROM [tables] WHERE [condition].` [download]	[reply] [d/l]