I have a form that may have just one or up to 20 or so sets of data. The
form fields will be passed, but could be blank for all but one set up data.
It's being passed as something like
form.name1
form.address1
form.city1
form.state1
form.name2
form.address2
form.city2
form.state2
... so on.
On the action page, I want to loop over an insert query and only execute the
query if the set of data is not ""
so I need to do a <cfif name1 is not ""....> run the query<cfelse>don't run
the query</cfif>
How do I run the count in the cfif statement since name#loopcount# won't
work within a cfif statement?
Then if I do the insert, how can I get the value of the variable for the
query. It has to be dynamically generated from the loop
Obviously this is not going to work, but I think it illustrates what I am
trying to do.
<CFQUERY NAME="name" DATASOURCE="name">
INSERT INTO tablename
(
name,
city,
...
)
VALUES
(
#name#loopcount##,
#city#loopcount##,
....
)
</CFQUERY>
Thanks!
--
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
