[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

XSLT and #temptable

Subject: XSLT and #temptable
From: pcaspian@xxxxxxxxxxx
Date: Fri, 25 May 2001 15:18:50 +0100
temptable
Hey, I am persisting to a file and I want to save the SQL recordset to it.

I incur a problem when I want to make use of a temporary table in my SQL
query.
Say for instance I want to have a large SQL query that saves information
into a 
temporary table #table1 and then I go "select * from #table1"

set PA = conn.execute(SQLsearch)
szFile = Server.MapPath(xmlfile)
PA.Save szFile, adPersistXML <- error falls on this line. 

('Operation is not allowed when the object is closed.')

Is this just a normal xsl problem ?

* Another question is a problem I have with regard to choosing between xsl
and VBScript. 
I am reasonably adequate with SQL queries and make use of these in my ASP
work. Now for instance 
I want to create a XML file that contains information from 2 tables (a
union as such), but if the same PK is 
found in the second table, it will always use the row from the second table
and discard the value from 
the first table. Now I can do this in SQL OK, but how difficult would it be
in XSL ? I have no actual XSL
books, just XML books containing XSL segments, so Im just curious if I
should rather just stick with making use of SQL with regard to this sort of
problem. I obviously would prefer to keep in touch with XSL, but would it
be a very steep learning curve ?

Also what is the efficiency of reading from a XML file compared to a SQL
query. I can see obviously the reduction in load on the SQL server should I
use more XML, but what about the impact on IIS. I mean, how fast would it
really be to read from am XML file, convert with XSL and then display ? 

* on another note, thanks to everyone that has helped me with queries so
far. Much appreciated.

Thanks

Karlo



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.