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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
