[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XSLT and #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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|