That did not work Charlie. Not only is it giving me the two static fields,
but also the hidden field and the submit button name.
I did try this though:
<cfif FindNoCase("Name_",i) OR FindNoCase("Phone_",i) OR
FindNoCase("Email_",i) AND LEN(form[i] GT 0)>
This did exclude all of the fields except the ones I want, but it is also
giving me all of the empty ones. If I just do this:
<cfif FindNoCase("Name_",i) AND LEN(form[i] GT 0)>
Then I get all of the fields with Name_ in them but nothing else. Surely I
am missing something basic?
On 12/18/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> <cfif ((i IS NOT "static_field1") OR (i IS NOT "static_field2")) AND
> (len(form[i]) GT 0)> ?
>
> On 12/18/06, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> > 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>
>
> --
> Charlie Griefer
>
> ================================================
> "...All the world shall be your enemy, Prince with a Thousand Enemies,
> and whenever they catch you, they will kill you. But first they must catch
> you, digger, listener, runner, prince with a swift warning.
> Be cunning and full of tricks and your people shall never be destroyed."
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:264396
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
