Re: [PHP] most powerful php editor

On Wed, 2007-01-24 at 20:44 -0600, Larry Garfield wrote:
On Wednesday 24 January 2007 8:07 pm, Robert Cummings wrote:

There is no way in hell one long line of SQL is easier to read than
formatted SQL that clearly delineates the clause structure.

Sure there is. If it's a very simple SQL statement.

I have at various times done all of the following, depending on the complexity
of the statement in question:

SELECT id, foo, FROM foo_table WHERE id=5

(Too short to really bother with splitting up.)

SELECT id, foo, bar, baz
FROM foo_table
INNER JOIN bar_table on a=b
LEFT OUTER JOIN baz_table on b=c
WHERE blah
AND stuff < narf
OR (thingie AND other)
ORDER BY foo

SELECT a.a, a.b, a.c
b.d, b.e, b.f
FROM a
INNER JOIN b ON whatever
ORDER BY a.b, a.c DESC

I notice you formatted all of the "long" ones. That's why in my original
statement I wrote "There is no way in hell one long line". Subsequently,
I deem you to be in agreement with my point, despite the misguided
protest :B

Cheers,
Rob.
--
..------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com |
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting |
| a powerful, scalable system for accessing system services |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for |
| creating re-usable components quickly and easily. |
`------------------------------------------------------------'
.

Relevant Pages