Ok, I knew someone out there could help.
Ok, although I have two problems I'll address the first problem first and
get to the second problem later.
I am using an AccessXP database which will import xml into my users table.
The Access db will be situated on the clients machine and the XML will
created via an .asp file on our server. I have included the magic .asp
below.
I am assuming that this .asp should be sufficient to return the data.
I know the access side of things works because I produced a version of this
.asp that actually displayed the results and save them to a file and the
access db would import this file.
This indicates, to me, that the xml is correct but for some reason the .asp
file is going wrong somewhere.
Thanks.
<!--#include file="../../Connections/includer.asp" -->
<%
on error resume next
set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.ActiveConnection = MM_NemarkQS_STRING
rsUsers.Source = "SELECT * FROM UsersTable"
rsUsers.CursorType = 0
rsUsers.CursorLocation = 2
rsUsers.LockType = 3
rsUsers.Open()
rsUsers_numRows = 0
response.write "<dataroot
xmlns:od=""urn:schemas-tblUsers-com:officedata""
xmlns:xsi=""http://www.w3.org/2000/10/XMLSchema-instance"";
xsi:noNamespaceSchemaLocation=""tblUsers.xsd"">" & "<br>"
While Not rsUsers.EOF
response.write "<tblUsers>" & "<br>"
For each TblField in rsUsers.Fields
Response.Write "<" & TblField.Name &">" & TblField.value &"</" &
TblField.name &">" & "<br>"
Next
response.write "</tblUsers>" & "<br>"
rsUsers.MoveNext
Wend
response.write "</dataroot>"
rsUsers.Close()
set rsUsers = nothing
%>
----- Original Message -----
From: "Michael Elfial" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 4:54 PM
Subject: RE: Returning XML from asp page and other
> Hm, it is not clear what is the problem. Someone will help
> for sure - this list always helps :) but specify a bit more
> about how the XML is generated and probably a few lines from
> these two pages.
>
> you can generate XML "manualy" - just printing in the output
> or create DOM or use ADO's abilities and so on. I lost the
> track somewhere in the middle of the sentences - that's why more
> details will be probably needed.
>
> -----Original Message-----
> From: Chris [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 5:21 PM
> To: ActiveServerPages
> Subject: Returning XML from asp page and other
>
>
> Can anyone help me?
>
> I have two XML related problems.
>
> Problem 1.
>
> I'm using an offline access xp db to 'importxml' some xml from an asp.
> The db is on the clients machine and he needs to connect online throught
> the db to the .asp to retrieve the xml data.
>
> The .asp querys an online access db and should build the xml based on the
> contents of the table.
>
> The offline db will download a normal .xml file, but not the xml produced
> from the .asp. Why???
>
> Any help on this would be brilliant.
>
> Problem 2.
>
> We need to post some xml via our .asp page to another .asp page on another
> site. Can't seem to get the connection going, code seems correct. Can
> anyone provide any help.
>
> Sorry if these details seem sparse but am willing provide whatever
> information should anyone be able to help.
>
> Chris
>
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
> %%email.unsub%%
>
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
>
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
