Ok, that's the problem. I was expecting a problem with the file reference bit. can I cast this then or do I have to change the datatype in the table. I probably should change the datatype but it will probably stop all sorts of things working!!
Thanks ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:22 AM Subject: Re: [ cf-dev ] More than one datasource in one query > 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] > -- ** 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]
