> With CFQUERY and INSERT INTO? Am using DWMX and it's context > sensitive help > for CFML (compared to Studio or HomeSite+) is appalling.
Cant you just write out the code? Just posted the code.. check it.. its fairly simple.. i personally think an index loop with list functions are faster than a list loop.. Joe Eugene > -----Original Message----- > From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 11:17 PM > To: CF-Talk > Subject: RE: Problem with list loop > > > With CFQUERY and INSERT INTO? Am using DWMX and it's context > sensitive help > for CFML (compared to Studio or HomeSite+) is appalling. > > == > Peter Tilbrook > Internet Applications Developer > Australian Building Codes Board > GPO Box 9839 > CANBERRA ACT 2601 > AUSTRALIA > > WWW: http://www.abcb.gov.au/ > E-Mail: [EMAIL PROTECTED] > Telephone: +61 (02) 6213 6731 > Mobile: 0439 401 823 > Facsimile: +61 (02) 6213 7287 > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 25 February 2003 1:41 PM > To: CF-Talk > Subject: Re: Problem with list loop > > > Its a cute trick, but probably fails against something internal to the > CFINSERT > tag. Once the tag 'views' the form fields as containing afghanistan (the > first > time), it caches it for future use. That seems to be what's going > on. Might > as > well just use real SQL for this. > > > > It correctly outputs unique countries per line but only inserts > > "AFGHANISTAN" repeatedly into the database table. Why? > > > > <cfset Countries="AFGHANISTAN,ALBANIA,ALGERIA,AMERICAN > .... > > > > <cfoutput> > > <cfloop index="CountriesList" list="#Countries#" delimiters=","> > > <cfset Form.CountryName=#CountriesList#> > > <p>#Form.CountryName#</p> > > <cfinsert datasource="Countries" tablename="Form_Countries" > > formfields="CountryName"> > > </cfloop> > > </cfoutput> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
