Professional Web Applications Themes

creating csv's from asp - ASP Components

Can anyone pls help. I'm just getting into asp and I want to do something that, in Access I could probably do with my eyes shut but, in asp it seems to be just about an impossibility. I've read the books and the kb articles and none seem to work for my intranet server or the web server I'm uploading to. I want to save (export?) the contents of a recordset (sql query) to a file on the server then attach it to an email to send to an administrator. I've tried various forms of ADO - connections, records, streams ...

  1. #1

    Default creating csv's from asp

    Can anyone pls help.

    I'm just getting into asp and I want to do something that, in Access I could
    probably do with my eyes shut but, in asp it seems to be just about an
    impossibility. I've read the books and the kb articles and none seem to work
    for my intranet server or the web server I'm uploading to.

    I want to save (export?) the contents of a recordset (sql query) to a file
    on the server then attach it to an email to send to an administrator.

    I've tried various forms of ADO - connections, records, streams and each
    seems to give one error or another.

    It is driving me demented.

    Terry Reader

    Associate Partner
    European Education Consultants
    [url]www.schoolshealthandsafety[/url] .co.uk

    Online animal sanctuary Register
    [url]www.animalsanctuaries[/url] .co.uk



    TR Guest

  2. #2

    Default Re: creating csv's from asp

    "TR" <trtr> wrote in message news:O6VhUxZRDHA.2152TK2MSFTNGP12.phx.gbl...
    > Can anyone pls help.
    >
    > I'm just getting into asp and I want to do something that, in Access I
    could
    > probably do with my eyes shut but, in asp it seems to be just about an
    > impossibility. I've read the books and the kb articles and none seem to
    work
    > for my intranet server or the web server I'm uploading to.
    >
    > I want to save (export?) the contents of a recordset (sql query) to a file
    > on the server then attach it to an email to send to an administrator.
    >
    > I've tried various forms of ADO - connections, records, streams and each
    > seems to give one error or another.
    Worst case, you could write out the data in a csv format using the
    FileSystemObject.
    [url]http://msdn.microsoft.com/library/default.asp?URL=/library/devprods/vs6/vbasic/vbenlr98/vaobjFileSystemObject.htm[/url]

    --
    Tom Kaminski IIS MVP
    [url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
    [url]http://mvp.support.microsoft.com/[/url]
    [url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]



    Tom Kaminski [MVP] Guest

  3. #3

    Default Re: creating csv's from asp

    Are you getting an error creating the recordset, or are you trying some
    method that's throwing the error?

    You should be able to use the GetString method on the recordset to
    create csv format, something like this (not sure about the chr(10) &
    chr(13) syntax, may have to play with that):
    sCsvFormatString = rs.GetString(,,",",chr(10) & chr(13),"null text")

    Then use FileSystemObject to write that out to a file. Full details
    here:
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script5[/url]
    6/html/FSOoriFileSystemObject.asp

    If you run into trouble, please post the code you're using and the
    specific error message (number and text) you're getting.

    "TR" <trtr> wrote in message
    news:O6VhUxZRDHA.2152TK2MSFTNGP12.phx.gbl...
    > Can anyone pls help.
    >
    > I'm just getting into asp and I want to do something that, in Access I
    could
    > probably do with my eyes shut but, in asp it seems to be just about an
    > impossibility. I've read the books and the kb articles and none seem
    to work
    > for my intranet server or the web server I'm uploading to.
    >
    > I want to save (export?) the contents of a recordset (sql query) to a
    file
    > on the server then attach it to an email to send to an administrator.
    >
    > I've tried various forms of ADO - connections, records, streams and
    each
    > seems to give one error or another.
    >
    > It is driving me demented.

    Kris Eiben Guest

Similar Threads

  1. creating shared folder location hanges when creating a review
    By Carma_Schramm@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: July 28th, 05:34 AM
  2. I need help creating a CMS
    By GG02 in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: November 7th, 03:30 AM
  3. help with rss creating code creating an XML rss feed]
    By Wayne... in forum PHP Development
    Replies: 0
    Last Post: July 6th, 04:20 PM
  4. creating pop ups on cd-rom
    By SuperMilku in forum Macromedia Director Basics
    Replies: 1
    Last Post: April 9th, 10:25 PM
  5. Creating WWW
    By kkkPL webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 9
    Last Post: August 26th, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139