Re: Persisting ADO as XML - almost convinced i'm crazy!

From: Kelly C (kelly.cromwell_at_synergisticbe.com)
Date: 12/21/04

  • Next message: Tom Moreau: "Re: Persisting ADO as XML - almost convinced i'm crazy!" 
    Date: Tue, 21 Dec 2004 19:59:56 GMT

    Thanks, I guess I wasn't going crazy at all .... bah, stupid non standards
    lol ..

    all hail .NET

    "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
    news:uS39$X55EHA.3120@TK2MSFTNGP12.phx.gbl...
    > Try adding the following at the top of your code:
    >
    > Const adPersistXML = 1
    >
    > --
    > Tom
    >
    > ---------------------------------------------------------------
    > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    > SQL Server MVP
    > Columnist, SQL Server Professional
    > Toronto, ON Canada
    > www.pinnaclepublishing.com
    >
    >
    > "Kelly C" <kelly.cromwell@synergisticbe.com> wrote in message
    > news:cYZxd.562280$%k.318934@pd7tw2no...
    > Alright folks, this is something i've done a few times before, and I think
    > i'm suffering from analysis paralysis ... so some fresh eyes' would be
    > appreciated. What i'm trying to do is run a query, take the resulting
    > ADO.Recordset and save it as an xml file. This is what i'm doing in an
    asp
    > file:
    >
    > strSQL = "SELECT * FROM TABLE"
    > Set rsMyRecordset= Server.CreateObject("ADODB.Recordset")
    > rsMyRecordset.Open strSQL, myConnection, adOpenStatic
    >
    > if rsMyRecordset.BOF and rsMyRecordset.EOF then
    > Response.write("No RecordsFound.")
    > else
    > rsMyRecordset.Save "C:\test.xml", adPersistXML
    > end if
    >
    > okay ... now basically what's happening is, i'm getting a test.xml file
    that
    > looks identical to the binary file I get when I drop the adPersistXML
    > option. Am I forgetting something? Why won't it just save as text!!!???
    >
    >

  • Next message: Tom Moreau: "Re: Persisting ADO as XML - almost convinced i'm crazy!"

    Relevant Pages

    • Re: Why will we never see anything even remotely resembling decent standards compliance in SQL Serve
      ... > it is a considerable undertaking to cram in all the features that would ... *Anyone* who writes any code for SQL Server should demand standars compliance ... SQL Server already uses such mechanisms to govern code-breaking standards ...
      (microsoft.public.sqlserver.server)
    • Re: datetime month question
      ... Learn to write code to Standards; it will save you and the ... poor bastards that have to maintain code a lot of problems. ... totally different way than SQL Server, ... MySQL has a dialect convention that zeros in the month or ...
      (microsoft.public.sqlserver.programming)
    • Re: Cant connect to SQL Server(SQL Express) in VS 2005
      ... LOL ... I do not know why your SQL Server won't work. ... the Xbox portable is built using Transmeta chips.. ...
      (microsoft.public.dotnet.languages.vb)
    • SQL Server Standards Documentation
      ... The purpose of this document is to outline SQL Server standards and best ... Hardware / Operating System Configurations 3 ... Enterprise Edition Installation Screenshots 12 ...
      (microsoft.public.sqlserver.server)
    • Re: Looking for contract work
      ... SQL Server ... do you have a philosophy? ... All hail the mighty Viv Savage! ...
      (comp.databases.pick)