By chance is one or more of the possible values of code a number? Mike
-----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 12: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:236724 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
