Jim DeMarco
Jdemarco at hudsonhealthplan.org
Tue Aug 30 08:35:22 CDT 2005
Sorry I should have mentioned that even though I opened a file to get the XML for the example I just posted you can do the same with a DOM object already loaded in memory. Jim D. -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Francisco Tapia Sent: Tuesday, August 30, 2005 8:59 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] XML DOM to string? more info:, the online ordering system is a dot net application, it calls a webservice that I created using the SQLXML 3.0, that was quite easy and fun, the xml document is sent as a parameter string to me via that webservice to a stored procedure which uses openxml to place into tables, the front end application reads the data in the tables to let users know that there are new orders, they open up he order as they normally would for editing via the Access Interface. when the order is complete I then create a new xml copy of the order, because I now need to transfer the order to our enterprise system, the method is via soap call, because the enterprise system is in unidata, (odbc has been proven to be too slow and unreliable in context to our unidata system). so using the ms dom object I re-create the xml document at the client side to leverage my use of cpu cycles, but, i thought I could just send the dom as a string instead of an object since the stored procedure in sql server's parameter takes a string, not an object.. so to create the string from the dom I just do the following, first save the dom as an xml, then read it back in as so. Dim strBuff As String Open "c:\temp\123.xml" For Input As #1 strBuff = Input(LOF(1), 1) Close #1 I was hoping that maybe I didn't need to save the .xml file first and maybe I missed a property in the dom object. On 8/30/05, Jim DeMarco <Jdemarco at hudsonhealthplan.org> wrote: > Would using the FileSystemObject and opening a TextStream help at all? > > Jim DeMarco > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Francisco Tapia > Sent: Monday, August 29, 2005 11:38 PM > To: dba-vb at databaseadvisors.com > Subject: Re: [dba-VB] XML DOM to string? > > > Well the order starts as an XML string received from an online order, > this is captured and imported to a table that temorarily holds the > order as a pending order. This gets approved by our service dept., > but at this time I need to take the tablized data and re-convert it to > xml, since the data is on the back end (sql server) I initially > created an "For XML" query, but that proved to be of much use even tho > it was formated correctly. I then converted the recordset using MSXML > (dom) object. This works and was the sample xml format I posted > earlier. I wanted to just pass the dom object, but my sql server wich > makes the soap call takes a string object instead, I thought of just > calling the soap object from Access, but instead went ahead and did it > via sql server, reason for it is that I can save a round trip by > calling the sql server and having sql server update the local tables > instead of pushing data via the client once more... > > What I did to make the xml object a string, was to save it as an .xml > file, I then re-open the file w/ an Open file for input standard text > procedure and read the entire file to a string... > > i just wondered if at least for the last step i could avoid hitting > the disk, but i think it doesnt' really matter after all this hoop > jumping ;) > > On 8/29/05, MartyConnelly <martyconnelly at shaw.ca> wrote: > > Why not grab the intial html string returned down the wire by the soap > > call before you place it in the xmldom. > > It would look something like this. Just strip off the envelope xml code > > and use the soap body. > > Assuming you are using xmlhttp it would be contained in > > XMLHTTP.responseXML.xml > > rather than XMLHTTP.responseText. > > > > <?xml version="1.0"?> > > <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"> > > <soap:Body><FullZipCodeResponse xmlns="http://webservices.eraserver.net/"> > > <FullZipCodeResult>00000-0000</FullZipCodeResult> > > </FullZipCodeResponse> > > </soap:Body> > > </soap:Envelope> > > > > > > > > Francisco Tapia wrote: > > > > >Well I need the XML formated in the way I metioned earlier, that's > > >because I then make a call to a soap object in which it calls a PICK > > >database (Unidata) to deliver an order. Originally I had a For XML > > >call from sql server but I was not able to take that result and stuff > > >it into a variable, so I did it in VB, I have a class that I use to > > >create the xml as previously listed, so I finished my document, but > > >wanted to simply make the soap call when I realized that this was an > > >object and not a string, thus it wasn't gonna work. My current > > >solution is to save it temporarily to the disk and re-read it back to > > >a string variable as a text file using LOF, it works fine, and on my > > >system is actually really quick, but it was just a bother. > > > > > >On 8/29/05, Jim DeMarco <Jdemarco at hudsonhealthplan.org> wrote: > > > > > > > > >>Francisco, > > >> > > >>I'm not quite sure what you need to do. You can create the XML from data in your database and you can persist it into a file. Do you need the ability to read the same XML back into your database (with mods or to receive orders)? > > >> > > >>Jim DeMarco > > >> > > >>-----Original Message----- > > >>From: dba-vb-bounces at databaseadvisors.com > > >>[mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Francisco Tapia > > >>Sent: Monday, August 29, 2005 2:25 PM > > >>To: dba-vb at databaseadvisors.com > > >>Subject: [dba-VB] XML DOM to string? > > >> > > >> > > >>I'm messing around w/ XML and it's quite late I suppose since there > > >>really is so much I do not know... what I'm trying to do, I have a > > >>class that I use to create a complex XML, that is: > > >> > > >>I can save my xmldom object down to a file, but then I'd have to > > >>re-open it and read it all back into a string, and I wondered since > > >>it's in memory if I can just somehow save it to a string instead... > > >>any clues? > > >>Thanks > > >> > > >> > > >>WSOrder> > > >>- <Header> > > >> <CustID>FO440</CustID> > > >> <CompanyName /> > > >> <UserType /> > > >> <UserNo /> > > >> <Address1 /> > > >> <Address2 /> > > >> <Address3 /> > > >> <City /> > > >> <State /> > > >> <Zip /> > > >> <Country /> > > >> <Contact /> > > >> <Phone /> > > >> <Notes /> > > >> <ShipMethod /> > > >> <PurchaseOrder /> > > >> <ShipToID /> > > >> <SchedDate /> > > >> <Freight /> > > >> </Header> > > >>- <OrderItems> > > >>- <WSOrderItem> > > >> <PartNumber>93-1000</PartNumber> > > >> <Quantity>10</Quantity> > > >> <SerialNumber>21222</SerialNumber> > > >> </WSOrderItem> > > >>- <WSOrderItem> > > >> <PartNumber>22-2222</PartNumber> > > >> <Quantity>5</Quantity> > > >> <SerialNumber>50101</SerialNumber> > > >> </WSOrderItem> > > >>- <WSOrderItem> > > >> <PartNumber>33-3333</PartNumber> > > >> <Quantity>33</Quantity> > > >> <SerialNumber>696969</SerialNumber> > > >> </WSOrderItem> > > >> </OrderItems> > > >> </WSOrder> > > >> > > >> > > >>-- > > >>-Francisco > > >>http://pcthis.blogspot.com |PC news with out the jargon! > > >>http://sqlthis.blogspot.com | Tsql and More... > > >>_______________________________________________ > > >>dba-VB mailing list > > >>dba-VB at databaseadvisors.com > > >>http://databaseadvisors.com/mailman/listinfo/dba-vb > > >>http://www.databaseadvisors.com > > >> > > >> > > >> > > >>*********************************************************************************** > > >>"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". > > >>*********************************************************************************** > > >> > > >>_______________________________________________ > > >>dba-VB mailing list > > >>dba-VB at databaseadvisors.com > > >>http://databaseadvisors.com/mailman/listinfo/dba-vb > > >>http://www.databaseadvisors.com > > >> > > >> > > >> > > >> > > > > > > > > > > > > > > > > -- > > Marty Connelly > > Victoria, B.C. > > Canada > > > > > > > > _______________________________________________ > > dba-VB mailing list > > dba-VB at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-vb > > http://www.databaseadvisors.com > > > > > > > -- > -Francisco > http://pcthis.blogspot.com |PC news with out the jargon! > http://sqlthis.blogspot.com | Tsql and More... > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > > > *********************************************************************************** > "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". > *********************************************************************************** > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************