Re: [WebDNA] Generating Excel File Via WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104666
interpreted = N
texte = >> On 30/01/2010, at 12:21 PM, Terry Nair wrote:>>>>> Hi all,>>>>>> Got a client that wants to extract a range of data from an >>> existing WebDNA>>> DB server ...not an issue. He wants the data extracted to be an >>> Excel file>>> that shows up as a link ... [snip]>>>>>> Many thanks ...Terry Nair> On Feb 1, 2010, at 12:46 AM, Toby Cox wrote:>> we use returnraw>> [ReturnRaw binarybody=../db/[database].db]HTTP/1.0 200 OK[unurl]%0D > %0A[/unurl]Content-type: application/vnd.ms-excel[unurl]%0D%0A[/ > unurl]Content-Disposition: attachment; > filename="[database].xls"[unurl]%0D%0A%0D%0A[/unurl][include file=../ > db/[database].db][/ReturnRaw]Thank you Toby!I thought there was something possible to solve this with [ReturnRaw]!.. but I had not played with it to go around offering specific examples.I wanted this for my own notes, not to mention to suggest it for Terry.------------Govindagovinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
>> On 30/01/2010, at 12:21 PM, Terry Nair wrote:>>>>> Hi all,>>>>>> Got a client that wants to extract a range of data from an >>> existing WebDNA>>> DB server ...not an issue. He wants the data extracted to be an >>> Excel file>>> that shows up as a link ... [snip]>>>>>> Many thanks ...Terry Nair> On Feb 1, 2010, at 12:46 AM, Toby Cox wrote:>> we use returnraw>> [ReturnRaw binarybody=../db/[database].db]HTTP/1.0 200 OK
[unurl]%0D > %0A[/unurl]Content-type: application/vnd.ms-excel
[unurl]%0D%0A[/ > unurl]Content-Disposition: attachment; > filename="[database].xls"
[unurl]%0D%0A%0D%0A[/unurl][include file=../ > db/[database].db][/ReturnRaw]Thank you Toby!I thought there was something possible to solve this with
[returnraw]!.. but I had not played with it to go around offering specific examples.I wanted this for my own notes, not to mention to suggest it for Terry.------------Govindagovinda.webdnatalk@gmail.com
Govinda
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WebDNA] Create PDF (2015)
[showif] not working (2003)
Interfacing WC with mail server (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Languages (1997)
WebCat2b12 - nesting [tags] (1997)
Getting Total Quantity (1997)
Quiestion (1997)
WebCat2 several catalogs? (1997)
Server Jumping and Web-networking (2000)
Auto-email upon restart? (2001)
Summary search -- speed (1997)
[LOOKUP] (1997)
ErrorLog with Linux? (2000)
[WebDNA] feature suggestion (2011)
shipping help (1998)
OT Hosting Q again. (2002)
b12 cannot limit records returned and more. (1997)
File not found error message (1998)
Date problem still... (2004)