Have you tried this directly in the DB from SQL Manager? If it still happens then ColdFusion is not part of the issue.
Wil Genovese Sr. Web Application Developer/ Systems Administrator [email protected] www.trunkful.com On Oct 18, 2010, at 3:36 PM, Bryan Stevenson wrote: > > I'd second a double check of caching....and I'd restart the CF services > between changes and test again. > > I mention the latter because every once in a while CF just doesn't "see" > changes at all or correctly. It's like it's not seeing the cource has > changed and is not re-compiling. > > Anyways...that is one thing I always consider when queries are involved > and I know the code should work or behave differently. > > Cheers > > On Mon, 2010-10-18 at 16:03 -0400, Les Mizzell wrote: > >> 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:338301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
