This CFQUERY originally worked with ONE DSN:
<--------------->
<cfquery name="getLineItems" datasource="#Request.AppVars.DSN#">
SELECT L.LineNum, L.Quantity, L.Price, L.Extended, L.OptPartNumber, L.WL_ID,
P.Product_ID, P.ProductTitle, P.PartNumber, O.OptTitle
FROM (LineItems L
LEFT JOIN Products P ON L.Product_ID = P.Product_ID)
LEFT JOIN Options O ON L.Opt_ID = O.Opt_ID
WHERE Order_ID=<CFQUERYPARAM VALUE="#Val(Variables.Order_ID)#"
CFSQLType="CF_SQL_INTEGER"></CFQUERYPARAM>
</cfquery>
<--------------->
Now, I have TWO DSNs. One DSN that holds the LineItems table
and one DSN that holds the Products table and the Options table.
Don't ask why :(
Can I use QueryOfQuerys to solve my problem here?
I have absolutely no clue how to so this!
I would like the QofQ to have the SAME functionality of the
original query.
TIA...Ché
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
