tracker issue : CF-3572225

select a category, or use search below
(searches all categories and all time range)
Title:

QoQ resorts input variable

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Roeland Verbeek / Roeland Verbeek (Roeland V,)

Created: 06/04/2013

Components: Database

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: 9.0 / 286622

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 1

Duplicate ID:	CF-3336700

Problem Description:
A query sent to a component gets a new order after component completes. It seems that the order is determined by the join field.

Steps to Reproduce:
See attachment: call TestQoQ.cfm

Actual Result:
 	PRODUCTDESCRIPTION 	PRODUCTID
1 	Red Car 	                                    ID1
2 	Green Bicycle 	                  ID2
3 	Blue Car 	                                    ID3
4 	Silver Car 	                                    ID4 


Expected Result:
  	PRODUCTDESCRIPTION 	PRODUCTID
1 	Blue Car 	                                    ID3
2 	Green Bicycle 	                  ID2
3 	Red Car 	                                    ID1
4 	Silver Car 	                                    ID4 

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3572225

External Customer Info:
External Company:  
External Customer Name: Kroelie
External Customer Email:  
External Test Config: My Hardware and Environment details:

Calling TestQoQ.cfm from a Windows 7 laptop, 64 bit in FireFox 21

Attachments:

  1. June 04, 2013 00:00:00: 1_TestQoQ.cfm
  2. June 04, 2013 00:00:00: 2_TestQoQ_Version_2.cfm

Comments:

Please use attachment "TestQoQ Version2.cfm"
Comment by External U.
15266 | June 04, 2013 04:23:43 AM GMT
I'm seeing this too on CF9.0.1. Note that if I pass the query by value rather than reference, there is no problem (to state the somewhat obvious). That said, CF should not be messing with the data unless it's solicited to do so, which it is not, in this case. +1 -- Adam
Vote by External U.
15267 | June 04, 2013 04:41:45 AM GMT