Hello,
Please take a minute to download this file:
[login to view URL]
You will find three (3) files:
1. [login to view URL]
2. [login to view URL]
3. [login to view URL]
What I would like to accomplish is to make [login to view URL] read from L3_Survey_Info.xml.
About the [login to view URL] file:
Notice that the course code is being pulled from the URL:
CourseCode = Request("ccode")
About the [login to view URL]
The typical variables sent to this page are:
[login to view URL];ForTrainees=Y&ccode=NAXXX
About [login to view URL] file:
You will notice that blocks of information are stored within the <survey></survey> tags.
I would like the [login to view URL] file to be able to search the "<survey></survey>" tags by course code (i.e. from the "CourseCode" variable).
For instance, if ccode=NAXXX is appended to the URL, then the first "<survey></survey>" tag would be searched because the "NAXXX" is found
in the <course_code></course_code> tags.
I would then need the rest of the values within the other tags in the selected "<survey></survey>" tag to be populated in the following variables, like so:
Q1FromXML '<question1></question1>
Q1Opt1FromXML '<question1_option1></question1_option1>
Q1Opt2FromXML '<question2_option1></question2_option1>
Q1Opt3FromXML '<question3_option1></question3_option1>
Q1AnsweredOftenQ1FromXML '<question1_answered_often_question1></question1_answered_often_question1>
Q1AnsweredOftenQ2FromXML '<question1_answered_often_question2></question1_answered_often_question2>
Q1AnsweredOftenQ3FromXML '<question1_answered_often_question3></question1_answered_often_question3>
Q1AnsweredOftenOpt1FromXML '<question1_answered_often_option1></question1_answered_often_option1>
Q1AnsweredOftenOpt2FromXML '<question1_answered_often_option2></question1_answered_often_option2>
Q1AnsweredOftenOpt3FromXML '<question1_answered_often_option3></question1_answered_often_option3>
Q2FromXML '<question2></question2>
Q3FromXML '<question3></question3>
Right now, some of these values are already temporarily populated directly from lines 100-106 (from [login to view URL])
I would need this to be done quickly, if possible.
Thanks!
You should use XMLDocument instead of XMLReader. Using this method you will have any flexibility in processing the XML data format like this. If you agree using this method I will be able to complete this within 1 - 2 hours only.