He is looking to input data from one "database" into another "database" not one table into another table.
============================================ Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ============================================ -----Original Message----- From: Stephen Moretti [mailto:stephen@;cfmaster.co.uk] Sent: Tuesday, October 29, 2002 12:51 PM To: CF-Talk Subject: Re: Reading database and inserting fields into another database > > True except for valuelist(), query returns comma delimited anyway, why the > extra function? > If that's the case : INSERT INTO data2 (strVal) SELECT env_var FROM data1 will do the trick. Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
