You can have the datasource dynamic i.e.
<cfquery name="myQuery" datasource="#myCurrentDatasource#">
some SQL.....
</cfquery>
you can set the variable 'myCurrentDatasource' elsewhere in your code
as required.
HTH
Mike
On 5/9/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote:
> Simmyana,
>
> Well... basically... you can't. :/
>
> Perhaps a more in-depth description of the need would help us resolve the
> issue?
>
> Laterz,
> J
>
> On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > How to use more than one datasource in <cfquery> tag?
> >
> > Thanks
> >
>
> --
> ---------------
> -------------------------------------
> Buy SQLSurveyor!
> http://www.web-relevant.com/sqlsurveyor
> Never make your developers open Enterprise Manager again.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:206034
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
