Insert Looped Form Entry into Database

2007-03-06 Thread Joel Watson
I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer choices are also dynamically named based upon the id of the question, e.g., input name=Q#QuestionID#. I am currently able, upon submit, to pass the values of user-selected answers,

RE: Insert Looped Form Entry into Database

2007-03-06 Thread Ben Nadel
Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 7:37 AM To: CF-Talk Subject: Insert Looped Form Entry into Database I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer choices are also dynamically named based upon the id

RE: Insert Looped Form Entry into Database

2007-03-06 Thread Everett, Al \(NIH/NIGMS\) [C]
Looped Form Entry into Database I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer choices are also dynamically named based upon the id of the question, e.g., input name=Q#QuestionID#. I am currently able, upon submit, to pass the values

Re: Insert Looped Form Entry into Database

2007-03-06 Thread Joel Watson
? www.bennadel.com/ask-ben/ -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 7:37 AM To: CF-Talk Subject: Insert Looped Form Entry into Database I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer

RE: Insert Looped Form Entry into Database

2007-03-06 Thread Everett, Al \(NIH/NIGMS\) [C]
, you either need to put that value in a local variable or explicitly name the row. Results.QuestionID[CurrentRow] -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 8:53 AM To: CF-Talk Subject: Re: Insert Looped Form Entry into Database Thanks

Re: Insert Looped Form Entry into Database

2007-03-06 Thread Joel Watson
of a loop for a query result, you either need to put that value in a local variable or explicitly name the row. Results.QuestionID[CurrentRow] -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 8:53 AM To: CF-Talk Subject: Re: Insert Looped Form Entry

Re: Insert Looped Form Entry into Database

2007-03-06 Thread Joel Watson
- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 8:53 AM To: CF-Talk Subject: Re: Insert Looped Form Entry into Database Thanks for the quick response! This does work, but now I am running into another problem. While it submits the right number of entries to my