Correct. On Tue, 29 Oct 2002 13:04:15 -0500, Bryan F. Hogan wrote:
> 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
