Re: XML + ASP
From: Robert J Egan (rob_j_egan_at_hotmail.com)
Date: 06/01/04
- Next message: Bob Barrows [MVP]: "Re: XML + ASP"
- Previous message: roisin: "delays in net send in .bat"
- Next in thread: Bob Barrows [MVP]: "Re: XML + ASP"
- Maybe reply: Bob Barrows [MVP]: "Re: XML + ASP"
- Reply: Mark Schupp: "Re: XML + ASP"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Jun 2004 13:27:01 +0100
Not sure where this should go as the output works fine when using a xml file
saved to my server, but when hitting the same result on a remote it doesn't.
The output is handled by a '.xsl' file, which outputs HTML as follows....
<html>
<body>
<h2>Courses</h2>
<table border="1">
<tr>
<td colspan="9">Search Phrase</td>
</tr>
<tr>
<td colspan="9">Records Returned</td>
</tr>
<tr bgcolor="#9acd32">
<th>CourseId</th>
<th>LDCS</th>
<th>Name</th>
<th>QualificationType</th>
<th>Description</th>
<th>LearnDirectFlag</th>
<th>Venue</th>
<th>AttendanceType</th>
<th>StartDetails</th>
</tr>
<tr>
<td>4988812</td>
<td>AK.6,FN.343</td>
<td>Accounting with French BA (Hons)</td>
<td>First Degree</td>
<td>3 year full time/ up to 8 years part time course run by Middlesex
University</td>
<td>TC</td>
<td>Hendon Campus</td>
<td>Full Time</td>
<td>Sep/04</td>
</tr>
<tr>
<td>4081296</td>
<td>AK.6,FN.343</td>
<td>Accounting with French BA (Hons)</td>
<td>First Degree</td>
<td>3 year full time/ up to 8 years part time course run by Middlesex
University</td>
<td>TC</td>
<td>Middlesex University</td>
<td>Full Time</td>
<td>Sep/04</td>
</tr>
................. etc
</table>
</body>
</html>
-------------
"Mark Schupp" <mschupp@ielearning.com> wrote in message
news:%23ZiqPMMREHA.1388@TK2MSFTNGP09.phx.gbl...
> Response.ContentType = "text/xml"
> Response.Write <xml string here>
> Response.End
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "Robert J Egan" <rob_j_egan@hotmail.com> wrote in message
> news:O6mY79LREHA.3504@TK2MSFTNGP09.phx.gbl...
> > Hi i'm trying to search a remote website page. The form returns xml
> > information, though the page extension is missing. I retrieve the
> > information and write it to the screen. So far so good - However i
cannot
> > format this information in anyway. A copy of the returned information
> saved
> > to my server results in the xml data being formatted and displayed as
> > intended! Can anyone explain to me why one would work but not the other.
> >
> > Regards
> >
> > Robert Egan
> >
> > -- Code Below --
> >
> > str_HC_url - variable formed from form information
> >
> > xml.Open "GET", str_HC_url , false - line of code used - does not work
> >
> > The above brings back info but cannot be formatted using code below.
> >
> > Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
> > xml.Open "GET", "http://www.accessburnley.co.uk/xml/asp/cdcatalog.xml"
,
> > false - alternate line of code - does work.
> > xml.Send
> > text = xml.ResponseText
> >
> > If xml.Status = 200 Then
> > Set oResponseXML = xml.ResponseXML
> > bXMLLoadError = False
> > Else
> > Response.Write("<font color=""red"">Page Error: Could not load XML
> from
> > remote server</font><br>")
> > bXMLLoadError = True
> > End If
> >
> > Set xml = nothing
> >
> > If Not bXMLLoadError Then
> >
> > // Load XML
> > set oXML = Server.CreateObject("Microsoft.XMLDOM")
> > oXML.Async = false
> > oXML.Load(oResponseXML)
> >
> > // Load XSL
> > set oXSL = Server.CreateObject("Microsoft.XMLDOM")
> > oXSL.Async = False
> > 'oXSL.Load(Server.MapPath("HotCourses.xsl"))
> > oXSL.Load(Server.MapPath("cdcatalog_ex3.xsl"))
> > // Transform
> > 'Response.Write(oXML.transformNode(oXSL))
> >
> > End If
> >
> >
>
>
- Next message: Bob Barrows [MVP]: "Re: XML + ASP"
- Previous message: roisin: "delays in net send in .bat"
- Next in thread: Bob Barrows [MVP]: "Re: XML + ASP"
- Maybe reply: Bob Barrows [MVP]: "Re: XML + ASP"
- Reply: Mark Schupp: "Re: XML + ASP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
