Well, If the XML is correct then the problem should be in the way you are putting it into the DB. I have no AccessXP but it should not be a problem. Say something about this phase.
-----Original Message----- From: Chris Mortimer [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 1:37 PM To: ActiveServerPages Subject: Re: Returning XML from asp page and other Really sorry, I didn't notice that I'd left the > stuff in, I'd put them there so I could see the xml results on the page. The original script follows the same format you correctly outlined. I hadn't included the content text/xml in the original script but will try it. Unfortunately I am an xml virgin, having only 1.5 days learning and am struggling with time to sort this out. Logically I can follow it but obviously without the experience I am struggling. Thanks for the help and any other ideas would be really helpful ----- Original Message ----- From: "Michael Elfial" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 11:16 AM Subject: RE: Returning XML from asp page and other > Hi, > > See the Marco's note and also do not use these > >, < (called entities officially). As I understood > that code generates XML and as I can see the > repsponse.write calls are intended to create such things > like: <tblUsers> and so on. The output you are creating is > definitelly not a XML. See these <BR> tags and so on. > > In fact you are escaping the XML markups. Well a little > example doneover your code (I am writting without testing > thus check for typing mistakes): > > While Not rsUsers.EOF > Response.Write "<tblUsers>" & vbCrLf > For each TblField in rsUsers.Fields > Response.Write "<" & TblField.Name & ">" & TblField.value & _ > "</" & TblField.name & ">" & vbCrLf > Next > Response.Write "</tblUsers>" & vbCrLf > rsUsers.MoveNext > Wend > > Something like that. vbCrLf can be omitted but with it the > generated code will look better and you will be able to perform > manual cheking. > > Notes: The TblField.value should be escaped if you expect some > values to contain resrved XML characters. In other words here is > the place where < must become <. Using Server.HTMLEncode will > be ok for XML in most cases. > > See if something else will not be better. Take a look at the MSXML > components and see if creating the XML tree using the components > will be more convenient for you. It will require a bit more code > but will give you some additional opportunities. > > > > > -----Original Message----- > From: Chris Mortimer [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 11:32 AM > To: ActiveServerPages > Subject: Re: Returning XML from asp page and other > > > 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.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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
