Re: Re: Re: Maximum DBI query length?

[le]

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

[Merlin83]

Oops, I thought the 'table.column' notation obviated the need for that. What should I be putting for the SQL query then?

[boo_radley]

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?

[Merlin83]

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.

[le]

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