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

Reply via email to