Thank you very much Alan, I think that did the trick :) On Thursday, May 16, 2013 3:53:43 PM UTC-5, [email protected] wrote: > > Try to format your variable with bracket notation: > > '#form["abil#i#"]#' > > That usually works for me > > > Thanks, > Alan > > On May 16, 2013, at 4:47 PM, Marcus F <[email protected] <javascript:>> > wrote: > > Once more I turn to you old CFML gurus in hope to save my sanity. > > I'm trying to figure out how to use a dynamic variable in a loop with a > query. > I have a form that submits 20 values, I need to collect info from a DB > based on the names of the values from the form. > Nothing fancy so far, but I'd like to not have to write 800 lines of code > when I could just use a loop, or so I'd like to think anyway, and there's > my problem. > > The form fields I need are named abil1 - abil20, so my query looks roughly > like this > > <cfloop from="1" to="20" index="i"> > SELECT cost FROM abilities WHERE name = '#form.abil1#' > </cfloop> > > I can't figure out how I can use the index to dynamically pull the > form.abil fields and run the query one by one. > > There's no way I'm the first to run into this, but I've looked and can't > find a solution out there, I found some solutions for dynamic variables but > nothing that would help in this case. > > -- > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Open BlueDragon" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/groups/opt_out. > > > >
-- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
