Downloading a recordset

[Kris Eiben]

You can pull the whole recordset into a variable using rs.GetString(),
formatted as .csv if you want. This example pulls in a recordset as a
table, but you can pretty easily convert to a .csv file:
[url]http://www.learnasp.com/learn/dbtablegetstring.asp[/url]

"Mitchell Nussbaum" <nussbm@dnr.state.wi.us> wrote in message
news:eGSwYJGWDHA.652@tk2msftngp13.phx.gbl...

> I have an .asp application that retrieves a table into an ADO

recordset and

> retrieves it as an HTML table.
>
> I would like to give users the option of downloading the contents of

the

> recordset as a .csv file, but I can't figure out how to do that. I've

found

> examples of code that download pre-existing files from the server to

the

> desktop, but I'd prefer not to have the script write a file on the

server if

> possible. So I'd like to construct the .csv records line by line, and

send

> them to a specified file on the client machine.
>
> Is there a way to do this? Or is there some other solution to my

problem?

[Ray at]

Just at first thought without thinking about the code, I'd probably create
my recordset, use GetString to delimit the columns by , and the rows by
vbCrLf, and then either write that to a file with the FSO and redirect to
it, or stream the file back to the user in an adodb.stream.

If you get stuck on the code, post back.

Ray at work

"Mitchell Nussbaum" <nussbm@dnr.state.wi.us> wrote in message
news:eGSwYJGWDHA.652@tk2msftngp13.phx.gbl...

> I have an .asp application that retrieves a table into an ADO recordset

and

> retrieves it as an HTML table.
>
> I would like to give users the option of downloading the contents of the
> recordset as a .csv file, but I can't figure out how to do that. I've

found

> examples of code that download pre-existing files from the server to the
> desktop, but I'd prefer not to have the script write a file on the server

if

> possible. So I'd like to construct the .csv records line by line, and

send

> them to a specified file on the client machine.
>
> Is there a way to do this? Or is there some other solution to my problem?
>
> Mitch Nussbaum
> Wisconsin Dept of Natural Resources
> [email]Mitch.Nussbaum@dnr.state.wi.us[/email]
>
>
>

[Mitchell Nussbaum]

"Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote in message
news:OFclJPGWDHA.892@TK2MSFTNGP10.phx.gbl...

> You can pull the whole recordset into a variable using rs.GetString(),
> formatted as .csv if you want. This example pulls in a recordset as a
> table, but you can pretty easily convert to a .csv file:
> [url]http://www.learnasp.com/learn/dbtablegetstring.asp[/url]

Thanks for this suggestion. I incorporated GetString in my code, and it's
really neat. Actually, I'd seen documentation for GetString before, but I
didn't pay much attention, since, at the time, it didn't look like something
I could use.

But I do have a problem with GetString for this particular application.
Some of the values I retrieve have embedded commas, which Excel sees as a
column delimiter when it reads a .csv file. So some values split into
multiple cells. When I create a .csv format row-by-row with my own code, I
enclose string values in quotes to keep values from splitting. Is there a
way to force GetString to do the same?

>
> "Mitchell Nussbaum" <nussbm@dnr.state.wi.us> wrote in message
> news:eGSwYJGWDHA.652@tk2msftngp13.phx.gbl...

> > I have an .asp application that retrieves a table into an ADO

> recordset and

> > retrieves it as an HTML table.
> >
> > I would like to give users the option of downloading the contents of

> the

> > recordset as a .csv file, but I can't figure out how to do that. I've

> found

> > examples of code that download pre-existing files from the server to

> the

> > desktop, but I'd prefer not to have the script write a file on the

> server if

> > possible. So I'd like to construct the .csv records line by line, and

> send

> > them to a specified file on the client machine.
> >
> > Is there a way to do this? Or is there some other solution to my

> problem?
>
>

[Bullschmidt]

Puzzle 5 Not much different from other solutions by Manohar Kamath
posted 1/12/99
[url]http://www.asp101.com/puzzles/puzzle5_s7.asp[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!