Thanks, all that Visual Basic has rotted my mind. Hutch
-----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:16 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Download Tab Delimited File From SQL Query You have a typo "<@chr 9><@CRLF>" should be "<@char 9><@CRLF>" in the second replace assignment Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hutch White Sent: Friday, June 07, 2002 6:38 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Download Tab Delimited File From SQL Query Ok, this results in a file download of the text file. Only problem is that instead of the data I want, the downloaded file is the first part of the source code for the taf. <@assign name="TabDelim" value="<@VAR NAME='@@resultSet[*,*]' Type='text' Encoding='none' APREFIX='' ASUFFIX='' RPREFIX='' RSUFFIX=<@CRLF> CPREFIX='' CSUFFIX=<@CHAR 9>>" Scope="local"> <@assign name="TabDelim" value="<@replace STR='<@var local$tabDelim>' FindStr=' 00:00:00' Replace=''>" Scope="local"> <@assign name="TabDelim" value="<@replace STR='<@var local$tabDelim>' FindStr='<@chr 9><@CRLF>' Replace='<@CRLF>'>" Scope="local"> <@ASSIGN LOCAL$encodeResults FALSE> <@ASSIGN LOCAL$fileName "Survey.txt"> <@ASSIGN LOCAL$fileContents "<@var local$TabDelim>"> <@ASSIGN local$httpHeader "Content-Type: text/download; name=<@VAR LOCAL$fileName ENCODING=NONE><@CRLF>Content-Disposition: file; filename=<@VAR LOCAL$fileName ENCODING=NONE><@CRLF>Content-Length: <@VARINFO LOCAL$fileContents SIZE><@CRLF><@CRLF>"> <@VAR LOCAL$fileContents ENCODING=NONE> What am I doing wrong? I run the query, assign the result set to a variable. That variable contains the tab delimited data I am looking for. When I assign it to local$filecontents and assign the httpHeader, the download file content is the first part of the taf, including java script, etc. Why isn't it the data in <@var local$TabDelim>? Appreciate any comment, Hutch -----Original Message----- From: [Gauthier] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 4:01 AM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: naming column/line of array Hi, I'm very glad to act as reminder for you ;) hopefully for Henning Sittler the other explanations was more understandable... I'm currently extensively using this notation for my cache system, but I don't know if it can lead to performance fall or if the server manage a double indexing (numbers and named elements) with array, did anyone have an idea on how it work on the server side implementation? Thanks! Gauthier ----- Original Message ----- From: "Scott Cadillac" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Thursday, June 06, 2002 8:08 PM Subject: Re: Witango-Talk: naming column/line of array > D'oh! > > Thank you Gauthier, I had forgotten about that feature. > > After assigning a value to the zero '0' column - it's becomes an excellent > way to report back the row number of a record in an array when using > something like <@FILTER>. > > Thank you. Cheers... > > Scott Cadillac > http://xml-extra.net > [EMAIL PROTECTED] > > VP, Research and Development > Plus International Corp. > 604-460-1843 > [EMAIL PROTECTED] > http://www.plusinternational.com > > Vancouver, BC, Canada > > Does your company have an Enterprise Information Portal? Check out Salsa at > www.plusinternational.com/flash/salsa.htm ________________________________________________________________________ ____ __ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
