What's the difference between 1. ------------------------------ SELECT nl_id FROM vw_newsletters WHERE (paID=<cfqueryparam value="#law.paid#" cfsqltype="cf_sql_integer" />) AND (nl_status = 'published' OR nl_status = 'archived')
2. ------------------------------ SELECT nl_id FROM vw_newsletters WHERE paID=<cfqueryparam value="#law.paid#" cfsqltype="cf_sql_integer" /> AND (nl_status = 'published' OR nl_status = 'archived') #1 returns the correct records #2 returns nothing Not sure what difference the first set of parenthesis makes in #1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
