navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Using XML-formatted data on a site

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Using XML-formatted data on a site
Page: [1]
 
pmagas

 

Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline

 
Using XML-formatted data on a site - 6/20/2002 21:52:23   
I'm a little over my head here, but that's how we learn, right? I manage a real estate site. Our MLS (multiple listing service) offers us three ways to offer our visitors a search of the database. One is simply framing - but their format is crude (at best) and the only information about a house that it gives is the name & number of the listing agent. To top it off, they include properties that are already under contract. The next option is to 'gateway.' But what the heck is that? They don't offer any information about that and I'm totally lost.

Finally, we can download the database and have our customers search it from our server. My hosting service doesn't have a problem with server space. BUT they're pretty young and aren't quite sure what to do with the data in XML format. (Although I'm not young, I don't really know anything about XML.)

Do any of you have any suggestions? Is there some software out there that will help me interface this data into my website? Thank you SO much for any direction you might be able to offer.

Penny
FrontPageHowTo.com

 

Posts: 43
Joined: 6/20/2002
From:
Status: offline

 
RE: Using XML-formatted data on a site - 6/21/2002 10:54:42   
Hi Penny,

So you have XML as the data source? What you need to do is build an XSL page to transform the raw XML into HTML format. When that is done, you can use ASP to load the XML and XSL transform. Here's a function we built for a particular project that does this:

'-------------------------------------------------------------------
'This function accepts two paramters:
'strXMLFile - The XML file that you wish to view
'strXSLFile - The XSL stylesheet that will transform the XML file
'-------------------------------------------------------------------
Function loadXMLFile(strXMLFile, strXSLFile)
'Declare local variables
Dim objXML
Dim objXSL
Dim objNode
'Instantiate the XMLDOM Object that will hold the XML file.
set objXML = Server.CreateObject("Microsoft.XMLDOM")
'Turn off asyncronous file loading.
objXML.async = false
'Load the XML file.
objXML.load(strXMLFile)
'Instantiate the XMLDOM Object that will hold the XSL file.
set objXSL = Server.CreateObject("Microsoft.XMLDOM")
'Turn off asyncronous file loading.
objXSL.async = false
'Load the XSL file.
objXSL.load(strXSLFile)
'Use the "transformNode" method of the XMLDOM to apply the XSL
'stylesheet to the XML document. Then the output is written to the
'client.
Response.Write(objXML.transformNode(objXSL))
End Function

Of course what you are talking about is a lot more complicated than this example. You probably want to allow various methods of searching and narrowing down of criteria etc.

I don't think that the software is quite there yet for building these types of interfaces unless you want to use Visual Studio .NET and ASP.NET. If you want to do this yourself, your best bet would be to start learning about ASP and XML.

FrontPageHowTo.com
FrontPage Database Examples
www.frontpagehowto.com

(in reply to pmagas)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Using XML-formatted data on a site
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts