Re: Query Oddness
Probably a longshot, but I had that problem once and it ended up being explained by the fact that I had copied a CFQUERY line that had a MAXROWS parameter set. Along the same lines, CFOUTPUT supports the MAXROWS parameter too. On 2/14/07, Tero Pikala <[EMAIL PROTECTED]> wrote: > > Also check that you don't have un-committed transactions lurking > somewhere, > I've been confused with query results few times for that. > > > > -Original Message- > From: Coldfusion [mailto:[EMAIL PROTECTED] > Sent: 13 February 2007 23:35 > To: CF-Talk > Subject: RE: Query Oddness > > Run the Query then do a CFDUMP on the Query and see if the results match > Query Analyzer > If not, I would validate the right datasource is being used in both > instances. > > -Original Message- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 6:27 PM > To: CF-Talk > Subject: Re: Query Oddness > > Im not using cfqueryparam. Maybe I should try to here > > Bryan Stevenson wrote: > > I have actually seen CFQUERYPARAM cause odd results like that against > > Oracle > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development Electric Edge Systems Group > > Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: [EMAIL PROTECTED] > > web: www.electricedgesystems.com > > > > Notice: > > This message, including any attachments, is confidential and may > > contain information that is privileged or exempt from disclosure. It > > is intended only for the person to whom it is addressed unless > > expressly authorized otherwise by the sender. If you are not an > > authorized recipient, please notify the sender immediately and > > permanently destroy all copies of this message and attachments. > > > > > > > > > > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Oddness
Also check that you don't have un-committed transactions lurking somewhere, I've been confused with query results few times for that. -Original Message- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: 13 February 2007 23:35 To: CF-Talk Subject: RE: Query Oddness Run the Query then do a CFDUMP on the Query and see if the results match Query Analyzer If not, I would validate the right datasource is being used in both instances. -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 6:27 PM To: CF-Talk Subject: Re: Query Oddness Im not using cfqueryparam. Maybe I should try to here Bryan Stevenson wrote: > I have actually seen CFQUERYPARAM cause odd results like that against > Oracle > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development Electric Edge Systems Group > Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > Notice: > This message, including any attachments, is confidential and may > contain information that is privileged or exempt from disclosure. It > is intended only for the person to whom it is addressed unless > expressly authorized otherwise by the sender. If you are not an > authorized recipient, please notify the sender immediately and > permanently destroy all copies of this message and attachments. > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Oddness
Run the Query then do a CFDUMP on the Query and see if the results match Query Analyzer If not, I would validate the right datasource is being used in both instances. -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 6:27 PM To: CF-Talk Subject: Re: Query Oddness Im not using cfqueryparam. Maybe I should try to here Bryan Stevenson wrote: > I have actually seen CFQUERYPARAM cause odd results like that against > Oracle > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development Electric Edge Systems Group > Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > Notice: > This message, including any attachments, is confidential and may > contain information that is privileged or exempt from disclosure. It > is intended only for the person to whom it is addressed unless > expressly authorized otherwise by the sender. If you are not an > authorized recipient, please notify the sender immediately and > permanently destroy all copies of this message and attachments. > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Oddness
Are you using the same user account in coldfusion as your are in query analyzer? There could be some nasty row-level permissions lurking around that are biting in CF but not QA. On 2/14/07, Brian Peddle <[EMAIL PROTECTED]> wrote: > > No login. > > mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 13, 2007 6:06 PM > > To: CF-Talk > > Subject: Query Oddness > > > > Anyone seen this or have any clues ... > > > > Query returns 8 rows. > > In the debugging it shows 8 rows. > > If I copy the debugging query into query analyzer is returns 27 like it > > should be. > > > > I am stumped. > > > > > > > > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Oddness
Im not using cfqueryparam. Maybe I should try to here Bryan Stevenson wrote: > I have actually seen CFQUERYPARAM cause odd results like that against Oracle > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > Notice: > This message, including any attachments, is confidential and may contain > information that is privileged or exempt from disclosure. It is intended > only for the person to whom it is addressed unless expressly authorized > otherwise by the sender. If you are not an authorized recipient, please > notify the sender immediately and permanently destroy all copies of this > message and attachments. > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Oddness
yes Dave Watts wrote: >> Query returns 8 rows. >> In the debugging it shows 8 rows. >> If I copy the debugging query into query analyzer is returns >> 27 like it should be. >> > > Are you using the same login from within Query Analyzer as from within your > CF application? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Oddness
No login. mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 6:06 PM > To: CF-Talk > Subject: Query Oddness > > Anyone seen this or have any clues ... > > Query returns 8 rows. > In the debugging it shows 8 rows. > If I copy the debugging query into query analyzer is returns 27 like it > should be. > > I am stumped. > > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Oddness
I have actually seen CFQUERYPARAM cause odd results like that against Oracle Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Oddness
> Query returns 8 rows. > In the debugging it shows 8 rows. > If I copy the debugging query into query analyzer is returns > 27 like it should be. Are you using the same login from within Query Analyzer as from within your CF application? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Oddness
Check your output logic. Check your IF statements to see if your bypassing some records -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 6:06 PM To: CF-Talk Subject: Query Oddness Anyone seen this or have any clues ... Query returns 8 rows. In the debugging it shows 8 rows. If I copy the debugging query into query analyzer is returns 27 like it should be. I am stumped. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Oddness
Anyone seen this or have any clues ... Query returns 8 rows. In the debugging it shows 8 rows. If I copy the debugging query into query analyzer is returns 27 like it should be. I am stumped. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query of Query Oddness
To steal from the docs: ColdFusion has a list of reserved keywords, which are typically part of the SQL language and are not normally used for names of columns or tables. To escape a reserved keyword for a column name or table name, enclose it in brackets. Caution: Earlier versions of ColdFusion let you use some reserved keywords without escaping them. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 10:02 AM > To: CF-Talk > Subject: RE: Query of Query Oddness > > > Ray, > > If section is reserved, do you know what it is reserved for? > Where is it > used? > > -mk > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 8:52 AM > To: CF-Talk > Subject: RE: Query of Query Oddness > > > Section is a reserved word. I checked the docs and it _wasnt_ on the > list, so I'm going to add it to livedocs. > > To correct, just change "section" to "[section]". > > == > = > Raymond Camden, ColdFusion Jedi Master for Hire > > Email: [EMAIL PROTECTED] > Yahoo IM : cfjedimaster > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 15, 2002 9:43 AM > > To: CF-Talk > > Subject: Query of Query Oddness > > > > > > This is really odd, this is a very simple Query of Query and the > > function keeps crapping out on me in CFMX ... any ideas? > > > > I did a cfdump of the query myQuery and it contains all the > fields I'd > > expect: > > > > HELPDOC (string) > > SECTION (string) > > TITLE (string) > > > > Here's the Query: > > > > SELECT * FROM myQuery > > WHERE section LIKE '%#s#%' > > > > > > Here's the actual SQL: > > SELECT * FROM myQuery WHERE section LIKE '%Membership%' > > > > Here's the Error: > > Query Of Queries syntax error. > > Encountered "section" at line 3, column 15. Incorrect conditional > > expression, Expected one of [like|null|between|in|comparison] > > condition, > > > > > > Thanks, > > > > Joshua Miller > > > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Ray, If section is reserved, do you know what it is reserved for? Where is it used? -mk -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:52 AM To: CF-Talk Subject: RE: Query of Query Oddness Section is a reserved word. I checked the docs and it _wasnt_ on the list, so I'm going to add it to livedocs. To correct, just change "section" to "[section]". === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:43 AM > To: CF-Talk > Subject: Query of Query Oddness > > > This is really odd, this is a very simple Query of Query and the > function keeps crapping out on me in CFMX ... any ideas? > > I did a cfdump of the query myQuery and it contains all the fields I'd > expect: > > HELPDOC (string) > SECTION (string) > TITLE (string) > > Here's the Query: > > SELECT * FROM myQuery > WHERE section LIKE '%#s#%' > > > Here's the actual SQL: > SELECT * FROM myQuery WHERE section LIKE '%Membership%' > > Here's the Error: > Query Of Queries syntax error. > Encountered "section" at line 3, column 15. Incorrect conditional > expression, Expected one of [like|null|between|in|comparison] > condition, > > > Thanks, > > Joshua Miller > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Josh,
Try putting the search string in parenthasis - i.e. WHERE SECTION LIKE
('%Membership%')
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 8:43 AM
To: CF-Talk
Subject: Query of Query Oddness
This is really odd, this is a very simple Query of Query and the
function keeps crapping out on me in CFMX ... any ideas?
I did a cfdump of the query myQuery and it contains all the fields I'd
expect:
HELPDOC (string)
SECTION (string)
TITLE (string)
Here's the Query:
SELECT * FROM myQuery
WHERE section LIKE '%#s#%'
Here's the actual SQL:
SELECT * FROM myQuery WHERE section LIKE '%Membership%'
Here's the Error:
Query Of Queries syntax error.
Encountered "section" at line 3, column 15. Incorrect conditional
expression, Expected one of [like|null|between|in|comparison] condition,
Thanks,
Joshua Miller
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Actually, it WAS in the table of reserved words - I was just reading the table wrong. As a general warning - CFMX QofQ has a large number of reserved words to watch out for (although QofQ in CFMX is a heck of a lot better, so it's not a big deal ;) === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:43 AM > To: CF-Talk > Subject: Query of Query Oddness > > > This is really odd, this is a very simple Query of Query and the > function keeps crapping out on me in CFMX ... any ideas? > > I did a cfdump of the query myQuery and it contains all the fields I'd > expect: > > HELPDOC (string) > SECTION (string) > TITLE (string) > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Section is a reserved word. I checked the docs and it _wasnt_ on the list, so I'm going to add it to livedocs. To correct, just change "section" to "[section]". === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:43 AM > To: CF-Talk > Subject: Query of Query Oddness > > > This is really odd, this is a very simple Query of Query and the > function keeps crapping out on me in CFMX ... any ideas? > > I did a cfdump of the query myQuery and it contains all the fields I'd > expect: > > HELPDOC (string) > SECTION (string) > TITLE (string) > > Here's the Query: > > SELECT * FROM myQuery > WHERE section LIKE '%#s#%' > > > Here's the actual SQL: > SELECT * FROM myQuery WHERE section LIKE '%Membership%' > > Here's the Error: > Query Of Queries syntax error. > Encountered "section" at line 3, column 15. Incorrect conditional > expression, Expected one of [like|null|between|in|comparison] > condition, > > > Thanks, > > Joshua Miller > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query of Query Oddness
This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: SELECT * FROM myQuery WHERE section LIKE '%#s#%' Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered "section" at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
