> 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]
