RE: Witango-Talk: Your email requires verification verify#R7Cot7J7rKQCJ95IwP6donRWotST2bYr

[Wolf, Gene (SA-1)]

-Original Message-
From: Ben Johansen [mailto:b...@pcforge.com] 
Sent: Friday, September 25, 2009 10:55 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Your email requires verification
verify#R7Cot7J7rKQCJ95IwP6donRWotST2bYr

The message you sent requires that you verify that you 
are a real live human being and not a spam source.

To complete this verification, simply reply to this message and leave
the subject line intact.

The headers of the message sent from your address are shown below:

From owner-witango-t...@witango.com Fri Sep 25 09:55:20 2009
Received: from 177.137.55.203-static.velocitynet.com.au
([203.55.137.177]:1737 helo=mail.witango.com)
 by gator945.hostgator.com with esmtps (SSLv3:AES256-SHA:256)
 (Exim 4.69)
 (envelope-from owner-witango-t...@witango.com)
 id 1MrCCX-0004Oe-3Z
 for b...@pcforge.com; Fri, 25 Sep 2009 09:55:20 -0500
Received: from fg-out-1718.google.com ([72.14.220.158])
by mail.witango.com (IceWarp 9.4.2) with ESMTP id GXC23310
for witango-talk@witango.com; Sat, 26 Sep 2009 00:55:10 +1000
Received: by fg-out-1718.google.com with SMTP id e12so171417fga.11
for witango-talk@witango.com; Fri, 25 Sep 2009 07:54:56 -0700
(PDT)
Received: by 10.86.230.27 with SMTP id c27mr1020310fgh.63.1253890496294;
Fri, 25 Sep 2009 07:54:56 -0700 (PDT)
Received: from ?192.168.1.31?
(pool-71-174-142-14.bstnma.east.verizon.net [71.174.142.14])
by mx.google.com with ESMTPS id
12sm590047fgg.18.2009.09.25.07.54.51
(version=SSLv3 cipher=RC4-MD5);
Fri, 25 Sep 2009 07:54:54 -0700 (PDT)
Subject: Re: Witango-Talk: Witango 5.5 and MS Server 2008
Mime-Version: 1.0 (Apple Message framework v1076)
Content-Type: multipart/signed; boundary=Apple-Mail-26-705382006;
protocol=application/pkcs7-signature; micalg=sha1
From: Richard Bates rich...@highlands.com
X-Priority: 3
In-Reply-To: 7ffea353f56c4040adefbd87a17be...@danielswinmac
Date: Fri, 25 Sep 2009 10:54:48 -0400
Cc: Witango-Talk witango-talk@witango.com
Message-Id: e900c57c-4ec4-4c3b-9258-8daf08880...@highlands.com
References: 3171534bd76e4da0bc66b54658000...@danielswinmac
7ffea353f56c4040adefbd87a17be...@danielswinmac
To: D. Richardy richa...@softdes.de
X-Mailer: Apple Mail (2.1076)
Reply-To: witango-talk@witango.com
X-Spam-Status: No, score=4.3
X-Spam-Score: 43
X-Spam-Bar: 
X-Spam-Flag: NO

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Java compiler/hosting alternatives

[Wolf, Gene (SA-1)]

*chirp* *chirp* *chirp* 

-Original Message-
From: Dan Stein [mailto:d...@dss-db.com] 
Sent: Wednesday, August 12, 2009 3:24 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Java compiler/hosting alternatives

Then again unless it is just me I don't think anyone has heard from the
folks in AU for almost a year now. Even direct email get no response.
Has anyone else heard anything?
--
Dan Stein MSN
FileMaker 7 Certified Developer
FileMaker 9 Certified Developer
Digital Software Solutions
303 W. Chestnut St
Souderton PA 18964
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 ( Call 1st)
FMP, WiTango,MSSQL, MySQL,PHP
d...@dss-db.com
www.dss-db.com


 When you are born, you cry and those who love you rejoice.  And if
you live your life as you should, when you die, you rejoice and those
who love you cry.






On Aug 11, 2009, at 12:31 PM, Scott Cadillac wrote:

  Its like the old medieval days when someone was in the dungeon. The 
  prisoner is seemingly dead, but when you leave food by the door and 
  come back later, the food is gone and the plate is returned.

 Ouch!


 __
 __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: FTP engine

[Wolf, Gene]

   Does anyone know if an FTP client exists that can be driven by
Witango? I have the need to access a file, via FTP, on a remote server
and read the contents and process the information via Witango. I would
need to have the ability to provide the ID and password to the server,
get the file, etc. Anyone know if this is even possible?


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango 6 update

[Wolf, Gene]

I agree with you folks. I can't imagine a better week in which good news
would be welcomed!

-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2008 8:13 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango 6 update

This would be a week for good information. :) Beverly

On 9/30/08 7:44 PM, Roland Dumas [EMAIL PROTECTED] wrote in whole
or in part:

 y'know. I think you're right. This is a very good week for
information.
 
 On Sep 30, 2008, at 5:22 AM, Dan Stein wrote:
 
 This week would be a good time to here about the progress or lack of 
 progress in moving forward.


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Re: Re: Re: Re: Re: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#cofchR30w40KTQzaHheF4

[Wolf, Gene]

Send everything from him to trash? *grins* 

