|
Kosta Cherry wrote:
is it any way to run XSLT processor withing ASP or JSP without using "CreateObject" method?
Yes, Look at the Apache XML code XALAN http://xml.apache.org/. For large processing it does not require the resources for a DOM implementation. That is the real issue (IMO), if you are having to go to disk to handle a DOM implementation and not for a SAX. If you know you have the resources I find that DOM works just as well. A warning though, The processing can be different between the two. A XSL file for one will not always give the same results when applied to the other.
If that is not acceptable. MSXML does have a SAX implementation. See
http://www.perfectxml.com/msxmlSAX.asp
Kosta Cherry wrote:
I cannot use any 3rd party software .
I have always been intrigued by this statement. MSXML is not 3rd party but XALAN / Xerces is, but the Apache code I can down load and look through.
"I will find a new sig someday."
|
|
|
|
|
i would transfrom the xml - and output it to a text file or session variable.
then when you get a request check the date of the xslt & xml file - if either are new regenerate the output.
otherwise just return the file/session variable as the output.
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
OK, I finally found answer (sort of) to my question and it is "SAX Parser with ASP" article at
http://www.experts-exchange.com/Web/Web_Languages/XML/Q_20150239.html
Here is copy of code from there (in case anyone interested):
<%Response.ContentType = "text/xml"
Dim generator, ch
' instantiate XML generator class
Set generator = Server.CreateObject("XMLFilesVBSAX.CGenerator")
Set ch = Server.CreateObject("XMLFilesVBSAX.CSerializer")
ch.RegisterOutputStream Response
generator.generateXML ch
%>
Then ->
<%Response.ContentType = "text/xml"
Dim reader, ch
' instantiate XMLReader class
Set reader = Server.CreateObject("MSXML2.VBSAXXMLReader.3.0")
' instantiate class that implements IVBSAXContentHandler
Set ch = Server.CreateObject("XMLFilesVBSAX.CSerializer")
ch.RegisterOutputStream Response
' turn off namespace prefixes
reader.putFeature "http://xml.org/sax/features/namespace-prefixes", False
' register ContentHandler implementation
Set reader.contentHandler = ch
' begin processing document
reader.parseURL "file://c:\temp\whatever.xml"
%>
And lastly ->
<%
Dim reader, ch
' instantiate XMLReader class
Set reader = Server.CreateObject("MSXML2.VBSAXXMLReader.3.0")
' instantiate class that implements IVBSAXContentHandler
Set ch = Server.CreateObject("XMLFilesVBSAX.CInvoice2HTML")
' turn off namespace prefixes
reader.putFeature "http://xml.org/sax/features/namespace-prefixes", False
' register ContentHandler implementation
Set reader.contentHandler = ch
' begin processing document
reader.parseURL "file://c:\temp\whatever.xml"
%>
Thanks for everybody!
|
|
|
|
|
Thanks for this info. I've never used SAX, and I did not know it could parse XSL. However, I note you've had to call 'CreateObject', I thought you were not allowed to ? :P
Christian
No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002
Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002
Again, you can screw up a C/C++ program just as easily as a VB program. OK, maybe not as easily, but it's certainly doable. - Jamie Nordmeyer - 15-Nov-2002
|
|
|
|
|
I am not allowed to create my own objects, but I could call existing ones
As far as I understand, government want to have all their projects to be written in one - two languages, so they could get rid of contractors after project finished and hire some idiots fresh from college to support all this trash
|
|
|
|
|
Kosta Cherry wrote:
I am not allowed to create my own objects, but I could call existing ones
Fair enough. In that case, I don't understand why you could not use the DOM, although it's certainly the case that SAX is more lightweight. I'm glad you asked this, I will use SAX myself in future in places where I've used to DOM.
Kosta Cherry wrote:
As far as I understand, government want to have all their projects to be written in one - two languages, so they could get rid of contractors after project finished and hire some idiots fresh from college to support all this trash
*grin* I see. In that case, I can see why 'no C++' was a requirement.
Christian
No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002
Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002
Again, you can screw up a C/C++ program just as easily as a VB program. OK, maybe not as easily, but it's certainly doable. - Jamie Nordmeyer - 15-Nov-2002
|
|
|
|
|
Hey Guys,
I've got an app that dumps some data as XML and I want to be able to use this data as the basis for a HTML report.
So, knowing nothing about XSL, can XSL do it for me? If so, can anyone give me some pointers about where to look?
Cheers
James
|
|
|
|
|
James Spibey wrote:
can XSL do it for me
Most definately, it is all just well formed text really.
Here is a good tut on it.[^]
Just remember it is all text and you won't go wrong. Don't get hung up on the buzz words sounding different.
Paul Watson
Bluegrass
Cape Town, South Africa
Colin Davies wrote:
...can you imagine a John Simmons stalker !
|
|
|
|
|
Thanks for that paul. Got it up and running in less than 5 minutes. 
Cheers
James
|
|
|
|
|
my hero.
but a vb link - oh the dark side of the force
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Philip Fitzsimons wrote:
but a vb link
LOL Well the site is called VBXML but what VB and XML have to do with each other I don't know. Anyway
Paul Watson
Bluegrass
Cape Town, South Africa
Colin Davies wrote:
...can you imagine a John Simmons stalker !
|
|
|
|
|
Paul Watson wrote:
LOL Well the site is called VBXML but what VB and XML have to do with each other I don't know.
It is just marketing to make comfortable those who do not wish to think still come. http://www.topxml.com[^] also works to those who do think.
"I will find a new sig someday."
|
|
|
|
|
Am encountering the following problem.
in my xml doc, there is elment as such:
<COMMAND function="Write"><![CDATA[$:set:mode EG]]></COMMAND>
the corresponding autogen xml schema from VS.NET returned
<xs:element name="COMMAND" minOccurs="0" maxOccurs="unbounded" >
<xs:complexType>
<xs:attribute name="function" form="unqualified" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
my understanding is the CDATA tag is asking the xml parser to ignore what is enclosed by the CDATA tag. By the same token, i would think the xml schema should also ignore the element value of COMMAND.
well, I isolated the xml schema validation is failing at this point. How should the xml schema really be to handle CDATA?
thanks,
huikm
|
|
|
|
|
Our app transforms xml data with xsl into html.
I use &#160;&#xD;&#xA; (space, carriage return, line feed) to separate data on different lines that eventually is displayed on an excel spreadsheet. After each line is a square that is undesirable.
Can anyone please tell me how to get rid of this square or how to display a line feed without it?
Thanks,
Lilian
|
|
|
|
|
this is realted to either:
&nbap;* your character encoding in your xslt
* or the fact that excel is not recognising the line feed - try missing out the line feed.
hope this helps.
|
|
|
|
|
After I retrieve the transformed CComBSTR that is produced with XML and xsl, I wrote code to parse through the wstring to replace the CRLF with a \n. I guess Excel didn't like what xsl did to it.
Lilian
|
|
|
|
|
A long time ago, I found an article on MSDN that had all the info for what version of the MSXML parser was included with what version of IE. Does anyone have a referece such as this? It was something as simple as:
IE v4.0 contains MSXML2
IE v4.1 contains MSXML2
...
IE v6.x contains MSXML3 (???)
Writing an app and if I know what version of XML was included with what version of IE (which is the standard browser), I know where to start. Know I'll need this in future apps.
Thanks!
AC
-AC
|
|
|
|
|
The KB article written for you[^]
lazy isn't my middle name.. its my first.. people just keep calling me Mel cause that's what they put on my drivers license. - Mel Feik
|
|
|
|
|
YOU ARE THE MAN! I'm sending you a fruitcake this year!
-AC
|
|
|
|
|
Andrew Connell wrote:
I'm sending you a fruitcake this year!
Aaarrgghh, poor chap. You are supposed to reward people for helping you, not subject them to the horrors of the *eery eye twitching music maestro* The Christmas Fruit Cake *crash of lightining, womens scream, eye of knewt, wing of bat...*.
Actually so long as there is no more than a milimetre of marzipan on the damned thing, I like fruit cakes (no, not those kind of fruit cakes all you sickos... I mean the one your auntie gives you and your mom keeps you away from in case you actually try to eat it! Most end up as doorstoppers or as "next years christmas" gifts)
Paul Watson
Bluegrass
Cape Town, South Africa
Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson
|
|
|
|
|
Paul Watson wrote:
no, not those kind of fruit cakes all you sickos
Hahaha, nice touch. Now I just need to find my info on each of the parsers (which one has the flaky XSL parser).
-AC
|
|
|
|
|
Could someone please look at the following code and tell me why I get the error below.
Sorry for the length of code.
=====ERROR on Page ======
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'child.Text'
/council_services/data/wastedata.asp, line 60
The error occurs no matter which field I choose from the database recordset.
Now the same code works fine with another database I used for testing, but not this one.
Please help.
=====END ERROR =====
Within the following code.
=====CODE=====
<%
'------------------------ DATABASE CONNECTION -----------------------------------------
'The database connection is done through the include file above.
'------------------------ XML DOM OBJECT CREATION ------------------------------------
'Create XMLDOM Object
Dim xmldoc
Set xmldoc = Server.CreateObject("Microsoft.XMLDOM")
'------------------------ BULK OF XML CODE ------------------------------------------------
If (xmldoc.childNodes.length = 0) Then
' Build the XML document, and asign the root node.
Set root = xmldoc.createNode("element", "council_services", "")
xmldoc.appendChild (root)
' Queries the database for customer data, this will be referenced later.
' Use recordset(0) where 0 is the order of the datafield of the recordset.
Sql = "SELECT StreetName, Area, Round, Day FROM WasteCollection"
Set rs = conn.Execute(Sql)
If Rs.eof or rs.bof then
'If there are no results from the search criteria, then put the following text
'onto the page
Response.Write "
" & "There are currently no information available, please try again." & "
"
Else
rs.MoveFirst
'Loop through the recordset
Do While Not rs.EOF
Set onode = xmldoc.createNode("element", "Waste", "")
xmldoc.documentElement.appendChild (onode)
'The following code, sets the child elements of the recordset
'to the xml data page.
'Set child = xmldoc.createNode("element", "CollectionStreet", "")
'child.Text = rs.fields(0)
'onode.appendChild (child)
'Set child = xmldoc.createNode("element", "CollectionArea", "")
'child.Text = rs.fields(1)
'onode.appendChild (child)
'Set child = xmldoc.createNode("element", "CollectionRound", "")
'child.Text = rs.fields(2)
'onode.appendChild (child)
Set child = xmldoc.createNode("element", "CollectionDay", "")
child.Text = rs.fields(2)
onode.appendChild (child)
rs.movenext
Loop
Set rs = Nothing
'Save the XML doc, this will be saved to the folder which contains the asp pages.
xmldoc.save server.mappath("wastedata.xml")
'--------------------------- DISPLAY THE XML DATA ---------------------------------------------
' Linking XML and XSL together
sourceFile = Server.MapPath("wastedata.xml")
styleFile = Server.MapPath("wastedata.xsl")
'Create the microsoft DOM object for both source and style (xsl) pages.
set source = Server.CreateObject("Microsoft.XMLDOM")
source.async = false
source.load(sourceFile)
set style = Server.CreateObject("Microsoft.XMLDOM")
style.async = false
style.load(styleFile)
Response.Write source.transformNode(style)
End If
End If
=====END CODE=====
The four fields form the database are all Varchar.
I would much appreciate some response to the about please.
Gazzer.
|
|
|
|
|
Hi,
I have converted a delimited text file to a DataTable and added to a new DataSet. I will add more than 1 table to this DataSet.
Then my next task is to convert these tables into serveral xml files.
For example, for the Category Table, I will have to make an xml file which contain datas where category num < 1000, and another xml file which contain datas where category num > 1000. However, since the WriteXml only belongs to the DataSet Object, but not the DataTable object, how do I do this????? ??????
Please help meeeee!!!! 
|
|
|
|
|
I'm not sure - are you asking how to write an XSL sheet to return the XML you want from the master document ? If not, this question would be better asked in the C# forum, because it relates to the .NET framework, more than XML itself.
Not wanting to be picky, it's just that, well, if you look at how many posts this forum has had, and how many the C# forum has had, you do the math. You'll get more airplay there if you're asking what I think. If you want to create an XSL, that's another matter, just say so and provide some sample XML and I'd be happy to help. I don't know the answer if the question relates to using ADO.NET components to extract a subset of the data as XML.
Christian
No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002
Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002
During last 10 years, with invention of VB and similar programming environments, every ill-educated moron became able to develop software. - Alex E. - 12-Sept-2002
|
|
|
|
|
Oh, thank you Christian!
I guess you are right! I should have posted this message to the ADO.NET one!
How about a question like this: How to get a subset from an xml?
Example:
The spreadsheet table is like this :
Category | SubCategory | AttributeName
----------------------------------------
Ottawa Tables Dimensions
Ottawa Chairs Weight
Alberta Tables Dimensions
Kingston Tables Dimensions
Alberta Chairs Weight
Right now I have an xml file which contains all the above datas.(It's a bit long, so I didn't type it out).. What I want to do is to make a new xml file named: Ottawa.xml where it only contains the following:
<Datas>
<Entry>
<SubCategory>Tables</SubCategory>
<AttributeName>Dimensions</AttributeName>
</Entry>
<Entry>
<SubCategory>Chairs</SubCategory>
<AttributeName>Weight</AttributeName>
</Entry>
</Datas>
Is there any possible way??? Please??? 
Karen
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
