Re: Witango-Talk: Writing & Reading Metagtags

2005-01-31 Thread Jason Schulz
Aha. Thanks. J. On 01/02/2005, at 2:38 PM, Scott Cadillac wrote: Hi Jason, Try putting everything inside an <@LITERAL> metatag. Hope this helps TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Writing & Reading Metagtags

2005-01-31 Thread Scott Cadillac
Hi Jason, Try putting everything inside an <@LITERAL> metatag. Hope this helps Scott Cadillac - Business Extranet Freedom IExtranet ~ http://IExtranet.com Online Demo ~ http://www.northwind.org/#demo - Weblog ~ http://xmlx.ca For Hire ~ http://xmlx.ca/forhire - 403

Witango-Talk: Writing & Reading Metagtags

2005-01-31 Thread Jason Schulz
I have a tml file that I write to disk via Witango that contains the meta tag <@CGIPARAM name='SERVER_NAME'>, amongst others. How can I escape the tag so that it is only evaluated by Witango when the file is served to the user, and not evalutated when the file is written to disk? Thanks, Jason.

RE: Witango-Talk: meta refresh [OT maybe]

2005-01-31 Thread Scott Cadillac
Hi Mike, I don't use Apache myself, but I understand mod_rewrite is just manipulating the HTTP Response headers to provide the HTTP redirect instructions. You can accomplish the same server-level results by writing your own custom HTTP Response headers in Witango by assigning to the request$httpH

Re: Witango-Talk: Download to excel

2005-01-31 Thread Wayne Irvine
Title: Re: Witango-Talk: Download to excel Scott Cadillac at [EMAIL PROTECTED] wrote: To fix formatting problems, just write some special HTML extensions that Excel understands. Thanks Scott, I wasn’t even asking the question and I got the answer! I love this place! Wayne   

RE: Witango-Talk: Download to excel

2005-01-31 Thread Scott Cadillac
Hi Wayne, Outputting Excel content is as simple as Jason describes, using an HTML table. To fix formatting problems, just write some special HTML extensions that Excel understands. Attached is a sample HTML file with some MS Office Extensions in HTML that instructs Excel to not do the scientific

Re: Witango-Talk: Download to excel

2005-01-31 Thread Roland Dumas
Title: Re: Witango-Talk: Download to excel Perfect. Thank you. On 1/31/05 6:06 PM, "Jason Schulz" <[EMAIL PROTECTED]> wrote: If you pass Excel your data in a table layout, of valid html, and tell it that the file extension is '.xls' in the headers, Excel's parser will do the rest. If you wa

Re: Witango-Talk: Download to excel

2005-01-31 Thread Wayne Irvine
Roland Dumas at [EMAIL PROTECTED] wrote: > What's the format of the resultset that will cause each field to fall into a > column and for each row to fall into an excel row? I just write the ResultSet to a file with the extension '.xls' so it opens in Excel. There are some interesting issues wit

Re: Witango-Talk: Download to excel

2005-01-31 Thread Jason Schulz
If you pass Excel your data in a table layout, of valid html, and tell it that the file extension is '.xls' in the headers, Excel's parser will do the rest. If you want styles, you will needs to do things locally (ie, within each table cell), as it doesn't get style sheets. J. On 01/02/2005, at

RE: Witango-Talk: meta refresh [OT maybe]

2005-01-31 Thread Michael Dittbrenner
With Apache mod_rewrite is the best cause its at the server level not browser level. There is a similar tool that is like mod_rewrite for IIS also. Mike D Educational Directories Unlimited, Inc. Michael Dittbrenner Systems Administrator http://www.Stu

Witango-Talk: Download to excel

2005-01-31 Thread Roland Dumas
There is a nice taf in the component zone that shows how to download a result set into an excel file. What's the format of the resultset that will cause each field to fall into a column and for each row to fall into an excel row? _

