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]
