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]
