I think i have replaced all of the queries that reference that field. I agree, the should both be numeric, that's why I changed it.
The two datasources are separate as it is easier to manage like this. One is to record information from the site, the other holds admin information. The admin database is small at a few MB but the logging database is around 100 MB so it is easier to copy the admin DB to and from the production server without the logging information attached. Giles ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:40 AM Subject: Re: [ cf-dev ] More than one datasource in one query > > 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!! > > > > Ermm well auuming that SiteID is a reference that is used in multiple places > for the same piece of information the data types should be the same where > ever you use it. > > Assuming you have a number in a text field in one of the databases. You > need to look out for all the SQL commands where you have single quotes > around your siteid. Those are the places that the code is gonna break. > > Incidently, how come the tables are in seperate databases? > > Regards > > Stephen > > > > -- > ** 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]
