Ok I got two tables in seperate databases. I want to be able to extract the data from one of the database tables to the other database table through CF code. This is NOT a one time thing. I want to be able to periodically do it over time. This would mean I need a way of checking for dupes (basically only transferring over the new info).
Would I use a CFLoop? I was successful using the CFLoop query and it filled it up, but when i ran it again it duplicated the information. Any help would be greatly appreciated. ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
