On 10/18/2010 3:33 PM, Michael Grant wrote:
>
> In this case specifically the parenthesis should make no difference at all.
> Are you sure the two queries are exactly as you've shown them?
Yup.
Database is SQL Server
I can run the query with the paranths, and get the expected results.
Edit the same page to remove them, no results.
I can also substitute the variable "#law.paid#" with a known ID integer,
and get the same results.
paID=<cfqueryparam value="45" cfsqltype="cf_sql_integer" />
Weird...
SELECT nl_id
FROM vw_newsletters
WHERE
(paID=<cfqueryparam value="#law.paid#" cfsqltype="cf_sql_integer" />)
AND (nl_status = 'published' OR nl_status = 'archived')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338293
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
