I think it was late night brain deadness...I worked it out this morning... phew...in the nick of time.. hehe so no worries
"Carl Vanderpal" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > Hello CFAussie, > > I will try and explain my question as clearly as possible... > > the add_linked_video.cfm page is easy to understand > > Step Thru 2 pages long - > > 1) Step 1 has drop down menu with list of clients and drop down box > (loop from 1 to 7) asking how many questions > > 2) Step 2 (based on how many question from previous page) is how many > question boxes appear, and how many multi-select boxes appear with > video's that are linked to that question > > (Values are held in SESSION in case person decides to go back) > > My problem is when I am updating the record... > > update_linked_video.cfm > > 1) Step 1 Gets query from DB, loops thru and puts into SESSION.VidWiz > > 2) Step 2 Here is the prob...if the DB has 3 records and I increase > the number of questions to say 4 it seem to get an error...whilst > looping through questions..saying "Element 4 is undefined in a CFML > structure referenced as part of an expression" > > here is the loop > > <cfloop from="1" to="#Form.QuestionCount#" index="i"> > <tr> > <td><font class="smallcontent"><strong>Question ###i#</strong></font></td> > <td><cfif Form.QuestionCount LTE "qGetVideoDetails2.RecordCount"> > <cfinput name="q#i#" type="text" size="40" class="form_input" > value="#SESSION.VidWiz.q[i]#" required="yes" message="Please Type A Question"> > <cfelse> > <cfinput name="q#i#" type="text" size="40" class="form_input" value="" > required="yes" message="Please Type A Question"> > </cfif> > </cfloop> > > My logic is Check how many records in DB minus the number of questions > (eg. DB has 3 questions but I increase to 6 on the form) so on the > second page, works out that I need 3 more question boxes and outputs > empty cfinputs, (cfinput name loops thru q1,q2,q3 then minuses > remaining questions and lops thru to give result q4,q5,q6) > > Hope this makes sense?? I am on the right track or totally off!! I am > happy to discuss over phone if you like... :-) > > > > Best regards, > Carl Vanderpal > Po Box 3462 Dural, NSW 2158 > mailto:[EMAIL PROTECTED] > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
