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