Wrox Programmer Forums
Classic ASP XML Using ASP 3 and XML. See also the XML category for more XML discussions not relating to ASP. NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 25th, 2004, 10:52 AM
ak ak is offline
Authorized User
Join Date: Sep 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default store a chunk of xml in a string

I want to read an xml file in asp page then create a string variable inorder to store a chunk from that xml file inorder that i can send it to sql server as a varchar data via stored procedure. any help?

i have the first part which is read the xml file into asp page:
SET objXMLDoc_bannerClicks = Server.CreateObject("Microsoft.XMLDOM")
objXMLDoc_bannerClicks.async = False
blnFileExist = objXMLDoc_bannerClicks.Load("bannerClicks.xml")

Old March 2nd, 2004, 12:44 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts

You can access the XML from the document (through the DOMDocument object) via the XML property (I think, it's been a while, but there is a property). You should be able to access XML at the node level also. I think you want to look for the XML and InnerXML properties. Look in the MSXML Parser SDK.

Similar Threads
Thread Thread Starter Forum Replies Last Post
xml column chunk Ameur537 .NET Web Services 0 November 21st, 2008 03:06 PM
Appending a chunk of XML to document mattTyson Ajax 0 December 7th, 2006 12:47 PM
Appending a chunk of XML to the document mattTyson BOOK: Professional Ajax ISBN: 978-0-471-77778-6 0 December 7th, 2006 12:44 PM
DTS Package, XML task. Read XML file and store it Victoria SQL Server DTS 0 July 24th, 2006 02:43 PM
store hyperlink into a string. europhreak Classic ASP Basics 1 February 2nd, 2006 11:16 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.