CFLOOP inside a CFQuery

2009-06-09 Thread Will Blake
the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting

Re: CFLOOP inside a CFQuery

2009-06-09 Thread N K
, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem

Re: CFLOOP inside a CFQuery[RESOLVED]

2009-06-09 Thread Will Blake
Check the following link might help... http://tutorial431.easycfm.com/ Thank you! I was thinking I had to do something like this to get it to work. I just did not know exactly what it was I needed to do so searching for it was difficult. Thanks again! Will

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Gabriel
: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Gabriel
: CFLOOP inside a CFQuery Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Gabriel
, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Gabriel
: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Will Blake
WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? Is there ever a reason not to use CFQUERYPARAM? Thanks

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Justin Scott
WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting

RE: CFLOOP inside a CFQuery

2009-06-09 Thread Gabriel
: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who

Re: CFLOOP inside a CFQuery

2009-06-09 Thread Ryan Letulle
queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept