RE: What difference does the parenthesis make?

2010-10-18 Thread DURETTE, STEVEN J (ATTASIAIT)
That depends on the DB server. MSSQL doesn't have any problem with getting rid of the () that I know of. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Monday, October 18, 2010 3:17 PM To: cf-talk Subject: What difference does the parenthesis make? What's

RE: What difference does the parenthesis make?

2010-10-18 Thread Paul Alkema
In mssql there shouldn't be a difference in the records returns. I would double check that the input variable #law.paid# is the same in both of these scenarios and also that none of these queries are cached. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent:

Re: What difference does the parenthesis make?

2010-10-18 Thread Michael Grant
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? For instance there's a BIG difference between this: WHERE paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer / AND (nl_status = 'published' OR

Re: What difference does the parenthesis make?

2010-10-18 Thread Les Mizzell
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

Re: What difference does the parenthesis make?

2010-10-18 Thread Bryan Stevenson
I'd second a double check of cachingand 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

Re: What difference does the parenthesis make?

2010-10-18 Thread Wil Genovese
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 wilg...@trunkful.com www.trunkful.com On Oct 18, 2010, at 3:36 PM, Bryan Stevenson wrote: I'd second a

Re: What difference does the parenthesis make?

2010-10-18 Thread Les Mizzell
On 10/18/2010 4:40 PM, Wil Genovese wrote: Have you tried this directly in the DB from SQL Manager? If it still happens then ColdFusion is not part of the issue. Directly in the DB will pull the expected/correct data set either way. Looks like the server needs a reboot!

RE: What difference does the parenthesis make?

2010-10-18 Thread Eric Roberts
to shut that off. -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Monday, October 18, 2010 4:36 PM To: cf-talk Subject: Re: What difference does the parenthesis make? I'd second a double check of cachingand I'd restart the CF services between