Not sure really.
What I have are a total of five dynamically named form fields. They are:
Name_X, Phone_x, Email_X for the first group, then
LanguageName_x, LanguageSpoken_x in the second group.
The first group of information goes into one table and the second group of
information goes into the second table. I have a hidden form field that
enters a FK into these tables that is linked to another table that has
already been populated with part one of the form. (this is a two part form).
There are a total of 10 rows for each group, but not all 10 rows are going
to be filled out all the time. There are some instances where only one or
two rows will be filled out, so that is why I am doing the LEN function. I
will get rid of the evaluate function and see what happens.
I am having one problem though. There are two other fields in this form that
go into the master table, so I need to exclude these from the array. I am
doing a FindNocase function and it works fine when I put in only one of the
fields (like <cfif FindNoCase("phone_",i) AND LEN(form[i])> and it gets all
of the fields with phone just fine, but when I add other fields to it,
nothing happens. So since I know the other two fields are not dynamic, how
can I exclude them from this so I get only the information I need?
Bruce
On 12/18/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> so, just out of curiousity...why do you need this array?
>
> you also don't need the evaluate(). you can simply do form[i] (which
> is -exactly- what you're doing in your conditional where you're
> testing len(form[i]).).
>
> On 12/18/06, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > OK, I figure it out so please disregard the last message.
> >
> > I did it like this:
> >
> > <!--- Create the initial array --->
> > <cfset languageArray= ArrayNew(1)>
> >
> > <!--- Loop through the form fields and get the names of them--->
> > <cfloop index="i" list="#form.fieldnames#">
> > <!--- If the field is not empty, get the info --->
> > <cfif LEN(form[i])>
> > <cfset languageArray[1][1] = #i#>
> > <cfset languageArray[1][2] = #evaluate("form.#i#")#>
> > <!--- Query will go here soon --->
> > </cfif>
> > </cfloop>
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264374
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
