> Well there you go Rich... ;oD jubbly. have needed to use it yet though! ;)
> -----Original Message----- > From: Stephen Moretti [mailto:stephen@;cfmaster.co.uk] > Sent: 29 October 2002 11:22 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] More than one datasource in one query > > > > > The workaround is to use a valid DSN in the CFQuery tag, > even if you are > not > > querying that DB > > > > The syntax to use is > > <cfquery name="queryname" > > datasource="Any_Valid_DSN_Name_which_points_to_another_DB"> > > select id from "fullpathname to Access DB".tblTable > > </cfquery> > > > Aye... That is exactly the workaround that Giles is using, > which is the > CF3/CF4 DNSless connection bodge. > > > > > > This does work on CFMX. > > > Well there you go Rich... ;oD > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
