Is your siteid on both tables the same data type?? are they both numeric? Stephen ----- Original Message ----- From: "Giles Roadnight" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:11 AM 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]
