This usually happens when you don't use CFQUERYPARAM in a QofQ. I don't know why exactly, but if you put that in, the type comparison is generally fixed (in my experience).
-ben ....................... Ben Nadel Web Developer Nylon Technology 350 7th Ave. Suite 1005 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 1:44 PM To: CF-Talk Subject: Query of Queries I don't use QofQ much and am having some troubles that maybe someone can help with. I am building a query called getShipping that populates code, description, rate. I am then running a query of queries checking on the selected rate. <cfquery name="shipping" dbtype="query"> SELECT code,description,rate FROM getShipping <cfif StructKeyExists(order, "shipMethod")> <cfif order.shipMethod Neq ""> WHERE code = '#order.shipMethod#' </cfif> </cfif> </cfquery> The problem is erroring out on the WHERE code = '#order.shipMethod#' ... even if it has a valid method (ie FEDEXGROUND) it is giving the following error: Query Of Queries runtime error. Unsupported type comparison. 1) does anyone see any problem with this? 2) Is there anotherway of getting a specific row/column value out of a query result set ? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
