WOW! You man I could have read the nice manual?! Thanks, Dave...
Rick -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 9:12 PM To: CF-Talk Subject: RE: How do I write a query to do this? > I want to pull some info straight from a MySQL table via a database > interface, not with CF queries, and then in the same query insert the > data into a table in another database. > I haven't written any combined "select" and "insert" queries. > With CF, it's always a "select" query, then a separate looping of the > select query to insert the data using another query. > These are live databases, so I don't want to foul another up! > Advice? INSERT INTO ... SELECT http://dev.mysql.com/doc/refman/5.0/en/insert-select.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
