At 12:22 AM 5/9/05, Thanks wrote: >How to use more than one datasource in <cfquery> tag?
I think J is technically right about CFQUERY but there have to be other ways to skin the cat, such as by using two separate queries on different datasources and then combining their outputs with a query-of-query UNION query (brought to you by the department of redundancy department) for example, if combining their outputs is what you're trying to accomplish. I'm not sure if such a QoQ in your case would work but that's what I would try first, success may depend on the complexity of your task because I seem to recall that QoQ's are somewhat limited in their functionality. More elegant would be to use a stored procedure in a database that supports them, for example you could use a stored procedure in MS SQL Server that's setup to query an external MS Access datasource as well as its own tables. That stored procedure could do some very complex things to produce output which you could retrieve with a single call to the stored procedure. Sorry I can't help you with code snips but some coding genius ought to be able to. Regards, Karl S. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/05 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206035 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
