ClueLess
11-13-2002, 08:19 PM
I am so new to XML. This is my very 1st project using XLM to get information from DB and Submit new information back to DB…I need your help.
Well, I am using XML method to retrieve information from DB.
'Get Information from DB:
Set mainNode = root.selectSingleNode("ID[@ID = '" & ID & "']")
<% 'Get Information of given ID
If mainNode.hasChildNodes = true Then
Set ChildNode = mainNode.selectSingleNode("Property") %>
<form action="InfoEdit.asp" method="post" name="SubmitForm" onsubmit="GiveDate()">
<table>
<tr>
<td width="180">Name: </td>
<td align="left">
<% dim Name
Name = ChildNode.attributes.getNamedItem("Name").nodeValue %>
<INPUT type="text" id="Name" name="Name" value="<%= (Name) %>">
</td>
</tr>
<tr>
<input type="submit" value="Update">
</tr>
</table>
</form>
<% end if%>
The question is: after I make a change....How can I submit new information back to DB from childnode to parentnode?
Well, I am using XML method to retrieve information from DB.
'Get Information from DB:
Set mainNode = root.selectSingleNode("ID[@ID = '" & ID & "']")
<% 'Get Information of given ID
If mainNode.hasChildNodes = true Then
Set ChildNode = mainNode.selectSingleNode("Property") %>
<form action="InfoEdit.asp" method="post" name="SubmitForm" onsubmit="GiveDate()">
<table>
<tr>
<td width="180">Name: </td>
<td align="left">
<% dim Name
Name = ChildNode.attributes.getNamedItem("Name").nodeValue %>
<INPUT type="text" id="Name" name="Name" value="<%= (Name) %>">
</td>
</tr>
<tr>
<input type="submit" value="Update">
</tr>
</table>
</form>
<% end if%>
The question is: after I make a change....How can I submit new information back to DB from childnode to parentnode?