-Original Message-
From: Ted Wolfley [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 15, 2008 8:12 AM
To: witango-talk@witango.com
Subject: RE: Re: Re: Re: Re: Re: Re: You have been added to
[EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was:
Re: Witango-Talk: Your email requires verification
verify#cofchR30w40KTQzaHheF4tPSosC3Trxz)

How do I stop Ben from filling up my in box?

Ted

-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2008 2:30 PM
To: witango-talk@witango.com
Subject: Re: Re: Re: Re: Re: Re: Re: You have been added to
[EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was:
Re: Witango-Talk: Your email requires verification
verify#cofchR30w40KTQzaHheF4tPSosC3Trxz)

This message is a reply to a boxtrapper verifcation message.

No action is needed on your part.

The headers of the message sent from your address are shown below:

From [EMAIL PROTECTED] Sun Sep 14 12:29:55 2008
Received: from webspinr by box443.bluehost.com with local-bsmtp (Exim
4.69)
 (envelope-from [EMAIL PROTECTED])  id 1KewM1-0008R3-Po
for [EMAIL PROTECTED]; Sun, 14 Sep 2008 12:29:55 -0600
X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on
box443.bluehost.com
X-Spam-Level: 
X-Spam-Status: No, score=-0.4 required=5.0 tests=ANY_BOUNCE_MESSAGE,AWL,

BAYES_00,CRBOUNCE_MESSAGE,MISSING_MID,NORMAL_HTTP_TO_IP,SPF_NEUTRAL,
URIBL_RHS_DOB shortcircuit=no autolearn=no version=3.2.4
Received: from 177.137.55.203-static.velocitynet.com.au
([203.55.137.177] helo=mail.witango.com)
by box443.bluehost.com with esmtps (SSLv3:AES256-SHA:256)
(Exim 4.69)
(envelope-from [EMAIL PROTECTED])
id 1KewM1-0008OT-Ax
for [EMAIL PROTECTED]; Sun, 14 Sep 2008 12:29:49 -0600
Received: from outbound-mail-x1.bluehost.com ([74.220.195.79])
by mail.witango.com (Merak 8.9.1) with SMTP id UBR59353
for witango-talk@witango.com; Mon, 15 Sep 2008 04:29:53 +1000
Received: (qmail 13449 invoked by uid 0); 14 Sep 2008 18:29:43 -
Received: from unknown (HELO box443.bluehost.com) (69.89.31.243)
  by xmail.bluehost.com with SMTP; 14 Sep 2008 18:29:43 -
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default;
d=webspinr.com;

h=Received:Date:X-Boxtrapper:X-Autorespond:Precedence:X-Precedence:From:
To:Subject:X-Identified-User;

b=Jhgmlmm4xvPqTVNvvQttMdFmv8pQCchQcKGnp3Tq+73ZCeuRIHQGqNOERyH6A/Z/r05vly
NWVWcMrjrjLyCIkDkX0meKDxr6xRc0K2BEiaXb8WE1F1S2IWHE3h9pQIl4;
Received: from localhost ([127.0.0.1] helo=box443.bluehost.com)
by box443.bluehost.com with esmtp (Exim 4.69)
(envelope-from [EMAIL PROTECTED])
id 1KewLv-0008MB-Lt
for witango-talk@witango.com; Sun, 14 Sep 2008 12:29:43 -0600
Date: Sun, 14 Sep 2008 12:29:43 -0600
X-Boxtrapper: hozmskVjSu28juBkgdbJcPqbzUrKryOx
X-Autorespond: hozmskVjSu28juBkgdbJcPqbzUrKryOx
Precedence: auto_reply
X-Precedence: auto_reply
From:  [EMAIL PROTECTED]
To: witango-talk@witango.com
Subject: Re: Re: Re: Re: Re: Re: You have been added to
[EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was:
Re: Witango-Talk: Your email requires verification
verify#cofchR30w40KTQzaHheF4tPSosC3Trxz)
X-Identified-User: {3228:box443.bluehost.com:webspinr:webspinr.com}
{sentby:program running on server}
Reply-To: witango-talk@witango.com
X-user: 203.55.137.177:box443.bluehost.com::
Message-Id: [EMAIL PROTECTED]
X-user-local: {3228:box443.bluehost.com:webspinr:webspinr.com}
{sentby:program running on server}

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Version 6?

[Wolf, Gene]

I also read the list and am as frustrated as anyone else with the lack
of support and communication from With. This lack of communication and
news on the product is one of the reasons my company has decided to move
away from Witango. It's hard to defend a product to management types
when you don't hear about it, no one seems to be using it and the only
real support you can contact are the people on this list and a
semi-searchable e-mail archive.
 
Has anyone thought of suggesting to a larger company, like Apple or
Oracle, that they look at Witango as an acquisition? We are moving to
Oracle and in the training I have taken so far their reporting and
programming tools are far from the power Witango provides. Yes, I know
Witango is supposed to be going open source but, to me anyway, it seems
like another dead end. I mean, six months with no word? Even if things
are running into roadblocks, which always seems to happen, at least
there could be monthly communication stating that fact.
 
Some of us must have contacts within larger companies that might be able
to get them to at least look at Witango and evaluate it. Some company
other than Pervasive that is. *grins* If Apple or Oracle picked up
Witango I imagine within a relatively short time we'd see improvements,
additional functionality, and communications. It would also make it
much, much easier to sell to customers (I consider my management a
customer) if we could say, Witango is an Apple (or place your large
company name here) product. 
 
Just a thought.



From: Rick Sanders [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 31, 2008 4:48 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Version 6?



I can understand everyone's frustration in this regard. Although I don't
post much, I do read emails on the list.

Communication is very important, and because of the lack of
communication unfortunately many people have left the WiTango
technology.

 

I can only hope that the delay is because of something really good on
the horizon. I don't know how WiTango sales have been, or how much
interest there is in the community, but I hope it's enough to keep
WiTango going.

 

 

Rick Sanders

Webenergy

Canada: 902-431-7279

USA:   919-799-9076

Canada: www.webenergy.ca

USA:   www.webenergyusa.com

 

From: Dan Stein [mailto:[EMAIL PROTECTED] 
Sent: July-31-08 5:34 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Version 6?

 

I have sent three back channel emails maybe more email to customer
support will get a response. But I agree communication keep declining
and I fail to understand why that is. I still love the product and even
if 6 never came out I would continue with 5.5 but it is a reasonable
request from the community that we be kept in the loop. Last we heard
there were just a few legal issues to resolve with open source license
but then nothing. It has been since 2/11/2008 since we had the last
official word. 6 months.

Dan
-- 
Dan Stein
FileMaker 7 Certified Developer
FileMaker 9 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 ( Call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com


When you are born, you cry and those who love you rejoice.  And if
you
live your life as you should, when you die, you rejoice and those who
love you cry.





From: Jonah Simpson [EMAIL PROTECTED]
Reply-To: witango-talk@witango.com witango-talk@witango.com
Date: Thu, 31 Jul 2008 14:00:02 -0600
To: witango-talk@witango.com witango-talk@witango.com
Subject: Re: Witango-Talk: Version 6?

quote sender=John McGowan
Sorry, should have put a 

sarcasam tag around my one week email.  I was only echoing the
latest information we received... which was months ago.

I like Witango and the company that makes it, but the communication to
the community is poor...

/John
/quote

On Thu, Jul 31, 2008 at 12:27 PM, Stefan Gonick
[EMAIL PROTECTED] wrote:

A while back someone predicted that version 6 was coming out last week,
though it was obviously not from With.  Was that a completely mistaken
notion, or was there something to it? Is version 6 coming out any time
soon?

Stefan

=
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

 

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to 

RE: Witango-Talk: import excel

[Wolf, Gene]

Yeah, many times. If it is a well formed CSV file all you need to do is
read the CSV file using a file action and assign the file to a variable.
Tokenize that variable using the comma as the separator character (with
all of the attending issues this brings about) and you have a Witango
array ready for processing.
 
Problems happen when the same number of columns are not in every row of
the CSV file. I also prefer tab delimited files instead of comma
separated because there is less chance that someone has placed a comma
in a numeric field or an address field which throws tokenization into a
cocked hat.
 
 



From: GK [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 02, 2008 7:05 AM
To: witango-talk@witango.com
Subject: Witango-Talk: import excel


Hi. Has anyone implemented an import of an excel or csv file with
witango.

Thx
George


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Different excel question

[Wolf, Gene]

Thanks Kent. Actually Beverly gave me the answer and Witango works
beautifully for my purpose. I'm including code here that was generated
from my program to create a few tabs and a couple of columns and rows
within each worksheet to show others who may have the need to do this
how it is done. As Beverly pointed out, if you save this as somefile.xml
Excel will read it and process it correctly as data within worksheets.
In my reading I'm also finding ways to include formulas within cells as
well so some really sophisticated worksheets could be created using this
method. The top portion of the form I just created an include file since
that will not change. Thanks Beverly. Just needed some idea of what
direction to look in.

Here is XML code, created by Witango. That will produce worksheets and
several rows and columns within each worksheet.

?xml version=1.0?
?mso-application progid=Excel.Sheet?
Workbook xmlns=urn:schemas-microsoft-com:office:spreadsheet
 xmlns:o=urn:schemas-microsoft-com:office:office
 xmlns:x=urn:schemas-microsoft-com:office:excel
 xmlns:ss=urn:schemas-microsoft-com:office:spreadsheet
 xmlns:html=http://www.w3.org/TR/REC-html40;
 DocumentProperties xmlns=urn:schemas-microsoft-com:office:office
  Authorwolfg/Author
  LastAuthorwolfg/LastAuthor
  Created2008-06-27T13:37:20Z/Created
  LastSaved2008-06-27T13:38:06Z/LastSaved
  CompanyDRS Optronics, Inc./Company
  Version11.8132/Version
 /DocumentProperties
 OfficeDocumentSettings
xmlns=urn:schemas-microsoft-com:office:office
  DownloadComponents/
  LocationOfComponents HRef=file:///D:\/
 /OfficeDocumentSettings
 ExcelWorkbook xmlns=urn:schemas-microsoft-com:office:excel
  WindowHeight12015/WindowHeight
  WindowWidth15195/WindowWidth
  WindowTopX195/WindowTopX
  WindowTopY-225/WindowTopY
  ActiveSheet178/ActiveSheet
  ProtectStructureFalse/ProtectStructure
  ProtectWindowsFalse/ProtectWindows
 /ExcelWorkbook
 Styles
  Style ss:ID=Default ss:Name=Normal
   Alignment ss:Vertical=Bottom/
   Borders/
   Font/
   Interior/
   NumberFormat/
   Protection/
  /Style
 /Styles


Worksheet ss:Name=340160-009RB-234340
  Table ss:ExpandedColumnCount=2 ss:ExpandedRowCount=5
x:FullColumns=1
   x:FullRows=1
Row
CellData
ss:Type=String340161-009/Data/Cell
CellData ss:Type=String01115/Data/Cell
/Row
Row
CellData
ss:Type=String400070-009RB/Data/Cell
CellData
ss:Type=String102893/Data/Cell
/Row
Row
CellData
ss:Type=String400078-009/Data/Cell
CellData
ss:Type=Stringm01062/Data/Cell
/Row
Row
CellData
ss:Type=String400080-009RB/Data/Cell
CellData
ss:Type=String102477/Data/Cell
/Row
Row
CellData
ss:Type=String400086-009RBM/Data/Cell
CellData
ss:Type=String102180/Data/Cell
/Row

  /Table
 /Worksheet

Worksheet ss:Name=350700-009RB-266200
  Table ss:ExpandedColumnCount=2 ss:ExpandedRowCount=6
x:FullColumns=1
   x:FullRows=1
Row
CellData
ss:Type=String350701-009/Data/Cell
CellData ss:Type=String01350/Data/Cell
/Row
Row
CellData
ss:Type=String400070-009/Data/Cell
CellData
ss:Type=String104771/Data/Cell
/Row
Row
CellData
ss:Type=String400075-009/Data/Cell
CellData
ss:Type=Stringh00997/Data/Cell
/Row
Row
CellData
ss:Type=String400080-009/Data/Cell
CellData
ss:Type=String201826/Data/Cell
/Row
Row
CellData
ss:Type=String400080-009/Data/Cell
CellData
ss:Type=String201826/Data/Cell
/Row
Row
CellData
ss:Type=String400086-009/Data/Cell
CellData
ss:Type=String201774/Data/Cell
/Row

  /Table
 /Worksheet

Worksheet ss:Name=340160-009RB-235693
  Table ss:ExpandedColumnCount=2 ss:ExpandedRowCount=7
x:FullColumns=1
   x:FullRows=1
Row
CellData
ss:Type=String340089/Data/Cell
CellData
ss:Type=StringP2321807/Data/Cell
/Row
Row
CellData
ss:Type=String340089/Data/Cell
CellData
ss:Type=StringP2321918/Data/Cell
/Row
Row
CellData
ss:Type=String340161-009/Data/Cell
CellData 

Witango-Talk: Different excel question

[Wolf, Gene]

Creating excel spreadsheets from Witango is trivial but I have a
different question. I have been asked to put together an excel workbook
containing several tabbed pages. The tabs will contain the part number
of a query I am performing and the data on the page that relates to that
tab will contain serial numbers of units shipped, along with other
information, pertaining to that tabbed part number. Can this be done
using Witango? 

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Witango_Server= and portability between servers

[Wolf, Gene]

   I have what I believe is a simple question. We are moving our
Intranet to a datacenter located in Dallas. At that location they are
very conscious of adding new servers, moving machines around, changing
IP addresses, etc. They seem to be able to want to mix and match
machines at will. While I agree that hardcoding server names or IP
addresses in code is very bad practice it seems to me that complete
flexibility isn't possible either. For example, according to the
documentation the client.ini file needs to have the IP addresses of the
servers serving Witango specified. For example a snippet of our
client.ini file looks like:

WITANGO_SERVER=Witango1,10.200.10.51,18150:Witango1a,10.200.10.51,18151

   Is it possible to replace the IP addresses with something else that
will resolve to an IP address of must the IP address be specified? Yes,
we can do a global search and replace if we ever need to move servers
but the powers that be want this as flexible as possible. Thanks for the
feedback and thoughts.



Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: SQL Generated Query

[Wolf, Gene]

   Easy question. Is there any way of obtaining, from Witango, the
actual SQL code generated by searches? I know the code is available in
the debug dump but It would be really handy to be able to pull a
variable that contains that code and be able to write it to a database
file for testing and checking. I'd really like to be able to write this
code to a database table where I could record employee ID, date and time
requested, etc. 

   Thoughts on how to accomplish this?

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: SQL Generated Query

[Wolf, Gene]

Your memory is not that fuzzy. *laughs* What you pointed out is the same
code you get if you open a SQL window and drag a query action into it.
However, I want to write the actual query string to a database and that
little trick does not help. For example, if a query action have three
vars in the criteria section and two of them are null the string
generated completely omits those conditions. Rightly so. So I would like
to be able to see what the SQL generated code is on every execution of a
given query action and I'll be damned if I can find a way of doing it in
Witango.

If Robert has requested this feature I suspect there is no way to
currently do this in Witango.

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2008 2:47 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: SQL Generated Query

Hi Gene,

If my fuzzy memory serves me correctly, if you right-click on a database
Action, you should have an option for SQL Query, which opens a little
query utility that contains your generated SQL statement. I think it may
also contain your metatags (for your WHERE clause arguments and such)
but not the actual values.

Hope that helps.

Scott,



On Monday, March 17, 2008 3:24pm, Robert Shubert [EMAIL PROTECTED]
said:

 @SQL is populated with the last run SQL statement - except for the 
 fact that bound values are not shown, which means that you may need to

 do additional work in certain places to know what was in the bindings.

 This is my #1 request for v6.
 
 
 
 Robert
 
 
 
   _
 
 From: Wolf, Gene [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 17, 2008 2:17 PM
 To: witango-talk@witango.com
 Subject: Witango-Talk: SQL Generated Query
 
 
 
Easy question. Is there any way of obtaining, from Witango, the 
 actual SQL code generated by searches? I know the code is available in

 the debug dump but It would be really handy to be able to pull a 
 variable that contains that code and be able to write it to a database

 file for testing and checking. I'd really like to be able to write 
 this code to a database table where I could record employee ID, date
and time requested, etc.
 
Thoughts on how to accomplish this?
 
 Gene Wolf
 Supervisor, Business Systems
 DRS Sensors  Targeting Systems-Optronics 2330 Commerce Park Drive NE 
 Palm Bay, Florida 32905
 Phone: 321-309-0685
321-309-0202 (fax)
 
 Dictionary.com Word of the Day
  http://dictionary.reference.com/wordoftheday/
 http://dictionary.reference.com/wordoftheday/
 
 This e-mail, including any attached files, may contain confidential 
 and privileged information for the sole use of the intended recipient.

 Any review, use, distribution, or disclosure by others is strictly
prohibited.
 If you are not the intended recipient (or authorized to receive 
 information for the intended recipient), please contact the sender by 
 reply e-mail and delete all copies of this message.
 
 This (document/presentation) may contain technical data as defined in

 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. 
 Export of this material is restricted by the Arms Export Control Act 
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons 
 without prior written approval from the U.S. Department of State.
 
 
 
 __
 __
 
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 
 __
 __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: In need of a Witango architecture consultant

[Wolf, Gene]

   OK, I put out a similar request a few months ago that was nixed by my
management. However, I have finally convinced them that we need to have
someone come in and look at our setup of Witango (currently 2 windows
servers and a SQL server box) We are experiencing slow execution of
Witango programs. This may be related to any one or all of the
following:

1. Poor programming
2. Setup of servers
3. Communication issues between Witango Servers and SQL Server
4. Gremlins

   I need someone who will be available for 3 days on site. No remote
entry possible. You have to be a US citizen and you have to be on site.
Airfare, hotel, car rental, meals and your daily rate are all covered.
Florida is a great place to visit in March, especially if you're from
one of the northern climates. 

   We are looking for someone who has set up multiple Witango servers,
has gotten them running efficiently, has experience with Witango in a
Windows and SQL Server environment, etc. We're talking Windows Server
2003, SQL Server 2000 and Witango Professional 5.5. I'd like to have
someone in here yesterday.

   Please contact me off list. 

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: IE 5 test

[Wolf, Gene]

I saw this online and thought it was quite ironic. Don't forget,
Microsoft put out operating systems named Windows CE, Windows ME and
Windows NT. Putting them al together gives you Windows CEMENT! Maybe
that was Windows 200? *grins*



From: WebDude [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 08, 2008 12:41 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: IE 5 test


Wow... Windows 200. Was that right after '98?
 
;-)
 
 
 



From: Dan Stein [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 08, 2008 11:27 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: IE 5 test


I have a pc with Windows 200 I'll check I may even have the orginal CD's
to do a VM version thanks 

-- 

Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 (call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, PHP
[EMAIL PROTECTED]

A diamond is just a piece of charcoal that handled stress exceptionally
well.


On Feb 8, 2008, at 12:24 PM, Robert Garcia wrote:


You setup a vm, and install windows 2000, that is IE 5, I
believe. And Win XP, original may be, I know sp2 is 5.5


-- 

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Feb 8, 2008, at 9:09 AM, Dan Stein wrote:


Assuming I could find IE 5 to download it and get it to
install on a system that already had IE on it
-- 
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 ( Call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com 

I destroy my enemies when I make them my friends.

Abraham Lincoln







From: Robert Garcia [EMAIL PROTECTED]
Reply-To: witango-talk@witango.com
witango-talk@witango.com
Date: Fri, 8 Feb 2008 08:53:04 -0800
To: witango-talk@witango.com
witango-talk@witango.com
Subject: Re: Witango-Talk: IE 5 test

Sounds like the perfect use of VMWare, or VirtualPC, or
Parallels.
 

 
-- 
 

 
Robert Garcia
 
President - BigHead Technology
 
VP Application Development - eventpix.com
 
13653 West Park Dr
 
Magalia, Ca 95954
 
ph: 530.645.4040 x222 fax: 530.645.4040
 
[EMAIL PROTECTED] - [EMAIL PROTECTED]
 
http://bighead.net/ - http://eventpix.com/
 
 

On Feb 8, 2008, at 8:38 AM, Dan Stein wrote:



Does anyone have a windows box running IE 5 that
we can get you to look at some web pages we have to see how the render?
 
 Would be over weekend or on Monday.
  
 -- 
 Dan Stein
 FileMaker 7 Certified Developer
 Digital Software Solutions
 799 Evergreen Circle
 Telford PA 18969
 Land: 215-799-0192
 Cell: 610-256-2843
 Fax 215-799-0192 ( Call 1st)
 FMP, WiTango, EDI,SQL 2000, MySQL, CWP
 [EMAIL PROTECTED]
 www.dss-db.com http://www.dss-db.com
http://www.dss-db.com  
 
 
 It's very hard to grow, because it's
difficult to let go of models of ourselves in which we've invested so
heavily.
  
  


TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Regex expression

[Wolf, Gene]

HA HA HA HA HA HA HA



From: Driscoll, Kevin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 07, 2008 12:28 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Regex expression



Use plsql


--
Sent from my BlackBerry Wireless Handheld


-Original Message-
From: Wolf, Gene
To: witango-talk@witango.com
Sent: Thu Feb 07 11:59:52 2008
Subject: Witango-Talk: Regex expression

   OK, I am pulling my hair out and I figure some of you have had quite
a bit more experience with this than I have. Here's what I'm trying to
get the regex expression in Witango to do:

   I want to process all records with a memo field containing :anything
here:

   Now, I'm selecting records and processing an array applying the regex
expression to the appropriate field. I'm using the following command:

   @REGEX EXPR=:{1,}[.]+{1,}:{1,} STR=.. (you get the idea)

  This expression is accepting anything that has at least one : in it. I
really want the field selected if it two : in it. So for example I do
not want Title: but I do want :Title: I don't want :important

But I do want :important:

   What am I doing wrong in the above code?

  

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/
http://dictionary.reference.com/wordoftheday/ 

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

This (document/presentation) may contain technical data as defined in
the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
Export of this material is restricted by the Arms Export Control Act (22
U.S.C. 2751 et seq.) and may not be exported to foreign persons without
prior written approval from the U.S. Department of State.



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Regex expression

[Wolf, Gene]

   OK, I am pulling my hair out and I figure some of you have had quite
a bit more experience with this than I have. Here's what I'm trying to
get the regex expression in Witango to do:

   I want to process all records with a memo field containing :anything
here:

   Now, I'm selecting records and processing an array applying the regex
expression to the appropriate field. I'm using the following command:

   @REGEX EXPR=:{1,}[.]+{1,}:{1,} STR=.. (you get the idea)

  This expression is accepting anything that has at least one : in it. I
really want the field selected if it two : in it. So for example I do
not want Title: but I do want :Title: I don't want :important
But I do want :important:

   What am I doing wrong in the above code?

   

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Passing login to JavaScript

[Wolf, Gene]

...or even what obfuscate means. *grins* 

-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 06, 2008 4:04 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Passing login to JavaScript

also you flood the cookies with a bunch of obfuscated names as decoys
and when the boss walks around and sees the cookie properties screen
open, because the user is so entranced in trying to figure it out, the
boss could question that.
Wait a sec...
How many bosses even know what a browser cookie is, ;-)

Ben

On Feb 6, 2008, at 12:52 PM, Robert Shubert wrote:

 But really cookies are the most convenient way to go from a Witango 
 page to a HTML page and back to a Witango page and maintain the 
 session.
 Heck the
 USR is going to do that automatically as long as the domain hasn't 
 changed and/or the scope hasn't timed out. You can also use cookies to

 step between programming languages.

 And don't leave out that the value of a cookie can be easily encrypted

 with tripledes or blowfish so storing and retrieve a relatively 
 sensitive piece of data can still be done safely. Combine that with a 
 method of timing them out along with the user's session and it should 
 be pretty secure.

 Just thinking out-loud a little.

 Robert



 -Original Message-
 From: Scott Cadillac [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 06, 2008 3:29 PM
 To: witango-talk@witango.com
 Subject: Re: Witango-Talk: Passing login to JavaScript

 Hi Ben,

 I agree with Robert here, this is what cookies where designed for

 True, to a point.

 Keep in mind cookies where introduced before server-side user/ session

 scope variables where commonly available for web apps.

 Once user/session scope variables did come along they became the 
 preferred alternative for some very good reasons. Namely security of 
 sensitive information like a user's ID.

 If the user's ID is available as a cookie (or a URL argument for that 
 matter), and not verified upon posting to a database for example, the 
 user has an opportunity to hijack somebody else's identity. This could

 potentially permit a malicious user to bypass authentication limits on

 what they are allowed and not allowed to do, e.g., change or delete 
 records.
 Chaos could ensue.

 An ambiguous session identifier, that only exists for a unique browser

 instance, is more protection than exposing something sensitive like a 
 real database identifier. Especially given the tools users have at 
 their disposal these days with Firefox extensions and the like that 
 allow anybody to alter their cookie values prior to posting.

 If a company has say 20 employees, and you know your ID is say 14, how

 long will it take to guess your boss' ID?

 Then again, if you're just using that information for something 
 innocent like displaying alternative menus then you're probably fine.

 But still, it's something to be mindful of.

 Scott,




 Ben

 On Feb 6, 2008, at 7:06 AM, Robert Shubert wrote:

 A cookie might work.

 From: Dan Stein [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 06, 2008 9:58 AM
 To: witango-talk@witango.com
 Subject: Witango-Talk: Passing login to JavaScript

 I have a site where 90% of the pages can be served with just plain 
 HTML or HTML and some XML and JavaScript.

 We use a Filemaker database for the members info and that is how 
 they log in.

 If they are logged in we show them a different menu because they get

 different information.

 I prefer not to keep loading and caching pages with The witango 
 server that only need this small bit of information which we could 
 easily make the users email address and ID number.

 Is there a way to store this information using JS or some other 
 technique after having witango log them in.

 So somehow I want to pass the user scope variables from witango and 
 have them available.

 Dan
 --
 Dan Stein
 FileMaker 7 Certified Developer
 Digital Software Solutions
 799 Evergreen Circle
 Telford PA 18969
 Land: 215-799-0192
 Cell: 610-256-2843
 Fax 215-799-0192 ( Call 1st)
 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com

 I destroy my enemies when I make them my friends.

 Abraham Lincoln

 
  TO UNSUBSCRIBE: Go to 
 http://www.witango.com/developer/maillist.taf
 
  TO UNSUBSCRIBE: Go to 
 http://www.witango.com/developer/maillist.taf


 _
 ___ TO UNSUBSCRIBE: Go to 
 http://www.witango.com/developer/maillist.taf

 __
 __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


 __
 __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: is witango alive?

[Wolf, Gene]

Here, but moving away from Witango for the same reasons others have
pointed out. 

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 3:03 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: is witango alive?

 Maybe no news is good news as far as the list being quiet.
 
 Nobody is reporting problems, maybe things are just working smoothly 
 for everyone (:

Either that or everybody else has left...

Maybe we should have a roll-call?

PRESENT, and I brought my pencil ;-)


Scott,







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Table and field names

[Wolf, Gene]

   Has anyone developed a program that would do the following in
windows:

   1. Get a listing of the contents of a specific directory and place it
into an array (easy with a .bat program)
   2. Reduce the members of that array to only .taf files (easy)
   3. Read the raw xml data from each program (easy with a file
component)
   4. List only the table and field names by doing an xml extract (I
have no clue how to do this).

   I am assuming someone must have done this in the past and any
guidance would be greatly appreciated.

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: I'm totally stumped - Thanks!

[Wolf, Gene]

 Thanks for the feedback Robert. Kevin finally figured it out. We have
been told by corporate to use UNC coding wherever possible. We tried it
in the Client.ini and Witango.ini files. Apparently the matching for
userreference and cookies looks at the IP address. The UNC code was not
the same as the IP address so Witango went to the next available stanza.
When we changed everything back to standard IP addresses everything
worked normally again. 

One good thing from this is we did learn from Tim Kelley exactly how to
code the ProcessAffinity parameter. Since we have 8 cpu's in a box ours
looks like:

ProcessAffinity=FIRST
ProcessAffinity=0100
ProcessAffinity=0010
ProcessAffinity=0001
ProcessAffinity=1000
ProcessAffinity=0100
ProcessAffinity=0010
ProcessAffinity=LAST

Since I have never seen this illustrated before I thought I would
include it here.

-Original Message-
From: Robert Shubert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 13, 2007 10:41 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: I'm totally stumped

Is it possible that cookies are being stripped by the firewall or web
server? Witango - even the setup you describe - will maintain a user
sessions automatically.

Also, double check that the userarguments are 36 characters long. This
means that Witango is aware that it's in a multi-service environment.

Robert

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 5:09 PM
To: witango-talk@witango.com
Subject: Witango-Talk: I'm totally stumped


   We are in the process of moving our Intranet to our datacenter in
Dallas. We have some new servers there and we have upgraded to the
professional version of Witango 5.5. These are Windows Server 2003 boxes
with quad CPU's installed. We're currently testing and have run into
something I cannot understand.

   Witango is up and working displaying pages. However every time a page
is refreshed we go to a new stanza (we have 4 set up and each one has
processaffinity=all set) and we get a new UserReference value. Needless
to say all of the variables associated with the old user reference are
lost. 

   Anyone have any idea what I screwed up? I thought the userreference
cookie would keep us on the original stanza for the life of the session.
Any help would be appreciated.

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: I'm totally stumped

[Wolf, Gene]

   We are in the process of moving our Intranet to our datacenter in
Dallas. We have some new servers there and we have upgraded to the
professional version of Witango 5.5. These are Windows Server 2003 boxes
with quad CPU's installed. We're currently testing and have run into
something I cannot understand.

   Witango is up and working displaying pages. However every time a page
is refreshed we go to a new stanza (we have 4 set up and each one has
processaffinity=all set) and we get a new UserReference value. Needless
to say all of the variables associated with the old user reference are
lost. 

   Anyone have any idea what I screwed up? I thought the userreference
cookie would keep us on the original stanza for the life of the session.
Any help would be appreciated.

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: A different tack

[Wolf, Gene]

   OK, I'm going to take some of the suggestions I have seen here and
try this a different way. Is there any company, here on the list, that
can send in a consultant to look at our setup over a period of say, 3
days, make suggestions as to what we can improve, tell us what we may
have done wrong (probably a lot), help us get our intranet as tuned as
possible and perhaps give us some suggestions as to how best to continue
as we develop a migration path away from Witango. What I am trying to
accomplish is to get our new networking folks, who are taking over
support of all our servers, and this includes Witango, educated in just
what it takes to run Witango.

   In a nutshell what I am asking:

   1. On site visit for approximately 3 days (more if you believe it
necessary)
   2. Look at our current configuration and make suggestions as to how
we can improve
   3. Educate our networking folks as to how to work with the client.ini
and server.ini files to tweak Witango so they can support it
   4. What you would charge for time, travel, accommodations, etc.

   This is a Windows environment running Windows Server 2003 and SQL
server 2000, eventually using SQL server 2005 when the transition to our
Dallas datacenter is complete. Because we are a defense contractor the
person on-site would have to be a US National and have to sign a
non-disclosure agreement.

   If your company can do this, and you are interested, please respond
to me off list.

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango Customer Support

[Wolf, Gene]

My thanks to Robert, William and Roland who responded. All saying much
the same thing. I've been a user of Witango since the Everyware days and
it's heavily in use here at DRS Optronics, a large division of DRS.
(www.DRS.com outbind://111/www.DRS.com ) Control of Witango, load
balancing, responsiveness, etc., is being passed to our Dallas division.
No longer will I have the hands on access I once did. I see this as a
good thing since I can concentrate more on what I'm good at and the guys
who know more about networking and database tweaking can concentrate on
what they know best.

The problem is Phil has already pissed off my management. I'm copying an
e-mail our IT Director in Dallas sent the other day. He has still
received no response. I am absolutely amazed. We all wonder why a tool
as good as Witango doesn't take off. I think we see the answer here. DRS
is a $1.5B company. The largest division of DRS is a heavy user of
Witango. Imagine if this company was convinced that Witango was a valid
tool? With the exchange of e-mail below, and the comments I have
received from you folks which I am going to pass on to management, I
don't see that happening here. 

It's unfortunate that this opportunity is being squandered by the folks
at Witango. 

 
 


From: Magnotti, Ernie [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 01, 2007 10:56 AM
To: [EMAIL PROTECTED]
Cc: Veltri, James; Wolf, Gene
Subject: FW: Witango Help
Importance: High



Dear Witango,

 

At the bottom of this thread is a request for support from one of my
datacenter staff. It has been over a week and we have not had any
response. 

Witango is a critical part of our infrastructure. We've also spent a lot
of money on licensing for Witango. Further, I have made it a priority
for James Veltri, who initiated this request for support, to confer with
Witango support regarding our configuration. The current performance is
unacceptable due to heavy CPU load during peak times of the business
day. 

Please follow up on James inquiry below, and let us know of a better way
to interact with you on future support issues.

 Ernie Magnotti

IT Manager
DRS Sensors  Targeting Systems, Inc.
mailto:[EMAIL PROTECTED]
Desk: 972-560-5790

 

 

 

From: Veltri, James [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 01, 2007 9:33 AM
To: Magnotti, Ernie
Subject: FW: Witango Help

 

FYI

 

From: Veltri, James 
Sent: Thursday, September 20, 2007 10:11 AM
To: '[EMAIL PROTECTED]'
Subject: Witango Help

 

Hello,

My name is James Veltri and I'm with DRS Optronics, Inc. we currently
use your product Witango to develop our Intranet applications. I'm not a
developer myself, but I'm one of the Data Center/Infrastructure people
and I've been assigned to troubleshoot a performance issue that we've
been experiencing.

I'll give you a quick breakdown on  how our Witango servers are
configured. Basically we have one main server which hosts IIS, Witango
which talks to a Backend server which hosts the SQL Databases for
Witango.

Basically what we've been experiencing is that during our heavy load
periods (which we could potentially have 1000 users trying at one time)
the processors on our main server peg out and eventually end up locking
up the system which requires a reboot. Now I was given a document by
Gene Wolf our BSG (Business Systems Group) guy Witango 5 Professional
Server Configuration Guide which spells out how to separate the Witango
services onto other Servers to spread out the load. 

However none of the documentation that I could find shows us a migration
path from our current configuration to the load-balanced configuration..
Any documentation you could send me on the above would be greatly
appreciated.

Also if possible could you provide me with an Best Practice guides you
may have on configuration of the servers for the Witango service.

Thanks,

James Veltri




From: Robert Garcia [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 03, 2007 5:14 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango Customer Support


You have to piss them off on this list, and then they respond. Of give
them a credit card number. Those are the only ways that are most likely
to work. 

Their support is horrible.


-- 

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Oct 3, 2007, at 1:19 PM, Wolf, Gene wrote:


   Hey all, quick question. We are reorganizing here at DRS and
moving our servers to our data center in Dallas (we're in Florida) and
centralizing our networking support there as well. This is all a good
thing. Needless to say Witango is an unknown to everyone in Dallas and
they want to understand as much as they can about Witango and supporting
it. They have written several e-mails to [EMAIL

RE: Witango-Talk: Witango Customer Support

[Wolf, Gene]

Wow, unprofessional and a spectacle? I've reached a new high. Needless
to say Scott I'm voicing concerns I've heard on this list many times
before. Check the archives. It's a fact. I've used Witango for years and
I've sold Witango clients to others on this list and believe I have
conducted myself in a very professional manner in all of those
transactions. Only others can judge that. 

I bring to light that my management is asking questions in my first
e-mail yesterday and get 3 answers, two on this list and one in private
that say, essentially, to get any response you have to piss off Phil.
Not my words. Due to those posts I point out that With may very well be
missing out on a huge opportunity, and point out that this potential
missed opportunity may be the reason Witango is not more widely in use
than it is, again statements made on this list many times before. 

When you have something constructive to post please do so. There's only
one person here posting anything sniveling and unprofessional and it's
not me. 

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 8:29 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Witango Customer Support

Hi Gene,

I'm not sure what you hope to gain out of publicly exposing Phil or your
company like this, but it won't be positive or anything that could
possibly help achieve a working solution to your problem. 

Despite whatever faults Phil or the Witango product and/or company may
have, nothing warrants this type of unprofessional response. 

If this is the position and opinion you've arrived at about Phil and
whomever else may work at Witango, than either whine and snivel
privately - or on the List like others have chosen. Or... make that
dreaded business decision to move on. But don't make a public spectacle
of yourself and your company in the process. 

Migrating away from Witango may be a painful decision to make (career
altering in fact [scary, huh?]), but don't try and blame your
less-than-perfect technology choices on somebody else. Who ever said
software was perfect? 

And how could you be absolutely amazed when for years we've all known
in stark terms that the future of Witango (if any) would be a long
hard-fought road. And that continuing with Witango, after Pervasive,
would be a gamble involving some personal sacrifices of our own. 

Suck it up Gene, and admit to your boss that maybe a different decision
should have been made years ago. 

I'm not here to defend Phil. I've moved on from Witango a long time ago.
I'm here to stay in touch with friends, and to occasionally give opinion
and advice - based on my own decision making experience. 

Best of luck.

Scott Cadillac
~ 902-624-1266
~ [EMAIL PROTECTED] 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango Customer Support

[Wolf, Gene]

I am asking my management where they got that e-mail address. That's why
I posted my first question to the list and provided the e-mail address
that they were using. Since I am now on the periphery of maintaining
Witango I figured a quick question to this list was the best way to get
an answer my management was asking because some of you probably have had
to contact support in the past and had an address readily available. I
hardly expected the vitriolic response I have received from some
quarters.



From: Stefan Gonick [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 9:39 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango Customer Support


Hi Gene,

I just checked the Witango.com site and looked at their support page.
No where on it is there any reference to an email address called
[EMAIL PROTECTED] .
What if they never got those emails?  Wouldn't it be a sad
misunderstanding
if there is all this anger about a lack of support when they didn't get
the messages?

Why don't you use [EMAIL PROTECTED] to set up a support contract like
the page says to do?
Alternatively, I know that Robert Shubert is great at setting up load
balancing configurations.

Let's not jump to conclusions before absolutely necessary...

Stefan

At 07:14 AM 10/4/2007, you wrote:



My thanks to Robert, William and Roland who responded. All
saying much the same thing. I've been a user of Witango since the
Everyware days and it's heavily in use here at DRS Optronics, a large
division of DRS. ( www.DRS.com outbind://111/www.DRS.com ) Control of
Witango, load balancing, responsiveness, etc., is being passed to our
Dallas division. No longer will I have the hands on access I once did. I
see this as a good thing since I can concentrate more on what I'm good
at and the guys who know more about networking and database tweaking can
concentrate on what they know best.

The problem is Phil has already pissed off my management. I'm
copying an e-mail our IT Director in Dallas sent the other day. He has
still received no response. I am absolutely amazed. We all wonder why a
tool as good as Witango doesn't take off. I think we see the answer
here. DRS is a $1.5B company. The largest division of DRS is a heavy
user of Witango. Imagine if this company was convinced that Witango was
a valid tool? With the exchange of e-mail below, and the comments I have
received from you folks which I am going to pass on to management, I
don't see that happening here. 

It's unfortunate that this opportunity is being squandered by
the folks at Witango. 
 
 



From: Magnotti, Ernie [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] 
Sent: Monday, October 01, 2007 10:56 AM
To: [EMAIL PROTECTED]
Cc: Veltri, James; Wolf, Gene
Subject: FW: Witango Help
Importance: High

Dear Witango,?xml:namespace prefix = o ns =
urn:schemas-microsoft-com:office:office /

 

At the bottom of this thread is a request for support from one
of my datacenter staff. It has been over a week and we have not had any
response. 

Witango is a critical part of our infrastructure. We've also
spent a lot of money on licensing for Witango. Further, I have made it a
priority for James Veltri, who initiated this request for support, to
confer with Witango support regarding our configuration. The current
performance is unacceptable due to heavy CPU load during peak times of
the business day. 

Please follow up on James inquiry below, and let us know of a
better way to interact with you on future support issues.

 Ernie Magnotti

IT Manager
DRS Sensors  Targeting Systems, Inc.
mailto:[EMAIL PROTECTED]
Desk: 972-560-5790

 

 

 

From: Veltri, James [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] 
Sent: Monday, October 01, 2007 9:33 AM
To: Magnotti, Ernie
Subject: FW: Witango Help

 

FYI

 

From: Veltri, James 
Sent: Thursday, September 20, 2007 10:11 AM
To: '[EMAIL PROTECTED]'
Subject: Witango Help

 

Hello,

My name is James Veltri and I'm with DRS Optronics, Inc. we
currently use your product Witango to develop our Intranet applications.
I'm not a developer myself, but I'm one of the Data
Center/Infrastructure people and I've been assigned to troubleshoot a
performance issue that we've been experiencing.

I'll give you a quick breakdown on  how our Witango servers are
configured. Basically we have one main server which hosts IIS, Witango
which talks to a Backend server which hosts the SQL Databases for
Witango

Witango-Talk: Witango Customer Support

[Wolf, Gene]

   Hey all, quick question. We are reorganizing here at DRS and moving
our servers to our data center in Dallas (we're in Florida) and
centralizing our networking support there as well. This is all a good
thing. Needless to say Witango is an unknown to everyone in Dallas and
they want to understand as much as they can about Witango and supporting
it. They have written several e-mails to [EMAIL PROTECTED]
and I've been told they have received no reply. 

   I have always used this forum to get answers and do not know the best
way to put our networking and support folks in touch with Witango
support. How do you folks do it? Do you basically rely on this list, or
is there some e-mail address other than the one listed above that should
be used for support issues? Thanks!

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Studio Feature Request

[Wolf, Gene]

Hi Bill,

When I want to join (Using MSSQL) across databases I use the Direct DBMS
in Witango. Works just fine. I figure if I can do it in a direct DMBS
that a standard select statement should do it as well. I mean, it's just
generating the SQL code so if it can link between tables in the same
database it should be able to link between tables between databases.
Just a request that would make my world a bit easier in some cases. Not
a critical request.

-Original Message-
From: William M Conlon [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 25, 2007 5:20 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Studio Feature Request

Hi Gene,

Your's is a separate feature request, unrelated to mine.

But ... mySQL will not JOIN across databases.  I certainly don't know
the SQL standard very well -- does it permit the JOIN clause to refer to
different databases?

Bill


On Sep 25, 2007, at 2:02 PM, Wolf, Gene wrote:

 How about the ability to use a standard search action and join tables 
 from multiple databases just like joining tables from the same 
 database?


 -Original Message-
 From: William M Conlon [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 25, 2007 2:46 PM
 To: Witango-Talk
 Subject: Witango-Talk: Studio Feature Request

 How about an Array builder?

 Specify the name, scope, number of rows and columns, and you get a 
 spreadsheet like interface with a grid so you can quickly enter and 
 edit the array values.  A radio button lets you select output as an 
 Action of as metatags to create an array variable and all the 
 elements.


 Bill

 William M. Conlon, P.E., Ph.D.
 To the Point
 2330 Bryant Street
 Palo Alto, CA 94301
 vox:  650.327.2175 (direct)
 fax:  650.329.8335
 mobile:  650.906.9929
 e-mail:  mailto:[EMAIL PROTECTED]
 web:  http://www.tothept.com

 __

 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 __

 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Very puzzling...

[Wolf, Gene]

   I have a situation here that I find very puzzling. So I am going back
to the experts for advice. 

   We have a few applications that, by their nature, perform thousands
of requests against a SQL database and return thousands of records. I am
quite sure that the coding of the application isn't as good as it could
be and we will look into rewriting it. Here's our issue: This program,
from start to the time it displays the returning page will take about 3
minutes. (stop groaning). We are testing this same application on a new
box containing 8 dual core cpu's. I would expect one of those cpus to be
pegged while Witango rips through these thousands of requests. Just the
opposite. The cpus indicate hardly anything happening on the box. The
same is true of SQL server. Even though I am literally throwing
thousands of requests at SQL 2005 I'm seeing virtually no cpu activity
on that box either.

   It looks almost like Witango is waiting for something, processes a
request, waits a bit more, processes the next request, waits again, etc.
The environment is Windows Server 2003. One Box is running Witango 5.5
with 8 dual core processors and the other box is Windows Server 2003
running SQL Server 2005. Yes, this program is coded and does some
looping but I would still expect it to run one heck of a lot faster than
it is.

   Any suggestions?

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: branching to html?

[Wolf, Gene]

   How about a redirect 
 
META HTTP-EQUIV=REFRESH CONTENT=0; URL=

and specify the location of the html file in that?




From: Jason Pamental [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 21, 2007 1:36 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: branching to html?


Norman, 

I don't think you can use the 'branch' action to do anything other than
branch to another part of a taf or a different taf file. You could
however use 'include' to bring the html file in. Depends on what you're
trying to accomplish really in order to figure out the best possible
approach.

Feel free to outline more completely what you're trying to do.

Jason


-

Jason Pamental
Director of Web Services
North Sails

Office: 401.643.1415
Fax: 401.643.1420
Mobile: 401.743.4406
Email: [EMAIL PROTECTED]




On Jun 21, 2007, at 1:25 PM, [EMAIL PROTECTED] wrote:


Hi,

I'd like to branch out of my .taf file to a .html file (and
perhaps some
other types of files to) and
then return to the .taf

is there any way to do this?

thanks

Norman


TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf


Visit us at http://www.northsails.com

[This E-mail scanned for viruses by Declude Virus]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Thank you for Helping us Win a Webby Award!!!

[Wolf, Gene]

Congratulations on a great accomplishment. I have one comment. When I
looked over the Blip.tv site I found their APIs and the people section
where you and Peter are mentioned. However I didn't see where Witango is
mentioned at all. Open source is mentioned, software with blip included
is mentioned, etc. Seems to me that a mention of Witango could certainly
be made.
 
One of my criticisms of Witango is its seeming lack of advertising.
Anything like blip.tv, and it is a fine site, getting literally millions
of views could certainly help especially if there is an area already
devoted to the software supporting the site.
 
Just a thought. Once again congratulations.



From: Shane Pearlman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 14, 2007 6:04 PM
To: 'Peter Chester'
Subject: Witango-Talk: Thank you for Helping us Win a Webby Award!!!



Thank you everyone,

 

Peter  I just got back from the Webby awards in New York. We truly
appreciate all the support each of you provided. Blip.tv swept the
tables and took both the people's choice and the jury prize for the
broadband category. We are incredibly proud of them and quite honored.
The event was extravagant and an absolute blast.

 

With Sincere Thanks,

 

Shane  Peter

 

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 

 

 



From: Shane Pearlman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 11, 2007 9:56 PM
To: 'Peter Chester'

Subject: Help us Win a Webby Award!!!

 

Hi everyone,

 

We placed one of our clients in the running for a webby award last year
and are now a finalist! There were over 8000 entries  they are in the
final top 5 in the broadband category. As some of you know, this is
basically the Emmy's of our industry.

 

We are incredibly excited. Please support us! Getting a webby is a huge
deal for our design/development team and for blip. Oh and pass this on!

 

Please go vote for blip.tv on the webbys and help us win the peoples
choice award. 

 

http://pv.webbyawards.com/account/login 

 

How to Vote:

 

Click the link above.

Login or Sign up using the forms to the right

Select the website category, then within entertainment, select broadband
and vote for 'blip.tv'! 

 

Thank you so much for all your support! Please pass this on to anyone
and everyone you can imagine.

 

If you've never checked out www.blip.tv http://www.blip.tv/  it's a
fabulous place for online entertainment.

 

=)

 

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 

 

 

 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Question of joins

[Wolf, Gene]

   This is probably simplistic and perhaps more of a SQL question than a
Witango question but I'm going to ask anyway. *laughs* I have an
application set up where a user selects a from location and a to
location, from a dropdown list, of something they are shipping. The
dropdown list is populated from a file and the resulting from and to
location codes are recorded to a database record in separate fields
named shipfrom and shipto. No problem so far. Everything works
perfectly.

   Now, in reporting I want to show the description of the ship from and
ship to locations. I can read the records into an array and look up each
location from the database and then display the array when done but that
seems inefficient, especially when I have to use a for loop to process
the array. Is there some way to join two different fields on the same
lookup table, in a Witango search action, in order to pull different
text values for each of the fields?

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Question of joins

[Wolf, Gene]

   I knew this wasn't going to be clear the first time. *laughs*
 
   Assume a record with the following fields and data:
 
  Field names:RecIDFromLocToLoc
11012
21410
311 9
41211
 
 
Now, the from and to locations are simply keys to another table
containing the description. My question is, what is the easiest way to
display the text value of the from and to location values other than
iterating through an array and looking up each individual value?



From: Jesse Parker [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 05, 2007 11:32 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Question of joins


I'm not sure I'm following you.  I think you have a file that contains
an array of values, and you want to do a join-like operation with your
DB for reporting purposes.
 
If this is the case, you can probably use @FILTER to get only the
relevant records from each array.  If you post more detail, I will try
to give you the filter expression.
 
I think you might be happier in the long run if you put your list of
values in the DB, instead of using the file to store these values - that
way you can use a simple join, and it's likely to be much faster than
any file-based operations.
 

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 11:00 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Question of joins



   This is probably simplistic and perhaps more of a SQL
question than a Witango question but I'm going to ask anyway. *laughs* I
have an application set up where a user selects a from location and a to
location, from a dropdown list, of something they are shipping. The
dropdown list is populated from a file and the resulting from and to
location codes are recorded to a database record in separate fields
named shipfrom and shipto. No problem so far. Everything works
perfectly.

   Now, in reporting I want to show the description of the ship
from and ship to locations. I can read the records into an array and
look up each location from the database and then display the array when
done but that seems inefficient, especially when I have to use a for
loop to process the array. Is there some way to join two different
fields on the same lookup table, in a Witango search action, in order to
pull different text values for each of the fields?

Gene Wolf 
Supervisor, Business Systems 
DRS Sensors  Targeting Systems-Optronics 
2330 Commerce Park Drive NE 
Palm Bay, Florida 32905 
Phone: 321-309-0685 
   321-309-0202 (fax) 

Dictionary.com Word of the Day 
http://dictionary.reference.com/wordoftheday/
http://dictionary.reference.com/wordoftheday/  

This e-mail, including any attached files, may contain
confidential and privileged information for the sole use of the intended
recipient. Any review, use, distribution, or disclosure by others is
strictly prohibited. If you are not the intended recipient (or
authorized to receive information for the intended recipient), please
contact the sender by reply e-mail and delete all copies of this
message.

This (document/presentation) may contain technical data as
defined in the International Traffic In Arms Regulations (ITAR) 22 CFR
120.10. Export of this material is restricted by the Arms Export Control
Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
without prior written approval from the U.S. Department of State.



TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Question of joins

[Wolf, Gene]

   Yep. This was the kind of thing I was looking for. Didn't know you
could do ON shipping.toloc = . Thanks for your help all.
Appreciate the feedback! 

-Original Message-
From: William Conlon [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 05, 2007 12:12 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Question of joins

Gene, You're after something like this?

SELECT shipping.id, shipping.FromLoc, shipping.ToLoc, To_location.name,
From_location.name FROM shipping LEFT JOIN locations To_location ON
shipping.ToLoc = To_location.id LEFT JOIN locations From_location ON
shipping.FromLoc = From_location.id WHERE ...

On Jun 5, 2007, at 9:03 AM, Beverly Voth wrote:

 Gene, if these are in an array, then you have to look them up, eh? :D
 If they are in a SQL table, you have to query them, right?

 You have a join table. If you are creating these on-the-fly and 
 putting the values into an array, why not put the text locations 
 into columns, too, as you make the join table/array?

 -- 
 Beverly Voth   Tier3 Data  Web Services Group, LLC
 606-864-0041   http://www.tier3web.com/xml.htm

  Certified FileMaker 7 Developer * FileMaker Business Alliance
  Web Design  Hosting
   Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
 Over 12 years experience integrating databases and the internet!


 On 6/5/07 11:44 AM, Wolf, Gene [EMAIL PROTECTED] wrote  
 in whole
 or in part:

I knew this wasn't going to be clear the first time. *laughs*

Assume a record with the following fields and data:

   Field names:RecIDFromLocToLoc
 11012
 21410
 311 9
 41211


 Now, the from and to locations are simply keys to another table
 containing the description. My question is, what is the easiest  
 way to
 display the text value of the from and to location values other than
 iterating through an array and looking up each individual value?

 

 From: Jesse Parker [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 05, 2007 11:32 AM
 To: witango-talk@witango.com
 Subject: RE: Witango-Talk: Question of joins


 I'm not sure I'm following you.  I think you have a file that  
 contains
 an array of values, and you want to do a join-like operation  
 with your
 DB for reporting purposes.

 If this is the case, you can probably use @FILTER to get only the
 relevant records from each array.  If you post more detail, I will  
 try
 to give you the filter expression.

 I think you might be happier in the long run if you put your list of
 values in the DB, instead of using the file to store these values  
 - that
 way you can use a simple join, and it's likely to be much faster than
 any file-based operations.


 -Original Message-
 From: Wolf, Gene [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 05, 2007 11:00 AM
 To: witango-talk@witango.com
 Subject: Witango-Talk: Question of joins



   This is probably simplistic and perhaps more of a SQL
 question than a Witango question but I'm going to ask anyway.  
 *laughs* I
 have an application set up where a user selects a from location  
 and a to
 location, from a dropdown list, of something they are shipping. The
 dropdown list is populated from a file and the resulting from and to
 location codes are recorded to a database record in separate fields
 named shipfrom and shipto. No problem so far. Everything works
 perfectly.

   Now, in reporting I want to show the description of the ship
 from and ship to locations. I can read the records into an array and
 look up each location from the database and then display the array  
 when
 done but that seems inefficient, especially when I have to use a for
 loop to process the array. Is there some way to join two different
 fields on the same lookup table, in a Witango search action, in  
 order to
 pull different text values for each of the fields?

 Gene Wolf

 __

 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Feature List Witango 6?

[Wolf, Gene]

I'd also like to make a feature request. Can the looping  @FOR, @WHILE,
@ROWS, etc. be optimized? It's a major slowdown in programs that use
them. 



From: Shane Pearlman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 31, 2007 9:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Feature List Witango 6?



Off the cuff - one feature request:

 

Image Manipulation Action (I currently use some com objects for this but
it would be nice not to have to leave WT)

(resize, watermark, examine and return properties... you get the idea)

 

-S

 

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 

 

 



From: Customer Support [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 31, 2007 6:25 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Feature List Witango 6?

 

SOME of the new features are:

 

New Witango Studio that will run on any platform (OS X, Windows, Linux,
etc)

Web Call actions with support for POST, GET, PUT, DELETE and HEAD.

Actions for easy sending, receiving emails and managing mailboxes (SMTP,
POP3 and IMAP4)

Backup Mail servers can now be used

Filesystem actions for List, Create and Delete directories.

All file actions can now used FTP

Insert and Search builders have been updated and modernised.

Heaps of interface improvements in the Studio

Transactions can be nested with different datasources

Admin functions for managing the datasource pool and user variable pool

Perl integration to the SCRIPT action and tag

Cron jobs should allow https requests

@ISFLOAT

@ISINT

@ISALPHANUMERIC

@SWITCH / @CASE

@ARRAYTOCSV and @CSVTOARRAY

@SERIALIZE

@UNSERIALIZE

 

There has also been some work done under the hood to improve stability
and in preparation for a 64-bit release of the server.

 

Windows (and linux) Dev Studio 6.0 beta will be available next week. An
alpha of the server will be available in about 2 weeks.

 

If you have requests for new features or ideas for improving existing
features let us know as the planning is already started for incremental
6.x releases.

 

 

Regards

 

Witango Support

 

 

On 01/06/2007, at 7:49 AM, Shane Pearlman wrote:





Thanks Gene!

Also, when will the Windows Beta become available? I would love to be
included.

-S

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 



size=2 width=100% align=center tabindex=-1 

From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 31, 2007 2:29 PM
To: witango-talk@witango.com mailto:witango-talk@witango.com 
Subject: RE: Witango-Talk: Feature List Witango 6?

Did anyone ever answer Shane's question? I'm curious as well.



From: Shane Pearlman [mailto:[EMAIL PROTECTED] 
Sent: Saturday, May 26, 2007 1:26 PM
To: witango-talk@witango.com mailto:witango-talk@witango.com 
Subject: Witango-Talk: Feature List Witango 6?

Has anyone published a feature list of what is changing in Witango 6?
Just curious.

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf





 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Feature List Witango 6?

[Wolf, Gene]

Did anyone ever answer Shane's question? I'm curious as well.



From: Shane Pearlman [mailto:[EMAIL PROTECTED] 
Sent: Saturday, May 26, 2007 1:26 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Feature List Witango 6?



Has anyone published a feature list of what is changing in Witango 6?
Just curious.

 

Shane Pearlman

831.345.7033

SP, Inc. http://www.shaneandpeter.com 

 

 

 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: !CST Bug

[Wolf, Gene]

I took Roland's advice and searched our programs for the !CST string.
The software I used to search reported Searched 3244 file(s), found 401
occurrences in 58 file(s) so it's obviously not just a Mac problem
since we are a windows environment. Looks like we have a few programs to
update.

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

-Original Message-
From: Roland Dumas [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 13, 2007 10:55 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: !CST Bug

Any time you edit an action that touches a database,  the taf should be
opened in a text editor and a search for CST.

On Apr 12, 2007, at 9:01 PM, Ben Johansen wrote:

 It is unconscionable for a vendor to have such a blatant bug in 
 software and not deal with it.
 this is going on 2 years, of knowing it has this issue and not fixing 
 it.
 and selling it as if there is not a problem.

 I really appreciate getting pressure and being accused of wasting 
 time, just to find out that it was this bug that should have been 
 fixed.

 No this is not just a Mac issue. It happens, though not as much in 
 Windows version of Dev Studio

 I caution anyone that is working on a high profile site and using this

 product. you better check each and every file after every save because

 the dev studio can't be trusted

 Ben
 __
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Passing a path with arguments as an ARG

[Wolf, Gene]

   There's probably a number of way you can do this. Two come to mind. 

   1. When you create your var do it like this: @Assign Local$Framevar
isellit/products/products.taf?_function=listProd_No=10.2035  Then
replace the troublesome characters like so:

@Assign Local$Framevar @Replace Str=@Var Local$Framevar
Findstr= ReplaceStr=^
@Assign Local$Framevar @Replace Str=@Var Local$Framevar
Findstr=? ReplaceStr=!

   Then reverse the process at the other end like so:

@Assign Local$Framevar @Replace Str=@Var Local$Framevar
Findstr=^ ReplaceStr=
@Assign Local$Framevar @Replace Str=@Var Local$Framevar
Findstr=! ReplaceStr=?

   2. Create a system var called Frameset. The do the assign to a
variable in the Frameset class:

@Assign Frameset$Framevar
isellit/products/products.taf?_function=listProd_No=10.2035 Then you
don't have to pass it at all. Just check, as you're building your frame,
whether a value exists in that variable or not. If so use it then purge
it otherwise take a default action.

   Hope that helps. Even better, I hope I understood your question
exactly. *laughs*

-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 09, 2007 9:58 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Passing a path with arguments as an ARG

I wish to pass a string such as:

isellit/products/products.taf?_function=listProd_No=10.2035

To a TAF that builds a frameset. Unfortunately by the time it gets there
it
is:

isellit/products/products.taf?_function=list

Obviously the ampersand is throwing me but I'm not sure what very
obvious thing I am doing wrong.

To test it I built a little test taf:

http://www.kayellaustralia.com.au/frametest.taf

Enter: isellit/products/products.taf?_function=listProd_No=10.2035

And it works!!

But the actual implementation is for a Newsletter that is built from a
content management system and sent as HTML email. You can view a sample
one
here:

http://www.kayellaustralia.com.au/sample_newsletter.html

The links in question are the 'Related Products' links.

I cannot fathom what the difference is except one argument string is
sent from a form and the other hard coded into a A HREF.

Anyone got some pointers?

Wayne Irvine


  Byte Services Pty Ltd
   http://www.byteserve.com.au/
  [EMAIL PROTECTED]
   Ph 02 9960 6099   Mob 0409 960 609   Fax 02 9960 6088


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Witango and BPEL

[Wolf, Gene]

   OK, some of you folks are steeped in the theoretical aspect of
programming. You're up to speed on the latest and greatest. I'd like
your feedback. We are now moving towards something called BPEL (Business
Process Execution Language) Here's a short excerpt from the wikipedia
website (http://en.wikipedia.org/wiki/BPEL) concerning BPEL:

is a business process modeling /wiki/Business_process_modeling
language that is executable. The origins of BPEL can be traced to WSFL
/wiki/Web_Services_Flow_Language  and XLANG /wiki/Xlang . It is
serialized in XML /wiki/Extensible_Markup_Language  and aims to enable
programming in the large /wiki/Programming_in_the_large . The concepts
of programming in the large and programming in the small
/wiki/Programming_in_the_small  distinguish between two aspects of
writing the type of long-running asynchronous processes that one
typically sees in business processes /wiki/Business_process .

This sounds an awful lot like Witango to me. In reading the entire
section it seems to be describing Witango. I'd like to get your take on
it and see what the Witango community thinks of this. Can Witango be
thought of as a BPEL language or and I just thinking wishfully?


Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: OT: Witango hosting

[Wolf, Gene]

   This is a bit off topic. I'm looking for a hosting service for my
personal use. No, not business related. *laughs* If any of you offer
site hosting and Witango app hosting (and perhaps database support as
well) would you please send me some information pertaining to costs?
Yes, I did try the Witango e-mail search looking for Hosting in the
message title and received the following error message:
Error
An error occurred while processing your request:
File: searchforum.taf
Position: DirectDBMS
Class: DBMS
Main Error Number: 1064

[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max]You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'ORDER BY
w1.datereceived DESC limit 50' at line 12
23000

File: searchforum.taf
Position: DirectDBMS
Class: Internal
Main Error Number: -101


Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Recommendation Sought

[Wolf, Gene]

   OK, I have looked through the mail archive and can't find a single
answer to my situation so maybe there isn't one. However I will put it
to this group in the form of soliciting recommendations. We are
currently running in a Windows 2003 environment on a 32-bit
architecture. We are going to be relocating our servers to Dallas on new
servers which will be running under a 64-bit technology. Now I have read
about running Witango 5.5 in WOW mode but some people indicated this
would be slow because of emulation. We can also install the 32-bit OS on
these 64-bit machines but my understanding about that is we will be
limited to 4gig of RAM if we did.

   If you were running Witango 5.5 on a 64-bit box what would you see as
the best way to set up a new environment? Linux? WOW? Yes, we also have
to run a web server on one of these boxes. Thanks for your input!

Gene Wolf
Supervisor, Business Systems
DRS Sensors  Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
   321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited. If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

 This (document/presentation) may contain technical data as defined in
 the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
 Export of this material is restricted by the Arms Export Control Act
 (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
 without prior written approval from the U.S. Department of State.
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Mail BCC - brain dead this morning

[Wolf, Gene]

I use commas. 

-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 06, 2006 8:04 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Mail BCC - brain dead this morning

Can't remember if I separate email addresses with , or ; for multiple
BCC addresses?
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com 

Men do not care how nobly they live, but only how long they live,
although it is within the reach of every man to live nobly, but within
no man's power to live long.  Brian Haig Private Sector





TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: File Builder

[Wolf, Gene]

OK, I'm stumped. We have set up another Witango Server (Windows) in
addition to the one we have been running and everything seemed to work
fine. The second box was receiving and processing requests, response
time looked like it had improved, etc. Great! However, we create a good
number of reports in PDF format and write them to a directory.  We use
this in our paperless shipping systems, etc.

Now comes the problem. In the File builder we specify a specific
directory, for example, 

D:/ETDocs/@Var Local$Docname

Now, depending on which server this executes on, it seems to me this
file would be written to different machines. If a person came back later
and tried to look at that document they may, or may not, get the machine
that this document is located on and not be able to see the file.

Now, I suppose we could map drive letters on every server to point to
the same place and make sure all of the drive letters are the same on
every server but this seem inelegant. Has anyone run into this before
and how did you work around it?

Thanks for your help.

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: File Builder

[Wolf, Gene]

Excellent solution! Thanks Bill! Knew there had to be a better way! 

-Original Message-
From: Bill Downall [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 06, 2006 8:29 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: File Builder

Gene,

Don't map the drive, just share it to the user name that the Witango
service runs under, and use the unc name:

\\servername\ETDOCS\@VAR request$Docname

Wolf, Gene wrote:
 OK, I'm stumped. We have set up another Witango Server (Windows) in 
 addition to the one we have been running and everything seemed to work

 fine. The second box was receiving and processing requests, response 
 time looked like it had improved, etc. Great! However, we create a 
 good number of reports in PDF format and write them to a directory.  
 We use this in our paperless shipping systems, etc.
 
 Now comes the problem. In the File builder we specify a specific 
 directory, for example,
 
 D:/ETDocs/@Var Local$Docname
 
 Now, depending on which server this executes on, it seems to me this 
 file would be written to different machines. If a person came back 
 later and tried to look at that document they may, or may not, get the

 machine that this document is located on and not be able to see the
file.
 
 Now, I suppose we could map drive letters on every server to point to 
 the same place and make sure all of the drive letters are the same on 
 every server but this seem inelegant. Has anyone run into this before 
 and how did you work around it?
 
 Thanks for your help.
 __
 __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Setting up multiple Witango boxes

[Wolf, Gene]

   Wow. You really scored some points here at my expense. I'm impressed and 
humbled by your prowess. 

   I did look at the Developers section, at the download section and then 
scanned the mail list archive. The closest I could come to was the generic 
http://developer.witango.com/downloads/downloads.taf?_function=list_UserReference=80D567F1A9887CDC44D1DC20dType=installguide
 however, I suspect if I spent more time I would eventually run across the link 
you sent. I also scanned the mail archives. Lots of discussion and some really 
great information for people who know what they're doing but no real how to 
step by step instructions. Having the link you sent I did a search on it. Seems 
that with all of the questions on multiple servers, multiple processors, and 
dual core processors, which was my question, many people would be referring to 
this document. It's referenced once back in 2004. 

   I will read this document. I will also see if there's a way we can avoid 
buying two more professional licenses. Probably not but now I am motivated. 
Thank you for taking the time to respond to my e-mail.

-Original Message-
From: Phil Wade [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 03, 2006 1:48 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Setting up multiple Witango boxes


 It seems really unreasonable to expect someone new to Witango to  
 have to pour through the Witango mail list archives to figure out  
 how to do this.

I agree.  You could always read the Witango 5 Professional Server  
Configuration Guide which you can download from the developer site.

http://www2.witango.com/downloads/ProfConfigGuide.pdf


Regards

Phil

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Setting up multiple Witango boxes

[Wolf, Gene]

I know 
a number of you have done this but I can't seem to find any instructions on 
doing this anywhere. We are outstripping our current hardware as we grow and 
slowly transition to another language. We need to gain capacity for processing 
Witango queries and plan on getting two new servers, dual core, strictly for 
processing Witango requests. I have two questions:

 1. Can Witango currently take advantage of dual core 
processors and 
 2. Are there instructions anywhere that someone can point me 
to explaining how to set up an environment similar to the 
following:



 If anyone can direct me to instructions, and offer pitfalls 
to watch out for I'd greatly appreciate it. Thanks! 

 Oh, we will be using Witango 5.5 professional on each 
Windows server box. Yes, we're planning on purchasing 2 additional licenses. 
*grins*

RE: Witango-Talk: Setting up multiple Witango boxes

[Wolf, Gene]

 Thanks Robert. I will check out the Witango site to find any 
messages I can for setting this up but it seems to me with dual core CPU's 
becoming commonplace and now multiple dual cores being readily available, it 
would be very useful for Witango to provide specific instructions on how to set 
up 1, 2 and 4 CPU boxes or single and dual core cpu'sand also how to set 
up multiple boxes to take best advantage of the cpu's. It seems really 
unreasonableto expectsomeone new to Witango to have to pour through 
the Witango mail list archives to figure out how to do this.

  -Original Message-From: Robert Garcia 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 02, 2006 3:00 
  PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: 
  Setting up multiple Witango boxesI missed the last line, 
  after the image, if you have professional licenses, you should be able to use 
  dual core on each, with will give you a load group of 4 witango servers, and 
  so you will have to have the 2 on the same servers, point to different ports, 
  which makes it a bit trickier, but doable. Unless the professional license 
  will allow you to set processor affinity to ALL, then you will have just 2 
  witango servers, taking advantage of all cores, which, IMHO, would be the best 
  setup.
  
  
  --
  
  Robert Garcia
  President - BigHead Technology
  VP Application Development - eventpix.com
  13653 West Park Dr
  Magalia, Ca 95954
  ph: 530.645.4040 x222 fax: 530.645.4040
  [EMAIL PROTECTED] - [EMAIL PROTECTED]
  http://bighead.net/ - http://eventpix.com/
  
  On Aug 2, 2006, at 11:50 AM, Wolf, Gene wrote:
  
I 
know a number of you have done this but I can't seem to find any 
instructions on doing this anywhere. We are outstripping our current 
hardware as we grow and slowly transition to another language. We need to 
gain capacity for processing Witango queries and plan on getting two new 
servers, dual core, strictly for processing Witango requests. I have two 
questions:

 1. Can Witango currently take advantage of dual core 
processors and 
 2. Are there instructions anywhere that someone can 
point me to explaining how to set up an environment similar to the 
following:


2006-08-02_14-43-44-069.png

 If anyone can direct me to instructions, and offer 
pitfalls to watch out for I'd greatly appreciate it. Thanks! 


 Oh, we will be using Witango 5.5 professional on each 
Windows server box. Yes, we're planning on purchasing 2 additional licenses. 
*grins*
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Array processing

[Wolf, Gene]

   David,

   This worked perfectly! Thank you! 

-Original Message-
From: David Shelley [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 8:53 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing


Another way to do this would be to create an array of all the rows in array1
that are not in array2, and an array of all the rows in 2 that are not in 1,
then append them together.

@assign local$array1 @array value=1;2;4;5;6;
@assign local$array2 @array value=2;3;4;5;6;7;

@assign local$in1not2 
@filter array=local$array1 expr=!(@@local$array2 contains #1)
@assign local$in2not1 
@filter array=local$array2 expr=!(@@local$array1 contains #1)

If both arrays are not empty then 
the result is local$in1not2 + local$in2not1
Else if local$in1not2 is not empty
the result is local$in1not2
Else 
the result is local$in2not1 


@if expr=@numrows array=local$in1not20  @numrows
array=local$in2not10
@assign local$result @@local$in1not2
@addrows array=local$result value=@@local$in2not1
@elseif expr=@numrows array=lcoal$in1not20
@assign local$result @@local$in1not2
@else
@assign local$result @@local$in2not1
/@if

@@local$result then contains the values 1;3;7;

Note that though this method uses only 2 filters and an addrows to implement
an exclusive or, the filter statements can be quite slow if the arrays are
large.

Also, I ran the code above through my tango debugger an it works, however
some modifications will be required for multi-column arrays or when doing
the comparison on a variable column number.

Dave Shelley

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 16, 2006 5:23 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing

This would give me all members of both arrays. Yes, I could then use that to
look at each individual array and if the number in the Union'd array did not
appear I could build my own list. I was just hoping that there was some
function I may have overlooked that would do this for me. *laughs*
Apparently not from the responses. Sounds like it's time for me to build a
tcf to do this.

-Original Message-
From: Matt Muro [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 5:14 PM
To: witango-talk@witango.com
Cc: witango-talk@witango.com
Subject: Re: Witango-Talk: Array processing


Just a thought as I run out the door here (I haven't tried this) ...

What about using @UNION to combine the arrays and then performing
@DISTINCT on the combined array to have only the DISTINCT elements
returned.



witango-talk@witango.com on Thursday, February 16, 2006 at 5:03 PM -0500
wrote:
   Not at all. Assume I have array 1 with the following rows:

1
2
3
4
5

And I have Array 2 with the following rows:

2
3
5
6
7

I'd like to have some kind of function that would tell me all of the
elements of these two arrays that do not appear in BOTH arrays, those
being 1,4,6,7. Does that help?

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing


Hi Gene,

 I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays.

I don't get it. Is this a trick question?


Scott Cadillac, 
Email: [EMAIL PROTECTED] 
http://scott.cadillac.bz 


  

 -Original Message-
 From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 16, 2006 2:42 PM
 To: witango-talk@witango.com
 Subject: Witango-Talk: Array processing
 
 I've seen a number of the array processing commands like 
 @intersect, @Union, etc. but I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays. Is there anything like the equivalent of 
 [EMAIL PROTECTED] *laughs* 
 __
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf






Matt Muro  [EMAIL PROTECTED]
Harvard University   phone:  617.998.8522
Division of Continuing Education   fax:  617.495.9176


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http

Witango-Talk: Array processing

[Wolf, Gene]

I've seen a number of the array processing commands like @intersect, 
@Union, etc. but I need something that compares two arrays and returns to me 
those rows that do not exist in BOTH arrays. Is there anything like the 
equivalent of [EMAIL PROTECTED] *laughs*

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Array processing

[Wolf, Gene]

   Not at all. Assume I have array 1 with the following rows:

1
2
3
4
5

And I have Array 2 with the following rows:

2
3
5
6
7

I'd like to have some kind of function that would tell me all of the elements 
of these two arrays that do not appear in BOTH arrays, those being 1,4,6,7. 
Does that help?

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing


Hi Gene,

 I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays.

I don't get it. Is this a trick question?


Scott Cadillac, 
Email: [EMAIL PROTECTED] 
http://scott.cadillac.bz 


  

 -Original Message-
 From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 16, 2006 2:42 PM
 To: witango-talk@witango.com
 Subject: Witango-Talk: Array processing
 
 I've seen a number of the array processing commands like 
 @intersect, @Union, etc. but I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays. Is there anything like the equivalent of 
 [EMAIL PROTECTED] *laughs* 
 __
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Array processing

[Wolf, Gene]

This would give me all members of both arrays. Yes, I could then use that to 
look at each individual array and if the number in the Union'd array did not 
appear I could build my own list. I was just hoping that there was some 
function I may have overlooked that would do this for me. *laughs* Apparently 
not from the responses. Sounds like it's time for me to build a tcf to do this.

-Original Message-
From: Matt Muro [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 5:14 PM
To: witango-talk@witango.com
Cc: witango-talk@witango.com
Subject: Re: Witango-Talk: Array processing


Just a thought as I run out the door here (I haven't tried this) ...

What about using @UNION to combine the arrays and then performing
@DISTINCT on the combined array to have only the DISTINCT elements
returned.



witango-talk@witango.com on Thursday, February 16, 2006 at 5:03 PM -0500
wrote:
   Not at all. Assume I have array 1 with the following rows:

1
2
3
4
5

And I have Array 2 with the following rows:

2
3
5
6
7

I'd like to have some kind of function that would tell me all of the
elements of these two arrays that do not appear in BOTH arrays, those
being 1,4,6,7. Does that help?

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing


Hi Gene,

 I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays.

I don't get it. Is this a trick question?


Scott Cadillac, 
Email: [EMAIL PROTECTED] 
http://scott.cadillac.bz 


  

 -Original Message-
 From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 16, 2006 2:42 PM
 To: witango-talk@witango.com
 Subject: Witango-Talk: Array processing
 
 I've seen a number of the array processing commands like 
 @intersect, @Union, etc. but I need something that compares 
 two arrays and returns to me those rows that do not exist in 
 BOTH arrays. Is there anything like the equivalent of 
 [EMAIL PROTECTED] *laughs* 
 __
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf






Matt Muro  [EMAIL PROTECTED]
Harvard University   phone:  617.998.8522
Division of Continuing Education   fax:  617.495.9176


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Tough question

[Wolf, Gene]

Title: Tough question






 I hate asking this question but most of you have either faced this question from your customers or management in the past or have addressed it yourselves. I figured I'd go to the people who know best.

 I have been strongly encouraged by my management to look for and train my people in a more mainstream product. They have been very patient (3 years now) and very pleased with the productivity that my group can deliver with Witango. However they can't take it upstairs to corporate. They can't find it in any trades, they can't find mention of it in any recent reviews, they can't find people who know it locally, etc. It makes them nervous. Hence the encouragement to move on.

 Witango has been a great tool for me for 10 years. I've been here since the Everyware days. However I understand management's nervousness. My question is, what mainstream product comes close to doing what Witango does? We're looking at Visual Studio, Oracle HTML DB, and some other tools. Some are slicker than Witango in that you can create templates, etc, but none come close to ease of use. 

 Anyone have any suggestion for a migration path? We're a Windows shop currently using MS SQL Server but transitioning to Oracle. Thanks for any suggestions you can give.






TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: General Question about COM objects

[Wolf, Gene]

 I am looking at an application package (Bartender 7.72) to 
allow up to generate barcoded shipping labels on a Printronix Printer on the 
fly. What I am trying to accomplish is to look up information from a database 
based on a product number scanned in via barcode scanner, retrieve specific 
customer information from the database, and create shipping labels (eventually 
RFID encoded from this printer) with specific barcodes. Now, the Bartender 
software controls the printer beautifully. However the database access of their 
software is not as easy as it is in Witango. The software does lend itself to be 
used as COM objects and I have added a reference to this software in Visual 
Studio .net environment. However, when I attempt to add this software as a COM 
object in Witango I receive a "No Type Library" error message in Witango and no 
methods are included.

 Does 
anyone know why this message is generated? I'm using Witango 5.5 Developer on a 
Windows XP 2002 environment. Thanks for your 
help!



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: WiTango 5.5, Corda 6.0, and Double Byte Languages

[Wolf, Gene]

   We are currently using Corda with Witango 5.0. Wish I could help.

-Original Message-
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 10, 2005 2:56 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: WiTango 5.5, Corda 6.0, and Double Byte
Languages


I don't use it, but as far as text encoding goes, witango is a one  
horse show. ISO-8859-1.

I don't know how corda works with witango, but I have done stuff with  
other integrations, where I had to write my own code in other  
languages that are aware of other text encodings.

-- 

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Nov 10, 2005, at 11:42 AM, Dave Machin wrote:

 Does anyone use Corda's Popchart graphing server with WiTango 5.5  
 on Windows
 with double-byte languages (like Chinese or Korean)?

 We're having serious trouble with the combination and it's  
 prohibiting us
 from upgrading several servers from 5.0 to 5.5.  Just wondering  
 where to go
 for some help...

 Dave Machin


 __ 
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Server setup question

[Wolf, Gene]

   Here's a general question that some of you have probably run in to before 
and I need some direction. We currently have Witango professional running on a 
Windows 2003 quad server accessing a SQL database on another server. At times, 
due to load, we are seeing the Witango server slow down. Now, our web server is 
also being run on this machine. What I would like to do is to purchase another 
Witango professional license, and move our current Witango application server 
to another box, and the new server to yet another box. This would give us two 
Witango application servers, accessing our SQL server and handling calls from 
our IIS server. Four boxes in all.

   First question, is this doable?
   Second question, how would I set up IIS to determine which box to send 
queries to?
   Third question, shouldn't this help our response time assuming the database 
is not the bottleneck?

   Thanks for your advice!

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: How to create a PDF

[Wolf, Gene]

  We have successfully used a product from CORDA called Highwire to generate 
PDF documents from Witango on the fly. It works great. Maybe a little pricey 
but it was worth it to us because everything is handled as a COM object. Since 
we also use their charting package it fit right in to our environment. Take a 
look at what they have to offer at www.corda.com

-Original Message-
From: jeffgoldstein
[mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 2:10 PM
To: witango-talk@witango.com
Subject: Witango-Talk: How to create a PDF


I have written several tango app's where there is functionality to create and 
.XLS file. Now I have been asked to create a PDF.

I attempted to change the header from:

HTTP/1.0 200 OK@CRLFContent-Disposition: 
attachment;filename=allocations-extract.xls@CRLFContent-Type: 
application/vnd.ms-excel@CRLFCache-control: private@CRLF@CRLF

This creates the .XLS file but when I changed it to;

HTTP/1.0 200 OK@CRLFContent-Disposition: 
attachment;filename=allocations-extract.pdf@CRLFContent-Type: 
application/pdf@CRLFCache-control: private@CRLF@CRLF

It did not work, but rather creates an error 500. Any help would be appreciated.

-Jeff Goldstein

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: OS X.4

[Wolf, Gene]

   Does anyone know if this is an issue with Windows and SQL Server? I have 
just performed a search and we have this in literally hundreds of places. I 
can't say we have been having major issues, but our server has shown some 
peculiar behavior from time to time and it could very well be related to this 
issue.

-Original Message-
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 6:44 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: OS X.4


I have seen it with primebase, and MSSQL 2000, and MYSQL.

--  

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Oct 20, 2005, at 3:08 AM, Dale Graham wrote:

 We're using Tiger 10.4.2 and Oracle via JDBC, and have never  
 experienced insert or update action corruptions. Could this be  
 database and/or DB connector related?

 We do occasionally see a tcf object's scope get lost shortly  
 after being added to a TAF, but after it gets changed once (or  
 twice) back, it finally sticks and we no longer have an issue  
 with it.

 On Oct 19, 2005, at 6:22 PM, Bill Conlon wrote:


 Thx much.  I found a used dual G4 1.25 GHz for the price of a  
 mini, so I'll probably stick with X.3.9.

 BTW, I've never had the corruption issue while running X.2.8.

 bill
 On Wednesday, October 19, 2005, at 03:00  PM, Robert Garcia wrote:



 I do, and there are others, like Mark Weiss and Roland.

 There is a serious bug that I don't think is JUST 10.4, but seems  
 to show up more in 10.4. Your insert and update actions can get  
 corrupted. It is a major pain, it has been reported to Witango  
 months ago. It has not been acknowledged, and none of (AFAIK)  
 have heard from witango on this.

 See previous posts for more details on the bug.

 -- 
 Robert Garcia
 President - BigHead Technology
 VP Application Development - eventpix.com
 13653 West Park Dr
 Magalia, Ca 95954
 ph: 530.645.4040 x222 fax: 530.645.4040
 [EMAIL PROTECTED] - [EMAIL PROTECTED]
 http://bighead.net/ - http://eventpix.com/

 On Oct 19, 2005, at 12:32 PM, Bill Conlon wrote:




 I think I'm ready to migrate from my circa 1998 G3 desktop.  
 Can't remember which feline is the current version, but does  
 anyone have experience running the Dev Studio on X.4?

 thx

 bill

 ___ 
 _
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf





  
 
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




 _ 
 ___
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




 __ 
 __
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Authorize.net - Shopping Cart, charting, etc.

[Wolf, Gene]

 Hutch,

 Please make sure you complain to these folks that you would 
like to see examples in Witango code. Also, for everyone else using a third 
party piece of software or utility that gives examples in everything but 
Witango, please do the same. I have done so with Corda, but they have said they 
have never heard of Witango and never received a request other than mine. If we 
make ourselves heard instead of just accepting that this is the status quo, 
maybe that will change with some of these vendors.

  -Original Message-From: Hutch White 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 17, 2005 7:22 
  PMTo: witango-talk@witango.comSubject: Witango-Talk: 
  Authorize.net - Shopping Cart
  
  Ive been so busy listening to the 
  good ideas and discussion on this list that Ive never needed to 
  post. Has anyone written code to authenticate credit card sales to 
  authorize.net? They have given examples in perl, .net and php, but I 
  sure could use some help setting it up in Tango.
  
  Thanks in 
  advance.
  
  Hutch 
White
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Witango question concerning cut and paste

[Wolf, Gene]

   OK, this is the first time I have run into this so I thought I'd ask the 
group that would know, or at least could point me in the right direction. I'm 
creating a database to store information (duh!) One of the users of this 
database today complained that they could not cut and paste pictures into the 
text area. Well no kidding! However, it got me thinking, is there some object 
that is supported by Witango that would allow a user to paste pictures into and 
then store into the database? If so, does anyone know where I could obtain 
examples, or see examples of such code on the web?

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Specifying Reply-To field

[Wolf, Gene]

Title: Specifying Reply-To field






 Is it possible, in Witango, to specify one e-mail address for the from address and a different address for the Reply-To address, much like this list does? In the standard e-mail function I do not see any way to signify this. I've looked through the documentation and do not see anything to allow this either. 

 Thanks for your help!


Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]






TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: @LDAP documentation and network authentication

[Wolf, Gene]

I'm also interested in this and anyone who might have done what we are 
trying to do now. We are running Witango under Windows and we want to be able 
to authenticate users through the Active X directory using Witango. When users 
log into the network, we want to be able to send them to a Witango program, 
have that program query Active directory to find out who they are and then give 
them access to the functions they are allowed to have. We do have a Witango 
login function, but that is in addition to their network login and we want to 
simplify that if at all possible.

   Has anyone done this and can you give me some guidance on where to look or 
examples of how to do that?



-Original Message-
From: Shannon Henderson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 2:22 PM
To: witango-talk@witango.com
Subject: Witango-Talk: @LDAP documentation


Does anyone know where I can find documentation on the @LDAP tag?  
I've found a number of references to other people looking for the same 
info, but I have yet to stumble upon the docs themselves. Any help 
would be appreciated.



Shannon Henderson
Web and System Services
Reed College
Portland, OR 97202-8199
503.517.7745
[EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: E-mail question

[Wolf, Gene]

Title: E-mail question






 I just ran into a situation where we are trying to e-mail to external clients and our e-mail server needs to have the e-mail user authenticated. This may seem like a really idiotic question for many of you but how does one go about authenticating Witango so that it is allowed to send e-mail to external users? This has had to come up in the past and I can see no config vars that relate to authentication with an ID and password.

 Thanks!


Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Does anyone know...

[Wolf, Gene]

Title: Does anyone know...






 why we would be getting the following error suddenly? It does not happen to everyone and not all of the time either.


Error

An error occurred while processing your request: 

File: DRSOLogin.taf
Position: Results3
Class: Internal
Main Error Number: -13

Cannot initialize the _javascript_ runtime.


File: DRSOLogin.taf
Position: Results3
Class: Internal
Main Error Number: -13

Cannot initialize the _javascript_ runtime.



Meta Stack Trace:

Line Meta Tag
0012 @SCRIPT EXPR=server.setVariable ('HighLow', 'Low');
*The meta stack is interpreted top-to-bottom: the top line shows the inner metatag that caused the error.



Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Job Opening requiring Witango

[Wolf, Gene]

Title: Job Opening requiring Witango






 Thought some of you might be interested in this position here in sunny Florida. Please respond directly to the ad, not to me.

http://www.careerbuilder.com/JobSeeker/Jobs/JobDetails.aspx?SiteID=cbdetshr_DID=J8C6B7798NN0TT2QY31



Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Everyone here with a stable witango 5+ / windows environment, please raise a hand

[Wolf, Gene]

 We're running 2003 Server (quad processor) with 5.0 
Professional and it's quite stable. Most of the time when we have to reboot it's 
because of something other than Witango crashing on us.

  -Original Message-From: Peter Ternström 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, December 02, 2004 
  12:14 PMTo: [EMAIL PROTECTED]Subject: 
  Witango-Talk: Everyone here with a stable witango 5+ / windows environment, 
  please raise a hand
  Hi all!
  
  if you have witango5.x / windows environment with 
  acceptable stability, please raise a hand!
  
  Peter
  
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango 5.5 Java

[Wolf, Gene]

Hey Scott, thanks for the advice. Yes, I agree we need to do a great deal more testing 
and your points are valid. Since we're playing with the 30 day trial I wanted to do 
something quick and dirty to see if there was a significant difference. I didn't see 
any and honestly expected to. I was just wondering if my expectations were unrealistic 
in this test. Obviously they are. We'll continue testing by converting some intensive 
programs over to Java and compare the time on those as well.

Thanks for the feedback.

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 4:38 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Witango 5.5 Java


Hi Gene,

I hate to say it, but I think you need to put more effort into your speed test than 
just a For 
loop.

What about the difference between how Java code handles datasources, and how Java code 
manages 
large arrays in memory and how Witango does these things?

In a production environment, these two points have been the two main stumbling blocks 
when it 
comes to seriously comparing Witango to other development platforms - as far as speed 
goes.

Of course, there are also other points to consider as well.

I would also test for performance under a load of several simultaneous requests. Say, 
20 
requests against each platform - what's the difference then?

Plus I would make sure your design approach can live with the Variable scoping rules 
you'll 
find in other platforms.

After you get through the above, then you might have a close to conclusive answer to 
your 
question.

Good luck

Scott Cadillac,
XML-Extranet ~ 403-254-5002 ~ [EMAIL PROTECTED]

Well-formed Programming in C# ASP.NET, Witango and XML 
For Hire ~ http://xmlx.ca/forhire

IExtranet ~ http://IExtranet.net

Weblog ~ http://xmlx.ca
Forums ~ http://forums.xmlx.ca
Knowledge Base ~ http://kb.xmlx.ca

P.O. Box 69006
RPO Bridlewood SW
Calgary, Alberta
Canada T2Y 4T9



-Original Message-
From: Wolf, Gene [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Tue, 21 Sep 2004 16:13:18 -0400
Subject: Witango-Talk: Witango 5.5 Java

OK, I think I am confused. *laughs* We're playing with Witango 5.5
 and one of my folks put in a lot of work and  got Witango 5.5 running
 on an older server box. I wanted to kick the tires on this during the
 30 day trial to see if compiled Java code was any faster than normal
 Witango code. So code was written to go through a for loop 100,000
 times and display the time the loop began and the time that it ended. 
 
In normal Witango code the loop took on average 21-22 seconds. Under
 compiled Java the average time was 19 seconds. We understand that we're
 running on two different boxes with different loads but I would have
 expected a much greater difference in execution speeds. Has anyone seen
 any major improvement in going to 5.5 and compiled Java. I'm wondering
 if this is even worth the trouble if the speed differences and that
 small.
 
Any feedback or thoughts are appreciated.
 ___
 _
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: What's going on?

[Wolf, Gene]

Robert wrote:

IT IS VITAL that you all read the What's New in 5.5 document.

Can you please point me in the direction of this document? I have looked at the 
Witango site and cannot seem to find it. I've looked under products and saw the what's 
new in 5.0 but not 5.5. I've looked under developer and can't find it there either. 
Unless of course he is referring to 5.5 developer and not server, but it didn't read 
that way. Thanks!


-Original Message-
From: Robert Shubert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 07, 2004 1:22 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: What's going on?


John, you make a valid point.

For who are interested in 5.5, read on...

The pricing was set on July 21, at which time the selling of the 5.0
server ceased. The resellers should all have updated their price lists
at this time.

The product was officially announced by WT's press release on Aug 28th,
as you noted, however it was more like Aug 30th in America by the time
the site was updated. I think a combination of the holiday weekend, and
perhaps a little under-enthusiasm by the resellers has led to what seems
to a lack of communication.

That said, Witango 5.5 is truly released. It is preferred that
developers make use of the 5.5 Studio at this time and provide guidance
to their clients to begin an upgrade process. IT IS VITAL that you all
read the What's New in 5.5 document. Witango 5.0 and previous files
may not be immediately usable on the 5.5 server due to some changes. 

Also, anyone who is seeking a free upgrade because they have purchased a
5.0 server after the deadline (11/1/03) should know that they will be
contacted over the next few weeks by WT directly with their upgrade.
Others seeking pricing or additional information regarding the upgrade
should review www.witango.com or seek their favorite reseller. 30-day
trial downloads, and the LITE versions are available on www.witango.com

Please contact myself, or any other reseller for more information.

Robert Shubert
www.witangostore.com


-Original Message-
From: John McGowan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 07, 2004 12:25 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: What's going on?

Any idea why I went to the Witango site today to see the press release 
titled WITANGO TECHNOLOGIES INTRODUCES WITANGO SERVER 5.5 FOR OS X and 
WINDOWS with a dateline of August 28, 2004.  But since 8/28 there has 
been NO official announcement on this mailing list?

Am I the only one who didn't get this, did my mail client destroy the 
mail before I saw it?

If not, does anybody else think it's strange that a company would forget

to tell it's best customers about a release of a product?  I've been 
waiting for the official release and the pricing information for a while

now so I could make up a proposal to do some upgrades.  I just can't 
believe we were not notified by this channel.

/John


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Reporting with Witango

[Wolf, Gene]

   Is anyone out there using any third party reporting tools either with or without 
Witango? We're trying to speed up our reporting capability and Witango is just not a 
reporting tool. We're looking at something like Crystal Reports (complicated), 
ActiveReports (http://www.datadynamics.com/default.aspx) have not looked at it yet, 
List  Label 10 (http://www.combit.com/) (can't figure out how to even use it) and 
others. 

   Ideally what I'd like to be able to do is design a report and call that report from 
within Witango either through COM objects or even web links. I'm not sure there's 
anything out there but I suspect there must be. I'd like suggestions as to what anyone 
else is using and your impressions of it. Thanks for your help!

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: ARRAY??

[Wolf, Gene]

   Sure. Here's sample code. I've tested it, it works.

@Assign Local$SpacedArray @ARRAY VALUE=A;B;C; ; ;D;E; ;F; ;G;H;

Spaced Array Begins as = @Var Local$SpacedArrayp
@Assign Local$RowCount @Numrows Array=Local$SpacedArray
@Assign Local$Ptr 1

@FOR START=1 STOP=@Var Local$RowCount
@IFEMPTY VALUE=@Trim Str=@Var Local$SpacedArray[@Currow,1]
@ELSE
@Assign Local$SpacedArray[@Var Local$Ptr,1] @Var 
Local$SpacedArray[@Currow,1]
@IF EXPR=@Currow!=@Var Local$Ptr
@Assign Local$SpacedArray[@Currow,1] ' '
/@IF
@Assign Local$Ptr @Calc EXPR=@Var Local$Ptr+1
/@IF
/@FOR
Spaced Array now = @Var Local$SpacedArrayp
@Assign Local$Ptr @Calc EXPR=@Var Local$Ptr


@CommentDelete Remaining blank rows in the Array/@Comment
@FOR START=@Var Local$Ptr STOP=@Var Local$RowCount
@Delrows Array=Local$SpacedArray
/@FOR
Spaced Array now = @Var Local$SpacedArrayp


Hope this helps!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 9:50 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: ARRAY??


Hey Gene,

I have been trying to wrap my arms around this one. Do you have a 
simple example you could show/send me? For some reason the second 
loop never counts.

Also,

is it possible to do this using the @for tag?

Thanks for any help.

May I suggest a solution? Introduce another variable called Ptr. 
Initialize it to one. Walk through your loop testing each element 
for values. For examining array fields for nulls I typically use 
@Trim Str=@Var...

Now, if you do NOT find the array element empty increment Ptr by 
one. As long as the array elements have valid values Ptr will keep 
pace with your look counter. When the first empty spot is detected 
both counters will be the same.

At the bottom of the loop you test to see the array element 
pointed to by your loop index is empty. If not, test to see if loop 
index and Ptr are the same. If so, do nothing. If not, assign the 
element pointed at by your loop variable to the location pointed at 
by Ptr and empty the element pointed at by your loop counter. Then 
increment your loop counter and Ptr. When you run across an empty 
cell, with your loop counter, you do not increment Ptr.

This will collapse all of the empty space out of your array and 
condense it at the end of your array.

It is complicated to explain but very easy to do. A small loop 
and a couple of if statements.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 4:20 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: ARRAY??


Okay,

I'm tired and crabby and need help. This should be simple, but for
some reason, I am just not seeing it.

I have variables that I am populating with small amounts of text.
They are named ...

@VAR lcell1 = test1
@VAR lcell2 =
@VAR lcell3 = test3
@VAR lcell4 = test4
etc.
etc.
etc.

Let's just stop at 4 for now to keep this simple (simple is good! Good simple)

Now I created a loop and a counter that counts up to 4 and I have
added this in the loop...

@IFEMPTY @VAR 'lcell@VAR l_counter'
@ELSE
@ASSIGN NAME=llcell@VAR l_counter VALUE=@VAR 'lcell@VAR l_counter'
/@IF

And when I display the results I can see the values correctly. It is
working as expected BUT I would like to skip the counter on every
@VAR lcell that is empty. I other words, If @VAR lcell2 is empty,
move the values from @VAR lcell3 into @VAR lcell2 and also move
the values from @VAR lcell4 into @VAR lcell3. Is this making
sense? I would like to get all the variables named 1, 2, 3, 4 etc.
with no empty variables between.

The final result should be a list of numbered variable that contain
no empty variables or empty variables in the end...

Original Variables...

@VAR lcell1 = test1
@VAR lcell2 =
@VAR lcell3 = test3
@VAR lcell4 = test4

Modified Variables

@VAR llcell1 = test1
@VAR llcell2 = test3
@VAR llcell3 = test4
@VAR llcell4 =

Thanks

There's gotta be an easy way to do this


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Maximum field length

[Wolf, Gene]

Title: Maximum field length






 Is there a limit to the maximum field length in Witango? The reason I'm asking is that I want to generate some PDF documents on the fly from Witango. The software we are using requires that the page to be rendered be sent in as a string. I'm seeing some pages in excess of 64K and it seems the software is not handling it well. I know the software is not at fault because when I send the same string, assigned to a Witango var, into the program as a text string the program generates the PDF just fine.

 I'm assuming that over a certain size Witango is having an issue with the var and is not completing it, hence giving the conversion software stomach problems.

 Thanks for your reply.


Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Doing a Between Search

[Wolf, Gene]

Title: Message



 Set up a form with two fields, one with a begin date and one 
with an end date. If you're using SQL you can then use the BETWEEN statement 
like the following SQL code snippet.

select 
* from programactions where ActionDate is not null AND ActionDate between 
'@Var Local$BegDate' and '@Var Local$EndDate' AND 
ProgramID='CARS' AND ActionDate is not null AND ResponseDate is not null order 
by 5,2,3

  -Original Message-From: Cecilia Cos 
  [mailto:[EMAIL PROTECTED]Sent: Friday, July 23, 2004 3:42 
  PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: 
  Doing a Between Search
  How 
  would I go about setting up a search form that allows users to search a date 
  fieldbetween date 1 and date 2?
  
  Cecilia C. 
  CosDatabase 
  AnalystNewsweek | 251 W 
  57th Street | New York, NY 
  | 
  10019212-445-4309[EMAIL PROTECTED]
  

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Maximum field length

[Wolf, Gene]

Title: Maximum field length



 Ben, is this the same size for variables too? If I am 
building a string, and not pulling the data from a data source, am I still 
constrained by 64K? Stated more plainly, what is the largest size a VAR can be? 
Will changing itemBufferSize change that limitation?

  -Original Message-From: Ben Johansen 
  [mailto:[EMAIL PROTECTED]Sent: Friday, July 23, 2004 4:01 
  PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: 
  Maximum field length
  
  Check 
  the configuration variable
  itemBufferSize 
  
  System 
  scope only 
  Specifies the 
  size, in bytes, of the largest column value that can be retrieved from a data 
  source. You need to increase this value only if you need to retrieve large 
  values. The default value is 65535 (64K). 
  
  
  
  
  
  Ben Johansen - http://www.pcforge.comAuthorized Witango 
   MDaemon ResellerAvailable for Witango 
  Developement
  -Original 
  Message-From: Wolf, Gene 
  [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:38 
  AMTo: 
  [EMAIL PROTECTED]Subject: Witango-Talk: Maximum field 
  length
  
   Is there a limit to 
  the maximum field length in Witango? The reason I'm asking is that I want to 
  generate some PDF documents on the fly from Witango. The software we are using 
  requires that the page to be rendered be sent in as a string. I'm seeing some 
  pages in excess of 64K and it seems the software is not handling it well. I 
  know the software is not at fault because when I send the same string, 
  assigned to a Witango var, into the program as a text string the program 
  generates the PDF just fine.
   I'm assuming that 
  over a certain size Witango is having an issue with the var and is not 
  completing it, hence giving the conversion software stomach 
  problems.
   Thanks for your 
  reply. 
  Gene 
  Wolf Business Systems Analyst, 
  TLMN DRS Optronics, Inc. 
  2330 Commerce Park 
  Drive Palm Bay, Florida 
  32905 Phone: 321-309-0685 
  E-mail: 
  [EMAIL PROTECTED] 
  
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: ARRAY??

[Wolf, Gene]

May I suggest a solution? Introduce another variable called Ptr. Initialize it to one. 
Walk through your loop testing each element for values. For examining array fields for 
nulls I typically use @Trim Str=@Var...

   Now, if you do NOT find the array element empty increment Ptr by one. As long as 
the array elements have valid values Ptr will keep pace with your look counter. When 
the first empty spot is detected both counters will be the same.

   At the bottom of the loop you test to see the array element pointed to by your loop 
index is empty. If not, test to see if loop index and Ptr are the same. If so, do 
nothing. If not, assign the element pointed at by your loop variable to the location 
pointed at by Ptr and empty the element pointed at by your loop counter. Then 
increment your loop counter and Ptr. When you run across an empty cell, with your loop 
counter, you do not increment Ptr. 

   This will collapse all of the empty space out of your array and condense it at the 
end of your array.

   It is complicated to explain but very easy to do. A small loop and a couple of if 
statements.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 4:20 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: ARRAY??


Okay,

I'm tired and crabby and need help. This should be simple, but for 
some reason, I am just not seeing it.

I have variables that I am populating with small amounts of text. 
They are named ...

@VAR lcell1 = test1
@VAR lcell2 =
@VAR lcell3 = test3
@VAR lcell4 = test4
etc.
etc.
etc.

Let's just stop at 4 for now to keep this simple (simple is good! Good simple)

Now I created a loop and a counter that counts up to 4 and I have 
added this in the loop...

@IFEMPTY @VAR 'lcell@VAR l_counter'
@ELSE
@ASSIGN NAME=llcell@VAR l_counter VALUE=@VAR 'lcell@VAR l_counter'
/@IF

And when I display the results I can see the values correctly. It is 
working as expected BUT I would like to skip the counter on every 
@VAR lcell that is empty. I other words, If @VAR lcell2 is empty, 
move the values from @VAR lcell3 into @VAR lcell2 and also move 
the values from @VAR lcell4 into @VAR lcell3. Is this making 
sense? I would like to get all the variables named 1, 2, 3, 4 etc. 
with no empty variables between.

The final result should be a list of numbered variable that contain 
no empty variables or empty variables in the end...

Original Variables...

@VAR lcell1 = test1
@VAR lcell2 =
@VAR lcell3 = test3
@VAR lcell4 = test4

Modified Variables

@VAR llcell1 = test1
@VAR llcell2 = test3
@VAR llcell3 = test4
@VAR llcell4 =

Thanks

There's gotta be an easy way to do this


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Scratching my head on this one

[Wolf, Gene]

   This has got to be simple but I'm stumped. How can I search a string for all 
occurrences of a double quote and replace them with something else, and then reverse 
the process?

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Scratching my head on this one

[Wolf, Gene]

That would be good but when I use  or '' to define what I'm looking for Witango 
has fits.

-Original Message-
From: John McGowan [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 10:06 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Scratching my head on this one


@replace

Wolf, Gene wrote:

   This has got to be simple but I'm stumped. How can I search a string for all 
 occurrences of a double quote and replace them with something else, and then reverse 
 the process?

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

  



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Javascript to Witango

[Wolf, Gene]

 When you are creating your VAR, include the value of the 
variable you want to send to your program and code it as an arg. For example, 


{var fileInfo = file 
+"?yMax="+yMax+"@USERREFERENCEARGUMENT";};

 Hope this is what you're looking for.

  -Original Message-From: Steve Smith 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 30, 2004 10:54 
  AMTo: WiTango ListSubject: Witango-Talk: _javascript_ to 
  Witango
  Forgive my basic level question but how can I pass a _javascript_ variable 
  to Witango? I'm calling a script that creates a popup and when I call it I 
  pass some parameters. I'd like one of those parameters to be a value that I 
  can assign to a Witango variable that will be used within the popup. 

  The calling code is: 
  A HREF="">"_javascript_:popupwin('popup.taf','returns',750,500);" 
  >"window.status='Returns Information'; return true" >"window.status=' '; return 
  true"Return Policy/A 
  and the _javascript_ code is: 
  function popupwin(file,info,x,y) { 
  {var fileInfo = file +"?@USERREFERENCEARGUMENT";}; 
  var winName = info + "x"; 
  var xMax = screen.width, yMax = screen.height; 
  var xSiz = x, ySiz = y; 
  var xPos = (xMax - xSiz)/2, yPos = (yMax - ySiz)/5; 
  infoFile = 
  window.open(fileInfo,winName,"toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=" 
  + xSiz + ",height=" + ySiz + ",screenX=" + xPos + ",screenY=" + yPos + 
  ",left=" + xPos + ",top=" + yPos); 
  } 
  I want to take the value from the 'info' parameter and assign it to a 
  Witango variable. 
  Can somebody point me in the right direction? 
  Thanks, 
  Steve Smith 
  Oakbridge Information Solutions 
  Office: (519) 624-4388 
  GTA: (416) 606-3885 
  Fax: (519) 624-3353 
  Cell: (416) 606-3885 
  Email: [EMAIL PROTECTED] 
  Web: http://www.oakbridge.ca 




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango Who?

[Wolf, Gene]

   I'd also suggest, if possible, to provide an estimate on the amount of time it took 
to get these sites up and running. One of the best selling points for Witango is the 
amount of time it takes to get something up and running as compares to Cold Fusion, 
PHP, or some other platform. 

-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 1:19 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Witango Who?


Most of what is being sent to me is good.

Isn't there a large presence in Australia?  I thought Phil gave a few really
big sites at the last conference.

on 6/27/04 8:14, Dan Stein at [EMAIL PROTECTED] wrote:

 I need a list and or some examples of where Witango applications are
 deployed especially in some larger or corporate settings and also in Higher
 Education.
 
 This is for a large proposal where I am going up against .Net people who say
 Witango who?
 
 Needed ASAP. I was hoping to see stuff like this on the new site.

-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


When you are born, you cry and those who love you rejoice.  And if you
live your life as you should, when you die, you rejoice and those who
love you cry.


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Unhandled exception BS!

[Wolf, Gene]

   Yes, we get it here too. Here's what we found:

   1. It's random. It does not happen for weeks then you get a flurry.
   2. It seems to happen most often when clicking in the Snippets tab at the bottom 
right of the editor.
   3. Greg McElhinney, one of our programmers here found out if you have Snippets open 
when you go into a program to edit it you do not get this error.
   4. As I said in number 1, it's random. You may or may not find any of the above 
helpful.



-Original Message-
From: Peter Ternström [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 1:35 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Unhandled exception BS!


Hey folks,

this error is really pissing me off now! Keep getting it every 2 minutes of
programming or so. It is not linked to any particular action and just shuts
down the editor randomly. Tried re-installing the product, but it doesnt
seem to help. Any ideas?

Peter



Date: Wed Jun 02 07:30:17 2004

Product: Witango Studio
Version: 5.0.1.037
CD Key: xx
Operating System: Windows NT, 5.1, 2600, Service Pack 1
Unhandled exception: 0xc005
Address:0x4a1ad6


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Recursion

[Wolf, Gene]

   We have a need to write a Witango .tcf that recurses. We are finding that 
everything works well as long as the .tcf is calling itself. However, as soon as it 
falls out of the loop it is in and goes back to a previous instance, it seems lost. 

   Does anyone has a simple example of a recursive routine in Witango they can send me 
so I can compare it against what I am doing to see what I am doing wrong? Thanks!

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Setting Witango variables inside of Javascript

[Wolf, Gene]

Title: Setting Witango variables inside of Javascript






 I've searched the discussion list and I know this has been asked before, because I believe I've asked it. *laughs* Here's what I would like to do. I want to call a tcf which will query the resolution setting on a users screen and set a Witango variable to be returned to the calling program. 

I have the _javascript_ working just fine. We know the resolution. Now I want to assign that value to a Witango variable and here's where I'm stumbling. How do I do that assignment in _javascript_ so I can return to the main program? In the past I have set up a form and set the value of a hidden field and then used the @ARG value but that does not pertain in this case. I have looked at the @Setparam metatag but I'll be damned if I can figure it out.

 Any help will be appreciated!



Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Setting Witango variables inside of Javascript

[Wolf, Gene]

Title: Setting Witango variables inside of Javascript



 Hey Alan, thanks for the reply. What I see this doing is 
that a person logs in.In the login programI want to call a TCF and 
capture his/her screen resolution. When the log in is complete I want to send 
that screen resolution (really a var set to either high or low) back to the 
calling program. 

 The TCF only needs to execute a _javascript_, which is working 
fine, and set a Witango variable, which I have no idea how to do. Any ideas how 
to accomplish this?

  -Original Message-From: Alan Wolfe 
  [mailto:[EMAIL PROTECTED]Sent: Friday, May 07, 2004 12:55 
  PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: 
  Setting Witango variables inside of _javascript_
  Hi Gene,
  
  The problem with setting witango variables in 
  _javascript_ is that the _javascript_ isbrowser side while assigning witango 
  variables is server side.
  
  So, the problem is how do you transmit the data 
  from browser to server?
  
  There's a couple different tricks to doing this, 
  but it depends on what your requirements are.
  
  How do you need this to function?
  
- Original Message - 
From: 
Wolf, Gene 
To: [EMAIL PROTECTED] 
Sent: Friday, May 07, 2004 8:41 
AM
Subject: Witango-Talk: Setting Witango 
variables inside of _javascript_

 I've searched the discussion list 
and I know this has been asked before, because I believe I've asked it. 
*laughs* Here's what I would like to do. I want to call a tcf which will 
query the resolution setting on a users screen and set a Witango variable to 
be returned to the calling program. 
I have the _javascript_ working just fine. We know 
the resolution. Now I want to assign that value to a Witango variable and 
here's where I'm stumbling. How do I do that assignment in _javascript_ so I 
can return to the main program? In the past I have set up a form and set the 
value of a hidden field and then used the @ARG value but that does not 
pertain in this case. I have looked at the @Setparam metatag but I'll be 
damned if I can figure it out.
 Any help will be appreciated! 

Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce 
Park Drive Palm Bay, Florida 
32905 Phone: 321-309-0685 
E-mail: [EMAIL PROTECTED] 

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Contact with Australia

[Wolf, Gene]

God 
response Rick. However, all of us "old timers" with Tango were probably feeling 
a little deja vu the last few days. It was like, "haven't I been through this 
before, twice???" I know I was feeling some angst as well but was hoping for the 
best. Phil and Sophie do need a break now and then and I'm glad Phil has the 
smarts to take an "old fashioned" vacation. Certainly will recharge the 
batteries. I have to say though that I am anxious to get the keys that can be 
upgraded. I'm dying to try out the new java technology to see if there's any 
speed increase.

Has 
anyone exercised this yet? Any reports on what might be expected in terms of 
reduced CPU load or speed increases. Yes, yes, I know, it depends on many 
factors, database access, query length, etc., but there has to be some effect 
that can be measured when moving tafs to java and I'd like to know if anyone has 
any experience.

Welcome back Sophie and Phil!!

  -Original Message-From: Rick Sanders 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 6:59 
  PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: 
  Contact with Australia
  
  
Hello,

And it was a shame that Everyware sold to 
Pervasive. 
Well, if it wasn't for Pervasive, Tango turning out XML 
files wouldn't be a reality today. Everyware may have done a great job in 
support, but the top executives didn't know how to run the company to turn a 
profit.
Neither did 
Pervasive, hence why they sold it. Both companies couldn't make money with 
the product.

The shame was that Pervasive raped their 
customers, and left them out in the cold. I paid Pervasive $24,000 and 
some change for an Enterprise license. 
Yes, it was a hefty bill for the software. I also paid 
large amounts for Tango product. However, I look at the money I've spent, 
and made, and it was worth it.

All I get for that today is With telling me 
that they won't support Tango, but I can't sell my license without their 
permission. Okay, so I won't sell my license... but I will give it 
away to anyone and everyone that asks.
Well, 
unfortunately that's With Enterprises' rules. The reason why they don't want 
you selling it is because they don't need the headaches of another client 
asking why they can't upgrade to WiTango 5.5 from Tango 2000. With 
Enterprise also owns the Tango 2000 technology, and they call the shots with 
old product too. The only technology With didn't buy was the Tango 3 
technology.
As far as 
giving it away, that's not legal either. You don't own the software, you 
have a license to use it. I believe that you need With's written permission 
to transfer the license to someone else, but I'm not a corporate 
lawyer.

As far as not 
being able to contact Phil or Sophie, it is possible they may have taken a 
much needed break. Their entire lives have been consumed by WiTango for the 
past 3 years. I certainly hope nothing bad has happened to them, or anyone 
within their organization. It would be nice to just know if they're 
OK.

Remember one 
thing ladies  gents:
Phil  
Sophie love the product as much as you do. And, they want to keep it going 
and going as much as the rest of us. So, stop thinking the worst and have a 
little faith!

Rick 
Sanders


  -Original Message-From: Steve Smith 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 10:26 
  AMTo: [EMAIL PROTECTED]Subject: Re: 
  Witango-Talk: Contact with AustraliaHey! As a former 
  EveryWare employee I must take offense at that remark. We did our best to 
  respond to users within 24 business hours and those that were paying 
  customers (as apposed to evaluation users) were given priority. However 
  any organization will have it's good days and bad ones. I just purchased a 
  new Palm and have been trying to get the Mac 4.1 desktop for two days now, 
  finally got it late last night. And there have been other 
  companies that I've dealt with in recent months where I don't receive any 
  response at all. Makes me wonder if they even received my email or 
  not.I do recall seeing a post a few weeks ago stating that Phil 
  and Sophie were doing a month long tour of North America. But I didn't 
  think that they were taking everyone with them.Hope this 
  helps,Steve SmithOakbridge Information 
  SolutionsOffice: (519) 624-4388GTA: (416) 606-3885Fax: (519) 
  624-3353Cell: (416) 606-3885Email: [EMAIL PROTECTED]Web: 
  http://www.oakbridge.caOn 
  Tuesday, April 20, 2004, at 09:40 AM, Tom Ferguson wrote:
  Everywhere... Pervasive... With...damn shame
-----Original Message-From: Wolf, Gene 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 
  9:17 AMTo

RE: Witango-Talk: Contact with Australia

[Wolf, Gene]

   I also sent an e-mail to them, asking for what they had on record for our keys so I 
could determine just how many 5.5 licenses we could upgrade to free. I also have not 
heard a response. 

-Original Message-
From: Tom Storey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 8:07 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Contact with Australia


I sent an email to sales last Friday, about a bad license #, and have 
not hear a word. This makes me very nervous.

John McGowan wrote:

 Has anybody had any contact with Australia lately I'm having the 
 hardest time trying to buy a product.

 Trying to figure out if Phil and Sophie are on Vacation or something...

 /John

 
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


-- 
Tom Storey
Research  Accountability
Pinellas County Schools
Largo, Fl
(727) 588-6254
[EMAIL PROTECTED]
--
The box said: Requires Windows XP, or better.
So I bought a Macintosh with OS XÉ
--


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: J2EE compliant web servers

[Wolf, Gene]

Title: J2EE compliant web servers






 Well, seeing as how 5.5 is now released, can someone make some suggestions as to what java web servers they would recommend and why? We don't have alot of java expertise here so we would want to try something that was easy to administer and maintain.



Thanks!



Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Document processing

[Wolf, Gene]

Title: Document processing






 OK, here's something that we have run into that I hope someone has already addressed. We are setting up an electronic document routing and approval system. We are standardizing on PDF documents. We are running on Windows 2003 and using Witango 5.0 Server. 

 We have set up a process where someone can scan a document, or create a document in PDF format and write it to a specific directory on our server. No problem there. This person can also specify another person in the chain or approval who will receive an e-mail telling them they have documents that need their attention. No problem there either. When that person logs into the system they are presented with a list of all documents that need their attention, and clicking on one link in the list they get to actually view the document. Again, no problem. All of this is up and working. Now we get to the difficult part.

 I want them to be able to electronically sign the document and save it back to the server. I do not want to force them to download the document, sign it, and then reupload the document. Here is our dilemma. Anyone can open the document. When they click on the Adobe save icon, the path to the last directory they accessed is displayed. This might be to their My Documents folder, their MP3 play list, wherever they went last. We have a virtual directory set up on our server, and if they just so happened to have gone there they will be pointing to the right place and able to save the document there. Most likely though they will not be pointing there and many people we are planning to give this system to are not sophisticated enough to find their way to the right directory on the server.

 What I'm looking for is maybe some way of pointing their directory to the right directory behind the scenes (unlikely, I know) or some way of making it easy for them to save the documents in the right place. My ideal is to make this as foolproof as possible. Anyone done this before and have any suggestion on how to accomplish this?

Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: batch printing WiTango web pages

[Wolf, Gene]

Title: Message



Ted, 
we are using Highwire by Corda. We have had great success with it and all of 
it's modules can be accessed as COM objects which makes programming trivial. You 
could easily generate a number of reports, save them to the server and bring 
them back as PDF documents. We use this with Witango and are finding ever more 
applications with it. We are just now finishing up a project where we generate 
documents from Witango, convert them to PDF with Highwire, and use Witango to 
then route the PDF from individual to individual within the company for 
electronic signature with Adobe 6.0

One of 
the features I like about Highwire is that if you define your report as a table 
with the column headings as TH tags, if the report runs for more than a 
page length, Highwire automatically copies the heading information, and the 
headings to the next page for you. This makes reading a report spanning multiple 
pages extremely nice. It's also nice that you don;t have to do anything to make 
this happen. The software does it all for you.

What 
you want to do is completely possible. Check out www.corda.com (No, I don;t get a kickback, just 
a happy client *grins*)

  -Original Message-From: Ted Wolfley 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 06, 2004 3:34 
  PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: 
  batch printing witango web pages
  Hi,
  
  We have a client 
  who wants to know if Witango can batch print web pages, either to a PDF file 
  or using the browser's printer. The existing taf creates an index 
  of nameswith hyperlinks toindividual profile of each person which 
  is then printed by using the print button on the browser. The client 
  would like to eliminate the middle step of opening each profile 
  individually. 
  
  The data is coming 
  from SQL Server 2000 on a Windows 2000 server.
  
  Ted Wolfley Database/Internet Programmer The Ogden Group of 
  Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] 
  www.ogdengroup.com
  
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Something completely different

[Wolf, Gene]

Title: Something completely different



 Chris, this sounds like a plan. I didn't even think about 
generating the SQL code on the fly in this case, though I have done it in 
others. That would make a good solution and allow me to reuse the same code for 
many different tables. Thanks for the suggestion!

  -Original Message-From: Chris Smith - Comcast Acct 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 26, 2004 12:30 
  AMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: 
  Something completely different
  I'm 
  currently working on something very similar. We have a national database of 
  zip code information provided by USPS. each table in our db is prefixed with 
  the first three digits of a given zip code. ex. (190_zip, 191_zip, 
  192_zip, etc) each table has the exact same layout. the way we have handled 
  your scenario is as follows.
  
  in 
  db we create two tables 
   app_call
   app_call_params
  
  when 
  user begins "building a list" by specifying zip codes we insert a record into 
  app_call, get back the id and insert the first zip code into app_call_params 
  table hat is keyed to call. we set the current call_id as a user var. we 
  then have several other options that the user can filter the selections by 
  like the addition of more zip codes, each is stored in the 
  app_call_params
  
  when 
  the user has completed the filter selections and executes the call we perform 
  a query on the app_call_paramstable to bring back allparams 
  into an array.we then use those vars in a loop that builds 
  thedynamic sql based onapp_call_param_type values in the result. 
  because each table isprefixed by first three digits of zip code we are 
  able to use a string function to manipulate that entered zip code value to 
  target theappropriate database table in the select.
  
  From 
  here we move the data we "got from the well" into a normalized temp table, at 
  that point all manipulation of selected data is performed on temp table and we 
  never have to "go back to the well" unless we want to re-execute the last call 
  or build a new call. 
  
  I 
  hope this helps
  
  csmith
  
-----Original Message-From: Wolf, Gene 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 25, 2004 
1:46 PMTo: [EMAIL PROTECTED]Subject: 
Witango-Talk: Something completely different
 OK, this may be way off the wall but 
I figured one of you folks would have tried this, or know it can't be done. 
I have a number of excel spreadsheets that I will be reading data from using 
Witango. There are about 14 of these sheets and I have working ODBC links to 
each one of these. Now, the format of all of these sheets is exactly the 
same and I need to be able to create the exact same reports from each of 
these spreadsheets. Is there any way I can change the table I'm looking at 
in either a search action or a direct DBMS so I can loop through a list of 
table names and create the reports without duplicating the code for every 
table?
 Does this make sense to anyone? 
*laughs* 
Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce 
Park Drive Palm Bay, Florida 
32905 Phone: 321-309-0685 
E-mail: [EMAIL PROTECTED] 

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Something completely different

[Wolf, Gene]

Title: Something completely different






 OK, this may be way off the wall but I figured one of you folks would have tried this, or know it can't be done. I have a number of excel spreadsheets that I will be reading data from using Witango. There are about 14 of these sheets and I have working ODBC links to each one of these. Now, the format of all of these sheets is exactly the same and I need to be able to create the exact same reports from each of these spreadsheets. Is there any way I can change the table I'm looking at in either a search action or a direct DBMS so I can loop through a list of table names and create the reports without duplicating the code for every table?

 Does this make sense to anyone? *laughs*


Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Something completely different

[Wolf, Gene]

   Scott, no, I could do that and that may be a solution. What I have, in essence, is 
a single ODBC with what amounts to multiple tables within the database. All of the 
tables have the exact same structure so I want to loop through all of the records of 
one table, list them, then read all of the records of the next table, list them, etc.

   This is hard to explain but I hope this gives you a better idea of what I'm trying 
to do.

   Thanks for your help!

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 2:19 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Something completely different


Hi Gene,

Not that I understand 100% of what you're doing, but I think you're saying
each Excel file has a different ODBC connection, right?

If you have an array that describes all your Excel file connections, then
you can do a Loop on that and use Variables for your datasource connections
- then you only need one Search Action and one set of code (for parsing the
data) for the whole thing.

See http://xmlx.ca/articles/571.aspx

Hope this helps. Cheers 

Scott Cadillac,
403-281-6090 ~ [EMAIL PROTECTED]

XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca
Well-formed Programming in C# .NET, Witango, MSIE and XML

IExtranet ~ http://iextranet.ca
Witango ~ http://witango.org
EasyXSLT ~ http://easyxslt.ca
IIS Watcher ~ http://iiswatcher.ca

   

 




From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 25, 2004 11:46 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Something completely different



   OK, this may be way off the wall but I figured one of you folks
would have tried this, or know it can't be done. I have a number of excel
spreadsheets that I will be reading data from using Witango. There are about
14 of these sheets and I have working ODBC links to each one of these. Now,
the format of all of these sheets is exactly the same and I need to be able
to create the exact same reports from each of these spreadsheets. Is there
any way I can change the table I'm looking at in either a search action or a
direct DBMS so I can loop through a list of table names and create the
reports without duplicating the code for every table?

   Does this make sense to anyone? *laughs* 

Gene Wolf 
Business Systems Analyst, TLMN 
DRS Optronics, Inc. 
2330 Commerce Park Drive 
Palm Bay, Florida  32905 
Phone: 321-309-0685 
E-mail: [EMAIL PROTECTED] 




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf





TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: @FILTER

[Wolf, Gene]

Are you using the EXPR= in the filter statement? I have found the Calc statement, 
while not always needing the EXPR expression is less tolerant when you don't use it 
than when you do.

-Original Message-
From: John McGowan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 4:24 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: @FILTER


I don't have to use the @filter tag very often, but when I do, it's 
always a pain in the rear.

There's always seems to be something wrong with my filter expressions 
that I can't see.

For example, right now i'm getting the following error.

-18 Error during expression evaluation. Illegal symbol in statement 
[(#11=1294)  (#12=3)]

What could possibly be wrong with that expression?

/John


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Back button and form cache

[Wolf, Gene]

Title: Back button and form cache






 Is anyone else seeing the behavior we are seeing and have you figures a way around it? We are on Windows 2003, SQL 2000 and Witango 5.0. We have a great number of forms that are being used by employees online to post info, product info, make requests, etc. If, in the verification process we display an error page and the user clicks on the browsers (typically IE 6.0) back button, all of the information that person has entered is gone. 

 We have tried different caching schemes, we have changed the settings on IIS to every combination available, we have played with browser caching settings. etc. We know something has changed because this behavior did not exist up until 2 weeks ago. Since we automatically push IE patches to user machines it may have been a change from Microsoft but we cannot be sure. 

 Anyone seen this same behavior and did you find a way around it?


Gene Wolf

Business Systems Analyst, TLMN

DRS Optronics, Inc.

2330 Commerce Park Drive

Palm Bay, Florida 32905

Phone: 321-309-0685

E-mail: [EMAIL PROTECTED]







TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Back button and form cache

[Wolf, Gene]

Title: Back button and form cache



have also tried that with the following code: 
a href="" Go 
back/a
and the 
text is still being erased in input text boxes and textareas. It's like IIS is 
performing another GET.

  -Original Message-From: Dan Stein 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 10, 2004 7:53 
  AMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: 
  Back button and form cache
  
  I always use the 
  _javascript_ back function and try and keep them away from that back button. 
  That leaves the control in my hands not MS.
  
  
  
  
  
  



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Size limit of database return

[Wolf, Gene]

   OK, I know some of you are going to cringe, but is there a size limit of
the amount of data that can be returned from a database call? Here's my
situation. We have a corporate database which receives literally thousands
of new records daily. We want to be able to allow people to query this
database and if the number of records are less than, say, 10,000 display the
records to them. If however, the file is larger we want to create the
report, assign the data created in @Results to a variable, convert this
file to an excel file, zip it up, and e-mail it to the requester.

   The problem we are running into seems to be size related. We believe that
once the file reaches a certain size it causes either Witango or IIS to
choke. We were timing out, but have upped the timeout period so that this is
not the problem. Anyone know of any size issues that could be causing this
program to issue a Client Error warning? Thanks in advance!

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Zipping files with Witango

[Wolf, Gene]

   Are there any zip programs that can be executed from Witango to zip a
file that is created on the fly? We have a need to allow a user to select
records, create excel spreadsheets from the results, write the file to a
directory, zip that file, and then mail that zipped file to the user. We can
do it all except for the zipping portion.



Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Zipping files with Witango

[Wolf, Gene]

   Thanks folks! This is just the directional nudge I needed! I knew someone
else out there must have come up against this at some point or another!

-Original Message-
From: Ian Daniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 3:58 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Zipping files with Witango


Hi Gene:

The Winzip Command Line Support Add-On requires that you have a licensed
copy of Winzip before you can use it.

As an alternative, if you just require simple zipping capabilities, you may
consider Freezip which is freeware for commercial and non-commercial use.
Freezip also allows you to zip directly from the command prompt.

http://www.freebyte.com/fbzip/

Note: you cannot password protect the zip file using Freezip.  If you want
to password protect the zip file, Winzip will allow you to do that.

tks,
Ian

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 12:34 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Zipping files with Witango


   Are there any zip programs that can be executed from Witango to zip a
file that is created on the fly? We have a need to allow a user to select
records, create excel spreadsheets from the results, write the file to a
directory, zip that file, and then mail that zipped file to the user. We can
do it all except for the zipping portion.



Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: [OT] Extract data from report

[Wolf, Gene]

We parse electronic documents all the time here and we use Witango. If your
headings and footings are similar, for examples our are the same except for
page number, department number and date, you can find them easily, take any
information you want out of them (for example, our reports always prefix the
dept number with Dept:), and then remove them completely. For each line you
want, tokenize on CRLF giving you all lines for a page. After that,
transpose the array, go through each line in a rows statement and tokenize
on blanks to pull out specific columns. Since most reports are column
oriented, and most have the same data in the same columns on a page, it's
then easy to build a database from the extracted data.

Do this for every page and you have all of your report in a searchable
database. We've been doing this for over a year with an electronic report
from corporate and it works quite well.

-Original Message-
From: Chuck Lockwood [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 10:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: [OT] Extract data from report


I highly recommend a product called Monarch whenever you need to extract
data from text files.  It makes it quick and easy.  Conbine it with data
from other sources as well.

http://www.datawatch.com


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Witango tool

[Wolf, Gene]

   Yep! *laughs* I figured it had to be something simple. Thanks!

-Original Message-
From: Customer Support [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 8:47 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Witango tool


Is  @TSTOSECS, what you are looking for?


Witango Support

On 20/02/2004, at 12:25 AM, Wolf, Gene wrote:

Before I reinvent the wheel, does anyone have a routine that will  
 convert
 the Witango @CurrentTimeStamp into seconds? From what I see I can  
 tokenize
 the results, based on a space, and do a @DateToSecs on one part and
 @TimeToSecs on the second part, but I was wondering if anyone  
 already had
 done this. I looked in the Component Zone and didn't see anything.

If not I'll create it and upload it. Thanks!

 Gene Wolf
 Business Systems Analyst, TLMN
 DRS Optronics, Inc.
 2330 Commerce Park Drive
 Palm Bay, Florida  32905
 Phone: 321-309-0685
 E-mail: [EMAIL PROTECTED]


 ___ 
 _
 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: [OT] Suggestion on Hardware

[Wolf, Gene]

   Ben,

   I have a server in NY, similar configuration to what you propose, except
that it's only 1 processor and not as fast, and that works fine. However, I
suggest you at least get two boxes, one for Witango and one for your
database. Depending on your volume, and how quickly you will be growing,
this will give you the most flexibility. Obviously this route is more
expensive, and if you don't expect your traffic to increase dramatically
then the solution you propose will suffice for some time. 

   Just my $.02 and your mileage may vary. *grins*

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]


-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 11:04 PM
To: 'WiTango List'
Subject: Witango-Talk: [OT] Suggestion on Hardware


Ok, Need suggestions for client of mine.

What's the ideal hardware requirement for running 
-Tango 2000 standard, 
-Win 2000, 
-MS SQL Server 7 
on one box?

I am thinking...
Dual processor (T2k on Proc1, SQL on Proc2)
At least 1 gig of ram
Like raid 5 - 3 40+ gig hard drives

Note: Yes I am working on them to upgrade to Witango 5.

Ben Johansen - http://www.pcforge.com
Authorized Witango  MDaemon Reseller 
Available for Witango Developement





TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Process Affinity

[Wolf, Gene]

   Here's a question to those of you running Witango server on a multiple
CPU server. We currently are running Witango Professional on a quad server
Windows 2003 server. We're trying to spread the load as evenly as possible
among all four processors but the Process Affinity setting in the
Witango.ini file is somewhat confusing. The Process Affinity parameter based
on the number of processors or does it represent a processor number?

   For example, for each or the four stanzas in the Witango.ini file would
we code:

PROCESSAFFINITY=0001
. . .
PROCESSAFFINITY=0010
. . .
PROCESSAFFINITY=0100
. . .
PROCESSAFFINITY=1000

Representing one process for each processor, or should we code

PROCESSAFFINITY=0001
...
PROCESSAFFINITY=0010
...
PROCESSAFFINITY=0011
...
PROCESSAFFINITY=0100

Representing the processor number 1,2,3,4 in binary?

Or should we be looking at something else altogether? Right now it seems
like only a single processor is getting most of the work and the others are
just coasting. We have gone over the documentation carefully, have created
different listener ports for each Witango service, they are all showing up
in the service list and in the Wintango.log file. It looks like we simply
don't understand how the affinity has to be coded. 

Thanks for any help!

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Dreamweaver MX WiTango

[Wolf, Gene]

   Charge? Are you serious? I asked Diane to get this going because of the
lengthy delays. The product does not install. We cannot get it working. We
have sent numerous e-mail messages listing the exact nature of the install
messages we are receiving. 

   DRS is not a small company. We have over 150 VPN clients running on
operating systems ranging from NT to XP to Macs. We are a defense contractor
and have field reps on the ground in Iraq who routinely VPN into our
network. DRS is a nationwide company. I'm pushing Witango as a great tool,
and proving it to be so here in Florida. People on this list who know me
know that I push business to them in an effort to boost usage of Witango.

   Computer problems are a fact of life. I thought Diane's e-mail have been
very polite and restrained considering the support we have received. I also
find the tone of this e-mail, and the insinuation that we should be thankful
that you have not mentioned charging for your time, insulting. 

   You want to sell software? Quit whining. Deal with the fact that there
are many, many different machine configurations and installation is not
necessarily the same on every machine. Rest assured that when we can even
start using your product we will happily pay full price. 

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]
Web: www.drs.com


-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 12:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Dreamweaver MX  WiTango



Hello,

Diane, please contact me off list to help resolve the issue with your tags.

The VPN was a Cisco VPN that your tech person gave me, which was not
compatible with Windows XP. It disabled my network card and forced me to
format my computer.
I've spent days trying to help resolve this issue, and this was all done
without even the mention of any charge. I also gave you the tags for you to
try and install before asking for any payment.

Rick Sanders



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: General Question - Testing Witango

[Wolf, Gene]

   I've not seen this addressed before so I'd like to address it with this
entire group. We purchased Witango 5 Professional with the knowledge that
later this year we were going to upgrade our Intranet server from a 2
processor to a 4 processor machine later this year. Well, later came earlier
than we expected. We have received the box, installed almost all of our
software, and are currently testing some of our applications.

   What we would like to do is install our Wintango 5 professional server on
this machine and stress test it by getting several hundred people to pound
on it for some period of time. This will let us shake out any additional
bugs we didn't find in the preliminary testing. I also don't want to get
into any licensing violation issues, nor disrupt our currently, heavily
used, Witango Intranet server. I'm assuming that to thoroughly test this new
box will take maybe 3-4 weeks. Yes, that long. We have some applications
that run on a monthly cycle, but are still very important.

   My question is, how do you folks address this kind of upgrade? I can't
justify purchasing another copy of the server, but in order to test we
typically need more time than temporary licenses allow. Are we out of the
ordinary in taking an extended time to test, or do others run into similar
situations and do it differently?

   Just curious.

Gene Wolf
Business Systems Analyst, TLMN
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida  32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf