Select items and download as file

Forum|Forum|18 years ago
April 19, 2007
6 replies
484 views

I have a simple mysql database table, which is displayed as "Select
newsID, newshead, newsdate". The results I would like to offer as a
download file. Is there a way to accomplish that?

Regards
Martin Lang

Server side applications

This topic has been closed for replies.

N

Newsgroup_UserAuthor

Inspiring

Thanks :))

N

Newsgroup_UserAuthor

Inspiring

lol Didn't hit paste!! ooOOPS!

http://www.w3schools.com/asp/prop_contenttype.asp

--
Piers

N

Newsgroup_UserAuthor

Inspiring

Thank you for your help. Although I'm working with php I would like to
study your solution for ASP/VB. Could you give me the link?

Martin Lang

N

Newsgroup_UserAuthor

Inspiring

If you're using ASP VBScript, example here of how to download as an Excel
file.

Just adapt the HTML table for your code.

--
Piers

N

Newsgroup_UserAuthor

Inspiring

Hi geschenk,

thank you for the links, but even the first one is far beyond my
abilities. So downloading the results as excel-file or just as simple
textfile would do it.

Martin Lang

Günter_Schenk

Inspiring

Hi Martin,

when exporting to Excel, you could for instance use FelixOne´s FX Import-Export CSV extension or Linecraft´s "Export to Excel" Server Behavior which both will generate a Comma-delimited (.csv) file out of a Recordset without writing it to the hosting server. Your web site user will be prompted to save the file to the hard drive to be open with Microsoft Excel.

"Linecraft" also provides an extension suite named "Save to Microsoft Word or Excel" that´s exporting a web page (not a recordset) as either Word (doc) or Excel (xls) file.

For other related solutions just google for "dreamweaver extension excel export "

Günter_Schenk

Inspiring

>>
The results I would like to offer as a download file
>>

what file type ? what´s your server side scripting language, PHP ?

>>
Is there a way to accomplish that?
>>

you´d probably need a server side "on the fly" generation of the respective recordset´s result to, say, PDF. For PHP you´ll find some existing solutions like the R&OS pdf class for generating rather simply structured PDF´s or html2ps and html2pdf for generating "advanced" PDF´s

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded