Passing recordset objects to XML

bigear · #1 (**permalink**) 03-05-03, 10:02

Hi,
I'm trying to pass ASP recordset to xml, I have no idea how to do this can anyone help, the goal is to send customised text messages from my site at the moment I can send test messages
xml file...
<?xml version ="1.0" encoding="ISO-8859-1"?>
<aspsms>
<Userkey></Userkey>
<Password></Password>
<Recipient>
<PhoneNumber></PhoneNumber>
</Recipient>
<MessageData>Test </MessageData>
<Action>SendTextSMS</Action>
</aspsms>

rhs98 · #2 (**permalink**) 03-09-03, 20:50

ASP record set --> XML is easy

you would just iterate through the rs ouputting the fields as bellow;

Code:

<%
response.contenttype="text/xml"
'make the rs and query
%>
<?xml version ="1.0" encoding="ISO-8859-1"?>
<aspsms>
<%
while not blah.bof or blah.eof
%>
<Userkey><%=blah.fields("messagedata")%></Userkey>
<Password><%=blah.fields("messagedata")%></Password>
<Recipient>
<%
'make sub query if needed
while not blah2.bof or blah2.eof
%>
<PhoneNumber></PhoneNumber>
<%
 blah2.movenext
wend
%>
</Recipient>
<MessageData><%=blah.fields("messagedata")%></MessageData>
<%
 blah.movenext
wend
%>
<Action>SendTextSMS</Action>
</aspsms>
<%
'clean up etc

Internet Services

Web Development

Digital Marketing

Consumer Tech