Newbie ASP Question

bake01 · bake01

I HAVE A RADIO BUTTON QUESTION SUCH AS:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<head>
<title>
Contact Information
</title>
</head>
<body>
<form action="xml2.asp" method="post">
<h3>What is your favorite color?</h3>

<p>
<label>
<input type="radio" name="RadioGroup1" value="red" />
red</label>
<br />
<label>
<input type="radio" name="RadioGroup1" value="blue" />
blue</label>
<br />
<label>
<input type="radio" name="RadioGroup1" value="green" />
green</label>
<br />
</p>
<input type="submit" id="btnSub" name="btnSub" value="Submit"><br>
</form>
</body>
</html>

</body>
</html>

AND THE ANSWER IS RETRIVED BY:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
xml2.asp: <%
'--------------------------------------------------------------------
'The "ConvertFormtoXML" Function accepts to parameters.
'strXMLFilePath - The physical path where the XML file will be saved.
'strFileName - The name of the XML file that will be saved.
'--------------------------------------------------------------------

Function ConvertFormtoXML(strXMLFilePath, strFileName)
'Declare local variables.
Dim objDom
Dim objRoot
Dim objField
Dim objFieldValue
Dim objattID
Dim objattTabOrder
Dim objPI
Dim x

'Instantiate the Microsoft XMLDOM.
Set objDom = server.CreateObject("Microsoft.XMLDOM")
objDom.preserveWhiteSpace = True

'Create your root element and append it to the XML document.
Set objRoot = objDom.createElement("contact")
objDom.appendChild objRoot

'Iterate through the Form Collection of the Request Object.
For x = 1 To Request.Form.Count
'Check to see if "btn" is in the name of the form element. If it is,
'then it is a button and we do not want to add it to the XML
'document".
If instr(1,Request.Form.Key(x),"btn") = 0 Then

'Create an element, "field".
Set objField = objDom.createElement("field")

'Create an attribute, "id".
Set objattID = objDom.createAttribute("id")

'Set the value of the id attribute equal the the name of the current
'form field.
objattID.Text = Request.Form.Key(x)

'The setAttributeNode method will append the id attribute to the
'field element.
objField.setAttributeNode objattID

'Create another attribute, "taborder". This just orders the
'elements.
Set objattTabOrder = objDom.createAttribute("taborder")

'Set the value of the taborder attribute.
objattTabOrder.Text = x

'Append the taborder attribute to the field element.
objField.setAttributeNode objattTabOrder

'Create a new element, "field_value".
Set objFieldValue = objDom.createElement("field_value")

'Set the value of the field_value element equal to the value of the
'current field in the Form Collection.
objFieldValue.Text = Request.Form(x)

'Append the field element as a child of the root element.
objRoot.appendChild objField

'Append the field_value element as a child of the field elemnt.
objField.appendChild objFieldValue
End If
Next

'Create the xml processing instruction.
Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'")

'Append the processing instruction to the XML document.
objDom.insertBefore objPI, objDom.childNodes(0)

'Save the XML document.
objDom.save strXMLFilePath & "\" & strFileName

'Release all of your object references.
Set objDom = Nothing
Set objRoot = Nothing
Set objField = Nothing
Set objFieldValue = Nothing
Set objattID = Nothing
Set objattTabOrder = Nothing
Set objPI = Nothing
End Function

'Do not break on an error.
On Error Resume Next

'Call the ConvertFormtoXML function, passing in the physical path to
'save the file to and the name that you wish to use for the file.
ConvertFormtoXML "c:","Contact.xml"

'Test to see if an error occurred, if so, let the user know.
'Otherwise, tell the user that the operation was successful.
If err.number <> 0 then
Response.write("Errors occurred while saving your form submission.")
Else
Response.write("Your form submission has been saved.")
End If
%>
</body>
</html>

WHICH CREATES THIS XML FILE:

<?xml version="1.0"?>
<contact><field id="RadioGroup1"
taborder="1"><field_value>red</field_value></field></contact>

MY QUESTION IS, HOW DO I COLLECT DATA FROM THOUSAND OF PEOPLE TO MY .XML FILE
AS EVERY TIME THE QUESTION IS ANSWERED, THE FILE CHANGES. I KNOW THIS MUST BE
A SIMPLE ANSWER BUT AFTER MUCH BROWSING, CAN'T FIND IT. THANKS!

TPK · TPK

Hi bake01,

Why not submit directly to a database? Each submit creates a record, all the
fields are mapped to the database. Your XML file would be perfect for that,
most databases will read it easily.

TPK

Newbie ASP Question

Thread Tools

Display

Newbie ASP Question

Similar Questions and Discussions

Newbie Question: Biz Card Template Question

A newbie with a newbie question

newbie question,,,

Pen Tool Use Question. (Embarrassingly Newbie Question)

Newbie OO question

Re: Newbie ASP Question

Posting Permissions