Have you tried doing an ExportXML from your database to see what the XML should look like? I am pretty sure ImportXML uses a different format (MDC OIM DTD) than the ADO recordset as adPersistXML (the "rowset" schema).
Also, you may need to open the database for exclusive access - I'm not quite sure about this one. HTH, Tore. -----Original Message----- From: Chris Mortimer [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:36 AM To: ActiveServerPages Subject: Re: Returning XML from asp page and other Have now made amendments suggested, i.e. including content type and still no luck. OfficeXP allows you to import xml data using the line below :- Application.ImportXML webURL & "nmquote/admin/myusers.asp", acStructureAndData The xml is then placed in acStructureAndData. I would then append this to my table, however, I can't get past this line because AccessXP complains :- Method 'importXML' of object '_Application' failed If I then try again I receive subsequent err messages saying 'automation err'. Seems so simple! Why won't it work!!!!! ----- Original Message ----- From: "Michael Elfial" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 1:15 PM Subject: RE: Returning XML from asp page and other > 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.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]
