Ah yes I do rememebr it now.
-----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]
