I prefer option 2
makes it more readable and easier to follow the code through. I also prefer to
indent the SQL inside the cfquery tag aswell like
<cfquery .....>
SELECT *
FROM table t
WHERE 0=0
<cfif isDefined("form.keyword") >
AND title like '%#title#%'
</cfif>
<cfif listLen(form.categoryIds) >
AND category_id IN (#form.categoryIDs#)
</cfif>
</cfquery>
Just following code indenting consistantly
Steve
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Pat
Branley
Sent: Wednesday, August 17, 2005 9:33 AM
To: CFAussie Mailing List
Subject: [cfaussie] CFQuery Style
Hi All
Just wondering what everyones opinion is about formatting SQL code
withing CFQuery ? Do you think its important to preserve the indentation
of the SQL or is it more important to see the flow of the CF code inside
the tag ?
Im way more in favour of preserving cold fusion indentation. I just
think its more important to follow the logic of the code, especially
when the query gets complex and there are more <CFIF calls in there.
Pat
eg. SQL indentation is Preseved
<cfquery .....>
SELECT *
FROM table t
WHERE 0=0 <cfif isDefined("form.keyword") >
AND title like '%#title#%'</cfif><cfif listLen(form.categoryIds) >
AND category_id IN (#form.categoryIDs#)</cfif>
</cfquery>
OR 2 cold fusion indentation is preserved
<cfquery .....>
SELECT *
FROM table t
WHERE 0=0
<cfif isDefined("form.keyword") >
AND title like '%#title#%'
</cfif>
<cfif listLen(form.categoryIds) >
AND category_id IN (#form.categoryIDs#)
</cfif>
</cfquery>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
