Thanks, it's working now. Silly mistake! This is only on a testing server hidden behind a firewall. The production server has the DB well hidden.
Thanks for the help. Giles ----- Original Message ----- From: "Matt Horn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:22 AM Subject: Re: [ cf-dev ] More than one datasource in one query > AFAIK > you need to have an ODBC datasource set up to point to the db > > and the inner query should look like this > > (select siteid from > OtherDB.tblenquirydetails) > > ------------------------------------------- > > wherE OtherDB = f:\inetpub\wwwroot\data_NewSystem\spndm_log.mdb > > also not such a good idea to have your DB in the webroot > > makes for ppl being able to d/l the whole database from a URL > > Matt > > > > > > At 10:11 29/10/2002 +0000, you wrote: > >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]
