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:236716
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
