> Just drop it right in there, making sure to use the same name as the
> 'real' query. The QofQ result will overwrite the result from the DB,
> and then you can return it just as you're currently doing.
>
Oh duhhhhh! I got it. I did this, works fine. Thanks again barney.
<cffunction name="listDistinctSKUImages" returntype="query" hint="Gets Distinct
SKU images">
<cfargument name="SKUID" required="yes" type="numeric">
<cfset var listskuimages ="">
<cfset var listdistinctskuimages ="">
<cfquery name="listskuimages" datasource="#VARIABLES.dsn#">
SELECT tbloptionimages.optionimageID, tbloptionimages.SKUID,
tbloptionimages.optionID, tbloptionimages.imagetypeID,
tbloptionimages.optionimagefilename, tblSKUoptions.optionID
FROM tbloptionimages, tblSKUoptions
WHERE tbloptionimages.SKUID = #ARGUMENTS.SKUID#
AND tbloptionimages.optionID = tblSKUoptions.optionID
</cfquery>
<cfquery dbtype="query" name="listDistinctImages">
SELECT DISTINCT imagetypeID, optionID, optionimagefilename
FROM listskuimages
</cfquery>
<cfreturn listDistinctImages>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222267
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
