tracker issue : CF-3037038

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

Bug 74211:I looked at the known issues doc for CF9 Alpha 2, and this doesn't seem to be a known issue

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Tariq Ahmed / Tariq Ahmed (Tariq Ahmed [ACP])

Created: 12/11/2008

Components: Database, CFQuery

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 / 218401

Priority/Frequency: Major / Unknown

Locale/System: English / Win All

Vote Count: 1

Duplicate ID:	CF-3036980

Problem:

I looked at the known issues doc for CF9 Alpha 2, and this doesn't seem to be a known issue.

But I'm getting all sorts of Query of Query errors, even when a QoQ isn't involved. E.g. this query on an MS SQL 2000 datasource:

<cfquery name="myQuery" datasource="AnMSSQLDB">
  SET NOCOUNT ON      	
        
  INSERT INTO foo(a,b,c)iationRelationship,
  VALUES (1,2,3)#Arguments.ProductID#,#Arguments.EmployerID#,

  SELECT RecordID=@@identity			
  SET NOCOUNT OFF	                
</cfquery>

<cfset newID = myQuery.RecordID>      

Results in a:

Query Of Queries runtime error.  
Cannot mix types DECIMAL and INTEGER in a compare binary operation.  

The above code works in CF8.

Thx.
Method:

<cfquery name="myQuery" datasource="AnMSSQLDB">
  SET NOCOUNT ON      	
        
  INSERT INTO foo(a,b,c)iationRelationship,
  VALUES (1,2,3)#Arguments.ProductID#,#Arguments.EmployerID#,

  SELECT RecordID=@@identity			
  SET NOCOUNT OFF	                
</cfquery>

<cfset newID = myQuery.RecordID>     
Result:

Query Of Queries runtime error.  
Cannot mix types DECIMAL and INTEGER in a compare binary operation.  

Exceptions

14:54:41.041 - Database Exception - in C:\web\_components\com\orhp\shared\product\association.cfc : line 125
	    Query Of Queries runtime error.

1  "Error","jrpp-8","12/11/08","14:56:43","Development","Query Of Queries runtime error.Cannot mix types DECIMAL and DOUBLE in a compare binary operation. The specific sequence of files included or processed is: C:\web\everest\html\Product_Display.cfm, line: 125 "  
2  coldfusion.sql.imq.ImqTypeMismatchException: Query Of Queries runtime error.  
3  at coldfusion.sql.imq.Row.compareTo(Row.java:196)  
4  at coldfusion.sql.imq.Row.equals(Row.java:133)  
5  at java.util.AbstractList.equals(AbstractList.java:507)  
6  at java.util.Vector.equals(Vector.java:925)  
7  at coldfusion.sql.QueryTable.equals(QueryTable.java:2787)  
8  at coldfusion.runtime.NeoPageContext.checkForQueryTable(NeoPageContext.java:1618)  
9  at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1389)  
10  at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1779)  
11  at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1772)  
12  at cfassociation2ecfc1001564704$funcADDASSOCIATION.runFunction(C:\web\_components\com\orhp\shared\product\association.cfc:125)  
13  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:424)  
14  at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)  
15  at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:357)  
16  at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:320)  
17  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)  
18  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:274)  
19  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:194)  
20  at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2522)  
21  at cfassociation2ecfc1001564704$funcBATCHPROCESS.runFunction(C:\web\_components\com\orhp\shared\product\association.cfc:143)  
22  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:424)  
23  at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)  
24  at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:357)  
25  at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:320)  
26  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)  
27  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:274)  
28  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:194)  
29  at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:507)  
30  at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:324)  
31  at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2318)  
32  at cfdisplayLib2ecfm470199922$funcAPPLYASSOCIATIONS.runFunction(C:\web\everest\html\Products\Display\Association\displayLib.cfm:86)  
33  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:424)  
34  at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:320)  
35  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)  
36  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:274)  
37  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:194)  
38  at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2522)  
39  at cfincUpdateProduct2ecfm1442407767._factor32(C:\web\everest\html\Products\Display\incUpdateProduct.cfm:650)  
40  at cfincUpdateProduct2ecfm1442407767._factor33(C:\web\everest\html\Products\Display\incUpdateProduct.cfm:12)

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

Watson Bug ID:	3037038

External Customer Info:
External Company:  
External Customer Name: Tariq Ahmed
External Customer Email: 755462B744617992992015D5
External Test Config: 12/11/2008

Attachments:

Comments:

I get the same problem when trying to assign the value returned in a query from the the MSSQL scope_identity() function to a variable Query Of Queries runtime error. Cannot mix types DECIMAL and INTEGER in a compare binary operation. The error occurred in C:\Inetpub\www\mercedesroot\_checkout\act_create_invoice.cfm: line 278 276 : select scope_identity() as new_invoice_product_id 277 : </cfquery> 278 : <cfset newinvoice_product_id = getproductinfo.new_invoice_product_id>
Vote by External U.
24413 | November 10, 2011 07:08:15 PM GMT