RE: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Tom Ferguson
good idea! Thanks > -Original Message- > From: Customer Support [mailto:[EMAIL PROTECTED] > Sent: Monday, January 31, 2005 7:06 PM > To: witango-talk@witango.com > Subject: Re: Witango-Talk: Eliminating the SQL error message on large > fields > > > Tom, > Make sure that you check your scr

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Customer Support
Tom, Make sure that you check your script with a browser with javascript turned off. I would still recommend using @LEFT so only the first 8000 chars were passed to the SQL server. Witango Support On 01/02/2005, at 10:56 AM, Tom Ferguson wrote: Thank you all for your responses... a big help,

RE: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Tom Ferguson
Thank you all for your responses... a big help, as always. What I ended up doing was add javascript to count the letters as they were typed into the textarea and display the count below the textarea. If more than 8000 characters are entered, it gives an error message. If you try to submit with

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Russell Stephany
tom, "Tom Ferguson" <[EMAIL PROTECTED]> wrote on 01/02/2005 09:50:54 AM: > There's probably some simple way to do this, but it escapes me at the > moment. > I have a form with several large fields (8000 chars). They are defined as > Textarea fields so there is no way to limit their size via H

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Peter Ternström
Great link, thanks! Peter - Original Message - From: "Bill Conlon" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 01, 2005 12:14 AM Subject: Re: Witango-Talk: Eliminating the SQL error message on large fields How about <@ASSIGN SCOPE="request" NAME="text" VALUE="<@SUBSRTING NAME='<@POS

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Bill Conlon
How about <@ASSIGN SCOPE="request" NAME="text" VALUE="<@SUBSRTING NAME='<@POSTARG textarea>' START='1' NUMCHARS='8000'>"> Then insert @@request$text into your db. You might also consider checking the input for SQL injection or other attacks. BTW, even if you used TEXT input, anyone can arbit

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Customer Support
Tom, If you do not mind losing the chars after 8000 you could use the following code in your action for the columns: <@LEFT STR="<@ARG MyArg>" NUMCHARS="8000"> Witango Support On 01/02/2005, at 9:50 AM, Tom Ferguson wrote: There's probably some simple way to do this, but it escapes me at the mom

Re: Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Peter Ternström
Hello Tom, why don't you convert the fields to "text" fields in SQL server? I think text fields might be better, even from a performance point of view. Text fields are not limited in size, and you can still perform searches on them (searches are costly, though). Peter - Original Message ---

Witango-Talk: Eliminating the SQL error message on large fields

2005-01-31 Thread Tom Ferguson
There's probably some simple way to do this, but it escapes me at the moment. I have a form with several large fields (8000 chars). They are defined as Textarea fields so there is no way to limit their size via HTML (that I know of). So if someone types 8010 chars, SQL throws an overflow error (

Re: Witango-Talk: meta refresh [OT maybe]

2005-01-31 Thread Bill Conlon
See apache mod_rewrite http://httpd.apache.org/docs-2.0/misc/rewriteguide.html You might want to use the 301 Moved Permanently code in place of 302 redirect. Also, see the various threads on "no-cache" directives in headers. You may have issues with proxy servers that have cached the old c

RE: Witango-Talk: meta refresh [OT maybe]

2005-01-31 Thread Scott Cadillac
Hi Chuck, MS Internet Explorer has a Security setting to disable META REFRESH (look under Miscellaneous). HTML Meta tag redirects are generally ignored by Search engines. An actual HTTP redirect command (302) is more reliable than the Meta tag (and recognized by Search engines), but is still sub

Witango-Talk: meta refresh [OT maybe]

2005-01-31 Thread Chuck Lockwood
Is there a surefire way to redirect to an alternate page, given all the platforms and browsers that exist?  Does the meta below do the trick, 100% of the time?  Are there browser setting that prohibit/warn about such things, if they’re within the same domain?     Chuck Lockwood ~~~

Re: Witango-Talk: Replacing double quotes

2005-01-31 Thread Roland Dumas
Title: Re: Witango-Talk: Replacing double quotes Ah, another error between the keyboard and the chair. The original code works – the logic was broken. On 1/31/05 1:11 PM, "John McGowan" <[EMAIL PROTECTED]> wrote: Ok, that doesn't make sense... try using the <@CHAR> tag to designate what you

RE: Witango-Talk: question on files

2005-01-31 Thread Ben Johansen
Ok, I put CVSNT on windows 2000 server. With TortiseCVS as client on XP It maintained a repository of the tafs But when I went to a xcopy of the folder it had problems I had to use Robocopy To get past locks that seemed to be an issue via command and not if I just copied via the GUI If you want

Re: Witango-Talk: Replacing double quotes

2005-01-31 Thread John McGowan
Ok, that doesn't make sense... try using the <@CHAR> tag to designate what you want to replace instead of @DQ and @SQ /John Roland Dumas wrote: @replace is returning the original string, yes On 1/31/05 1:04 PM, "John McGowan" <[EMAIL PROTECTED]> wrote: Roland... Replace

RE: Witango-Talk: Replacing double quotes

2005-01-31 Thread Jon Pevzner
Roland, Try <@replace str='<@ARG comment>' findstr='<@CHAR 34>' replacestr='<@CHAR 39>'> Jon -Original Message- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 4:01 PM To: witango-talk@witango.com Subject: Witango-Talk: Replacing double quotes This is probab

Re: Witango-Talk: Replacing double quotes

2005-01-31 Thread Roland Dumas
@replace is returning the original string, yes On 1/31/05 1:04 PM, "John McGowan" <[EMAIL PROTECTED]> wrote: > Roland... > > Replace doesn't mutate the Arg... it returns a modified string... > > is the @replace returning the original string? > > /John > > Roland Dumas wrote: > >> This is pr

Re: Witango-Talk: Replacing double quotes

2005-01-31 Thread John McGowan
Roland... Replace doesn't mutate the Arg... it returns a modified string... is the @replace returning the original string? /John Roland Dumas wrote: This is probably obvious, but not to me: I have a form field into which users put comments. I wish to lose all the double quotes - makes a mess of the

Witango-Talk: Replacing double quotes

2005-01-31 Thread Roland Dumas
This is probably obvious, but not to me: I have a form field into which users put comments. I wish to lose all the double quotes - makes a mess of the csv file I'm writing to. How do I replace a " with a '?? I try: <@replace str='<@ARG comment>' findstr='<@DQ>' replacestr='<@SQ>'> And it doesn

RE: Witango-Talk: question on files

2005-01-31 Thread Chuck Lockwood
One more thing ... I do remember occasions when caching was off, a user would report that tango returned a "taf file is corrupt" error if they hit it will I was ftping it up. But a page refresh would correct it, no crash! Chuck Lockwood -Original Message- From: Chuck Lockwood [mailto:[

RE: Witango-Talk: question on files

2005-01-31 Thread Chuck Lockwood
Likewise. I ftp new files to production everyday almost, while the server is running and have never seen a crash related to it. Whether caching is on or off, for that matter. Does your checkin/out utility keep a lock on for some reason? Maybe try copying or ftping the files instead. Chuck Loc

Re: Witango-Talk: @INCLUDE files outside Apache Virtual Hosts DocumentRoot

2005-01-31 Thread Bill Conlon
Matt, you know what, my include files are actually inside the web root, just different for different domains that are aliased to the same web root. I did have a need to specify the path into a script-aliased cgi-bin directory (to select the search index on a per domain basis), and for that,

Re: Witango-Talk: question on files

2005-01-31 Thread Bill Conlon
I run my dev server with cache off, so I can immediately see changes. Never have any problems, but I'm the only person hitting the system. Production has caching on. Files are copied and then I purge cache. Have never had a problem (W5, apache2, Redhat 9). On Monday, January 31, 2005, at 1

Re: Witango-Talk: @INCLUDE files outside Apache Virtual Hosts DocumentRoot

2005-01-31 Thread Matt Muro
Bill, Does your org_path and org_include variables point to a directory *outside* the document root of the server? It shouldn't matter if I don't user domain variables and just type the full path, right? I am unable to include a file outside the web server document root even after changing my h

Re: Witango-Talk: question on files

2005-01-31 Thread Alan Wolfe
That makes sense. We have cacheing on so maybe it's a problem if the file isnt cached yet or maybe it's something else. Does anyone upload new versions of .taf files to a production server while people are making requests of witango and experience anything like this? - Original Message -

Re: Witango-Talk: Asp variables to wiango variables

2005-01-31 Thread Bryan Hughes
Create a psuedo web service, have your ASP scripts retrun XML you parse on the witango side. You man have to create wrappers for the ASP scripts. Ted Wolfley wrote on 1/31/05, 1:58 PM: Hi,   I am creating a witango application that is using pages from an asp application.  What

RE: Witango-Talk: question on files

2005-01-31 Thread Chuck Lockwood
I guess it could be a problem if caching is off, but if its on (highly recommended), then Witango doesn't access the file at all until cache is purged, which needs to be done for it to read your new file. Chuck Lockwood LockData Technologies, Inc.

Witango-Talk: Asp variables to wiango variables

2005-01-31 Thread Ted Wolfley
Hi,   I am creating a witango application that is using pages from an asp application.  What is the best way to return the results of the asp script functions into Witango variables.    Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (5

Witango-Talk: question on files

2005-01-31 Thread Alan Wolfe
Does anyone know if it's safe to overwrite a .taf file on a server while that file may be in use by witango? For instance if i have a dostuff.taf and someone makes a request of it while we are uploading a new dostuff.taf or someone makes a request to dostuff.taf while we are uploading can that cau

Re: Witango-Talk: ODBC problem with MySql on Dev Studio 5.5 on WinXP

2005-01-31 Thread John McGowan
In my experience problems with MySQL and ODBC are usually related to a problem granting access to the database.  Be sure you know what you're doing with respect to granting access to the MySQL database.  Make sure you can connect to it using the MySQL control center before attempting to connect

Re: Witango-Talk: @INCLUDE files outside Apache Virtual Hosts DocumentRoot

2005-01-31 Thread Bill Conlon
Matt, The witango include <@include file="/sharedfiles/ocmFooter.tml"> is an absolute reference, so the path is wrong. I usually set up a domain variable with an absolute path prefix for my includes a la: <@INCLUDE FILE="@@domain$org_path/@@domain$org_includes/admin_index.html"> where: @@dom

RE: Witango-Talk: ODBC problem with MySql on Dev Studio 5.5 on WinXP

2005-01-31 Thread Ben Johansen
As for connecting to MySql via odbc from Dev. Studio I have done it with 5 and 5.5 on XP to Win2003 Server no problem. I would have to question the ODBC DSN configuration. When you setup the ODBC on the XP Client did you perform the connection test under ODBC Admin? Ben Johansen - http://www.pcf

Re: Witango-Talk: ODBC problem with MySql on Dev Studio 5.5 on WinXP

2005-01-31 Thread Jonah Simpson
Robert, I've never tried using the tutorial database setup. I HAVE been using WiTango 5.0 with Windows 2000 for about the past year and a half, and I have had no problems connecting to MySQL, MS SQL and Oracle via ODBC. I've use the Mac version as well and never had any problems in that regard.

Witango-Talk: @INCLUDE files outside Apache Virtual Hosts DocumentRoot

2005-01-31 Thread Matt Muro
I am trying to @INCLUDE a file outside the DocumentRoot of an Apache2 Virtual Hostwithout success, so far. I've searched the Mail List Archive and found some posts that touch on this, but none that address it directly. First let me say that, yes, I know if we were running Apache on Linux I co