Jump to content

ASP to XML


mmcnab
 Share

Recommended Posts

I have a form with checkboxes, radio buttions and a text box. A user sumbits the form that is processed by this .asp form:<%@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><%'--------------------------------------------------------------------'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("RESPONSE") 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. 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:/inetpub/wwwroot/casino/mohegan","RESPONSE.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("Thank you for participating in our survey! Please use your 'BACK' button to return to your home page.")End If%></body></html>My problem is that every time a user submits a new form, the XML is overwritten. How do I 'store' or 'persist' the XML so that the inputs from multiple users will be available? I just need to save it into a .txt file or similar. I do not want to post back to SQL server. I'm relatively new to this and have been picking up pieces of code here and there. All was well until now! Thank you!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...