are u using CF5 dynamic DSN's ? -----Original Message----- From: Giles Roadnight [mailto:giles@;roadnight.name] Sent: 29 October 2002 10:20 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] More than one datasource in one query
Well, I know for a fact that this works: insert into tmp_enq_det select * from "#request.dataroot#enquiries.mdb".enq_det ----- Original Message ----- From: "Russ 'Snake' Michaels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:11 AM Subject: RE: [ cf-dev ] More than one datasource in one query > Where do u get the idea that you can select from a file ? > > -----Original Message----- > From: Giles Roadnight [mailto:giles@;roadnight.name] > Sent: 29 October 2002 10:12 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] More than one datasource in one query > > > Hi guys > > can anyone tell me why this doesn't work: > > select siteid, sitename > from tblSiteDetails > where siteid in (select siteid from > "f:\inetpub\wwwroot\data_NewSystem\spndm_log.mdb".tblenquirydetails) > order by sitename > > the path to the DB is correct. The error I get is "Type mismatch in > expression" > > Thanks > > Giles > > > -- > ** 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] > -- ** 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]
