Sure, just use syndication. Have the machine on server 1 run foo.cfm. Foo.cfm uses CFHTTP to hit server 2. The file on server 2 does a query, uses WDDX to serialize it, and returns the packet to foo on box 1. Foo can then deserialize it and enter it into the DB.
This is, of course, a high level description. Let me know if you need additional details, and where. ======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Yager, Brian T Contractor/NCCIM > [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 26, 2001 3:46 PM > To: CF-Talk > Subject: Can this be done?? > > > I want to be able to run a file on one server that goes out > to a page on another > server, run a query, grab the information, and put it into a > DB on the first > server. Has anyone done this before?? > > > > Brian Yager > President - North AL Cold Fusion Users Group > Sr. Systems Analyst > NCCIM/CIC > [EMAIL PROTECTED] > (256) 842-8342 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
