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
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:
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
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
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
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
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!
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
8 matches
Mail list logo