RE: Witango-Talk: FW: year-end update

[WebDude]

I would also like to chime in and give kudos to Robert. I am currently
preparing to move forward and the help Robert has been giving me is nothing
short of stellar. This is far different then any support received in the
past and the responses and clarity in which concerns are put to rest is very
refreshing. It is clear that Robert cares for this program, its users and
the success of us all. Hats off to the new management and I am hoping for
Robert great success in the future.

Thanks Robert!


John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

  http://cipromo.com



  _

From: Fogelson, Steve [mailto:stevefogel...@askics.net]
Sent: Friday, December 09, 2011 4:28 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: FW: year-end update



I would like to applaud Robert and his staff. I have worked with Robert on a
few issues with TeraScript and he has quickly responded and provided
patches, versions, etc. He has been great at offering advice and suggestions
to resolve issues.



I think everyone would agree Robert's acquisition of Witango has been great.
Quick responses to questions on the forum is refreshing.



As a side note, we have been running TeraScript Pro on Windows 2008 R2 with
four instances using MySQL on a new server (six cores with hyper-threading)
and have been adding websites to it every week. Users have been holding
their sessions and we haven't had one service crash or lock up in a month.
It has been very stable. Our application is an eCommerce app and things are
hopping coming into the Christmas season.



We are adding our largest traffic site this weekend and I expect great
results.



I am excited about the future with TeraScript.



Merry Christmas to all.



Steve Fogelson



From: Witango Sales [mailto:sa...@witango.com]
Sent: Friday, December 09, 2011 3:43 PM
To: Fogelson, Steve
Subject: year-end update



Dear Customer,

Last fall, we released Witango 6.0 for Windows, our first release after
purchasing the platform.



It's been a year since we took that first step towards our ultimate
objective of revitalizing the language and the software, and we'd like to
take a moment to share with you some of the goals we've accomplished,
lessons we've learned, and our plans for the coming year.



One notable decision we've made was to rename the Witango platform to
TeraScript, the application server to TeraScript Server and the development
studio to TeraScribe. We put a lot of thought into this choice and believe
that the Tango/Witango platform will be well represented by this new name
into the future.



Over the past year we've produced five releases which cumulatively corrected
hundreds of bugs. Today the product is more stable and better situated than
it has been in many years. We are using modern compilers and fully
supporting current releases of Windows, Mac OS X, and Linux. We have the
ability to identify and correct customer reported issues quickly and add
features in a timely manner. Our hope is that this growth of the platform is
translating into better applications, faster web sites, stable servers, and
happier developers and clients.



One lesson we've learned over this past year is that developing a language,
server application and development tool is a challenge beyond just the
programming. Our customers are diverse in how they use the platform and have
many great ideas, feature requests and requirements. Coalescing this
feedback into a coherent, stable and desirable platform is a huge
responsibility. Thus far our primary driving force has been to bring
stability to a platform that went 5 years since its last major release and
provide a convenient upgrade path to users of that, and previous, versions
of the product.  This way of thinking will soon change, however, as we begin
to introduce new features and some new ideas to the platform and the
products.



In the near future we'll be releasing one more major version of the 6.x
series, version 6.2. This version will serve as a stable release during the
development of version 7 and will provide a few major improvements such as
renewed support for the Oracle native client (OCCI). After that release,
we'll begin development of version 7, the next major version of the
platform. Development is expected to take at least 6 months; during which
we'll be offering a number of preview builds for users to work with, test
and provide feedback on.



We hope that you've seen our excitement and commitment to the platform over
the past year. While we constantly wish we could have done more, we're proud
of the product that we've produced to date. Our efforts will not stop here
and there is much more to look forward to.



We hope everyone has a cheerful holiday season.



Thank you,



The TeraScript Development Team

Tronics Software LLC


To contact Tronics Software with questions, please email
 supp...@terascript.com or 

RE: Witango-Talk: Scoping Variables

[WebDude]

Another question and maybe a stupid one. Are variables scoped as local local
to the user scope? I would assume so. In other words, a locally scoped
variable is local for that particular user, right?



  _

From: Wayne Irvine [mailto:wa...@byteserve.com.au]
Sent: Monday, November 21, 2011 4:15 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Scoping Variables


I go through this often with code written for Tango 3/2000/5.

As long as you change Terascripts default scope to user it should all work
fine. But I prefer to have request as my default scope and specify scopes
specifically in my code. This means a lot of work, but also a chance to
review the code I am upgrading. Some of it was written over a decade ago.

Wayne Irvine

On 22/11/2011, at 6:57 AM, Tom Ferguson wrote:


Not to hijack WebDude's thread, but I'll be doing the very same thing soon,
going from 4.5 to TeraScribe.  I have no scopes specified either.  What
happens if I leave the scopes as is?

Thanks!

  _____

From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 21, 2011 1:18 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Scoping Variables


Hi Folks,

I am currently preparing to upgrade from version 4, probably to version 6
and then up to Terascribe. I remember that syntax and scoping of variables
have changed. I am trying to prepare as much of the old files as possible
before upgrading. I will probabaly have more questions to come, but I am
going to take this a step at a time.

First question is concerning scoping variables. Presently, almost all
variables are not scoped so I am going through the ardious process of
straightening these out. A few questions, if you don't mind...

I would assume that you need to scope all <@ASSIGNs Most of the applications
have no scope assigned to them presently. Of course, the default for this is
"user" in the version I am using, but I am going to go through each assign
and scope it appropriately. Almost all are goinmg to be scoped as user, but
I have a few that can be scoped as local. Whenever calling on the variable,
such as <@VAR blah> I am also going to assume these need to be scoped as
well, as is <@VAR blah scope "user">

Do I need to scope any <@PURGE variables?
When calling a local variable, should these be scoped as well? i.e. <@VAR
blah scope "local">
What exactly is the request scope? This will be for futue reference. It
appears to be the same as the local scope. When I upgrade, will I need to
change all local scopes to request scope? Is this just a neam change to
avoid confusion

Thanks for any help!

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Scoping Variables

[WebDude]

thanks Robert...

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 21, 2011 2:01 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Scoping Variables



You can probably get away with doing less work to start, and then just
cleaning up any bugs you find in testing.



Essentially the change is this:



In your version, the default scope is user, so when you do <@ASSIGN myVar
myValue> you are effectively creating that variable in the user scope (as if
<@ASSIGN user$myVar myValue>), which is a persistent scope.



When you upgrade, the default is changed to request (aka local) and so your
unscoped variable assignments will change to the request scope and loose
persistency.



To correct for this in code, you simply need to add the user scope syntax to
your assignments. <@ASSIGN myVar myValue> becomes <@VAR user$myVar myValue>
or <@ASSIGN myVar myValue scope=user>



It is notable that all versions of Witango and TeraScript support setting
the default scope back to the user scope if you wish. It is, therefore,
possible to have TeraScript 6.1 operate using the same scoping rules as
Tango 2000. This is NOT recommended, however.



You should not need to adjust any usages of variables (<@VAR myVar>, <@PURGE
myVar>, etc) because the scoping rules will search up the scope hierarchy
until the variable is found. The only time this will cause a problem for you
is if you wish to have two different variables distinguished only by scope:
<@ASSIGN request$myVar yes> <@ASSIGN user$myVar no>. Now if you just do
<@VAR myVar> you'll get "yes" because the request scope is more specific
than the user scope. To access the value in the user scope, you would need
to use <@VAR user$myVar>.



The term 'local' is currently a synonym for the term 'request'. The use of
'local' is not recommended, and the term is officially deprecated. I'm not
sure exactly when, but in a future release of TeraScript there will be a new
scope which acts like a true local scope, and will use the 'local' syntax.
At such time, you will need to make sure all references to the request scope
use 'request' rather than 'local', unless of course you wish to have a truly
local variable.



Note that I often used the dollar-sign syntax for scoping: SCOPE$VARNAME.
This is the shorthand syntax for providing a variable name and its scope at
the same time. While the long hand <@TAG name="VARNAME" scope="SCOPE"> is
not going to be removed from the platform, the shorthand is recommended. One
easy way to update your applications would be to search for the string
"<@ASSIGN " and replace it with "<@ASSIGN user$".



Robert





From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 21, 2011 2:18 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Scoping Variables



Hi Folks,



I am currently preparing to upgrade from version 4, probably to version 6
and then up to Terascribe. I remember that syntax and scoping of variables
have changed. I am trying to prepare as much of the old files as possible
before upgrading. I will probabaly have more questions to come, but I am
going to take this a step at a time.



First question is concerning scoping variables. Presently, almost all
variables are not scoped so I am going through the ardious process of
straightening these out. A few questions, if you don't mind...



I would assume that you need to scope all <@ASSIGNs Most of the applications
have no scope assigned to them presently. Of course, the default for this is
"user" in the version I am using, but I am going to go through each assign
and scope it appropriately. Almost all are goinmg to be scoped as user, but
I have a few that can be scoped as local. Whenever calling on the variable,
such as <@VAR blah> I am also going to assume these need to be scoped as
well, as is <@VAR blah scope "user">



Do I need to scope any <@PURGE variables?

When calling a local variable, should these be scoped as well? i.e. <@VAR
blah scope "local">

What exactly is the request scope? This will be for futue reference. It
appears to be the same as the local scope. When I upgrade, will I need to
change all local scopes to request scope? Is this just a neam change to
avoid confusion



Thanks for any help!



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.
<>

Witango-Talk: Scoping Variables

[WebDude]

Hi Folks,

I am currently preparing to upgrade from version 4, probably to version 6
and then up to Terascribe. I remember that syntax and scoping of variables
have changed. I am trying to prepare as much of the old files as possible
before upgrading. I will probabaly have more questions to come, but I am
going to take this a step at a time.

First question is concerning scoping variables. Presently, almost all
variables are not scoped so I am going through the ardious process of
straightening these out. A few questions, if you don't mind...

I would assume that you need to scope all <@ASSIGNs Most of the applications
have no scope assigned to them presently. Of course, the default for this is
"user" in the version I am using, but I am going to go through each assign
and scope it appropriately. Almost all are goinmg to be scoped as user, but
I have a few that can be scoped as local. Whenever calling on the variable,
such as <@VAR blah> I am also going to assume these need to be scoped as
well, as is <@VAR blah scope "user">

Do I need to scope any <@PURGE variables?
When calling a local variable, should these be scoped as well? i.e. <@VAR
blah scope "local">
What exactly is the request scope? This will be for futue reference. It
appears to be the same as the local scope. When I upgrade, will I need to
change all local scopes to request scope? Is this just a neam change to
avoid confusion

Thanks for any help!




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Exact Numeric Character IFs

[WebDude]

Actually, Robert... it does make a difference and I switched to your method.
These are groups of numbers like...

Thanks!


John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, August 15, 2011 11:22 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs



I doubt that this would be an issue in your case, but your method using
len() doesn't force an actual string comparison, so you will still get the
incorrect response in the case of:



Value1 = 0.01

Value2 - .010



Robert



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 12:16 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs



Appreciate the help from both Robert and Anthony. I did get it to work using
Robert's method. I also came up with



<@IF EXPR="'000' = '0' AND 'len(000)' = 'len(0)'" TRUE ="true"
FALSE="false">



which seems to work for what I am trying to do.



John Muldoon

Corporate Incentives

3416 Nicollet Ave S

Minneapolis, MN 55408-4552

612.822.

webd...@cipromo.com



 <http://cipromo.com/> http://cipromo.com







  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, August 15, 2011 10:52 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs

I have two:



Variables:



request$input1 = "00"

request$input2 = ""



<@IF expr="

'A<@VAR input1>' = 'A<@VAR input2>'

">



By placing an arbitrary letter before the variables, you will force
TeraScript to internally compare them as strings. This will be False.



OR



<@IF expr="

<@CIPHER hash md5 <@VAR input1> = <@CIPHER hash md5 <@VAR
input2>>

">



Since the MD5 hash of 0 is different from 00, this will be False. This trick
also allows you to do case sensitive string comparisons, where @IF normally
is case insensitive.



Robert



PS. Both of these short-comings are issues that should be corrected. I'll
add them to my to-do list.



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 11:31 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs



Any ideas?









  _

From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 9:39 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs

This is what I need...



0 = 0 True

00 = 0 False



Simply changing the TRUE and FALSE values does not work. Both of these
equate to TRUE.



All of these equate to true too...



<@IF EXPR="'000' = '0'" TRUE ="true" FALSE="false">

<@IF EXPR="'0' = '0'" TRUE ="true" FALSE="false">

<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">

<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">

<@IFEQUAL "00" "">true<@ELSE>false

<@IFEQUAL "0" "0">true<@ELSE>false











  _

From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, August 15, 2011 9:24 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Exact Numeric Character IFs

John,

It seems to me like you should reverse your TRUE and FALSE values.

Bill

On Monday, August 15, 2011, WebDude  wrote:
> This has never come up before and I know it's probably a stupid question,
but I am trying to write an IF statement where I need to compare characters
rather then numbers. I went through the manual and I am a bit confused. I
thought that if you used single quotes, it would look at the expression as a
character compare rather then a numeric compare. For example...
>
> <@IF EXPR="'0 = '0'" TRUE ="They really are not the same - one has a
lot more zeros then the other" FALSE="They are the same">
>
> I have a client who has numeric codes that can start with multiple zeros
and I need to be able to get a true or false depending on the actual
characters rather then the numeric value.
>
> 0 = 0 would then be false.
>
> Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL>
tag evaluates the same way. I need a string comparison rather the numeric.
>
> Any help would be appreciated.
>
> Thanks!
>
> John M.
>
>
>
>
>
> 
> To unsubscribe from this list, please send an email to
lists...@witango.com with "unsubscribe witango-talk" i

RE: Witango-Talk: Exact Numeric Character IFs

[WebDude]

Appreciate the help from both Robert and Anthony. I did get it to work using
Robert's method. I also came up with

<@IF EXPR="'000' = '0' AND 'len(000)' = 'len(0)'" TRUE ="true"
FALSE="false">

which seems to work for what I am trying to do.

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, August 15, 2011 10:52 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs



I have two:



Variables:



request$input1 = "00"

request$input2 = ""



<@IF expr="

'A<@VAR input1>' = 'A<@VAR input2>'

">



By placing an arbitrary letter before the variables, you will force
TeraScript to internally compare them as strings. This will be False.



OR



<@IF expr="

<@CIPHER hash md5 <@VAR input1> = <@CIPHER hash md5 <@VAR
input2>>

">



Since the MD5 hash of 0 is different from 00, this will be False. This trick
also allows you to do case sensitive string comparisons, where @IF normally
is case insensitive.



Robert



PS. Both of these short-comings are issues that should be corrected. I'll
add them to my to-do list.



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 11:31 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs



Any ideas?









  _

From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 9:39 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs

This is what I need...



0 = 0 True

00 = 0 False



Simply changing the TRUE and FALSE values does not work. Both of these
equate to TRUE.



All of these equate to true too...



<@IF EXPR="'000' = '0'" TRUE ="true" FALSE="false">

<@IF EXPR="'0' = '0'" TRUE ="true" FALSE="false">

<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">

<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">

<@IFEQUAL "00" "">true<@ELSE>false

<@IFEQUAL "0" "0">true<@ELSE>false











  _

From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, August 15, 2011 9:24 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Exact Numeric Character IFs

John,

It seems to me like you should reverse your TRUE and FALSE values.

Bill

On Monday, August 15, 2011, WebDude  wrote:
> This has never come up before and I know it's probably a stupid question,
but I am trying to write an IF statement where I need to compare characters
rather then numbers. I went through the manual and I am a bit confused. I
thought that if you used single quotes, it would look at the expression as a
character compare rather then a numeric compare. For example...
>
> <@IF EXPR="'0 = '0'" TRUE ="They really are not the same - one has a
lot more zeros then the other" FALSE="They are the same">
>
> I have a client who has numeric codes that can start with multiple zeros
and I need to be able to get a true or false depending on the actual
characters rather then the numeric value.
>
> 0 = 0 would then be false.
>
> Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL>
tag evaluates the same way. I need a string comparison rather the numeric.
>
> Any help would be appreciated.
>
> Thanks!
>
> John M.
>
>
>
>
>
> 
> To unsubscribe from this list, please send an email to
lists...@witango.com with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.
<>

RE: Witango-Talk: Exact Numeric Character IFs

[WebDude]

Any ideas?




  _

From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, August 15, 2011 9:39 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Exact Numeric Character IFs


This is what I need...

0 = 0 True
00 = 0 False

Simply changing the TRUE and FALSE values does not work. Both of these
equate to TRUE.

All of these equate to true too...

<@IF EXPR="'000' = '0'" TRUE ="true" FALSE="false">
<@IF EXPR="'0' = '0'" TRUE ="true" FALSE="false">
<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">
<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">
<@IFEQUAL "00" "">true<@ELSE>false
<@IFEQUAL "0" "0">true<@ELSE>false





  _

From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, August 15, 2011 9:24 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Exact Numeric Character IFs


John,

It seems to me like you should reverse your TRUE and FALSE values.

Bill

On Monday, August 15, 2011, WebDude  wrote:
> This has never come up before and I know it's probably a stupid question,
but I am trying to write an IF statement where I need to compare characters
rather then numbers. I went through the manual and I am a bit confused. I
thought that if you used single quotes, it would look at the expression as a
character compare rather then a numeric compare. For example...
>
> <@IF EXPR="'0 = '0'" TRUE ="They really are not the same - one has a
lot more zeros then the other" FALSE="They are the same">
>
> I have a client who has numeric codes that can start with multiple zeros
and I need to be able to get a true or false depending on the actual
characters rather then the numeric value.
>
> 0 = 0 would then be false.
>
> Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL>
tag evaluates the same way. I need a string comparison rather the numeric.
>
> Any help would be appreciated.
>
> Thanks!
>
> John M.
>
>
>
>
>
> 
> To unsubscribe from this list, please send an email to
lists...@witango.com with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Exact Numeric Character IFs

[WebDude]

This is what I need...

0 = 0 True
00 = 0 False

Simply changing the TRUE and FALSE values does not work. Both of these
equate to TRUE.

All of these equate to true too...

<@IF EXPR="'000' = '0'" TRUE ="true" FALSE="false">
<@IF EXPR="'0' = '0'" TRUE ="true" FALSE="false">
<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">
<@IF EXPR="0 = 0" TRUE ="true" FALSE="false">
<@IFEQUAL "00" "">true<@ELSE>false
<@IFEQUAL "0" "0">true<@ELSE>false





  _

From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, August 15, 2011 9:24 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Exact Numeric Character IFs


John,

It seems to me like you should reverse your TRUE and FALSE values.

Bill

On Monday, August 15, 2011, WebDude  wrote:
> This has never come up before and I know it's probably a stupid question,
but I am trying to write an IF statement where I need to compare characters
rather then numbers. I went through the manual and I am a bit confused. I
thought that if you used single quotes, it would look at the expression as a
character compare rather then a numeric compare. For example...
>
> <@IF EXPR="'0 = '0'" TRUE ="They really are not the same - one has a
lot more zeros then the other" FALSE="They are the same">
>
> I have a client who has numeric codes that can start with multiple zeros
and I need to be able to get a true or false depending on the actual
characters rather then the numeric value.
>
> 0 = 0 would then be false.
>
> Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL>
tag evaluates the same way. I need a string comparison rather the numeric.
>
> Any help would be appreciated.
>
> Thanks!
>
> John M.
>
>
>
>
>
> 
> To unsubscribe from this list, please send an email to
lists...@witango.com with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: Exact Numeric Character IFs

[WebDude]

This has never come up before and I know it's probably a stupid question,
but I am trying to write an IF statement where I need to compare characters
rather then numbers. I went through the manual and I am a bit confused. I
thought that if you used single quotes, it would look at the expression as a
character compare rather then a numeric compare. For example...

<@IF EXPR="'0 = '0'" TRUE ="They really are not the same - one has a lot
more zeros then the other" FALSE="They are the same">

I have a client who has numeric codes that can start with multiple zeros and
I need to be able to get a true or false depending on the actual characters
rather then the numeric value.

0 = 0 would then be false.

Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL> tag
evaluates the same way. I need a string comparison rather the numeric.

Any help would be appreciated.

Thanks!

John M.









To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: OT - UTF-8

[WebDude]

Thank you Robert... that explains a lot. It also helped form the answer to
my client.




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Thursday, July 14, 2011 11:47 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - UTF-8



I'm happy to answer your questions, however it's not likely to work well to
use Witango.



I understand that I need to declare the charset to UTF-8 to display the
characters. Do I actually need to install a language pack on the server to
display?



No. The server just needs to manage data. You may need to install language
packs if you want to see the web pages render correctly in IE or have a text
editor render correctly - but it's not technically necessary for you to read
the content in order to manipulate it. Just keep in mind that if you are
manipulating UTF-8 data by hand (like in a text editor) then that text
editor must read and write UTF-8 encoded files.



Right now I have no language packs installed on any machines so when I get
Chinese text it displays as a series of boxes. Can I change the charset to
UTF-8 and just cut and paste the boxes? Will that display correctly?



It should, as long as you copy and paste with a UTF-8 capable text editor.
Keep in mind that the TAF/TCF structure uses 8859-1 encoding and therefore
cannot hold UTF-8 characters. You can't copy and paste them into the Studio
nor manually into the TAF/TCF. Also, you can't put them into an include file
because the Server will not strip out the BOM, although it will pass the
encoded characters unaltered to the webpage (I think - untested).



I think I can display both English and Chinese on the same page, is this
correct?



Of course, the first 128 characters of the UTF-8 character set are the exact
same characters as ASCII. What you can't do is use any high-bit characters
from the 8859-1 encoding without first re-encoding them into UTF-8. This
would be true for most accented characters.



I will more then likeyy be adding this text via email into the Witango
editor, is there a problem with this?



As I noted before, you cannot copy UTF-8 encoded content into the Witango
Studio. It will be corrupted.



I take it that using MS SQL for data would be a bit more complicated?



Yes, you may recall seeing that most data types in MS SQL have a variant
that begins with an 'n', such as char has nchar. Well, the n means that the
column can hold UTF-8 encoded characters. It's also true that you need to
signal in the SQL query when you are passing UTF-8 encoded content. It works
like this: UPDATE table SET column = N'My UTF-8 Encoded Text' WHERE
primary_key = 1 Note the N preceding the UTF-8 encoded string.



Is this as easy as it seems to be?



I don't believe it's easy, no.



Is there a simple step by step doc/webpage/place I could go for more
information?



Not that I am aware of, but Google is your friend.



Sorry for all the questions, but I would like to respond to the client with
at least a very base knowledge of how this will work without getting egg on
my face. Right now they have supplied me with artwork of some very base
translations for some of the headers on certain pages and I think they are
wondering if we could take the next step and actually use the language.



You should be able to get this to work if you follow these 2 steps. Although
note that I have never tried this myself, so I could be completely wrong:



1)  Force your current English pages to have UTF-8 encoding - this is
simply done by setting the Meta information on the HTML document
accordingly. If any characters look incorrect (probably question marks) on
the web page, then you must correct these first. You can use the <@CIPHER>
tag to convert from 8859-1 to UTF-8.

2)  Then place all of the Chinese text into the SQL server. Use proper
UTF-8 aware tools to do so, so that you SQL Server has properly encoded
content in it. Now, the trick is that when Witango reads data out of the
database and puts it onto the webpage it should not alter it. This is the
part I'm not 100% about. If I'm right then the UTF-8 encoded content will go
onto the webpage without issue and your browser will display it properly.
Note that you can not do ANY manipulation of the content in Witango.



Robert



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: OT - UTF-8

[WebDude]

Sorry for the Off Topic questions...

I have a client asking about having some pages or parts of pages in
Chinese... either simple or possibly Mandarin. I am trying to find info on
this, but it seems a bit confusing, though it seems it might be an easy
thing to do. But I have questions for any who may have gone through this.

I understand that I need to declare the charset to UTF-8 to display the
characters. Do I actually need to install a language pack on the server to
display?

Right now I have no language packs installed on any machines so when I get
Chinese text it displays as a series of boxes. Can I change the charset to
UTF-8 and just cut and paste the boxes? Will that display correctly?

I think I can display both English and Chinese on the same page, is this
correct?

I will more then likeyy be adding this text via email into the Witango
editor, is there a problem with this?

I take it that using MS SQL for data would be a bit more complicated?

Is this as easy as it seems to be?

Is there a simple step by step doc/webpage/place I could go for more
information?

Sorry for all the questions, but I would like to respond to the client with
at least a very base knowledge of how this will work without getting egg on
my face. Right now they have supplied me with artwork of some very base
translations for some of the headers on certain pages and I think they are
wondering if we could take the next step and actually use the language.






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: ODBC via IP to OpenBase

[WebDude]

Hi folks,

I am hoping someone could help me. Granted, I am using an old version of
Witango, 2000, but hopefully someone a bit more knowledgable might be able
to point me in the right direction.

I need to connect via IP to an OpenBase database. I downloaded the
recommended ODBC driver, Actual OpenBase and installed it on a Win 2003
server. After install, instructions state to create a user DSN, then I
should be ready to go.

When I create a User DSN, I can load the tables and view the columns in the
Editor. But when I try doing a simple search, I get "The specified data
source cannot be found." and "Unable to connect to the specified data
source. Verify that data source is properly configured and that database
server is online."

When I create a System DSN, I also can load the tables and view the columns
in the Editor. I can also search and return data, but whenever I try to
update, I get a Witango crash...

"Client Error.

The server refused connection."

I go to the Witango logs and get the following...

"Fatal error at 0285aa11: Write EXCEPTION_ACCESS_VIOLATION at f133c6dd."

And then Witango goes through the restart stuff.

So I guess one question would be, am I supposed to be using a User DNS or a
System DSN?

If a User DSN, is there something else I am supposed to be doing to get this
to work past the Editor? I can view and load tables in the Editor, but
cannot run an application through a browser.

And the System DSN seems to get me a bit closer, but it seems very buggy and
I cannot update the tables. Would a crash happen if a user on the other end
did not have the correct permissions?

Sorry for all the questions. I am not sure whet exactly the difference is
between User and System. Also, I have made similar types of connections to
MSSQL databases and have not had these types of problems, but this was
several years ago.

Thanks for any insight!














To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Looking For a Developer

[WebDude]

Hi Norm,

Thanks for answering my email.

Unfortunately, we are looking for a full time employee who resides in our
area. A lot of this work would require being local.



John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: n...@no-worries.net [mailto:n...@no-worries.net]
Sent: Wednesday, April 06, 2011 3:48 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Looking For a Developer


Hi,

I'm interested. I began working with Tango way, way back but work has been
somewhat sporadic. I've worked with php, Mysql, MSsql, credit cards, ftp,
email and a few others. But I'm in San Francisco.

Let me inow if you're nterested.

thanks
Norm Wheatley



 Original Message 
Subject: Witango-Talk: Looking For a Developer
From: "WebDude" 
Date: Wed, April 06, 2011 12:20 pm
To: Witango-Talk@witango.com


Hi Folks,

I am looking for someone who would like to get into a start-up position with
the opportunity to grow. Not sure if any of you are in the Minneapolis/St.
Paul area, but thought I would give this list a shot before going to a more
traditional search. I fell into a situation with another company that's
going to keep me very busy for the next couple of years. Last month I billed
over 230 hours and quite frankly, I am getting a bit overworked. All
programming I have been doing has been done in Witango. We are planning on
upgrading servers and software. We have been working with very large retail
corporations on the certification of packaging companies both here in the
states and overseas. Along with the certification process is another
component where packaging is measured, evaluated and data stored in separate
databases for these retail corporations. They use the data to evaluate the
packaging suppliers and the products they produce. All of the data input and
output is done via the Web. There are many facets to these projects and each
retail corporation changes the criteria just enough to keep the individual
websites unique. We also have about 50 other sites that are not related to
the packaging certification process, some of these with large companies as
well.

Ultimately, what we are looking for could go in two directions, after much
discussion...

1. A seasoned developer in Witango and PHP who is already established and
would bring expertise to the table along with established clients that he or
she would move into our hosting environment. This person would have the
ability to bring in more business and also be able to handle pretty much
anything we threw at them. A good working knowledge of MSSQL, DNS, CC
processing, FTP, Routers, email servers and firewalls would be a plus.

2. A person just starting out who is well versed in PHP and would like to
learn Witango on his or her own. This person would need to be a self-starter
who would take the bull by the horns, so to speak, and have the ability to
problem solve to advance their knowledge in programming in Witango. I won't
have time for too much handholding. No body ever held my hand and I would
expect the same of people who are truly interested in something like this.
(Well... the only hand holding I got was from all you good people on the
list who have taught me a lot over the years)

All our servers used for Web applications are Windows based. Some of the
internal stuff is MAC, but we would really be concentrating on the Web
stuff. Granted, our platforms are fairly old (Win2000 and 2003) and we are
still working with Witango 2000, but we are looking for upgrades across the
board as the work is being ramped up. Some of the work will involve these
upgrades and moving sites to more recent software and platforms. We plan on
upgrading to the latest Witango, and to upgrade all platforms while leaving
the old in place so we can migrate and test as time allows.

The only reason I am throwing PHP into the mix is because we feel it might
attract a wider customer base by offering programming in a more popular
language. We would be willing to buy the server(s) in order for us to expand
into this arena. PHP may or may not play a role in the hiring, but may be a
plus that we could discuss. I personally am a novice with PHP and for the
type of work we do; the language of my choice has never been an issue. Most
of my clients could care less what I am using, just so the job gets done.

If any of this sounds interesting to you, email me and I will send you a
list of current clients and links and we could possibly start a dialogue. I
would list the clients here, but feel that dropping names on the list would
be in poor taste.

Thanks!


John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com


 <http://cipromo.com/> http://cipromo.com



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with &

Witango-Talk: Looking For a Developer

[WebDude]

Hi Folks,



I am looking for someone who would like to get into a start-up position with
the opportunity to grow. Not sure if any of you are in the Minneapolis/St.
Paul area, but thought I would give this list a shot before going to a more
traditional search. I fell into a situation with another company that's
going to keep me very busy for the next couple of years. Last month I billed
over 230 hours and quite frankly, I am getting a bit overworked. All
programming I have been doing has been done in Witango. We are planning on
upgrading servers and software. We have been working with very large retail
corporations on the certification of packaging companies both here in the
states and overseas. Along with the certification process is another
component where packaging is measured, evaluated and data stored in separate
databases for these retail corporations. They use the data to evaluate the
packaging suppliers and the products they produce. All of the data input and
output is done via the Web. There are many facets to these projects and each
retail corporation changes the criteria just enough to keep the individual
websites unique. We also have about 50 other sites that are not related to
the packaging certification process, some of these with large companies as
well.



Ultimately, what we are looking for could go in two directions, after much
discussion...



1. A seasoned developer in Witango and PHP who is already established and
would bring expertise to the table along with established clients that he or
she would move into our hosting environment. This person would have the
ability to bring in more business and also be able to handle pretty much
anything we threw at them. A good working knowledge of MSSQL, DNS, CC
processing, FTP, Routers, email servers and firewalls would be a plus.



2. A person just starting out who is well versed in PHP and would like to
learn Witango on his or her own. This person would need to be a self-starter
who would take the bull by the horns, so to speak, and have the ability to
problem solve to advance their knowledge in programming in Witango. I won't
have time for too much handholding. No body ever held my hand and I would
expect the same of people who are truly interested in something like this.
(Well... the only hand holding I got was from all you good people on the
list who have taught me a lot over the years)



All our servers used for Web applications are Windows based. Some of the
internal stuff is MAC, but we would really be concentrating on the Web
stuff. Granted, our platforms are fairly old (Win2000 and 2003) and we are
still working with Witango 2000, but we are looking for upgrades across the
board as the work is being ramped up. Some of the work will involve these
upgrades and moving sites to more recent software and platforms. We plan on
upgrading to the latest Witango, and to upgrade all platforms while leaving
the old in place so we can migrate and test as time allows.



The only reason I am throwing PHP into the mix is because we feel it might
attract a wider customer base by offering programming in a more popular
language. We would be willing to buy the server(s) in order for us to expand
into this arena. PHP may or may not play a role in the hiring, but may be a
plus that we could discuss. I personally am a novice with PHP and for the
type of work we do; the language of my choice has never been an issue. Most
of my clients could care less what I am using, just so the job gets done.



If any of this sounds interesting to you, email me and I will send you a
list of current clients and links and we could possibly start a dialogue. I
would list the clients here, but feel that dropping names on the list would
be in poor taste.

Thanks!


John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

  http://cipromo.com






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.
<>

RE: Witango-Talk: Forcing jpg Download

[WebDude]

Well folks,

I never did get this to work. I tried everything and could never get a jpg
or gif that wasn't corrupted somehow. I even compared file sizes and they
were exactly the same from the original. I went as far as thinking that the
read function was corrupting the file so I created a read, loaded a variable
and then wrote that variable to a different directory to see if the jpg
would corrupt and guess what?... that worked fine... in other words, this
does not seem to be a Witango problem because a can read and write without
any corruption whatsoever. It appears to be an IIS problem. All of these
were tested on MAC and PC using IE and Firefox... none of them worked.

So I decided to bite the bullet and I created a directory structure and
changed the mime types in those directories in IIS for gif and jpg to
x-application/attachment and it works flawlessly for both gifs and jpgs. Oh
well. Guess I'll have to update the images in 2 places rather then one. Not
a big deal... there are only about 3000 images. I appreciate the help
anyway. I have done header rewrites in the past for purging cache and such
and never had a problem, I just couldn't get this to work and the amount of
time I was spending on this for the client was a bit beyond what the client
was going to pay. Here are the 4 header rewrites that I tried to no avail,
if anyone is interested...

<@purgeresults><@ASSIGN local$httpHeader VALUE="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-Type:
application/jpg<@CRLF>Content-Disposition: attachment; filename=<@VAR
filename><@CRLF><@USERREFERENCECOOKIE><@CRLF><@CRLF>"><@VAR FileData
scope="local">

<@assign name="httpHeader" scope="local" value="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-type:
application/jpg<@crlf>Content-Disposition: attachment; filename=<@VAR
filename><@crlf>Content-Length: <@VARINFO NAME="FileData"
size><@crlf><@crlf>"><@purgeresults><@VAR FileData scope="local">

<@purgeresults><@assign local$httpHeader 'HTTP/1.0 200
OK<@crlf>Content-Type: image/jpeg; filename="<@VAR
filename>"<@CRLF>Content-Disposition: attachment; filename="<@VAR
filename>"<@CRLF><@CRLF>'><@var local$FileData encoding=none>

<@ASSIGN httpHeader VALUE="HTTP/1.0 200 OK<@crlf>MIME-Version:
1.0<@crlf>Content-Type: image/jpeg<@CRLF>Content-Disposition: attachment;
filename=<@VAR filename><@CRLF><@CRLF>"><@var local$FileData encoding=none>


Thanks again!


  _

From: Robert Garcia [mailto:rgar...@bighead.net]
Sent: Wednesday, March 30, 2011 1:18 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Forcing jpg Download


So I found a taf from one of the more recent applications I had done in
witango.

First, I have a data action that gets data from db, this is in the results
for that action:

<@assign local$image <@column "hiRez.image" encoding=none>>
<@assign local$cLength <@column "hiRez.data_size" encoding=none>>

Then a results only action to assign header, notice use of <@exclude> to
allow nice formatting, but not add anything to the result buffer:

<@exclude>
<@ifempty <@arg filename>>
    <@assign local$fileName "image.jpg">
<@else>
    <@assign local$fileName <@arg fileName>>

<@assign local$httpHeader 'HTTP/1.1 200 OK<@crlf>Server: WiTango Server
4.05.047<@crlf>MIME-Version: 1.0<@crlf>Content-Type:
application/download<@crlf>Content-disposition: attachment; filename="<@var
local$fileName>"<@crlf>Content-length: <@var local$cLength><@crlf>Expires:
-1<@crlf><@crlf>'>
<@assign local$encodehttpresponse "False">


And then a final results only results page for the image data:

<@purgeresults><@var local$image encoding=none>

A couple of notes.

1. I am aware of deprecation of local scope, this is not in service anymore.
2. Before we started storing the content-length in the DB, we would get it
like this:

<@assign local$cLength <@length <@column "hiRez.image" encoding=none>>>

This worked reliably, this was not for eventpix, but for a large image
library website, stock photography and such. The only issue with the above
was that sometimes @length would be 1 byte off, and cause an issue.

On 3/29/2011 4:18 PM, Robert Garcia wrote:

Also Disposition inline will not download, must be attachment.

--Â

Robert Garcia
BigHead Technology
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net -Â http://bighead.net/
Sent with Sparrow <http://bit.ly/

RE: Witango-Talk: Forcing jpg Download

[WebDude]

I appreciate the help so far. I feel I am 95% there.

I have tried this with these 2 header rewrites (all on one line, of
course)...

<@purgeresults><@ASSIGN local$httpHeader VALUE="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-Type:
application/jpg<@CRLF>Content-Disposition: attachment; filename=<@VAR
filename><@CRLF><@USERREFERENCECOOKIE><@CRLF>"><@VAR FileData scope="local">




<@assign name="httpHeader" scope="local" value="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-type:
application/jpg<@crlf>Content-Disposition: attachment; filename=<@VAR
filename><@crlf>Content-Length: <@VARINFO NAME="FileData"
size><@crlf><@crlf>"><@purgeresults><@VAR FileData scope="local">

I am assigning the filename from a search and writing the data to FileData

It actually finds the filename and downloads the file. The problem is that
the file seems to be corrupt. It will not display in a browser and when I
try to open it in PhotoShop I get the following error (I tried this in
multiple browsers)

"Could not open the document because a JPEG marker segment length is too
short (the file may be truncated or incomplete).

Is there something else I may be missing?

I appreciate the help!




-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Tuesday, March 29, 2011 1:57 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download

Yes - you have that correct.

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 2:58 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download

What do you mean by "Then you dump out the contents of the jpeg AFTER the
header." Do I read the jpg using the Read File Action as in what the other
Robert suggested? Is that what the <@VAR Request$FileData> is?

M... I'll give it a shot...




-Original Message-
From: Robert Garcia [mailto:rgar...@bighead.net]
Sent: Tuesday, March 29, 2011 1:28 PM
To: Witango-Talk@witango.com
Cc: Robert Shubert
Subject: Re: Witango-Talk: Forcing jpg Download

We have done that many times before in witango. That is the correct header
you need to use, and attachment is the correct way. However, it looks like
you are trying to put the contents of the file in the filename part, that
header just takes the filename, and it should end in JPG or JPEG, or match
the mime of the content with the extension, or it may not work on all
browsers. Then you dump out the contents of the jpeg AFTER the header. Here
is an example I found from a TAF that I know we had working:

<@assign name="httpHeader" scope="request" value="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-type:
application/download<@crlf>Content-Disposition: attachment;
filename=downloadreport.xls<@crlf>Content-Length: <@length
@@request$FileData><@crlf><@crlf>"><@purgeresults><@VAR Request$FileData>

It is important to know that you must NOT have ANY returns in this results
page where you use this code, it should be on one line. We do this in other
places with JPEGs, but we use image/jpeg for content-type, and a variable
usually for filename. Content-length is also important, but can be a big
buggy in witango.

On 3/29/2011 11:09 AM, Robert Shubert wrote:
> In that case, I think you have the header correct. What you need to do
> afterwards is use a Read File Action to bring the content of the JPEG
> into Witango and then simply display it as the response. It's
> important that you don't get any additional characters (like extra
> returns or spaces in the result)
>
> Robert
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Tuesday, March 29, 2011 1:49 PM
> To: Witango-Talk@witango.com
> Subject: RE: Witango-Talk: Forcing jpg Download
>
> <@COLUMN "images.LargerImage">  is the name of the file.
>
>
>
>
> -Original Message-
> From: Robert Shubert [mailto:rshub...@tronics.com]
> Sent: Tuesday, March 29, 2011 12:06 PM
> To: Witango-Talk@witango.com
> Subject: RE: Witango-Talk: Forcing jpg Download
>
> What is in the database column<@COLUMN "images.LargerImage">? Is this
> the name of the image file or the binary JPEG data?
>
> Robert
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Tuesday, March 29, 2011 12:45 PM
> To: Witango-Talk@witango.com
> Subject: Witango-Talk: Forcing jpg Download
>
> PHP has a handy header rewrite for forcing a jpg download. I was
> wondering if anyone has ever done this in Witango. I've been able to
>

RE: Witango-Talk: Forcing jpg Download

[WebDude]

What do you mean by "Then you dump out the contents of the jpeg AFTER the
header." Do I read the jpg using the Read File Action as in what the other
Robert suggested? Is that what the <@VAR Request$FileData> is?

M... I'll give it a shot...




-Original Message-
From: Robert Garcia [mailto:rgar...@bighead.net]
Sent: Tuesday, March 29, 2011 1:28 PM
To: Witango-Talk@witango.com
Cc: Robert Shubert
Subject: Re: Witango-Talk: Forcing jpg Download

We have done that many times before in witango. That is the correct header
you need to use, and attachment is the correct way. However, it looks like
you are trying to put the contents of the file in the filename part, that
header just takes the filename, and it should end in JPG or JPEG, or match
the mime of the content with the extension, or it may not work on all
browsers. Then you dump out the contents of the jpeg AFTER the header. Here
is an example I found from a TAF that I know we had working:

<@assign name="httpHeader" scope="request" value="HTTP/1.0 200
OK<@crlf>MIME-Version: 1.0<@crlf>Content-type:
application/download<@crlf>Content-Disposition: attachment;
filename=downloadreport.xls<@crlf>Content-Length: <@length
@@request$FileData><@crlf><@crlf>"><@purgeresults><@VAR Request$FileData>

It is important to know that you must NOT have ANY returns in this results
page where you use this code, it should be on one line. We do this in other
places with JPEGs, but we use image/jpeg for content-type, and a variable
usually for filename. Content-length is also important, but can be a big
buggy in witango.

On 3/29/2011 11:09 AM, Robert Shubert wrote:
> In that case, I think you have the header correct. What you need to do
> afterwards is use a Read File Action to bring the content of the JPEG
> into Witango and then simply display it as the response. It's
> important that you don't get any additional characters (like extra
> returns or spaces in the result)
>
> Robert
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Tuesday, March 29, 2011 1:49 PM
> To: Witango-Talk@witango.com
> Subject: RE: Witango-Talk: Forcing jpg Download
>
> <@COLUMN "images.LargerImage">  is the name of the file.
>
>
>
>
> -Original Message-
> From: Robert Shubert [mailto:rshub...@tronics.com]
> Sent: Tuesday, March 29, 2011 12:06 PM
> To: Witango-Talk@witango.com
> Subject: RE: Witango-Talk: Forcing jpg Download
>
> What is in the database column<@COLUMN "images.LargerImage">? Is this
> the name of the image file or the binary JPEG data?
>
> Robert
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Tuesday, March 29, 2011 12:45 PM
> To: Witango-Talk@witango.com
> Subject: Witango-Talk: Forcing jpg Download
>
> PHP has a handy header rewrite for forcing a jpg download. I was
> wondering if anyone has ever done this in Witango. I've been able to
> get this to work on IIS by changing the directory header, the problem
> being is that I have 2 sites that reference the same images and one
> needs to force a download and the other to view the image in a browser
> (same images in the same directories).
>
> I've been dabbling but can't seem to get it to work right. Of course
> when I add header change to the top of the taf file, it tries to
> download the taf file itself rather then the jpg file. This is stupid
> I know, but what is the best way to force a download of a jpg and get
> it to work? This is what I have so far. Am I missing something fundamental
in trying to do this?
>
> <@purgeresults><@ASSIGN local$httpHeader
> VALUE="Content-Type:application/jpg<@CRLF>Content-Disposition:
> attachment, filename='<@COLUMN
> "images.LargerImage">'<@CRLF>readfile('<@COLUMN
> "images.LargerImage">')<@CRLF><@USERREFERENCECOOKIE><@CRLF>">
>
> Thanks for your thoughts...
>
>
>
> WebDude
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to
> lists...@witango.com with "unsubscribe witango-talk" in the body.
>
>
>
> 
>
> To unsubscribe from this list, please send an email to
> lists...@witango.com with "unsubscribe witango-talk" in the body.
>
>
>
> 
>
> To unsubscribe from this list, please send an email to
lists...@witango.com with "unsubscribe witango-talk" in the body.
>
>
>
> 
>
> To unsubs

RE: Witango-Talk: Forcing jpg Download

[WebDude]

<@COLUMN "images.LargerImage"> is the name of the file.




-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Tuesday, March 29, 2011 12:06 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download

What is in the database column <@COLUMN "images.LargerImage">? Is this the
name of the image file or the binary JPEG data?

Robert

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 12:45 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Forcing jpg Download

PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).

I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?

<@purgeresults><@ASSIGN local$httpHeader
VALUE="Content-Type:application/jpg<@CRLF>Content-Disposition: attachment,
filename='<@COLUMN "images.LargerImage">'<@CRLF>readfile('<@COLUMN
"images.LargerImage">')<@CRLF><@USERREFERENCECOOKIE><@CRLF>">

Thanks for your thoughts...



WebDude






To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Forcing jpg Download

[WebDude]

M wondering if I need the oimage path anywhere in the header



-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 11:45 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Forcing jpg Download

PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).

I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?

<@purgeresults><@ASSIGN local$httpHeader
VALUE="Content-Type:application/jpg<@CRLF>Content-Disposition: attachment,
filename='<@COLUMN "images.LargerImage">'<@CRLF>readfile('<@COLUMN
"images.LargerImage">')<@CRLF><@USERREFERENCECOOKIE><@CRLF>">

Thanks for your thoughts...



WebDude






To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: Forcing jpg Download

[WebDude]

PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).

I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?

<@purgeresults><@ASSIGN local$httpHeader
VALUE="Content-Type:application/jpg<@CRLF>Content-Disposition: attachment,
filename='<@COLUMN "images.LargerImage">'<@CRLF>readfile('<@COLUMN
"images.LargerImage">')<@CRLF><@USERREFERENCECOOKIE><@CRLF>">

Thanks for your thoughts...



WebDude






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Print on javascript

[WebDude]

ooops,

Sorry, I didn't see the "without displaying the print dialogue." Anthony is
right. To open up javascript to be able to get into and influence system
apps and files would open up serious security issues.


  _

From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, February 22, 2011 7:10 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Print on javascript


On one page, add something like this...





In the header of that page or as a linked JS script, use this for a pop-up
window...

function print1() {

window.open("","suppliers1","width=1,height=1,resizable=no,toolbar=no,locati
on=no,directories=no,scrollbars=no,top=1,left=2000")

}


left=2000 will pop the window open off screen. Kind of annoying to have it
pop up on screen.

On the page you want to print, us this in the body tag...



Setting the window close to 500 is important because on on some browsers,
most notably on Safari for the Mac, the print will error if not all the
information is loaded on the print page and that page is trying to close,
thus time out to load the page before closing it.

You could also use something like this...




to load a different page like a conformation page in the original location
that had the print button.

Hope this helps.





  _

From: Anthony Humphreys [mailto:anth...@humphreys.org]
Sent: Monday, February 21, 2011 11:08 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Print on javascript


For "security reasons", you cannot take control of my printer, nor change
it's settings (like force duplex, or turn off colour, or print 100 copies)


All you can do is offer the user a convenient link to print with
"window.print()" and let the user decide to press OK, or whatever.

I, for one, would not want to be "surprised" to find that some web page has
randomly taken over my printer. However, there are other products which do
allow more control (and offer usually better quality) for printing. However,
the quantity printed is generally on the "honour" system, and limited by
licence. PDF is one such mechanism, but there are others.

With CSS you do have some control over what does, and does not, get sent to
the printer (or screen). This allows you to, for instance, turn off menus
that aren't part of the main content that a user would want printed; or,as
another example, place a different style of banner ad on the printed page,
as opposed to the version of the same ad which appears on the screen -- this
printed version may even include a coupon or discount for a product or a
store. If available in the browser, CSS may even suggest where the page
break should go. But -- again -- it cannot change the settings of, or even
the number of copies on, the printer.

However, some browsers (and/or some browser plug-ins) do allow users to turn
on/off CSS -- or even use a user-supplied CSS. Developers (like myself)
often use tools like these to help them test their pages for certain things.

Anthony -



On Mon, Feb 21, 2011 at 4:41 PM, MC Tay  wrote:


Hi:

We are looking for an alternative print page javascript that would
print once only and without displaying the print dialog. Any one has
any script that can share please?

We use window.print() currently.

Thanks!

MC





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Print on javascript

[WebDude]

On one page, add something like this...





In the header of that page or as a linked JS script, use this for a pop-up
window...

function print1() {

window.open("","suppliers1","width=1,height=1,resizable=no,toolbar=no,locati
on=no,directories=no,scrollbars=no,top=1,left=2000")

}


left=2000 will pop the window open off screen. Kind of annoying to have it
pop up on screen.

On the page you want to print, us this in the body tag...



Setting the window close to 500 is important because on on some browsers,
most notably on Safari for the Mac, the print will error if not all the
information is loaded on the print page and that page is trying to close,
thus time out to load the page before closing it.

You could also use something like this...




to load a different page like a conformation page in the original location
that had the print button.

Hope this helps.





  _

From: Anthony Humphreys [mailto:anth...@humphreys.org]
Sent: Monday, February 21, 2011 11:08 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Print on javascript


For "security reasons", you cannot take control of my printer, nor change
it's settings (like force duplex, or turn off colour, or print 100 copies)


All you can do is offer the user a convenient link to print with
"window.print()" and let the user decide to press OK, or whatever.

I, for one, would not want to be "surprised" to find that some web page has
randomly taken over my printer. However, there are other products which do
allow more control (and offer usually better quality) for printing. However,
the quantity printed is generally on the "honour" system, and limited by
licence. PDF is one such mechanism, but there are others.

With CSS you do have some control over what does, and does not, get sent to
the printer (or screen). This allows you to, for instance, turn off menus
that aren't part of the main content that a user would want printed; or,as
another example, place a different style of banner ad on the printed page,
as opposed to the version of the same ad which appears on the screen -- this
printed version may even include a coupon or discount for a product or a
store. If available in the browser, CSS may even suggest where the page
break should go. But -- again -- it cannot change the settings of, or even
the number of copies on, the printer.

However, some browsers (and/or some browser plug-ins) do allow users to turn
on/off CSS -- or even use a user-supplied CSS. Developers (like myself)
often use tools like these to help them test their pages for certain things.

Anthony -



On Mon, Feb 21, 2011 at 4:41 PM, MC Tay  wrote:


Hi:

We are looking for an alternative print page javascript that would
print once only and without displaying the print dialog. Any one has
any script that can share please?

We use window.print() currently.

Thanks!

MC





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: OT - FTP interactions

[WebDude]

Thanks... I will take a hack at this. I contacted the client and might be
able to get them to pay to upgrade to 6. I like it when clients are like
that, eh?


  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Tuesday, November 23, 2010 9:38 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



Over the years I've built tools for my hosting customers, one of them being
FTP. Attached is the raw code from that tool, and below are the
instructions:



I'm sorry that I can't work this up more, but I'm tied up with Witango 6
release, and once that's out all of this will be moot anyway. Note that this
is intended for Witango 5.5 so you might have to hack around with it. It's
also tested on Windows 2003, using the included FTP client.



Robert



This method provides basic FTP functions on-the-fly from within your
application. You can quickly upload and download files to any remote FTP
server. Keep in mind that the transfer time is counted towards your request
execution time and large transfers will likely timeout, although they should
complete.



Action: (Required) GET (download) | PUT (upload) | LIST (get a directory
listing).

File_Name: (Required for GET and PUT) This is the name of the file that you
wish to transfer.

File_Path: (Required for GET and PUT) This is the local directory in your
web folder that you want to transfer the file from or to.

Remote_Server: (Required) This can either be a host name (ftp.tronics.com)
or IP address.

Username: (Required for authentication) The username used to login to the
remote server.

Password: (Required for authentication) The password used to login to the
remote server.

Remote_Directory: (optional) You can specify a directory to change to on the
remote server after login but before the action.

Directory_Listing: (Out Parameter) Array. Only populated when using the LIST
action.



The method will return a transcript of the session with the remote server.
This is useful for debugging, but should be considered sensitive and should
not be stored or displayed except for debugging purposes.



You can only execute one action per call. The File_Path will automatically
be forced to your web site's root level. You can specify additional folders
if needed (path1\path2). The remote server can also accept a port number
after a colon such as 23.123.123.123:456. The Remote_Directory can also have
multiple levels defined at once (path1/path2).





From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, November 23, 2010 8:09 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



Okay, so let's talk about command line tools and forget about diplaying
thumbs. Sorry, I have never tried using/firing command line tools from
Witango. Any hints on how to get started with this? Let's say I just want to
be able to list the contents (filenames) of a directory via ftp and possibly
parse that data out into a text file or an array. I am not sure where to
start. Any hints?



p.s. Windows OS...



Thanks!





  _

From: Robert Garcia [mailto:wita...@bighead.net]
Sent: Monday, November 22, 2010 2:44 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: OT - FTP interactions

I used to use witango pretty successfully with FTP, but I was using a
special FTP server that came with a com object that worked with witango. It
was TitanFTP. Another way, is just working with command line tools. Once you
get it working, you can make an ftp class with chdir, ls, put, get routines,
etc.



Thumbnails are going to be a b*tch if you are going to try to to make the
thumb represent the content. I would say this is probably NOT doable unless
you have an FTP server that does this for you, and you have a webservice to
call. If it doesn't, you would have to traverse the site, cache your own
thumbs on a regular basis, very prohibitive.



A simple way of doing thumbs, is use OS X or windows thumbnails for the
TYPES of file that it is. So you just check if its extension is JPG, and use
a thumb for that, PDF, you get the idea. Then have a generic FILE thumbnail
for all else, and over time you can build up how many extensions you
recognize.



Good luck!


--



Robert Garcia

President - BigHead Technology

VP Application Development - eventpix.com

15520 Coutelenc Rd

Magalia, Ca 95954

ph: 530.645.4040 x222 fax: 530.645.4040

rgar...@bighead.net - rgar...@eventpix.com

http://bighead.net/ - http://eventpix.com/



On Nov 22, 2010, at 6:01 AM, WebDude wrote:





This is way off topic, but I have a client who is asking some questions that
I am having a hard time answering. I was hoping some of you with more
knowledge then I can give me some direction. I see all sorts of probems with
this, but am trying to figure out what to say to him. I believe the files he
is talking about are pfd files. I would think, first off, that you would
need at least to have the directory structure 

RE: Witango-Talk: OT - FTP interactions

[WebDude]

Okay, so let's talk about command line tools and forget about diplaying
thumbs. Sorry, I have never tried using/firing command line tools from
Witango. Any hints on how to get started with this? Let's say I just want to
be able to list the contents (filenames) of a directory via ftp and possibly
parse that data out into a text file or an array. I am not sure where to
start. Any hints?

p.s. Windows OS...

Thanks!


  _

From: Robert Garcia [mailto:wita...@bighead.net]
Sent: Monday, November 22, 2010 2:44 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: OT - FTP interactions


I used to use witango pretty successfully with FTP, but I was using a
special FTP server that came with a com object that worked with witango. It
was TitanFTP. Another way, is just working with command line tools. Once you
get it working, you can make an ftp class with chdir, ls, put, get routines,
etc.

Thumbnails are going to be a b*tch if you are going to try to to make the
thumb represent the content. I would say this is probably NOT doable unless
you have an FTP server that does this for you, and you have a webservice to
call. If it doesn't, you would have to traverse the site, cache your own
thumbs on a regular basis, very prohibitive.

A simple way of doing thumbs, is use OS X or windows thumbnails for the
TYPES of file that it is. So you just check if its extension is JPG, and use
a thumb for that, PDF, you get the idea. Then have a generic FILE thumbnail
for all else, and over time you can build up how many extensions you
recognize.

Good luck!


--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net - rgar...@eventpix.com
http://bighead.net/ - http://eventpix.com/

On Nov 22, 2010, at 6:01 AM, WebDude wrote:


This is way off topic, but I have a client who is asking some questions that
I am having a hard time answering. I was hoping some of you with more
knowledge then I can give me some direction. I see all sorts of probems with
this, but am trying to figure out what to say to him. I believe the files he
is talking about are pfd files. I would think, first off, that you would
need at least to have the directory structure along with filenames loaded
into the DB before you could do anything he is asking me to do. In other
words, it sounds like he wants to "crawl" the ftp site and load the
information into a db. And then just display the files via thumbs, probably
clicking them to add to a basket system, etc. Don't shoot me on this, I am
just the messenger, but below is what is being asked for word for word from
the client...

"I have a couple of key questions, one is how can a database interact with a
FTP?  Could a DB pull thumbnails from an FTP and display them on the web?
Could a DB understand from a folder location on a sever what value to assign
to it?  For example if the DB searched the server for a file, and file's
location was in folder 1, could it assign a price to it, if the DB
understood all items in folder 1 have a $10 value?"

My head hurts. I think he wants to be able to have the client find these
files, add them to a basket system, and download them when done.










  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: OT - FTP interactions

[WebDude]

Well I am hosed then since I am working with Witango 2000. Maybe that was
why I was so confused.

Very cool with this new functionality in 6.0. I am going back to the client
to see of the importance of this. I may be upgrading sooner then I thought!




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 10:46 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



Here's the part that I think you missing:



Your user goes to the page:



www.yoursite.com/ftp_cart.taf



ftp_cart.taf in turn logs into the FTP server, reads the root directory and
displays an HTML page of options (files and folders) to the user.



The user then clicks a folder (say folder1) which looks like this:



www.yoursite.com/ftp_cart.taf?browse=/folder1



ftp_cart.taf, now with a path argument, logs into the FTP server and
retrieves the path given and displays it to the user as a nice HTML page.



Now let's say the user clicks a file to add to his cart:



www.yoursite.com/ftp_cart.taf?add=/folder1/file2.pdf



now, you know "folder1" so you can derive "$10.00". And you know the full
path and filename so you can download the file and present it to the user
with a Witango script.



Hopefully that gives you some idea of how your Witango application will act
as a "window" to the FTP site and allow you to apply all the necessary
logic. This is similar to building an HTML email client in Witango, or
perhaps accessing information stored in XML files or on remote sites through
web services (eg. RSS). In this case, the remote data source just happens to
be an FTP site.



Unfortunately, Witango 5/5.5 doesn't help you here at all. I'm working hard
to get Witango 6 out soon, and the server-side FTP functions should help you
to develop this functionality easily.



Robert







From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 10:42 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



Well, call me dumb, but where could I get information on how to do this. I
am having a hard enough time just trying to display a directory of images
thorugh the http protocol. Are you saying that we could let the customer
traverse the ftp site via the ftp protocol (i.e.
ftp://test1/test2/test3/file.pdf <ftp://test1/test2/test3/file.pdf> ) ? I
get that part, but when they click, how do you capture that filepath and
file and insert the info into a db?



or am I missing something here...



By the way... thanks...









  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 9:28 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions

Well, I'm not sure how you would generate a thumb of a specific PDF. I
suppose your could use a tool that renders PDF to JPEG, but that could get a
little complex.



Other than that, this is straight forward. Simply traverse the FTP structure
through the FTP protocol. Think of it like working with an XML file.



Robert



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 10:11 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



M...



This FTP site is not in my control. It is housed by a third party and as far
as I know it has no http capabilities. We will not be able to add meta-data
or control the directory/file structure in any way. Nor will we know ahead
of time what the file structure is or the filenames within any of the
directories. All we will be getting is a list of the directories (maybe
multiple levels) and a username and password. From this they want to display
thumbs of pdf files within these directories and when a thumb (pdf file) is
clicked, add the thumb (filename, I would suspect) into a basket built on
our end along with the price via the directory the pdf file happened to be
in.







  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 8:46 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions

This doesn't seem too hard.



I think I would first try using the FTP site as if it were a database. This
may be too slow, however, depending on the amount of content in the FTP
server and the load on the site, but I would probably add simple memory
caching rather than trying to sync a db.



Witango 6 will be able to implement something easily as it directly supports
server-side FTP now.



The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10)



You could even put meta-data files in each directory (or for each file) with
descriptions and prices.



Doesn't sound altogether unreasonable.



Robert





From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 9:02 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: OT - FTP interactions



This is wa

RE: Witango-Talk: OT - FTP interactions

[WebDude]

Well, call me dumb, but where could I get information on how to do this. I
am having a hard enough time just trying to display a directory of images
thorugh the http protocol. Are you saying that we could let the customer
traverse the ftp site via the ftp protocol (i.e.
ftp://test1/test2/test3/file.pdf <ftp://test1/test2/test3/file.pdf> ) ? I
get that part, but when they click, how do you capture that filepath and
file and insert the info into a db?

or am I missing something here...

By the way... thanks...




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 9:28 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



Well, I'm not sure how you would generate a thumb of a specific PDF. I
suppose your could use a tool that renders PDF to JPEG, but that could get a
little complex.



Other than that, this is straight forward. Simply traverse the FTP structure
through the FTP protocol. Think of it like working with an XML file.



Robert



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 10:11 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



M...



This FTP site is not in my control. It is housed by a third party and as far
as I know it has no http capabilities. We will not be able to add meta-data
or control the directory/file structure in any way. Nor will we know ahead
of time what the file structure is or the filenames within any of the
directories. All we will be getting is a list of the directories (maybe
multiple levels) and a username and password. From this they want to display
thumbs of pdf files within these directories and when a thumb (pdf file) is
clicked, add the thumb (filename, I would suspect) into a basket built on
our end along with the price via the directory the pdf file happened to be
in.







  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 8:46 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions

This doesn't seem too hard.



I think I would first try using the FTP site as if it were a database. This
may be too slow, however, depending on the amount of content in the FTP
server and the load on the site, but I would probably add simple memory
caching rather than trying to sync a db.



Witango 6 will be able to implement something easily as it directly supports
server-side FTP now.



The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10)



You could even put meta-data files in each directory (or for each file) with
descriptions and prices.



Doesn't sound altogether unreasonable.



Robert





From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 9:02 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: OT - FTP interactions



This is way off topic, but I have a client who is asking some questions that
I am having a hard time answering. I was hoping some of you with more
knowledge then I can give me some direction. I see all sorts of probems with
this, but am trying to figure out what to say to him. I believe the files he
is talking about are pfd files. I would think, first off, that you would
need at least to have the directory structure along with filenames loaded
into the DB before you could do anything he is asking me to do. In other
words, it sounds like he wants to "crawl" the ftp site and load the
information into a db. And then just display the files via thumbs, probably
clicking them to add to a basket system, etc. Don't shoot me on this, I am
just the messenger, but below is what is being asked for word for word from
the client...



"I have a couple of key questions, one is how can a database interact with a
FTP?  Could a DB pull thumbnails from an FTP and display them on the web?
Could a DB understand from a folder location on a sever what value to assign
to it?  For example if the DB searched the server for a file, and file's
location was in folder 1, could it assign a price to it, if the DB
understood all items in folder 1 have a $10 value?"



My head hurts. I think he wants to be able to have the client find these
files, add them to a basket system, and download them when done.











  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: OT - FTP interactions

[WebDude]

M...

This FTP site is not in my control. It is housed by a third party and as far
as I know it has no http capabilities. We will not be able to add meta-data
or control the directory/file structure in any way. Nor will we know ahead
of time what the file structure is or the filenames within any of the
directories. All we will be getting is a list of the directories (maybe
multiple levels) and a username and password. From this they want to display
thumbs of pdf files within these directories and when a thumb (pdf file) is
clicked, add the thumb (filename, I would suspect) into a basket built on
our end along with the price via the directory the pdf file happened to be
in.



  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, November 22, 2010 8:46 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: OT - FTP interactions



This doesn't seem too hard.



I think I would first try using the FTP site as if it were a database. This
may be too slow, however, depending on the amount of content in the FTP
server and the load on the site, but I would probably add simple memory
caching rather than trying to sync a db.



Witango 6 will be able to implement something easily as it directly supports
server-side FTP now.



The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10)



You could even put meta-data files in each directory (or for each file) with
descriptions and prices.



Doesn't sound altogether unreasonable.



Robert





From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, November 22, 2010 9:02 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: OT - FTP interactions



This is way off topic, but I have a client who is asking some questions that
I am having a hard time answering. I was hoping some of you with more
knowledge then I can give me some direction. I see all sorts of probems with
this, but am trying to figure out what to say to him. I believe the files he
is talking about are pfd files. I would think, first off, that you would
need at least to have the directory structure along with filenames loaded
into the DB before you could do anything he is asking me to do. In other
words, it sounds like he wants to "crawl" the ftp site and load the
information into a db. And then just display the files via thumbs, probably
clicking them to add to a basket system, etc. Don't shoot me on this, I am
just the messenger, but below is what is being asked for word for word from
the client...



"I have a couple of key questions, one is how can a database interact with a
FTP?  Could a DB pull thumbnails from an FTP and display them on the web?
Could a DB understand from a folder location on a sever what value to assign
to it?  For example if the DB searched the server for a file, and file's
location was in folder 1, could it assign a price to it, if the DB
understood all items in folder 1 have a $10 value?"



My head hurts. I think he wants to be able to have the client find these
files, add them to a basket system, and download them when done.













  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: OT - FTP interactions

[WebDude]

This is way off topic, but I have a client who is asking some questions that
I am having a hard time answering. I was hoping some of you with more
knowledge then I can give me some direction. I see all sorts of probems with
this, but am trying to figure out what to say to him. I believe the files he
is talking about are pfd files. I would think, first off, that you would
need at least to have the directory structure along with filenames loaded
into the DB before you could do anything he is asking me to do. In other
words, it sounds like he wants to "crawl" the ftp site and load the
information into a db. And then just display the files via thumbs, probably
clicking them to add to a basket system, etc. Don't shoot me on this, I am
just the messenger, but below is what is being asked for word for word from
the client...

"I have a couple of key questions, one is how can a database interact with a
FTP?  Could a DB pull thumbnails from an FTP and display them on the web?
Could a DB understand from a folder location on a sever what value to assign
to it?  For example if the DB searched the server for a file, and file's
location was in folder 1, could it assign a price to it, if the DB
understood all items in folder 1 have a $10 value?"

My head hurts. I think he wants to be able to have the client find these
files, add them to a basket system, and download them when done.











To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Feature Request - Multiple Line replace

[WebDude]

Perfect! Thanks Robert!




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Wednesday, October 20, 2010 12:07 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Feature Request - Multiple Line replace



Studio 6 allows for blocks of text in the find and replace functions.



Robert



From: WebDude [mailto:webd...@cipromo.com]
Sent: Wednesday, October 20, 2010 12:59 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Feature Request - Multiple Line replace



I don't know if anyone else remembers this, but way back when EveryWare had
Tango, the find and replace function worked differently then is does now.
Back then, you could find and replace multiple lines of code rather then
just a string. Would this be something that could be easy to impliment? I
found this very useful.



Just a thought...







  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: Feature Request - Multiple Line replace

[WebDude]

I don't know if anyone else remembers this, but way back when EveryWare had
Tango, the find and replace function worked differently then is does now.
Back then, you could find and replace multiple lines of code rather then
just a string. Would this be something that could be easy to impliment? I
found this very useful.

Just a thought...






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: What's in a name?

[WebDude]

I also agree... especially the rolling off the tongue part. I always had a
problem saying w - i - tango... er... um... or is it why Tango?




  _

From: Rich [mailto:r...@ogdengroup.com]
Sent: Wednesday, October 20, 2010 8:20 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: What's in a name?


I agree, time to leave the bad taste in everyone's mouth Witango. A relaunch
with the Tango is a great idea.
Rich

  _

From: Steve Smith [mailto:ssm...@oakbridge.ca]
Sent: Wednesday, October 20, 2010 8:35 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: What's in a name?


I second the idea of a name change and agree that I'd like to see the
product's name return to Tango.

Perhaps I'm biased because I was a employee of EveryWare and Pervasive,
(1995-2000 and I go back to version 1.0 of Tango) but I still refer to it
today as Tango whenever it comes up in conversation. Tango rolls off the
tongue, Witango never did.

And it was never as easy to explain what a .taf or .tcf file was after the
name change. For those that aren't aware of the origins, .taf is Tango
Application File and .tcf is Tango Class File.

Steve Smith

Oakbridge Information Solutions
Oakville Office: (416) 628-0793
Cambridge Office:   (519) 489-0142
Email:  ssm...@oakbridge.ca
Web:   www.oakbridge.ca

Certified   DayLite Master Partner

Certified   DayLite Trainer
Billings   Consultant
FileMaker Business   Alliance Member
MoneyWorks   Consultant

LightSpeed   Authorized Reseller

On 2010-10-20, at 5:14 AM, Wayne Irvine wrote:


A rose would smell as sweet, yadda yadda.

Just wondering about the name 'Witango'. I knew the product when it was
called Tango, which had a nice ring to it and brought about images of
serious gentlemen and ravishing ladies entwined in something that was midway
between a  dance and a domestic.

I believe the name change was force on 'With Imagination' (there's a clue to
where the WI came from) when they negotiated rights to the product from
Everywhere (IIRC). I wonder if this requirement is still valid?

I for one would love a return to the old name now that With Imagination (who
proved to be 'without' at least as far as Tango went) are no longer part of
the equation.

Might also make the logo design a bit simpler.

Wayne irvine



To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Standard and Advanced

[WebDude]

Actually,

That sounds rather reasonable since the corporate license I have cost in
excess of $20,000. If I needed to include the editor for all 3, would that
be another $900?


webd...@cipromo.com


-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Wednesday, October 13, 2010 9:38 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Standard and Advanced

The Corporate (and Site and other large scale, multi-system) licenses have
been discontinued. They may have been supported for version 5.0, but I do
not believe they were sold for version 5.5 and we will not be supporting
them for version 6.

Each operating system requires a Witango Server license. This usually means
that each physical server needs a license, but in the case of
virtualization, each virtualized OS that you wish to run Witango on would
require a license.

So in your case, since you have 3 physical servers, you would purchase 3
Witango licenses. You can get any combination of Standard and Advanced that
fits your hardware.

For example, let's say that you have two Intel 3000 class servers each with
a single quad-core CPU, and a newer Intel 5000 class server with dual
quad-cores with HT (8 cores, 16 threads). You would purchase two Standard
Editions for the 3000s and one Advanced Edition for the larger server.

We offer a 10% volume discount for orders over 2 licenses. Therefore, you
could pre-order now for 20% of the price as such:

2x  999 (-20%) = 1,598.40
1x 2499 (-20%) = 1,999.20

Total to license all 3 servers: $3,597.60

Robert

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Wednesday, October 13, 2010 10:20 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Standard and Advanced

Sorry,

I am a bit confused.

What if I have 3 servers... One single instance on each server for Standard?
Or would that require 3 Standards. How about Advanced... One advanced on 3
servers? 3 advanced for 3 servers?

Sorry, I have the corporate which allows multiple installs on multiple
servers and was wondering if there is something similar.

Thanks!



webd...@cipromo.com




-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Wednesday, October 13, 2010 9:10 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Standard and Advanced

Wayne,

We just updated this section of the website yesterday:

https://www.witango.com/products/licensing

As it shows, there are 2 restrictions on the Standard Edition:

- You can only run it on a server with 4 or fewer CPU cores.
- You can only run a single instance on each server.

The Advanced Edition removes these two limitations.

Also, future versions of the v6 product line will add some features to the
Advanced server only. These features will be mostly geared towards better
server pooling support for high traffic websites.

The Standard Edition is being sold for use on workstations, entry-level
servers, older hardware, and virtual servers.

In all cases, the Witango server will use all addressable CPUs. Affinity has
been removed from the product.

Robert

-Original Message-
From: Wayne Irvine [mailto:wa...@byteserve.com.au]
Sent: Tuesday, October 12, 2010 11:39 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Standard and Advanced

I'm guessing this has been covered before but in my cursory glance over the
archives I didn't see it.

What is the difference between the Standard and Advanced Servers in version
6?

Wayne Irvine





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Standard and Advanced

[WebDude]

Sorry,

I am a bit confused.

What if I have 3 servers... One single instance on each server for Standard?
Or would that require 3 Standards. How about Advanced... One advanced on 3
servers? 3 advanced for 3 servers?

Sorry, I have the corporate which allows multiple installs on multiple
servers and was wondering if there is something similar.

Thanks!



webd...@cipromo.com




-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Wednesday, October 13, 2010 9:10 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Standard and Advanced

Wayne,

We just updated this section of the website yesterday:

https://www.witango.com/products/licensing

As it shows, there are 2 restrictions on the Standard Edition:

- You can only run it on a server with 4 or fewer CPU cores.
- You can only run a single instance on each server.

The Advanced Edition removes these two limitations.

Also, future versions of the v6 product line will add some features to the
Advanced server only. These features will be mostly geared towards better
server pooling support for high traffic websites.

The Standard Edition is being sold for use on workstations, entry-level
servers, older hardware, and virtual servers.

In all cases, the Witango server will use all addressable CPUs. Affinity has
been removed from the product.

Robert

-Original Message-
From: Wayne Irvine [mailto:wa...@byteserve.com.au]
Sent: Tuesday, October 12, 2010 11:39 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Standard and Advanced

I'm guessing this has been covered before but in my cursory glance over the
archives I didn't see it.

What is the difference between the Standard and Advanced Servers in version
6?

Wayne Irvine





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.





To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Witango 6 Question

[WebDude]

yeah... you know... sleep!




Sleep?


--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net - rgar...@eventpix.com
http://bighead.net/ - http://eventpix.com/

On Oct 5, 2010, at 10:44 AM, Ben Johansen wrote:


humm, I have worked with both the Roberts and noticed, this don't sleep
phenomenon

I wonder is it in the name ;-)

On Oct 5, 2010, at 4:53 AM, Dan Stein wrote:


but not surprising given the mazing speed of response and service that
Tronics has provided as a hosting service and Witango hosting service all
these years. I know for a fact that Robert is in fact a very friendly Zombie
who in fact never sleeps. Or so it would seem.


--
Dan Stein MSN, CPNP
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 


"It is perfectly safe to stand nowhere."

On Oct 4, 2010, at 6:54 PM, Robert Garcia wrote:


It really is amazing to see the quick response to the questions Robert. You
may resurrect this thing yet, at least enough to restore a small but vibrant
development community. Who knows where it can go after that, good job.



--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com 
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net - rgar...@eventpix.com
http://bighead.net/ - http://eventpix.com/

On Oct 4, 2010, at 2:55 PM, Robert Shubert wrote:



Kaustav,

There are no security issues in Witango at this time (that I am aware of)
and after hosting 5.5 for many years now, I have yet to see a situation
occur on my servers where a breach has happened through Witango. Of course,
should anything like this be brought to my attention, I will implement a fix
ASAP. One other notable item is that I am working to update what
dependencies I can for the v6 release. This is done mostly to ensure that
bug and security fixes that have been made to the underlying libraries are
included in Witango.

I am deprecating some minor functionality, such as the @DOCS tag, which can
be considered a security issue. I am keeping the "save as run only"
(encryption) functionality, and am planning to implement more host-friendly
features for site segregation and isolation of log and error data.

Version 6 will have a completely reworked @URL functionality. It is now
implemented as an Action in the studio and has drag-and-drop access to all
aspects of the HTTP protocol.

Robert


From: Kaustav Acharya [mailto:kacha...@colleges.com]
Sent: Monday, October 04, 2010 5:15 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Witango 6 Question
Hi Robert,
John and I were actually wondering about whether Witango 6 had any updated
security fixes that were worthy of mentioning.  Also another aspect which
you've mentioned is the inability for Witango 5.5 Server on Windows to post
via SSL using the @URL metatag. You mentioned that the best way to work
around this is to use Win HTTP 5.1.
Has this been an additional feature been addressed in the new version?
Installing another object  to do something so rudimentary is just an
inconvenience so we were just wondering.
Thanks very much!

Kaustav Acharya
   Web Developer

  U. Inc.
  12264 El Camino Real, Suite #401
  San Diego, CA. 92130

  Office: (858) 847-3350 x1004
  Fax: (858) 847-3340
  email: kacha...@colleges.com

  http://www.colleges.com 


 Power to the People - http://www.campaign.com 


Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in error, you are
hereby notified
that any review, copying or distribution of it is strictly prohibited.
Please inform kacha...@colleges.com Immediately and permanently destroy the
original transmittal.




  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.

  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



Ben Johansen
http://www.webspinr.com 
b...@webspinr.com
Phone: 360-597-3372
Mobile: 360-600-7775




  _

To unsubscribe from this list, please send an em

RE: Witango-Talk: Chat or IM

[WebDude]

I just missed ya in there. Login again and we can chat a bit. I'm in there
now. I'll dig up the code for ya...

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Friday, September 17, 2010 11:44 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Chat or IM



That is a really sweet chatroom! How do I find the source code?



Kind Regards,



WebLogomailsig

Rick Sanders

Webenergy Software

902-401-7689

 <http://www.webenergy.ca/> http://www.webenergy.ca



From: WebDude [mailto:webd...@cipromo.com]
Sent: Friday, September 17, 2010 1:13 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Chat or IM



http://myfishingpals.com/



Check the chatroom... must be a member to view, but it's free. The chatroom
script is free too. The whole thing runs in javascript/css/asp.









  _

From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Friday, September 17, 2010 10:13 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Chat or IM

Hey all. I have a dating site written in WiTango. I need to add a live chat
or IM capability to the site. Something like Facebook or Plenty of Fish. I'm
not looking to have a 3rd party host the chat for me as I need to link it to
my database so when users login they get logged into the chat as well. Java
would be ideal, but through my searching I haven't found much. If anyone has
done this before and can recommend something please let me know.



Kind Regards,



WebLogomailsig

Rick Sanders

Webenergy Software

902-401-7689

http://www.webenergy.ca <http://www.webenergy.ca/>



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.
<><><>

RE: Witango-Talk: Chat or IM

[WebDude]

http://myfishingpals.com/

Check the chatroom... must be a member to view, but it's free. The chatroom
script is free too. The whole thing runs in javascript/css/asp.




  _

From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Friday, September 17, 2010 10:13 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Chat or IM



Hey all. I have a dating site written in WiTango. I need to add a live chat
or IM capability to the site. Something like Facebook or Plenty of Fish. I'm
not looking to have a 3rd party host the chat for me as I need to link it to
my database so when users login they get logged into the chat as well. Java
would be ideal, but through my searching I haven't found much. If anyone has
done this before and can recommend something please let me know.



Kind Regards,



WebLogomailsig

Rick Sanders

Webenergy Software

902-401-7689

  http://www.webenergy.ca


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.
<>

RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

Ben and Robert,

Thank you very much. Direct DBMS was the ticket and it is working great.

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 3:04 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field


Ben and Robert,

Unfortunately, I have to run to a meeting right now. I really appreciate the
input. I'll pick this up again tomorrow early.

Thanks you guys!

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Ben Johansen [mailto:b...@webspinr.com]
Sent: Monday, September 13, 2010 2:18 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field


wrapping the value in <@SQ> wont work if you are not using DirectDBMS
you need to set Quote Value to True to get rid of the {ts ...


On Sep 13, 2010, at 12:12 PM, WebDude wrote:



Okay,

By the way... thanks for your help...

I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.

Also note in the debug, it shows...

site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...

The variable loads fine. I am using...


<@IFEMPTY <@ARG site_eval_completed>>
<@ASSIGN user$site_eval_completed "NULL">
<@ELSE>
<@ASSIGN user$site_eval_completed" <@SQ><@ARG
site_eval_completed><@SQ>">
/@IF

It shows the variable loaded correctly in debug...




[ElseIf Action]  [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars]   [50]user$site_eval_completed=NULL
[Update Action]  [50]Update1
[Query]  [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals]  [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200
hugo_camb...@gt.shr2shr.comcesar_montes@gt.shr2shr.com'; v7='07.24.2009';
v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment received 7.14.10';
v11='CN0097, 7.16.10, test sheets received 8.9'; v12='9.23.10'; v13='Open']

[Error]  [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error]  [66]-101 General error during data source operation.










Path:/admin/
File Name:   status.taf
Position:Update1
Class:   DBMS
Main Error Number:   241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008

  _

Path:/admin/
File Name:   status.taf
Position:Update1
Class:   Internal
Main Error Number:   -101
General error during data source operation.




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field


This is no problem

First, setup a variable as such:

<@IFEMPTY <@ARG date>>
<@ASSIGN request$sql_date_value "NULL">
<@ELSE>
<@ASSIGN request$sql_date_value "<@SQ><@ARG DATE><@SQ>">


Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the <@SQ>s) rather than attempting to format the date
automatically.

Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.

Also, this would effectively create the value '

RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

Ben and Robert,

Unfortunately, I have to run to a meeting right now. I really appreciate the
input. I'll pick this up again tomorrow early.

Thanks you guys!

John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com



  _

From: Ben Johansen [mailto:b...@webspinr.com]
Sent: Monday, September 13, 2010 2:18 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field


wrapping the value in <@SQ> wont work if you are not using DirectDBMS
you need to set Quote Value to True to get rid of the {ts ...


On Sep 13, 2010, at 12:12 PM, WebDude wrote:



Okay,

By the way... thanks for your help...

I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.

Also note in the debug, it shows...

site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...

The variable loads fine. I am using...


<@IFEMPTY <@ARG site_eval_completed>>
<@ASSIGN user$site_eval_completed "NULL">
<@ELSE>
<@ASSIGN user$site_eval_completed" <@SQ><@ARG
site_eval_completed><@SQ>">
/@IF

It shows the variable loaded correctly in debug...




[ElseIf Action]  [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars]   [50]user$site_eval_completed=NULL
[Update Action]  [50]Update1
[Query]  [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals]  [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200
hugo_camb...@gt.shr2shr.comcesar_montes@gt.shr2shr.com'; v7='07.24.2009';
v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment received 7.14.10';
v11='CN0097, 7.16.10, test sheets received 8.9'; v12='9.23.10'; v13='Open']

[Error]  [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error]  [66]-101 General error during data source operation.










Path:/admin/
File Name:   status.taf
Position:Update1
Class:   DBMS
Main Error Number:   241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008

  _

Path:/admin/
File Name:   status.taf
Position:Update1
Class:   Internal
Main Error Number:   -101
General error during data source operation.




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field


This is no problem

First, setup a variable as such:

<@IFEMPTY <@ARG date>>
<@ASSIGN request$sql_date_value "NULL">
<@ELSE>
<@ASSIGN request$sql_date_value "<@SQ><@ARG DATE><@SQ>">


Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the <@SQ>s) rather than attempting to format the date
automatically.

Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.

Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm

Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)

The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.

RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

I guess I am hosed then, eh?




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 2:19 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field



I think I just remembered that you are using Tango2000..



I suspect that my notes will only apply to the newer SQL Generator found in
5.x (possibly only 5.5).



Robert





From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 3:13 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field



Okay,



By the way... thanks for your help...



I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.



Also note in the debug, it shows...



site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...



The variable loads fine. I am using...



<@IFEMPTY <@ARG site_eval_completed>>

<@ASSIGN user$site_eval_completed "NULL">

<@ELSE>

<@ASSIGN user$site_eval_completed" <@SQ><@ARG
site_eval_completed><@SQ>">

/@IF



It shows the variable loaded correctly in debug...




[ElseIf Action]

[50]

ElseIfUpdate


[Results Action]

[50]

Results4


[Changed Vars]

[50]

user$site_eval_completed=NULL


[Update Action]

[50]

Update1


[Query]

[50]

UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)


[BoundVals]

[50]

[v1='Shore To Shore'; v2='Central America'; v3='Shore To Shore Lacar,
Ltda.'; v4='Boulevard Industrial Norte, No 440 Zona 4 de Mixco, El Naranjo,
Guatemala City, Guatemala 01057'; v5='Hugo Cambran/Cesar Montes';
v6='502-2422-0200 hugo_camb...@gt.shr2shr.com cesar_mon...@gt.shr2shr.com';
v7='07.24.2009'; v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment
received 7.14.10'; v11='CN0097, 7.16.10, test sheets received 8.9';
v12='9.23.10'; v13='Open']


[Error]

[66]

241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string. 22008


[Error]

[66]

-101 General error during data source operation.














Path:

/admin/


File Name:

status.taf


Position:

Update1


Class:

DBMS


Main Error Number:

241


[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string.


22008


  _


Path:

/admin/


File Name:

status.taf


Position:

Update1


Class:

Internal


Main Error Number:

-101


General error during data source operation.









  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field

This is no problem



First, setup a variable as such:



<@IFEMPTY <@ARG date>>

<@ASSIGN request$sql_date_value "NULL">

<@ELSE>

<@ASSIGN request$sql_date_value "<@SQ><@ARG DATE><@SQ>">





Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the <@SQ>s) rather than attempting to format the date
automatically.



Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.



Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm



Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)



The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.



Robert



PS. The value of "NULL" does not get quoted.



From: WebDude [mailto:webd...@cipromo.com]
Sent

RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

Okay,

By the way... thanks for your help...

I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.

Also note in the debug, it shows...

site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...

The variable loads fine. I am using...


<@IFEMPTY <@ARG site_eval_completed>>

<@ASSIGN user$site_eval_completed "NULL">

<@ELSE>

<@ASSIGN user$site_eval_completed" <@SQ><@ARG
site_eval_completed><@SQ>">

/@IF



It shows the variable loaded correctly in debug...




[ElseIf Action]  [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars]   [50]user$site_eval_completed=NULL
[Update Action]  [50]Update1
[Query]  [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals]  [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200 hugo_camb...@gt.shr2shr.com
cesar_mon...@gt.shr2shr.com'; v7='07.24.2009'; v8='YES.'; v9='08.10.09,
0809-1003'; v10='Wire payment received 7.14.10'; v11='CN0097, 7.16.10, test
sheets received 8.9'; v12='9.23.10'; v13='Open']
[Error]  [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error]  [66]-101 General error during data source operation.









Path:/admin/
File Name:   status.taf
Position:Update1
Class:   DBMS
Main Error Number:   241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008

  _

Path:/admin/
File Name:   status.taf
Position:Update1
Class:   Internal
Main Error Number:   -101
General error during data source operation.




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field



This is no problem



First, setup a variable as such:



<@IFEMPTY <@ARG date>>

<@ASSIGN request$sql_date_value "NULL">

<@ELSE>

<@ASSIGN request$sql_date_value "<@SQ><@ARG DATE><@SQ>">





Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the <@SQ>s) rather than attempting to format the date
automatically.



Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.



Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm



Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)



The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.



Robert



PS. The value of "NULL" does not get quoted.



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 1:46 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field



Hello,



Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able to
update the date, delete the date (make null) or keep the date null on an
insert. Keeping the dat null on insert is fairly easy, but what if they want
to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db.
Can an insert of NULL be written in SQL? I tried he obv

RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

That works fine on the initial insert. What about an update where a date
existed before and now we want to delete the date? Only thing MSSQL will let
you do is change to NULL. If you go into the Enterprise Manager, you can
change the dates to NULL by doing a control 0. I am trying to write a
statement that allows a NULL to be written as an update to the datetime
field.



  _

From: Ted Wolfley [mailto:t...@ogdengroup.com]
Sent: Monday, September 13, 2010 1:05 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field



If the date form field is blank don't include the date insert section as
part of the insert statement.

Best way is to use the Direct DBMS action.



Ted



From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 1:46 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field



Hello,



Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able to
update the date, delete the date (make null) or keep the date null on an
insert. Keeping the dat null on insert is fairly easy, but what if they want
to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db.
Can an insert of NULL be written in SQL? I tried he obvious... <@IFEMPTY
<@ARG date>>NULL<@ELSE><@ARG date>>/@IF>, <@IFEMPTY <@ARG
date>>DbNull.value<@ELSE><@ARG date>>/@IF>, etc...



Has anyone done this before?



Thanks!







  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: Updating or Inserting NULL into MSSQL datetime field

[WebDude]

Hello,

Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able to
update the date, delete the date (make null) or keep the date null on an
insert. Keeping the dat null on insert is fairly easy, but what if they want
to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db.
Can an insert of NULL be written in SQL? I tried he obvious... <@IFEMPTY
<@ARG date>>NULL<@ELSE><@ARG date>>/@IF>, <@IFEMPTY <@ARG
date>>DbNull.value<@ELSE><@ARG date>>/@IF>, etc...

Has anyone done this before?

Thanks!






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Still using Tango 2000?

[WebDude]

Thanks Robert...


  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Thursday, August 12, 2010 3:17 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Still using Tango 2000?



WebDude & anyone else still using Tango 2000.



I've updated the page on the Witango.com site (Products > What's New) so
that it has working links to the two "What's New" documents. The top part of
the page talks about migration from Tango 2000 to Witango 5. The bottom part
is about moving from 5.0 to 5.5.



I strongly recommend that you read both documents carefully, as there are a
few major differences, as we've pointed out, and they are explained in
detail here.



Let me know if you have any problems with the PDFs.



As for advice regarding upgrading, I'm of two minds here. On the one hand,
the file format in version 6 will be compatible with 5.5, therefore you can
begin working on your migration now (moving to 5.5) knowing that you won't
be wasting your time. However, moving to the 5.5 platform may have its own
issues, especially for OS X users, JDBC users, and those wishing to use the
newest hardware and software. In other words, I do recommend using 5.5 as a
tool in your migration, but you may want to wait until 6 is out before
upgrading your production environment. The one caveat to this rule is that
if you are using older hardware and software (or can do so with
virtualization) then v5.5 can still be quite effective.



Any v5.5 licenses which are purchased from now on will automatically get a
free upgrade to v6. So if you are committed to moving to v6 when it comes
out, then there is no risk in getting an early start on that process.



Robert

Witango







From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, August 10, 2010 3:28 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Windows 7 Server





Folks... I am so excited about the latest developments, I almost peed
myself. I have been holding out for years on upgrading... pretty much
because I spent so much on the Corporate Server. But, since there seems to
be new life being pumped into the product, I am seriuosly considering
buying, at the minimum, 2 professional servers. The reason for this post is
I have some concerns. I am still using Witango 2000 and very happy with it.
I have it installed on 3 servers and never really had any issues. 2 of the
servers are Win2k and one is a 2003. We run about 70 websites, some getting
about a half million visits per month. I also have some very important
corporate clients that are very critical  when it comes to uptime, speed,
etc. (yeah, I know... but corporate america can be kind of dumb when it
comes to this stuff... still running such an old version). Nothing is
clustered, all servers are dedicated to specific sites. All tie into a
single database server.



Anyway, I am going to be purchasing a few Windows Servers and would like to
load the new platform on them. I know there are some adjustments that will
need to be made. I believe that one of these is setting the default scope of
all unscoped variables to user... is that correct? What I need to know is
any other caveats that some of you may have run into. (i.e. do I actually
have to open and save each taf before they will work with a new server?) I
am thinking of porting 1 site at a time. I will have the luxury of having
new servers configured and ready to go along with the old servers.



Any help would be greatly appreciated. I just landed some pretty hefty
contracts and would like to keep using Witango as it is my program of choice
for almost all of our development. I also would like to try to get Witango
into the mainsteam a bit more, too. Not sure how to do this, but I would
think if we could put our collective heads together, we might be able to
come up with something. I do work for some very big corporations and, though
I don't want to drop any names here, I might be able to get them to support
the product a bit. Not sure how to approach them, just thinking out loud.
Endoresements maybe? I am not sure how this stuff works.



Thanks!







  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.


  _

To unsubscribe from this list, please send an email to lists...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

Witango-Talk: Windows 7 Server

[WebDude]

Folks... I am so excited about the latest developments, I almost peed
myself. I have been holding out for years on upgrading... pretty much
because I spent so much on the Corporate Server. But, since there seems to
be new life being pumped into the product, I am seriuosly considering
buying, at the minimum, 2 professional servers. The reason for this post is
I have some concerns. I am still using Witango 2000 and very happy with it.
I have it installed on 3 servers and never really had any issues. 2 of the
servers are Win2k and one is a 2003. We run about 70 websites, some getting
about a half million visits per month. I also have some very important
corporate clients that are very critical  when it comes to uptime, speed,
etc. (yeah, I know... but corporate america can be kind of dumb when it
comes to this stuff... still running such an old version). Nothing is
clustered, all servers are dedicated to specific sites. All tie into a
single database server.

Anyway, I am going to be purchasing a few Windows Servers and would like to
load the new platform on them. I know there are some adjustments that will
need to be made. I believe that one of these is setting the default scope of
all unscoped variables to user... is that correct? What I need to know is
any other caveats that some of you may have run into. (i.e. do I actually
have to open and save each taf before they will work with a new server?) I
am thinking of porting 1 site at a time. I will have the luxury of having
new servers configured and ready to go along with the old servers.

Any help would be greatly appreciated. I just landed some pretty hefty
contracts and would like to keep using Witango as it is my program of choice
for almost all of our development. I also would like to try to get Witango
into the mainsteam a bit more, too. Not sure how to do this, but I would
think if we could put our collective heads together, we might be able to
come up with something. I do work for some very big corporations and, though
I don't want to drop any names here, I might be able to get them to support
the product a bit. Not sure how to approach them, just thinking out loud.
Endoresements maybe? I am not sure how this stuff works.

Thanks!






To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Announcement - Witango under new ownership

[WebDude]

Whoo Hoo

Does this mean I can keep on keeping on?


  _

From: Kaustav Acharya [mailto:kacha...@colleges.com]
Sent: Monday, August 02, 2010 1:55 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Announcement - Witango under new ownership


Congratulations on the acquisition Robert and we wish you all the success.
Hopefully we can focus on getting WiTango back on the map :)

Kaustav


Kaustav Acharya
   Web Developer

  U. Inc.
  12264 El Camino Real, Suite #401
  San Diego, CA. 92130

  Office: (858) 847-3350 x1004
  Fax: (858) 847-3340
  email: kacha...@colleges.com


  http://www.colleges.com


 Power to the People - http://www.campaign.com


Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in error, you are
hereby notified
that any review, copying or distribution of it is strictly prohibited.
Please inform kacha...@colleges.com Immediately and permanently destroy the
original transmittal.



On Aug 2, 2010, at 11:43 AM, supp...@witango.com wrote:





To the Witango community:

Tronics Software LLC has purchased the Witango product suite from Witango
Technologies Pty Ltd.  We at Tronics Software are extremely excited to
launch this new chapter for Witango, and we are dedicated to the ongoing
support and development of the Witango products.

Over the next few days and weeks we will be releasing further information
about our plans for Witango, the timing of the version 6.0 release, and
pricing details.  We are also committed to supporting and expanding the
Witango community, and we will be launching community forums and a
development blog shortly.

We will post all announcements to the list and to the witango.com
  website - please check back often!

Thank you all for your continued support of Witango,

Tronics Software LLC



Tronics Software LLC is a software development company in New Jersey, part
of the Tronics group of companies founded by Robert Shubert.  Robert has
been a part of the Witango community since 1998 and owns Tronics, the
leading Witango web hosting provider.  To contact Tronics Software with
questions, please email   supp...@witango.com or
call (570) 647-4370.


  _

To unsubscribe from this list, please send an email to mails...@witango.com
with "unsubscribe witango-talk" in the body.



  _

To unsubscribe from this list, please send an email to mails...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to mails...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Sum of Square Root

[WebDude]

pong




  _

From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, August 02, 2010 12:02 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Sum of Square Root



Ping?



From: WebDude [mailto:webd...@cipromo.com]
Sent: Thursday, July 22, 2010 10:49 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Sum of Square Root



Excellent... thank you...







  _

From: Paul Wilson [mailto:pwilson@gmail.com]
Sent: Tuesday, July 20, 2010 7:56 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Sum of Square Root

Excuse me, I meant the sum of the squares



I believe it is the sum of the squares.  For example SUMSQ(2,3,4) = 29

(2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29



It may be a simple as breaking up Excel's fancy SUMSQ into a formula.

sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e





On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson  wrote:

I believe it is the sum of the square roots.  For example SUMSQ(2,3,4) = 29

(2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29



It may be a simple as breaking up Excel's fancy SUMSQ into a formula.

sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e







On Tue, Jul 20, 2010 at 8:31 AM, WebDude  wrote:

I was given an excel file that needs to be converted to a web page. I am not
a Math guru and was wondering if someone could help me out.



The form has some fields with a formula that looks like this (cell e is the
result)...



=SQRT(SUMSQ(b1-b2,c1-c2,d1-d2))   ---  This is the formula for cell e



 bc d e





Reference:







0.00


Sample Measurement:











All 6 yellow cells will be inputs. What I don't get is how to sum a square
root. Any help would be appreciated.



Thanks!



p.s. I hope the format of this email doesn't fall apart.




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 to this list, please send an email to mails...@witango.com
with "unsubscribe witango-talk" in the body.




To unsubscribe from this list, please send an email to mails...@witango.com 
with "unsubscribe witango-talk" in the body.

RE: Witango-Talk: Sum of Square Root

[WebDude]

Excellent... thank you...
 
 

  _  

From: Paul Wilson [mailto:pwilson@gmail.com] 
Sent: Tuesday, July 20, 2010 7:56 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Sum of Square Root


Excuse me, I meant the sum of the squares

I believe it is the sum of the squares.  For example SUMSQ(2,3,4) = 29 
(2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29

It may be a simple as breaking up Excel's fancy SUMSQ into a formula.
sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e


On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson  wrote:


I believe it is the sum of the square roots.  For example SUMSQ(2,3,4) = 29 
(2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29

It may be a simple as breaking up Excel's fancy SUMSQ into a formula.
sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e



On Tue, Jul 20, 2010 at 8:31 AM, WebDude  wrote:


I was given an excel file that needs to be converted to a web page. I am not
a Math guru and was wondering if someone could help me out. 
 
The form has some fields with a formula that looks like this (cell e is the
result)...
 
=SQRT(SUMSQ(b1-b2,c1-c2,d1-d2))   ---  This is the formula for cell e
 
 bc d e

Reference:  0.00
Sample Measurement: 
 
All 6 yellow cells will be inputs. What I don't get is how to sum a square
root. Any help would be appreciated.
 
Thanks!
 
p.s. I hope the format of this email doesn't fall apart.
 


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: Sum of Square Root

[WebDude]

I was given an excel file that needs to be converted to a web page. I am not
a Math guru and was wondering if someone could help me out. 
 
The form has some fields with a formula that looks like this (cell e is the
result)...
 
=SQRT(SUMSQ(b1-b2,c1-c2,d1-d2))   ---  This is the formula for cell e
 
 bc d e
Reference:  0.00
Sample Measurement: 
 
All 6 yellow cells will be inputs. What I don't get is how to sum a square
root. Any help would be appreciated.
 
Thanks!
 
p.s. I hope the format of this email doesn't fall apart.
 


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

RE: Witango-Talk: Print a page automatically

[WebDude]

Unfortunately, these are system calls and you cannot pass those parameters
to the print function via javascript, as far as I know. Notice, you also
cannot get rid of the URL at the bottom of the page, the date, the "page 1of
1" or any of the other parameters that are set up in various types of
browsers. These are all stored in options/preferences of the individual
browser. Not only that, different browsers will print different headers and
footers. 
 

  _  

From: Fogelson, Steve [mailto:stevefogel...@askics.net] 
Sent: Monday, June 28, 2010 1:20 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Print a page automatically



Hi,

 

I found that I can use the following javascript in the Body tag to open the
print window when a web page loads

 



 

Is there a way in Witango I can I pass the printer name to print to and
select "Print" to save some clicks?

 

Thanks

 

Steve Fogelson

Internet Commerce Solutions



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: Muxed variable on a hard crash

[WebDude]

Witango 2000
Windows 2000 Fully patched
There are actually 2 variables that hold the breadcrumb. It is configured
like this...
 
top/archive/<@VAR q>/<@VAR mc>/ 
 
Note, the whole path ends up in the ini file
(Path=top/archive/history/creamy/). 
 
No crash event dump, just s restart. 
 
I will try changing the persistentrestart=false


Witango version?

 

OS & version?

 

Name of variable that holds the breadcrumb nav?

 

Does witangoevents.log report a crash event (a dump?)

 

You can try editing Witango.ini, set persistentrestart=false and see if it
continues with that setting.

 

Robert

 

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Friday, June 04, 2010 1:58 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Muxed variable on a hard crash

 

Hey Everyone,

 

I got a wierd thing happening... it has happened twice so far. 

 

When one of our servers crashes (i.e. a power outage), on reboot, everything
comes up fine except for the applications.ini file. Typically, one of the
settings is Path=/ 

 

But on a hard crash, the Path is changed to
Path=top/archive/history/flavors/creamy/

 

After the hard crash, I go and change the ini file back to Path=/, stop
Witango and restart it and everything is fine.

 

What is wierd is that this path does not exist on the server, though it does
exist as a user scoped variable that loads breadcrumb navigation on one of
our sites. I searched everything on the server for this string of text,
including the registry and cannot find it. I am wondering on a hard crash
where Witango gets this value. Does anyone have any clue as to what is
happening? 

 

No, the server is not hacked. It is only noticeable on one site in which I
use an application scoped variable. It is the only place on this server in
which an application scoped variable is used... and it's not even the same
site as where the breadcrumb navigation is?!?!?!

 

Wierd...

 

 

 

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: Muxed variable on a hard crash

[WebDude]

Anyone?
 
 
 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Friday, June 04, 2010 12:58 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Muxed variable on a hard crash


Hey Everyone,
 
I got a wierd thing happening... it has happened twice so far. 
 
When one of our servers crashes (i.e. a power outage), on reboot, everything
comes up fine except for the applications.ini file. Typically, one of the
settings is Path=/ 
 
But on a hard crash, the Path is changed to
Path=top/archive/history/flavors/creamy/
 
After the hard crash, I go and change the ini file back to Path=/, stop
Witango and restart it and everything is fine.
 
What is wierd is that this path does not exist on the server, though it does
exist as a user scoped variable that loads breadcrumb navigation on one of
our sites. I searched everything on the server for this string of text,
including the registry and cannot find it. I am wondering on a hard crash
where Witango gets this value. Does anyone have any clue as to what is
happening? 
 
No, the server is not hacked. It is only noticeable on one site in which I
use an application scoped variable. It is the only place on this server in
which an application scoped variable is used... and it's not even the same
site as where the breadcrumb navigation is?!?!?!
 
Wierd...
 
 


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


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

Witango-Talk: Muxed variable on a hard crash

[WebDude]

Hey Everyone,
 
I got a wierd thing happening... it has happened twice so far. 
 
When one of our servers crashes (i.e. a power outage), on reboot, everything
comes up fine except for the applications.ini file. Typically, one of the
settings is Path=/ 
 
But on a hard crash, the Path is changed to
Path=top/archive/history/flavors/creamy/
 
After the hard crash, I go and change the ini file back to Path=/, stop
Witango and restart it and everything is fine.
 
What is wierd is that this path does not exist on the server, though it does
exist as a user scoped variable that loads breadcrumb navigation on one of
our sites. I searched everything on the server for this string of text,
including the registry and cannot find it. I am wondering on a hard crash
where Witango gets this value. Does anyone have any clue as to what is
happening? 
 
No, the server is not hacked. It is only noticeable on one site in which I
use an application scoped variable. It is the only place on this server in
which an application scoped variable is used... and it's not even the same
site as where the breadcrumb navigation is?!?!?!
 
Wierd...
 
 


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

RE: Witango-Talk: date sent on mail actions is off

[WebDude]

I had this same problem last year. I stopped and started the Witango service
and it corrected itself. I noticed that all my cron jobs were firing an hour
off...
 
 
 

  _  

From: Roland Dumas [mailto:radu...@mac.com] 
Sent: Sunday, April 11, 2010 12:32 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: date sent on mail actions is off


wait a minute. DST started on the first sunday in april as of 1986 (in the
US). THe system clock knows the time, time zone, and that it's daylight
saving. witango is off. I don't recall this happening last year or the year
before. The witango log is stamping the right time, just emails get pushed
forward an hour. 


On Apr 11, 2010, at 9:16 AM, Steve Smith wrote:


Remember that this should go away in a couple of weeks. My guess is that if
there is a problem with the code, it is because the rules were created when
DST started on the last Sunday in April. 


Steve Smith

Oakbridge Information Solutions
Oakville Office: (416) 628-0793
Cambridge Office:   (519) 489-0142
Email:    ssm...@oakbridge.ca
Web:   www.oakbridge.ca 


Certified DayLite Master Partner
Certified DayLite Trainer
Billings Consultant
FileMaker Solutions Alliance Member
MoneyWorks Consultant
LightSpeed Authorized Reseller 

Sent from my iPad

On 2010-04-11, at 11:34 AM, Roland Dumas  wrote:



Thanks. I'm running two servers with witango 5 and they both have the same
problem. I'm using the services of a witango server 5.5, and it's giving me
correct datetime on emails. 
Now to figure out a workaround...


On Apr 11, 2010, at 12:15 AM, D. Richardy wrote:



It looks like Witango's daylight time handling code is wrong.
...
Not only this.
 
Just my 1 Cent from Europe.

  _  

PS: ANY NEWS ABOUT WITAN"GO" 6. Or is it a really WIT(h)-ON-"GO"
 
Mail from Phil (29-04-2008):
Hi all, 
Before this thread gets a life of its own let me just say that there is more
to this release as we move to commercial open source model than just
software.   We have basically finished the engineering but there are still
some legal and business issues we are continuing to work through.


It all takes time and we are not just sitting here idly.  While we have been
waiting for these issue to be resolved we have been adding extra features to
the studio.  As soon as I can release v6 I will.  


Regards


Phil


- Original Message -
From: Anthony Humphreys  
To:   witango-talk@witango.com
Cc: Roland Dumas  
Sent: Sunday, April 11, 2010 6:48 AM
Subject: Re: Witango-Talk: date sent on mail actions is off

Witango shouldn't have its own Timezone rules; Witango should use the
server's local time and offset (from GMT).
However, Witango does need to reformat the time to specific SMTP format.
However, this reformat is the ONLY thing that Witango should be doing.

PDT stands for Pacific Daylight Time and has an offset of -0700. 
PST stands for Pacific Standard Time and has an offset of -0800.

13:43:47 -0700 PDT is not equivalent to 2:43:47 PM PDT

It looks like Witango's daylight time handling code is wrong.







On Sat, Apr 10, 2010 at 12:29 PM, Roland Dumas < 
radu...@mac.com> wrote:


does the tango server had its own date rules?  I didn't see anything in
witango.ini that set the time zone.


On Apr 10, 2010, at 9:27 AM, Steve Smith wrote:

> Could it have something to do with the fact that the Witango code was
created before the new rules came into effect for Daylite Savings Time in
2007?
>
> Steve Smith
>
> Oakbridge Information Solutions
> Oakville Office: (416) 628-0793
> Cambridge Office:   (519) 489-0142
> Email:    ssm...@oakbridge.ca
> Web:   www.oakbridge.ca
 
>
> Certified DayLite Master Partner
> Certified DayLite Trainer
> Billings Consultant
> FileMaker Solutions Alliance Member
> MoneyWorks Consultant
> LightSpeed Authorized Reseller
>
> Sent from my iPad
>
> On 2010-04-10, at 12:19 PM, Roland Dumas < 
radu...@mac.com> wrote:
>
>> Anyone have a clue why witango mail action gets timestamp off an hour?
>>
>> On Apr 9, 2010, at 2:11 PM, Roland Dumas wrote:
>>
>>> This is an example: Note the date field says 2:43 PM while the
header correctly shows 1:43 PM.  This discrepancy happens only for witango
mail action generated messages.
>>>
>>>
>>> DateApril 9, 2010 2:43:47 PM PDT
>>> To: Roland Dumas < 
radu...@servqual.com>
>>> Received:   from Imagineworks.localhost (
 mail.imagineworks.com
  [64.151.109.164]) BY
 imagineworks.com 
([64.151.109.164]) WITH ESMTP (4D WebSTAR V Mail (5.4.1)); Fri, 09 Apr 2010
13:43:47 -0700
>>> R

RE: Witango-Talk: Multiple Sorts

[WebDude]

SET ROWCOUNT  n? Where is this?
date desc;?  no date here
 
 
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com
 
 

  _  

From: Ted Wolfley [mailto:t...@ogdengroup.com] 
Sent: Tuesday, March 02, 2010 12:45 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts



If you are using SQL SERVER you can actually use both.  Set the number of
results to be returned using the SET ROWCOUNT  n option;  Then use the ORDER
BY SQL  to retrieve the latest n records. Remember to use SET ROWCOUNT  0 to
turn off the option.  

 

In DirectDBMS:

SET ROWCOUNT  100;

Select * from table order by date desc;

SET ROWCOUNT  0;

 

You now have the Resultset available for sorting.

 

Ted

 

From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Tuesday, March 02, 2010 1:04 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

 

If you are using SQL server to limit the results, then you can not use the
@SORT option, but must use the ORDER BY SQL clause. Ted's option of using
@SORT and <@ROWS start=/stop=> only works if you initially retrieve the
entire dataset from SQL and store it as a user variable as he explained.
This will usually work, but can be deadly if you are working with many
thousands of rows or more. Robert

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, March 02, 2010 12:42 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

 

Now for the $10,000 question... If you are using a max of 100 returns and
paging through the returns, is there a way of carrying the sort(s) through
to the next page. 

 

John Muldoon

Corporate Incentives

3416 Nicollet Ave S

Minneapolis, MN 55408-4552

612.822.

webd...@cipromo.com



 <http://cipromo.com/> http://cipromo.com

 

 

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, March 02, 2010 11:13 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

Not very pretty, but this works great! Thanks!

<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 1 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 2">
<@COMMENT>lname
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 2 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 3">
<@COMMENT>state
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 3 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 4">
<@COMMENT>customerid
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 4 NUM ASC" REPLACESTR="">'>

<@ELSE>
<@COMMENT>default
<@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user">

/@IF

<@IFEMPTY VALUE="<@VAR ResultSet>">
<@else>
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@else>
<@SORT ARRAY="ResultSet" scope="local" COLS=&qu

RE: Witango-Talk: Multiple Sorts

[WebDude]

bummer... 
 
 Yes... we are using an SQL server... any suggestions?
 
 

  _  

From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Tuesday, March 02, 2010 12:04 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts



If you are using SQL server to limit the results, then you can not use the
@SORT option, but must use the ORDER BY SQL clause. Ted's option of using
@SORT and <@ROWS start=/stop=> only works if you initially retrieve the
entire dataset from SQL and store it as a user variable as he explained.
This will usually work, but can be deadly if you are working with many
thousands of rows or more. Robert

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, March 02, 2010 12:42 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

 

Now for the $10,000 question... If you are using a max of 100 returns and
paging through the returns, is there a way of carrying the sort(s) through
to the next page. 

 

John Muldoon

Corporate Incentives

3416 Nicollet Ave S

Minneapolis, MN 55408-4552

612.822.

webd...@cipromo.com



 <http://cipromo.com/> http://cipromo.com

 

 

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, March 02, 2010 11:13 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

Not very pretty, but this works great! Thanks!

<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 1 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 2">
<@COMMENT>lname
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 2 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 3">
<@COMMENT>state
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 3 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 4">
<@COMMENT>customerid
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 4 NUM ASC" REPLACESTR="">'>

<@ELSE>
<@COMMENT>default
<@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user">

/@IF

<@IFEMPTY VALUE="<@VAR ResultSet>">
<@else>
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@else>
<@SORT ARRAY="ResultSet" scope="local" COLS="<@VAR
vsortorder SCOPE=User>">



-Original Message-
From: Ted Wolfley [mailto:t...@ogdengroup.com]
Sent: Tuesday, March 02, 2010 9:48 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

My mistake on the @@request$vsortorder should have been @@user$vsortorder.

You will have to add a replace tag before assigning the new sort. Ex( sort
version): if existing sort order is "1,2,3,4" and the new sort to be added
is "3" to make the sort "3,1,2,4" you have to remove the existing "3" first.

Ted

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 02, 2010 10:25 AM
To: witango-talk@witango.com
Subje

RE: Witango-Talk: Multiple Sorts

[WebDude]

Now for the $10,000 question... If you are using a max of 100 returns and
paging through the returns, is there a way of carrying the sort(s) through
to the next page. 
 
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com
 
 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, March 02, 2010 11:13 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts



Not very pretty, but this works great! Thanks!

<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 1 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 2">
<@COMMENT>lname
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 2 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 3">
<@COMMENT>state
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 3 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 4">
<@COMMENT>customerid
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 4 NUM ASC" REPLACESTR="">'>

<@ELSE>
<@COMMENT>default
<@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user">

/@IF

<@IFEMPTY VALUE="<@VAR ResultSet>">
<@else>
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@else>
<@SORT ARRAY="ResultSet" scope="local" COLS="<@VAR
vsortorder SCOPE=User>">



-Original Message-
From: Ted Wolfley [mailto:t...@ogdengroup.com]
Sent: Tuesday, March 02, 2010 9:48 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

My mistake on the @@request$vsortorder should have been @@user$vsortorder.

You will have to add a replace tag before assigning the new sort. Ex( sort
version): if existing sort order is "1,2,3,4" and the new sort to be added
is "3" to make the sort "3,1,2,4" you have to remove the existing "3" first.

Ted

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 02, 2010 10:25 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts


Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use
@@request$vsortorder... It just isn't being recognized. I think I have an
older version of Witango that doesn't let me use that scope. When I change
it to <@VAR vsortorder> it works fine.

Now that being said... I get to around 5 clicks (in which the sorts all work
exactly as planned) and then Witango crashes. I am muxing the result array
somehow. I am not sure how to post the sort arguments... Do I need to do a
search for every post of the sort? Here is what I have so far.

By the way... Thank you for the help... I appreciate it.

  
Matching Records



<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsort

RE: Witango-Talk: Multiple Sorts

[WebDude]

Not very pretty, but this works great! Thanks!

<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 1 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 2">
<@COMMENT>lname
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 2 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 3">
<@COMMENT>state
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 3 NUM ASC" REPLACESTR="">'>

<@ELSEIF EXPR="<@ARG sort>= 4">
<@COMMENT>customerid
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC" SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">
<@ASSIGN vsortorder '<@REPLACE STR="<@VAR vsortorder>"
FINDSTR=", 4 NUM ASC" REPLACESTR="">'>

<@ELSE>
<@COMMENT>default
<@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user">

/@IF

<@IFEMPTY VALUE="<@VAR ResultSet>">
<@else>
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@else>
<@SORT ARRAY="ResultSet" scope="local" COLS="<@VAR
vsortorder SCOPE=User>">



-Original Message-
From: Ted Wolfley [mailto:t...@ogdengroup.com]
Sent: Tuesday, March 02, 2010 9:48 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

My mistake on the @@request$vsortorder should have been @@user$vsortorder.

You will have to add a replace tag before assigning the new sort. Ex( sort
version): if existing sort order is "1,2,3,4" and the new sort to be added
is "3" to make the sort "3,1,2,4" you have to remove the existing "3" first.

Ted

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 02, 2010 10:25 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts


Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use
@@request$vsortorder... It just isn't being recognized. I think I have an
older version of Witango that doesn't let me use that scope. When I change
it to <@VAR vsortorder> it works fine.

Now that being said... I get to around 5 clicks (in which the sorts all work
exactly as planned) and then Witango crashes. I am muxing the result array
somehow. I am not sure how to post the sort arguments... Do I need to do a
search for every post of the sort? Here is what I have so far.

By the way... Thank you for the help... I appreciate it.

  
Matching Records



<@IF EXPR="<@ARG sort>= 1">
<@COMMENT>company
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC"
SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">

<@ELSEIF EXPR="<@ARG sort>= 2">
<@COMMENT>lname
<@IFEMPTY VALUE="<@VAR vsortorder>">
<@ASSIGN NAME="vso

RE: Witango-Talk: Multiple Sorts

[WebDude]

user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="2 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">

<@ELSEIF EXPR="<@ARG sort>= 3">
<@COMMENT>state
<@IFEMPTY VALUE="@@request$vsortorder">
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC"
SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="3 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">

<@ELSEIF EXPR="<@ARG sort>= 4">
<@COMMENT>customerid
<@IFEMPTY VALUE="@@request$vsortorder">
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC"
SCOPE="user">
<@else>
<@ASSIGN NAME="vsortorder" VALUE="4 NUM ASC, <@VAR
vsortorder SCOPE=User> " SCOPE="user">

<@ELSE>
<@COMMENT>default
<@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user">




Sort the results set, checking if there is results first or it will
error:
<@IFEMPTY VALUE="@@request$ResultSet">
<@else>
<@IFEMPTY VALUE="@@request$vsortorder">
<@else>
<@SORT ARRAY="ResultSet" scope="request"
COLS="<@VAR vsortorder SCOPE=User>">



I did the example in ascending order, it can also be done in descending or
both directions, just add additional <@elseif> to the sortorder statements.

Ted
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 02, 2010 7:31 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts

Well... That's the way I do it. But it seems that you cannot have a blank
variable or multiple sorts within 1 variable... Or am I missing something
here.

Do you have an example? 



-Original Message-
From: Ted Wolfley [mailto:t...@ogdengroup.com]
Sent: Monday, March 01, 2010 10:13 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts


I found it better and faster to do the sort after the results are
returned
in the Results Action.  Use a user variable and keep appending  to the
beginning, then use the variable in the sort tag.  Remember to have a
way to
clear the sort and the variable

Ted


-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Mon 3/1/2010 7:29 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Multiple Sorts
 
Typically in the past, I load a sort into a variable and then add that
variable as a sort in the search function...
 
I then use an argument to change the sorts...
 
<@IFEQUAL <@ARG sort> "1"><@ASSIGN sort "company_info.company">/@IF
<@IFEQUAL <@ARG sort> "2"><@ASSIGN sort "company_info.lname">/@IF
<@IFEQUAL
<@ARG sort> "3"><@ASSIGN sort "company_info.state">/@IF <@IFEQUAL <@ARG
sort> "4"><@ASSIGN sort "company_info.customer_id">/@IF
 
I've been going around and around on this... is there anyway to hold
onto
the sorts so, let's say, they click on Company first, and then click on
last
name, they get a sort by lname, company. An thus, if they click next on
State, they get a sort of state, lname, company... and so on. 
 
I'm sure this has comeup before... I just can't find the answer.
 
Thanks!
 
 


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: Multiple Sorts

[WebDude]

Well... That's the way I do it. But it seems that you cannot have a blank
variable or multiple sorts within 1 variable... Or am I missing something
here.

Do you have an example? 



-Original Message-
From: Ted Wolfley [mailto:t...@ogdengroup.com] 
Sent: Monday, March 01, 2010 10:13 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Multiple Sorts


I found it better and faster to do the sort after the results are returned
in the Results Action.  Use a user variable and keep appending  to the
beginning, then use the variable in the sort tag.  Remember to have a way to
clear the sort and the variable

Ted


-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Mon 3/1/2010 7:29 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Multiple Sorts
 
Typically in the past, I load a sort into a variable and then add that
variable as a sort in the search function...
 
I then use an argument to change the sorts...
 
<@IFEQUAL <@ARG sort> "1"><@ASSIGN sort "company_info.company">/@IF
<@IFEQUAL <@ARG sort> "2"><@ASSIGN sort "company_info.lname">/@IF <@IFEQUAL
<@ARG sort> "3"><@ASSIGN sort "company_info.state">/@IF <@IFEQUAL <@ARG
sort> "4"><@ASSIGN sort "company_info.customer_id">/@IF
 
I've been going around and around on this... is there anyway to hold onto
the sorts so, let's say, they click on Company first, and then click on last
name, they get a sort by lname, company. An thus, if they click next on
State, they get a sort of state, lname, company... and so on. 
 
I'm sure this has comeup before... I just can't find the answer.
 
Thanks!
 
 


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: Multiple Sorts

[WebDude]

Typically in the past, I load a sort into a variable and then add that
variable as a sort in the search function...
 
I then use an argument to change the sorts...
 
<@IFEQUAL <@ARG sort> "1"><@ASSIGN sort "company_info.company">/@IF
<@IFEQUAL <@ARG sort> "2"><@ASSIGN sort "company_info.lname">/@IF
<@IFEQUAL <@ARG sort> "3"><@ASSIGN sort "company_info.state">/@IF
<@IFEQUAL <@ARG sort> "4"><@ASSIGN sort "company_info.customer_id">/@IF
 
I've been going around and around on this... is there anyway to hold onto
the sorts so, let's say, they click on Company first, and then click on last
name, they get a sort by lname, company. An thus, if they click next on
State, they get a sort of state, lname, company... and so on. 
 
I'm sure this has comeup before... I just can't find the answer.
 
Thanks!
 
 


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

RE: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action

[WebDude]

Interesting... Thanks for the link, Ben. 




-Original Message-
From: Ben Johansen [mailto:b...@webspinr.com] 
Sent: Sunday, February 07, 2010 1:22 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the
Mail Action

users, gotta love'm

FYI, (you might know this, but thought i would mention it) you can have
SUBJECT and BCC in the mailto I don't like to just throw up a mail thing
without a subject, they might not mail it right off, (see first statement
;-) I split the email and use first mail as main mailto and subequent as
bcc, actually saves on email server

a
href="mailto:us...@mail.com?bcc=user2@mail.com,us...@mail.com&subject=newlet
ter
  for some company"

you can see all the possibilities here
http://www.ianr.unl.edu/internet/mailto.html

But, the reason it worked as comma separated in mailto was comma is the
standard separator, but in Witango mail action, it is treated as an array,
and that is why you needed the semi-colon, to separate the email addresses,
when witango sends the mail to mail server it will comma separate the
addresses



On Feb 7, 2010, at 9:29 AM, Webdude wrote:

> "You're trying to create a hyperlink, not insert the address in a mail 
> action, ok.
>
> No... I am trying to do both. The links that are displayed in results 
> to the user are hyperlinks when searching on the site. The table is 
> also used for a bulkemail program and newsletter I have set up. Each 
> string (with multiple email addresses) are loaded in one field (stupid 
> I know, but users who felt they needed to add more then one email 
> address added more emails using a comma to seperate them. In other 
> words, I had a field set up to take 150 characters and the users added 
> multiple email addresses in that field).
>
> Look... it's not a big deal. I can replace all the commas with a 
> semicolon in the table. In the newsletter and bulkemail program, I can 
> simply use @replace and can get it to work just fine. I should have 
> been more stringent in what the users were inputting. The probelm is 
> most of the users are from China and and there seems to have been a 
> problem with a translation.
>
> Live and learn, eh?
>
>
> -Original message-
> From: Roland Dumas radu...@mac.com
> Date: Sat,  6 Feb 2010 11:39:13 -0600
> To: witango-talk@witango.com
> Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in 
> the Mail Action
>
>> You're trying to create a hyperlink, not insert the address in a mail 
>> action, ok.
>>
>> You can either create a one-row array with the column delimiter=;   
>> or you can spin your string with an <@ROWS><@COL NUM=X>;
>>
>> On Feb 6, 2010, at 9:32 AM, Webdude wrote:
>>
>>> The reason is simple... most email clients seperate multiple 
>>> addresses by semicolon. If you load a db table with a string of 
>>> emails that are comma delimited, you cannot create a hyperlink that 
>>> will load the emails into the email client automatically. For 
>>> example, a string of emails returned from a table like thus...
>>>
>>> us...@mail1.com,us...@mail2.com,us...@mail3.com
>>>
>>> when usung a hyperlink like this...
>>>
>>> >> href="mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com";>user1@
>>> mail1.com ,us...@mail2.com,us...@mail3.com
>>>
>>> will not work, but it works fine using the Witango email action.
>>>
>>> But when using a string like this...
>>>
>>> us...@mail1.com;us...@mail2.com;us...@mail3.com
>>>
>>> And using a hyperlink like this...
>>>
>>> >> href="mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com";>user1@
>>> mail1.com ,;us...@mail2.com;us...@mail3.com
>>>
>>> Works for the email client, but not the email action in Witango.
>>>
>>>
>>>
>>> -Original message-
>>> From: Ben Johansen b...@webspinr.com
>>> Date: Fri, 5 Feb 2010 15:31:54 -0600
>>> To: witango-talk@witango.com
>>> Subject: Re: Witango-Talk: Changing comma delim to semicolon delim 
>>> in the Mail Action
>>>
>>>
>>> at a loss for why?, but according to RFC 2822 comma is the only 
>>> separator allowed"The destination fields of a message consist of 
>>> three possible fields,  each of the same form: The field name, which 
>>> is either "To", "Cc", or  "Bcc", followed by a comma-separated list 
>>> of one or more addresses "Read more: 
>>> http://www.faqs.org/rfcs/rfc2822.html#ixzz0eh

Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action

[Webdude]

"You're trying to create a hyperlink, not insert the address in a mail action, 
ok.

No... I am trying to do both. The links that are displayed in results to the 
user are hyperlinks when searching on the site. The table is also used for a 
bulkemail program and newsletter I have set up. Each string (with multiple 
email addresses) are loaded in one field (stupid I know, but users who felt 
they needed to add more then one email address added more emails using a comma 
to seperate them. In other words, I had a field set up to take 150 characters 
and the users added multiple email addresses in that field). 

Look... it's not a big deal. I can replace all the commas with a semicolon in 
the table. In the newsletter and bulkemail program, I can simply use @replace 
and can get it to work just fine. I should have been more stringent in what the 
users were inputting. The probelm is most of the users are from China and and 
there seems to have been a problem with a translation.

Live and learn, eh? 


-Original message-
From: Roland Dumas radu...@mac.com
Date: Sat,  6 Feb 2010 11:39:13 -0600
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail
 Action

> You're trying to create a hyperlink, not insert the address in a mail action, 
> ok.
> 
> You can either create a one-row array with the column delimiter=;  or you can 
> spin your string with an <@ROWS><@COL NUM=X>;
> 
> On Feb 6, 2010, at 9:32 AM, Webdude wrote:
> 
> > The reason is simple... most email clients seperate multiple addresses by 
> > semicolon. If you load a db table with a string of emails that are comma 
> > delimited, you cannot create a hyperlink that will load the emails into the 
> > email client automatically. For example, a string of emails returned from a 
> > table like thus...
> > 
> > us...@mail1.com,us...@mail2.com,us...@mail3.com
> > 
> > when usung a hyperlink like this...
> > 
> >  > href="mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com";>us...@mail1.com,us...@mail2.com,us...@mail3.com
> > 
> > will not work, but it works fine using the Witango email action. 
> > 
> > But when using a string like this...
> > 
> > us...@mail1.com;us...@mail2.com;us...@mail3.com
> > 
> > And using a hyperlink like this...
> > 
> >  > href="mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com";>us...@mail1.com,;us...@mail2.com;us...@mail3.com
> > 
> > Works for the email client, but not the email action in Witango.
> > 
> > 
> > 
> > -Original message-
> > From: Ben Johansen b...@webspinr.com
> > Date: Fri, 5 Feb 2010 15:31:54 -0600
> > To: witango-talk@witango.com
> > Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the 
> > Mail Action
> > 
> > 
> > at a loss for why?, but according to RFC 2822 comma is the only separator 
> > allowed"The destination fields of a message consist of three possible 
> > fields,
> >   each of the same form: The field name, which is either "To", "Cc", or
> >   "Bcc", followed by a comma-separated list of one or more addresses
> > "Read more: http://www.faqs.org/rfcs/rfc2822.html#ixzz0ehQZoxaH
> > On Feb 5, 2010, at 8:35 AM, WebDude wrote:
> > Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. 
> > in the Mail Action.  I know I can do a replace character... Thanks!   
> > 
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> > 
> > Ben Johansenhttp://www.webspinr.comb...@webspinr.comphone: 
> > 360-597-3372Mobile: 360-600-7775
> > 
> > 
> > 
> > 
> > 
> > 
> > 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: Changing comma delim to semicolon delim in the Mail Action

[Webdude]

The reason is simple... most email clients seperate multiple addresses by 
semicolon. If you load a db table with a string of emails that are comma 
delimited, you cannot create a hyperlink that will load the emails into the 
email client automatically. For example, a string of emails returned from a 
table like thus...

us...@mail1.com,us...@mail2.com,us...@mail3.com

when usung a hyperlink like this...

mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com";>us...@mail1.com,us...@mail2.com,us...@mail3.com

will not work, but it works fine using the Witango email action. 

But when using a string like this...

us...@mail1.com;us...@mail2.com;us...@mail3.com

And using a hyperlink like this...

mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com";>us...@mail1.com,;us...@mail2.com;us...@mail3.com

Works for the email client, but not the email action in Witango.



-Original message-
From: Ben Johansen b...@webspinr.com
Date: Fri, 5 Feb 2010 15:31:54 -0600
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail 
Action


at a loss for why?, but according to RFC 2822 comma is the only separator 
allowed"The destination fields of a message consist of three possible fields,
   each of the same form: The field name, which is either "To", "Cc", or
   "Bcc", followed by a comma-separated list of one or more addresses
"Read more: http://www.faqs.org/rfcs/rfc2822.html#ixzz0ehQZoxaH
On Feb 5, 2010, at 8:35 AM, WebDude wrote:
Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. in 
the Mail Action.  I know I can do a replace character... Thanks!   

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

Ben Johansenhttp://www.webspinr.comb...@webspinr.comphone: 360-597-3372Mobile: 
360-600-7775






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


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

Witango-Talk: Changing comma delim to semicolon delim in the Mail Action

[WebDude]

Is this possible? I mean, when adding multiple emails in the To:, CC:, etc.
in the Mail Action. 
 
I know I can do a replace character...
 
Thanks!
 
 
 


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

RE: Witango-Talk: Calendar

[WebDude]

http://myfishingpals.com/minnesota-fishing-buddy-up.taf?function=month&calda
te=01/08/2010 



-Original Message-
From: William Conlon [mailto:b...@tothept.com] 
Sent: Friday, January 08, 2010 12:29 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Calendar

I don't think I released this to the public, since it has the To the Point
copyright embedded in it [see:
http://www.tothept.com/software/cal/calendar.taf?_function=readme
]

contact me directly.

On Jan 7, 2010, at 12:45 PM, Roland Dumas wrote:

> I'm in need of a calendar taf
> Does this or any other exist as a shared app?
>
>
> On Apr 25, 2006, at 10:03 AM, William M Conlon wrote:
>
>> http://www3.tothept.com/examples/calendar.taf
>>
>> I was planning on contributing this, probably under the GNU license, 
>> on sourceforge.
>>
>> bill
>> On Apr 25, 2006, at 7:46 AM, Rick Sanders wrote:
>>
>>>
>>>
>>> Hello list,
>>>
>>>
>>>
>>> I'm just wondering if anyone has created a calendar in WiTango.  
>>> I'm doing an events calendar for a client. I can program it myself, 
>>> but it's much easier if someone has one to share.
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>> 
>>>
>>> Rick Sanders
>>> President
>>> 902-401-7689
>>> www.webenergy-sw.com
>>>
>>> 
>>>   TO UNSUBSCRIBE: Go to 
>>> http://www.witango.com/developer/maillist.taf
>>
>> Bill
>>
>> William M. Conlon, P.E., Ph.D.
>> To the Point
>> 345 California Avenue Suite 2
>> Palo Alto, CA 94306
>> vox:  650.327.2175 (direct)
>> fax:  650.329.8335
>> mobile:  650.906.9929
>> e-mail:  mailto:b...@tothept.com
>> 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

RE: Witango-Talk: Deleting empty Rows in Array

[WebDude]

Okay, the problem is I need blanks in the middle. In other words, if I
have...
 
1; 2; 3; 4; ; 5; 6; ; ; ; 
 
I would need the array to end up like this...
1; 2; 3; 4; ; 5; 6; 
 
???
 
 
 <http://cipromo.com/> 
 

  _  

From: Ben Johansen [mailto:b...@webspinr.com] 
Sent: Wednesday, December 30, 2009 3:25 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Deleting empty Rows in Array


you may be able to use tokenize on your string 


1 ;2 ;3 ;4 ;5 ; ; ; ; ; 


<@TOKENIZE VALUE="1 ;2 ;3 ;4 ;5 ; ; ;" CHARS=";" NULLTOKENS="false">

NULLTOKENS are when you have a blank cell as a result of the tokenize.
for example if you tokenize "one,two,,four" on comma: 
if you have NULLTOKENS = true then the resulting array will have 4 elements
with the 3rd being empty
if you have NULLTOKENS = false then the resulting array will have 3
elements, skipping the 3rd


you can use the NULLTOKENS to deal with the empty spots, so that filter will
not break


Ben

On Dec 30, 2009, at 6:13 AM, WebDude wrote:


Hi Folks,

I have another one I have been working on and I am having a devil of a time
trying to get either <@filter> or any type of filtering on text strings to
work correctly. I would appreciate any help.

I have an app that let's you copy and paste text from an XLS file into a
 field. I then take the text and bust it out into columns and rows
and populate  fields and then loop through an insert
routine. It works well, but I am trying to delete rows that have no values.
The reason for no values is from multiple returns from the user without
text, or when I present the text back into the  for editing after
the  fields have been edited. I am doing something like
this (using just 1 column for simplicity sake)...

>From the ...
<@ASSIGN text11 "<@REPLACE STR='<@ARG text1>' FINDSTR='<@CHAR 10>'
REPLACESTR=';'>">
<@ASSIGN text11 "<@REPLACE STR='<@VAR text11>' FINDSTR='<@CHAR 9>'
REPLACESTR=','>">


I the assign the results to an array... 


<@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> 
<@ASSIGN NAME="array1" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>"> 
<@ASSIGN column1<@CURROW> "<@VAR NAME='array1[<@CURROW>,1]'>">



The array1 will look something like this when done using <@VAR array1
APrefix='' ASuffix='' RPrefix='' RSuffix=';' CPrefix='' CSuffix=''>...

1 ;2 ;3 ;4 ;5 ;

But sometimes, when a user inputs incorrectly or goes back and edits values,
I may end up with an array that looks like this...

1 ;2 ;3 ;4 ;5 ; ; ; ; ; 

What I am trying to do is filter out the empty rows at the end - (; ; ;)

Now when I use <@FILTER> I am totally confused. I can't seem to get it to
work at all. Even a simple filter that I know should work. Examples...

<@FILTER ARRAY="array1" SCOPE="local" EXPR="#1=1"> 
I get...
An Array was expected as a parameter

OR

<@FILTER ARRAY="<@VAR array1>" SCOPE="local" EXPR="#1=1">
I get...
Error during expression evaluation.  
Illegal symbol in statement ["<@__REF name=array1
userref=...@3605a6082eac17134b3b591b>
[1,1]=1]

BUT

<@FILTER ARRAY="<@VAR array1>" SCOPE="local" EXPR=""> does not throw an
error, but I am filtering nothing.

I also tried to use any type of string manipluation to get rid of the empty
rows but using anything like 
<@CHAR 10>; or just " ;" does not seem to work either. 

Any insight would be greatly appreciated.

Thanks! 

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





Ben Johansen
http://www.webspinr.com
b...@webspinr.com
Phone: 360-597-3372
Mobile: 360-600-7775





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


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

Witango-Talk: Deleting empty Rows in Array

[WebDude]

Hi Folks,
 
I have another one I have been working on and I am having a devil of a time
trying to get either <@filter> or any type of filtering on text strings to
work correctly. I would appreciate any help.
 
I have an app that let's you copy and paste text from an XLS file into a
 field. I then take the text and bust it out into columns and rows
and populate  fields and then loop through an insert
routine. It works well, but I am trying to delete rows that have no values.
The reason for no values is from multiple returns from the user without
text, or when I present the text back into the  for editing after
the  fields have been edited. I am doing something like
this (using just 1 column for simplicity sake)...
 
>From the ...
<@ASSIGN text11 "<@REPLACE STR='<@ARG text1>' FINDSTR='<@CHAR 10>'
REPLACESTR=';'>">
<@ASSIGN text11 "<@REPLACE STR='<@VAR text11>' FINDSTR='<@CHAR 9>'
REPLACESTR=','>">


I the assign the results to an array... 


<@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> 
<@ASSIGN NAME="array1" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>"> 
<@ASSIGN column1<@CURROW> "<@VAR NAME='array1[<@CURROW>,1]'>">



The array1 will look something like this when done using <@VAR array1
APrefix='' ASuffix='' RPrefix='' RSuffix=';' CPrefix='' CSuffix=''>...

1 ;2 ;3 ;4 ;5 ;

But sometimes, when a user inputs incorrectly or goes back and edits values,
I may end up with an array that looks like this...

1 ;2 ;3 ;4 ;5 ; ; ; ; ; 

What I am trying to do is filter out the empty rows at the end - (; ; ;)

Now when I use <@FILTER> I am totally confused. I can't seem to get it to
work at all. Even a simple filter that I know should work. Examples...

<@FILTER ARRAY="array1" SCOPE="local" EXPR="#1=1"> 
I get...
An Array was expected as a parameter

OR

<@FILTER ARRAY="<@VAR array1>" SCOPE="local" EXPR="#1=1">
I get...
Error during expression evaluation.  
 Illegal symbol in statement ["<@__REF name=array1
userref=...@3605a6082eac17134b3b591b>
[1,1]=1]

BUT

<@FILTER ARRAY="<@VAR array1>" SCOPE="local" EXPR=""> does not throw an
error, but I am filtering nothing.

I also tried to use any type of string manipluation to get rid of the empty
rows but using anything like 
<@CHAR 10>; or just " ;" does not seem to work either. 

Any insight would be greatly appreciated.

Thanks! 

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

Re: Witango-Talk: [Off Topic] happy holidays

[Webdude]

Same to you, Ben and all!


-Original message-
From: Ben Johansen b...@webspinr.com
Date: Thu, 24 Dec 2009 15:06:30 -0600
To: witango-talk@witango.com
Subject: Witango-Talk: [Off Topic] happy holidays


> I Hope all have a happy holiday season

> 

> Thanks for all the support of the years

> 

> Ben Johansen

> http://www.webspinr.com

> b...@webspinr.com

> Phone: 360-597-3372

> Mobile: 360-600-7775

> 

> 

> 

> 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 and Left

[WebDude]

Mmmm... Still doesn't work. I cut and pasted directly into a taf file. 
 
Witango 2000? Could that be a problem?
 
Maybe that's why I am having these problems.
 

  _  

From: Bill Downall [mailto:bdown...@downallconsulting.com] 
Sent: Monday, December 21, 2009 12:14 PM
To: witango-talk
Subject: Re: Witango-Talk: Array and Left



On Mon, Dec 21, 2009 at 1:08 PM, WebDude  wrote:
> Could you give me an example?

Your code shown, with my addition in bold blue highlighted:

<@ASSIGN NAME="initValue" VALUE="123456789,123456789,123456789">

<@ASSIGN NAME="array3" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>">


<@rows array='array3'>
<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array3[<@CURROW>,1]>"
NUMCHARS="3">'>


<@ROWS ARRAY="<@VAR array3>">
<@VAR array3[<@CURROW>,1]>

or


<@VAR array3[1,1]>

> -Original Message-
> From: Bill Downall [mailto:bdown...@downallconsulting.com]
> Sent: Monday, December 21, 2009 11:04 AM
> To: witango-talk
> Subject: Re: Witango-Talk: Array and Left
>
> WebDude,
>
> Put an <@ROWS array='array3'> pair of tags around your assign promoid
> statement.
>
> Bill
>
> On Mon, Dec 21, 2009 at 12:02 PM, WebDude  wrote:
>> Mmmm... Interesting. I cannot get it to work. Full code...
>>
>>
>> <@ASSIGN NAME="initValue" VALUE="123456789,123456789,123456789">
>>
>> <@ASSIGN NAME="array3" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
>> RDELIM=';'>">
>>
>> <@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array3[<@CURROW>,1]>"
>> NUMCHARS="3">'>
>>
>>
>> <@ROWS ARRAY="<@VAR array3>">
>> <@VAR array3[<@CURROW>,1]>
>> 
>> or
>> 
>>
>> <@VAR array3[1,1]>
>>
>>
>>
>> -Original Message-
>> From: Robert Shubert [mailto:rshub...@tronics.com]
>> Sent: Monday, December 21, 2009 10:02 AM
>> To: witango-talk@witango.com
>> Subject: RE: Witango-Talk: Array and Left
>>
>> It 100% does work in that situation - there must be something else off.
>>
>> -Original Message-
>> From: WebDude [mailto:webd...@cipromo.com]
>> Sent: Monday, December 21, 2009 10:36 AM
>> To: witango-talk@witango.com
>> Subject: RE: Witango-Talk: Array and Left
>>
>> Like I said, I can use left in the input file like thus...
>>
>> > value="<@LEFT STR="<@VAR array2[<@CURROW>,1]>" NUMCHARS="3">">
>>
>> I was wondering if there was a way to use @left when creating the array.
>> Something like this...
>>
>> <@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
>> NUMCHARS="3">'>
>>
>>
>> It doesn't seem to work on the @assign.
>>
>>
>>
>> -Original Message-
>> From: Robert Shubert [mailto:rshub...@tronics.com]
>> Sent: Monday, December 21, 2009 9:15 AM
>> To: witango-talk@witango.com
>> Subject: RE: Witango-Talk: Array and Left
>>
>> I can confirm that little quick in HTML about over-populating a text
>> input with a maxlength. It's always been the way it's worked for some
> reason.
>>
>> As for your code, that looks fine and should work, assuming you are
>> executing inside a @ROWS or @FOR block so that the @CURROW evaluates.
>>
>> I @LEFT and @RIGHT things all the time without issue.
>>
>> Robert
>>
>> -Original Message-
>> From: WebDude [mailto:webd...@cipromo.com]
>> Sent: Monday, December 21, 2009 9:52 AM
>> To: witango-talk@witango.com
>> Subject: Witango-Talk: Array and Left
>>
>> I am having a bit of a problem. I noticed that when I create a
>> variable and load that variable into an HTML text form input, the
>> MAXLENGTH attribute is ignored. It seems that if you set the input
>> field to MAXLENGTH=5, you cannot type more then 5 characters into the
>> field, however, when loading a variable into the field, the MAXLENGTH is
> ignored. M...
>>
>> The values I am loading into the input form are from an array. Seems
>> it would be simple enough, but I cannot seem to get it to work.
>> Currently, I have something like this (using just on column for clarity
> sake).
>>
>> <@ASSIGN NAME="initValue&quo

RE: Witango-Talk: Array and Left

[WebDude]

Could you give me an example? 




-Original Message-
From: Bill Downall [mailto:bdown...@downallconsulting.com] 
Sent: Monday, December 21, 2009 11:04 AM
To: witango-talk
Subject: Re: Witango-Talk: Array and Left

WebDude,

Put an <@ROWS array='array3'> pair of tags around your assign promoid
statement.

Bill

On Mon, Dec 21, 2009 at 12:02 PM, WebDude  wrote:
> Mmmm... Interesting. I cannot get it to work. Full code...
>
>
> <@ASSIGN NAME="initValue" VALUE="123456789,123456789,123456789">
>
> <@ASSIGN NAME="array3" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
> RDELIM=';'>">
>
> <@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array3[<@CURROW>,1]>"
> NUMCHARS="3">'>
>
>
> <@ROWS ARRAY="<@VAR array3>">
> <@VAR array3[<@CURROW>,1]>
> 
> or
> 
>
> <@VAR array3[1,1]>
>
>
>
> -Original Message-
> From: Robert Shubert [mailto:rshub...@tronics.com]
> Sent: Monday, December 21, 2009 10:02 AM
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Array and Left
>
> It 100% does work in that situation - there must be something else off.
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Monday, December 21, 2009 10:36 AM
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Array and Left
>
> Like I said, I can use left in the input file like thus...
>
>  value="<@LEFT STR="<@VAR array2[<@CURROW>,1]>" NUMCHARS="3">">
>
> I was wondering if there was a way to use @left when creating the array.
> Something like this...
>
> <@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
> NUMCHARS="3">'>
>
>
> It doesn't seem to work on the @assign.
>
>
>
> -Original Message-
> From: Robert Shubert [mailto:rshub...@tronics.com]
> Sent: Monday, December 21, 2009 9:15 AM
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Array and Left
>
> I can confirm that little quick in HTML about over-populating a text 
> input with a maxlength. It's always been the way it's worked for some
reason.
>
> As for your code, that looks fine and should work, assuming you are 
> executing inside a @ROWS or @FOR block so that the @CURROW evaluates.
>
> I @LEFT and @RIGHT things all the time without issue.
>
> Robert
>
> -Original Message-
> From: WebDude [mailto:webd...@cipromo.com]
> Sent: Monday, December 21, 2009 9:52 AM
> To: witango-talk@witango.com
> Subject: Witango-Talk: Array and Left
>
> I am having a bit of a problem. I noticed that when I create a 
> variable and load that variable into an HTML text form input, the 
> MAXLENGTH attribute is ignored. It seems that if you set the input 
> field to MAXLENGTH=5, you cannot type more then 5 characters into the 
> field, however, when loading a variable into the field, the MAXLENGTH is
ignored. M...
>
> The values I am loading into the input form are from an array. Seems 
> it would be simple enough, but I cannot seem to get it to work. 
> Currently, I have something like this (using just on column for clarity
sake).
>
> <@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> <@ASSIGN NAME="array2"
> VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
> RDELIM=';'>">
> <@ASSIGN promoid<@CURROW> '<@VAR array2[<@CURROW>,1]>'>
>
> I tried changing the promoid to
>
> <@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
> NUMCHARS="3">'>
>
> But I get no love. Am I missing something here? I just want to be able 
> to limit the number of characters to 3. Yes, I can use this on the 
> form page, but was interested in a more elegant way of doing this.
>
> Thanks!
>
> __
> __ 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

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

RE: Witango-Talk: Array and Left

[WebDude]

Mmmm... Interesting. I cannot get it to work. Full code...


<@ASSIGN NAME="initValue" VALUE="123456789,123456789,123456789"> 

<@ASSIGN NAME="array3" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>"> 

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array3[<@CURROW>,1]>"
NUMCHARS="3">'>


<@ROWS ARRAY="<@VAR array3>">
<@VAR array3[<@CURROW>,1]>

or


<@VAR array3[1,1]> 



-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Monday, December 21, 2009 10:02 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left

It 100% does work in that situation - there must be something else off.

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, December 21, 2009 10:36 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left

Like I said, I can use left in the input file like thus...

,1]>" NUMCHARS="3">">

I was wondering if there was a way to use @left when creating the array.
Something like this...

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
NUMCHARS="3">'>  


It doesn't seem to work on the @assign.



-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, December 21, 2009 9:15 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left

I can confirm that little quick in HTML about over-populating a text input
with a maxlength. It's always been the way it's worked for some reason.

As for your code, that looks fine and should work, assuming you are
executing inside a @ROWS or @FOR block so that the @CURROW evaluates.

I @LEFT and @RIGHT things all the time without issue. 

Robert

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, December 21, 2009 9:52 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Array and Left

I am having a bit of a problem. I noticed that when I create a variable and
load that variable into an HTML text form input, the MAXLENGTH attribute is
ignored. It seems that if you set the input field to MAXLENGTH=5, you cannot
type more then 5 characters into the field, however, when loading a variable
into the field, the MAXLENGTH is ignored. M...

The values I am loading into the input form are from an array. Seems it
would be simple enough, but I cannot seem to get it to work. Currently, I
have something like this (using just on column for clarity sake).

<@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> <@ASSIGN NAME="array2"
VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>">
<@ASSIGN promoid<@CURROW> '<@VAR array2[<@CURROW>,1]>'>

I tried changing the promoid to

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
NUMCHARS="3">'>

But I get no love. Am I missing something here? I just want to be able to
limit the number of characters to 3. Yes, I can use this on the form page,
but was interested in a more elegant way of doing this.

Thanks!
 

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: Array and Left

[WebDude]

Like I said, I can use left in the input file like thus...

,1]>" NUMCHARS="3">">

I was wondering if there was a way to use @left when creating the array.
Something like this...

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
NUMCHARS="3">'>  


It doesn't seem to work on the @assign.



-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Monday, December 21, 2009 9:15 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left

I can confirm that little quick in HTML about over-populating a text input
with a maxlength. It's always been the way it's worked for some reason.

As for your code, that looks fine and should work, assuming you are
executing inside a @ROWS or @FOR block so that the @CURROW evaluates.

I @LEFT and @RIGHT things all the time without issue. 

Robert

-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, December 21, 2009 9:52 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Array and Left

I am having a bit of a problem. I noticed that when I create a variable and
load that variable into an HTML text form input, the MAXLENGTH attribute is
ignored. It seems that if you set the input field to MAXLENGTH=5, you cannot
type more then 5 characters into the field, however, when loading a variable
into the field, the MAXLENGTH is ignored. M...

The values I am loading into the input form are from an array. Seems it
would be simple enough, but I cannot seem to get it to work. Currently, I
have something like this (using just on column for clarity sake).

<@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> <@ASSIGN NAME="array2"
VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>">
<@ASSIGN promoid<@CURROW> '<@VAR array2[<@CURROW>,1]>'>

I tried changing the promoid to

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
NUMCHARS="3">'>

But I get no love. Am I missing something here? I just want to be able to
limit the number of characters to 3. Yes, I can use this on the form page,
but was interested in a more elegant way of doing this.

Thanks!
 

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: Array and Left

[WebDude]

I am having a bit of a problem. I noticed that when I create a variable and
load that variable into an HTML text form input, the MAXLENGTH attribute is
ignored. It seems that if you set the input field to MAXLENGTH=5, you cannot
type more then 5 characters into the field, however, when loading a variable
into the field, the MAXLENGTH is ignored. M...

The values I am loading into the input form are from an array. Seems it
would be simple enough, but I cannot seem to get it to work. Currently, I
have something like this (using just on column for clarity sake).

<@ASSIGN NAME="initValue" VALUE="<@VAR text11>"> 
<@ASSIGN NAME="array2" VALUE="<@ARRAY VALUE=@@initValue CDELIM=','
RDELIM=';'>"> 
<@ASSIGN promoid<@CURROW> '<@VAR array2[<@CURROW>,1]>'>

I tried changing the promoid to

<@ASSIGN promoid<@CURROW> '<@LEFT STR="<@VAR array2[<@CURROW>,1]>"
NUMCHARS="3">'>

But I get no love. Am I missing something here? I just want to be able to
limit the number of characters to 3. Yes, I can use this on the form page,
but was interested in a more elegant way of doing this.

Thanks!
 

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

RE: Witango-Talk: Witango 6 Update

[WebDude]

Well... Don't die over the product, Phil... It's not worth it. 

I am still patiently waiting. I am still using Witango and I still live by
the product. Also, I have never been so busy, as of late. If you ever need
any endorsements for your product, I would be willing to do that for you. I
have been working on apps for Target, Blue Cross, Dairy Queen, Assurant
Health, Honeywell, US Health, and a host of smaller companies. Since the
economy went South, companies looking for rapid development are looking more
diligently at costs. The fact that I can bid at 20% or less then most other
developers gives me a distinct advantage. I have come to realize that most
of the corporate world could care less what platform/software you use...
They just want results, stability and redundency. If you can give them that,
who cares what I use.


 

-Original Message-
From: Phil Wade [mailto:p...@witango.com] 
Sent: Wednesday, September 23, 2009 7:27 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango 6 Update

You can cross of Scenarios 1 to 3.  Scenario 4 is is close to the mark.
Scenario 5, still not sure about this one.  Jury is still out on whether
Witango will be the death of me!


To those still using Witango and wanting to, As I have admitted previously I
do not live a public life, I am not a communicator, marketer or PR guru, I
am just the guy that is in the background getting on with what I need to get
done.  Witango has not been shelved.  Admittedly it is has not been on a
fast track but it is still alive.  Yes, it is still a niche product and will
continue to be.  It is still part of our business model and we are still
providing licensing and support for version 5.5 to those that require it and
we will continue to do so while there is a demand for it right down to the
very last user.

Witango 6 will be available to those that still want to use it.  With the
latest OS X Java update we now have a fully functioning dev studio that is
able to replace the old carbon Mac studio.


...


To Robert G,
What you do and whether you listening to your peers is entirely up to you.
It is your decision and I am sure you will balance the pros and cons of your
actions.

Personally I have never been judged so often and harshly by someone who does
not know me, have any contact with me, have any understanding of me,
understanding of the way I lead my life or run my business, what motivates
me personally or professionally or knows what is going on in my private
life.  May I offer you some wisdom - a long time ago I learnt not to make
judgements without compassion and to never judge  
someone's actions until I knew what there motives or situation was.   
This wisdom has served me well time and time again.

You have told us all on several occasions that you are moving on to the PHP
community so if there is nothing positive keeping you here please move on
with your professional life.  I am sure there are many more positive things
you can dedicate your time and energy to there than beating up on Witango/Me
here.



Regards


Phil


On 23/09/2009, at 9:51 PM, WebDude wrote:

> Scenario 1 - Phil is letting the product die... Perhaps we could group 
> together and purchase the code and then we could have truly Open 
> Source Licensing and rework the code ourselves.
>
> Scenario 2 - Phil is in over his head and is trying to find someone to 
> purchase the product to pick up where he left off.
>
> Scenario 3 - Phil wants to claim bankruptcy and the only way he can is 
> by showing massive losses on the product (not sure if this is feasible 
> in Australia).
>
> Scenario 4 - Phil is still wrangling through the legal process and got 
> fed up with all the negativity on this list.
>
> Scenario 5 - Phil is dead.

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 6 Update

[WebDude]

Scenario 1 - Phil is letting the product die... Perhaps we could group
together and purchase the code and then we could have truly Open Source
Licensing and rework the code ourselves.

Scenario 2 - Phil is in over his head and is trying to find someone to
purchase the product to pick up where he left off.

Scenario 3 - Phil wants to claim bankruptcy and the only way he can is by
showing massive losses on the product (not sure if this is feasible in
Australia).

Scenario 4 - Phil is still wrangling through the legal process and got fed
up with all the negativity on this list. 

Scenario 5 - Phil is dead. 




-Original Message-
From: Robert Garcia [mailto:wita...@bighead.net] 
Sent: Tuesday, September 22, 2009 6:11 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango 6 Update

I really never liked the fact that they used the term "Open Source".  
If you look back at the updates from phil, it was not going to be open
source. It was still paid software, where if you agreed to the restrictions,
you could download the source and modify it yourself and then submit back to
witango. So it still costs money, you still pay for it, but you can modify
the code, and if they like it, they own the modification and then sell it to
others. So its not Open Source. Its a way for them to try to have unpaid
developers.

 From Phil

New Licensing
-
Once the beta testing has been completed and version 6 goes into release,
the source code for both the server and studio will be open sourced under
its own license.  Witango will continue to be a commercial product and a
license will need to be purchased. There will be 3 editions of the Server:

The Lite edition - no change to current license conditions The Developer
edition - no change to current license conditions.
The Professional edition - single machine license, with no limitation on
number of processes or CPUs.

-- 

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
rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ -
http://eventpix.com/

On Sep 22, 2009, at 2:44 PM, Michael Heth wrote:

>
> On Sep 22, 2009, at 2:27 PM, Stefan Gonick wrote:
>
>> My guess is that they stopped working on replacing the licensed code 
>> so that the situation hasn't changed much since the last message.
>
>
> So they could figure out what the cost per license is for the licensed 
> code, and charge that amount plus 10% forward it on to the licensor 
> and be done. Not open source but last official release never to be 
> updated. If it was reasonable and ran on our current systems it would 
> be worth paying some money for. I keep a last version Titanium 
> Powerbook around just to run old OS9 software that doesn't like 
> classic.
>
> The above would cure all the issues except for support which they 
> could charge for or someone on this list could charge for.
>
> Thanks,
>
> M./
>
> Michael Heth
> tangopo...@serversmiths.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

RE: Witango-Talk: License Keys

[WebDude]

Perhaps there is an occassional sale that comes in, once a month or so and
With doesn't want to kill it.

I know... I know... That would be a really nasty thing to do... But could
there any other reason? I can't find any. Has anyone tried purchasing a
license lately? Now that would be interesting.

Hey... I just had a thought Maybe there is a a whole new Witango, forum,
support, etc. out there and we don't even know it! Could we be on the wrong
mailing list Mmmm?

-Original Message-
From: Scott Cadillac [mailto:sc...@xmlx.net] 
Sent: Tuesday, September 22, 2009 2:39 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: License Keys

Lawn mowers don't come with non-transferable license agreements Robert. This
is a poor analogy.

And no, I'm not making a big deal of this because Phil is ignoring his
user-base - you are.

I'm making a big deal of this because your words and intended actions are
wrong.

Scott,





On Sep-22-2009, at 4:22 PM, Robert Garcia wrote:

> I agree that by this time, if you had not had a backup plan, or other 
> arrangements, it would be poor planning on your end. I don't mean it 
> as a threat, even if phil asked me on list or privately to not send 
> the keys out, although the product IS dead, I wouldn't do it. If he 
> said, no comment on anything, but don't send the keys out, I wouldn't 
> do it. Its like if someone loans you their lawn mower.
> You don't need it anymore and another guy asks for it. I am attempting 
> to get permission from first guy, but he moved away, left no 
> forwarding address. So I post a note in the paper and give him a week. 
> If no answer, I assume he is gone and doesn't care so I let the second 
> guy, who could really use it take the lawn mower.
>
> I think the only reason you or anyone else think this could be a big 
> issue, is because you can actually imagine a scenario where Phil 
> (witango inc) is still around, but would purposely and actively ignore 
> his user base for a LONG period of time. Which is sad. Anyone else, 
> you would assume they left and its over.
>
> --
>
> 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 rgar...@bighead.net - 
> rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/
>
> On Sep 22, 2009, at 10:41 AM, Scott Cadillac wrote:
>
>> You're right on the money Mark,
>>
>> Another way to put it is "two wrongs don't make a right", or "you 
>> can't fight fire with fire".
>>
>> The fact that support for Witango has been reduced to the 
>> unprofessional situation it is, doesn't mean we should continue to 
>> perpetuate more unprofessional conduct, such as what has been 
>> circulating on this list for so many years, as well as recently.
>>
>>
>> And for those others who still subscribe to this List; Pervasive  
>> dumped Tango flat-out 9 years ago, with nary a buyer in sight, the  
>> product was worthless in their view. If that wasn't a clear enough  
>> indicator that it was time to switch platforms, I don't know what is.
>>
>> Then the next year along comes this individual that few if any had  
>> heard of, with some small business sense and only a big heart to  
>> back him up - will this one guy solve our problems? Many "hoped"  
>> so. But is "hope" good enough to continue banking our livings on?  
>> From this point, if anybody continued to invest in Witango - you  
>> did so at your own risk.
>>
>> The writing has been on the wall for 9 years - 9 YEARS [one more  
>> and it'll be 10!], so if people feel they have been burned by  
>> Phil... well, that's what happens when you can't stop yourself from  
>> gambling. Eventually you lose.
>>
>> As for who started the unprofessional death-spiral, I think fingers  
>> can be pointed in a lot of directions that don't necessarily take  
>> you down-under.
>>
>> I haven't had personal correspondence with Phil or Sophie in over 3  
>> or 4 years I think, so I have no idea what they're up to, but I  
>> don't blame them one bit for not answering the threats or insults  
>> that come from some people on this List.
>>
>> Scott,
>>
>>
>>
>>
>>
>> On Sep-22-2009, at 12:48 PM, Mark Weiss wrote:
>>
>>> Scott,
>>>
>>> As much respect as I have for Robert, and I do, he isn't perfect  
>>> as we all know. We aren't either. Reminds me of a story.. Mother  
>>> having a baby. In distress. Country doctor can't be found. He  
>>> finally shows up, sees the situation acts quickly and it seems  
>>> everything was resolved. A few days later, the mother died of the  
>>> disease the doctor was treating at the home prior to arriving to  
>>> deliver the baby. The father became angry and more angry. This  
>>> doctor should have been more careful. He should not be allowed to  
>>> practice. A terrible wrong had been committed and he needed to pay  
>>> for it.
>>>
>>> One day, this man's spiritual leader offered this council. "John,  
>>> le

RE: Witango-Talk: Expired Variables and Forms

[WebDude]

That's what I do on some forms... but imagine a forum where you get a big
textbox to write in your info. If you don't get all the info you want
written within 30 minutes, you're outta luck. I have one forum that lets
users submit a story. Some of the users have been getting half-way through
and then the variables expire and when they post, they lose everything they
have been working on. Now that can be a pain. I just need to hold on to the
user variables while they are on that particular forms page. It isn't a
matter of how many input fields there are, it's how long does it take the
user to fill out a box...
 

  _  

From: Roland Dumas [mailto:radu...@mac.com] 
Sent: Wednesday, July 22, 2009 12:07 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Expired Variables and Forms


how come you don't parse the form into smaller sets of fields and just
accumulate the responses in user scope, and then submit it all at the end? I
had much better user experience by having one question/form and letting the
user tick through the questions with a "you are at 3 of 20" kind of message
with each. 


On Jul 17, 2009, at 12:05 PM, WebDude wrote:


I have always had a problem with long forms and having user info expire
before the forms were filled. I have done long forms in sections with a
submit for every page. I have done timed javascripts that calls a pop-up
after 25 minutes telling the user to save and continue.  Yada Yada Yada. 
 
I am in the middle of putting together a very long form for a client and
decided to try a different approach. I load a taf into an iframe with height
and width attributes set to 1. The taf doesn't return anything, it's just a
header with a meta-refresh every 25 minutes (1500 seconds).
 
Now call me dumb, but this works perfectly, as far as I can tell. I've
tested it on many forms, forums, in-house blogs, etc., and I cannot get it
to break. Every refresh refreshes the variables and holds onto all the user
info. 
 
A really simple solution to what I thought was a vexing problem. I just
updated a bunch of stuff by adding the iframe at the bottom of a bunch of
form pages.
 
I cannot find any drawbacks to this... I hope I am not missing something.
 
 
 


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: Expired Variables and Forms

[WebDude]

I have always had a problem with long forms and having user info expire
before the forms were filled. I have done long forms in sections with a
submit for every page. I have done timed javascripts that calls a pop-up
after 25 minutes telling the user to save and continue.  Yada Yada Yada. 
 
I am in the middle of putting together a very long form for a client and
decided to try a different approach. I load a taf into an iframe with height
and width attributes set to 1. The taf doesn't return anything, it's just a
header with a meta-refresh every 25 minutes (1500 seconds).
 
Now call me dumb, but this works perfectly, as far as I can tell. I've
tested it on many forms, forums, in-house blogs, etc., and I cannot get it
to break. Every refresh refreshes the variables and holds onto all the user
info. 
 
A really simple solution to what I thought was a vexing problem. I just
updated a bunch of stuff by adding the iframe at the bottom of a bunch of
form pages.
 
I cannot find any drawbacks to this... I hope I am not missing something.
 
 
 


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

RE: Witango-Talk: OT... sort of - Topic Notification for Forum

[WebDude]

I was trying to make the mailing taf seemless with the user experience... I
have a bulk email program I use for other clients that sends an email every
.5 seconds (using a redirect and a <@CALC <@ARG start>+1>)... works great
and I was hoping to do the same with the notification. Short of time
stamping the post and seeing if there was a response and running a cron job
to send the notifications, I was thinking of firing off the bulk email when
a post was made. The problem is that a branch or <@URL> takes the user
through the redirects and then back to the post. Very clunky which is why I
was toying with the idea of firing the external bulk email taf during the
post without taking the user there...
 
M... Ben, what (how) do you mean by wrapped in an IF block?
 

  _  

From: Ben Johansen [mailto:b...@webspinr.com] 
Sent: Tuesday, June 30, 2009 3:04 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: OT... sort of - Topic Notification for Forum


ah, maybe an include wrapped in an IF block 

On Jun 30, 2009, at 12:59 PM, WebDude wrote:



Another qustion... may be easy, I don't know...
 
Is there any way to trigger a taf within another taf not using <@URL>
 
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com


 <http://cipromo.com/> http://cipromo.com
 
 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, June 30, 2009 11:23 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum


Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS
feed... the forums already have that, but very few people actually use them.
It seesm they would rather check a box then deal with readers.
 

  _  

From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Tuesday, June 30, 2009 10:28 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum


You need a subscriptions table of sorts: which contains just the member_id
and the master_thread_id

You can add rows when people signup to get a thread emailed and remove them
when they opt-out.

Additional columns that come to mind are:

Primary key ID (not completely necessary for this type of table, but always
helpful)
Active/Inactive flag so that you can turn subscriptions on and off (as
opposed to deleting the row)
Number of emails sent: a counter for how many emails this subscription
created, which would be interesting statistically

Then when a new post comes in for thread #483, you simply look up all the
people that have subscribed to thread #483 and send them an email.

Also (and a little off-topic) you many want to consider adding RSS
capabilities. It solves basically the same thing, but with less traffic.

Robert


  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, June 30, 2009 8:58 AM
To: witango-talk@witango.com
Subject: Witango-Talk: OT... sort of - Topic Notification for Forum

Hey all,

I was wondering if some of you bright bulbs may be able to help me.

I have a forum I built that is 100% Witango. It has close to 8,000 members
and is fairly busy. I have several tables set up for the forum which include
usertable (login, email, password, etc.), forummastertable (table of topics,
threadnum, startdate, views, etc.) and threadtable (individual posts,
masterthreadnum, postdate, user, etc).

This forum is rock solid and has been operating for over 5 years. I have
built many bells and whistles into it and decided it would be nice to add an
opt in email notification. I've seen this on other forums (a checkbox where
you can get an email notification if someone replies to a particular
thread), but I am having trouble trying to figure out just where to start
and how to do this. I don't mean the programming specifically, but more the
theory on how to set this up. I have been looking at other forums but cannot
find any particular clue as to how this is done. Would I set up a table with
the masterthreadnum and email address and when a topic is reponded to, query
that table and send an email? This does not seem like a very efficient way
to do this.

Any ideas would be appreciated.

Thanks!

   WebDude

 <http://myfishingpals.com/> MyFishingPals.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




Ben Johansen
http://www.webspinr.com
b...@we

RE: Witango-Talk: OT... sort of - Topic Notification for Forum

[WebDude]

Another qustion... may be easy, I don't know...
 
Is there any way to trigger a taf within another taf not using <@URL> 
 
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com

 <http://cipromo.com/> http://cipromo.com
 
 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, June 30, 2009 11:23 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum


Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS
feed... the forums already have that, but very few people actually use them.
It seesm they would rather check a box then deal with readers.
 

  _  

From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Tuesday, June 30, 2009 10:28 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum



You need a subscriptions table of sorts: which contains just the member_id
and the master_thread_id

 

You can add rows when people signup to get a thread emailed and remove them
when they opt-out. 

 

Additional columns that come to mind are:

 

Primary key ID (not completely necessary for this type of table, but always
helpful)

Active/Inactive flag so that you can turn subscriptions on and off (as
opposed to deleting the row)

Number of emails sent: a counter for how many emails this subscription
created, which would be interesting statistically

 

Then when a new post comes in for thread #483, you simply look up all the
people that have subscribed to thread #483 and send them an email.

 

Also (and a little off-topic) you many want to consider adding RSS
capabilities. It solves basically the same thing, but with less traffic.

 

Robert

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, June 30, 2009 8:58 AM
To: witango-talk@witango.com
Subject: Witango-Talk: OT... sort of - Topic Notification for Forum

 

Hey all,

 

I was wondering if some of you bright bulbs may be able to help me. 

 

I have a forum I built that is 100% Witango. It has close to 8,000 members
and is fairly busy. I have several tables set up for the forum which include
usertable (login, email, password, etc.), forummastertable (table of topics,
threadnum, startdate, views, etc.) and threadtable (individual posts,
masterthreadnum, postdate, user, etc).

 

This forum is rock solid and has been operating for over 5 years. I have
built many bells and whistles into it and decided it would be nice to add an
opt in email notification. I've seen this on other forums (a checkbox where
you can get an email notification if someone replies to a particular
thread), but I am having trouble trying to figure out just where to start
and how to do this. I don't mean the programming specifically, but more the
theory on how to set this up. I have been looking at other forums but cannot
find any particular clue as to how this is done. Would I set up a table with
the masterthreadnum and email address and when a topic is reponded to, query
that table and send an email? This does not seem like a very efficient way
to do this. 

 

Any ideas would be appreciated.

 

Thanks!

 

   WebDude



 <http://myfishingpals.com/> MyFishingPals.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<><>

RE: Witango-Talk: OT... sort of - Topic Notification for Forum

[WebDude]

Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS
feed... the forums already have that, but very few people actually use them.
It seesm they would rather check a box then deal with readers.
 

  _  

From: Robert Shubert [mailto:rshub...@tronics.com] 
Sent: Tuesday, June 30, 2009 10:28 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum



You need a subscriptions table of sorts: which contains just the member_id
and the master_thread_id

 

You can add rows when people signup to get a thread emailed and remove them
when they opt-out. 

 

Additional columns that come to mind are:

 

Primary key ID (not completely necessary for this type of table, but always
helpful)

Active/Inactive flag so that you can turn subscriptions on and off (as
opposed to deleting the row)

Number of emails sent: a counter for how many emails this subscription
created, which would be interesting statistically

 

Then when a new post comes in for thread #483, you simply look up all the
people that have subscribed to thread #483 and send them an email.

 

Also (and a little off-topic) you many want to consider adding RSS
capabilities. It solves basically the same thing, but with less traffic.

 

Robert

 

  _  

From: WebDude [mailto:webd...@cipromo.com] 
Sent: Tuesday, June 30, 2009 8:58 AM
To: witango-talk@witango.com
Subject: Witango-Talk: OT... sort of - Topic Notification for Forum

 

Hey all,

 

I was wondering if some of you bright bulbs may be able to help me. 

 

I have a forum I built that is 100% Witango. It has close to 8,000 members
and is fairly busy. I have several tables set up for the forum which include
usertable (login, email, password, etc.), forummastertable (table of topics,
threadnum, startdate, views, etc.) and threadtable (individual posts,
masterthreadnum, postdate, user, etc).

 

This forum is rock solid and has been operating for over 5 years. I have
built many bells and whistles into it and decided it would be nice to add an
opt in email notification. I've seen this on other forums (a checkbox where
you can get an email notification if someone replies to a particular
thread), but I am having trouble trying to figure out just where to start
and how to do this. I don't mean the programming specifically, but more the
theory on how to set this up. I have been looking at other forums but cannot
find any particular clue as to how this is done. Would I set up a table with
the masterthreadnum and email address and when a topic is reponded to, query
that table and send an email? This does not seem like a very efficient way
to do this. 

 

Any ideas would be appreciated.

 

Thanks!

 

   WebDude



 <http://myfishingpals.com/> MyFishingPals.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<>

Witango-Talk: OT... sort of - Topic Notification for Forum

[WebDude]

Hey all,
 
I was wondering if some of you bright bulbs may be able to help me. 
 
I have a forum I built that is 100% Witango. It has close to 8,000 members
and is fairly busy. I have several tables set up for the forum which include
usertable (login, email, password, etc.), forummastertable (table of topics,
threadnum, startdate, views, etc.) and threadtable (individual posts,
masterthreadnum, postdate, user, etc).
 
This forum is rock solid and has been operating for over 5 years. I have
built many bells and whistles into it and decided it would be nice to add an
opt in email notification. I've seen this on other forums (a checkbox where
you can get an email notification if someone replies to a particular
thread), but I am having trouble trying to figure out just where to start
and how to do this. I don't mean the programming specifically, but more the
theory on how to set this up. I have been looking at other forums but cannot
find any particular clue as to how this is done. Would I set up a table with
the masterthreadnum and email address and when a topic is reponded to, query
that table and send an email? This does not seem like a very efficient way
to do this. 
 
Any ideas would be appreciated.
 
Thanks!
 
   WebDude

 <http://myfishingpals.com/> MyFishingPals.com
 
 


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

Re: Witango-Talk: Testing: List still up? V6?

[Webdude]

yes... still up...

And waiting...


-Original message-
From: Mikal Anderson mi...@digitalshore.com
Date: Fri,  1 May 2009 21:56:55 -0500
To: witango-talk@witango.com
Subject: Witango-Talk: Testing: List still up?  V6?

> Any news on v6?
> 
> -- 
> Mikal Anderson
> www.LakeOMedia.com
> "What has your website done for you lately?"
> 
> 
> This message, including any attachments, is confidential and intended solely 
> for the person(s) or organization to whom it is addressed.  If you are not 
> the intended recipient, or have received this message by mistake, please 
> notify Mikal Anderson, the original sender, and delete this message from your 
> system. Any unauthorised use, forwarding, or other dissemination of this 
> message, in whole or in part, is strictly prohibited. 
> 
> 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: PDF Form submission

[WebDude]

I have been using ActivePDF and it works well. I use a combination of
Witango and asp to get the job done. I load all data as variables and pass
them to an asp page and then create and stream the data into a pdf. As for
streaming out the data, I am not sure what you mean. If the data is being
changed, you could change the variables and reinsert the data back into the
db. 


John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
[EMAIL PROTECTED]
 
http://cipromo.com
 

-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 17, 2008 7:48 AM
To: witango-talk@witango.com
Subject: Witango-Talk: PDF Form submission

I have a client who has applications set up as PDF forms. We want to be able
to pre=populate these from the database and also write the data back out.
The forms are all set with field ID's and we have a dictionary.

Has anyone done this already? Best tools? Can we use witango?

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

"The love of one's country is a splendid thing. But why should love stop at
the border? "

Pablo Casals




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 6 Update

[WebDude]

Good news, Phil... Thank you! 


WebDude

-Original Message-
From: Phil Wade [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 27, 2008 5:37 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Witango 6 Update

Contrary to the rumours started on the list version 6 is on the way and is
not dead.  The hold up is all legal issues and related to locating and
isolating 3rd part code that has been used in the server under license and
replacing it with open API calls so we can go open source.  This is taking a
lot longer than we thought.

We understand that some developers have out grown the platform and  
have moved on to other platforms, that is their prerogative.   We have  
plans to keep supporting Witango while there are people out there wanting to
use it.  To this end, can I ask that the you take up Robert's offer and move
the porting to PHP discussion to his forum - http://devcom.bighead.net/
  .

And yes we do have a lot of holidays down here minimum of 30 days leave a
year which is 4 weeks statutory leave plus New Years Day, Australia Day,
Anzac Day, Easter Friday and Monday, Queen's Birthday, Labour Day, Melbourne
Cup Day, Christmas and Boxing Day, etc.  Keeps us a happy and family
oriented business.

The Witango portion of our business is running above expectations albeit a
little behind schedule.  Apart from that we are just moving ahead at a
steady pace.


If you have any specific issues or questions contact me off list.


Regards

Phil

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: Open Letter to Phil and Sophie

[WebDude]

Janet,

I feel your pain. I have been busy downloading stuff and poking around. I have 
read hundreds of pages on just the install stuff for Apache, MySQL, PHP, 
ColdFusion, .NET... I even spent a day on nothing but open source. I have a 
spare server I have been thinking of using just to try some stuff out. What is 
really daunting is the pages upon pages and gotchyas on just an installation... 
not to mention the additional downloads needed to make it work in Windows. 
Funny... I have about 60 sites, some getting well more then 100,000 page views 
per day... well over 1,000,000 visitors per month in all - all on one MSSQL 
dedicated server and two dedicated Witango servers runninng Witango 2000. Never 
a slowdown and has been rock solid for over 8 years. 16 e-commerce sites, 2 
Data Access Managements sites, 4 forums, 12 internal employee sites for some 
very large corporations, one very large directory site, 2 online streaming PDF 
sites and a smattering of... well, justwebsites. Now I am losing sleep because 
I am so worried about what direction to go. I spent a very large amount on the 
corporate license thinking that this was the way to go and have spent much time 
and resources in developing all I have going. I never upgraded because of the 
20,000 plus I dished out and I remember the days when it was discussed that the 
editor would be able to output ASP and possibly PHP code... but that never  
happened or was just a pipe dream. Frankly, I thought it would have been a 
great idea to port output of the editor to more popular languages. Anyway... 
enough crying in my beer. I went this route and now I am going to have to do 
something about it. I just spent most of the day trying to install PHP and 
getting the "hello world" to work. Tomorrow, I might try to see if I can 
actually connect to a database. This is going to take me a little while...


-Original message-
From: "janet" [EMAIL PROTECTED]
Date: Thu, 23Oct 2008 15:55:41 -0500
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Open Letter to Phil and Sophie


> I was wondering what to say until I saw this email from Webdude 

> 

> "Well, I have a problem and maybe some of you could help me. I have been

> using nothing but Tango and Witango since I started developing many years

> ago" 

> 

> Yes this is my story also.

> Pretty good at SQL ( MS SQL) triggers, stored procedure, views, groupings

> , maxvalues etc just a happy place for me, also HTML and Witango. I found

> that if I had good array results then the Witango stuff was easy.

> So I have looked at other RAD visual products. With ASP.net you end up with

> blocks of code either in VB or C+, there is s Borland PHP RAD, Cold fusion

> and Dreamweaver etc. But it seems that the builder tools all create either

> PHP, VB, C+ or something.

> How come Witango shielded me from all of these languages?

> I know Witango is an XML code generator so why isn't there any other

> products creating XML? I am asking the wrong question?

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

RE: Witango-Talk: community

[WebDude]

I registered. I am still waiting...

Still in moderation queue to be added to the forum 


webdude

-Original Message-
From: Robert Garcia [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 10:22 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: community

I guess registration is disabled, I will have that resolved today.  
Keep trying.

-- 

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 21, 2008, at 8:12 AM, Robert Garcia wrote:

> I would hate to see the community die. A while ago, a few of us 
> started to build a community that was not list based, but in a 
> searchable forum with a wiki and such. It never went anywhere, because 
> we couldn't agree on if it was a negative thing to witango the 
> company. That seems all moot now. And since this list may go away 
> soon, I thought I would post up.
>
> http://devcom.bighead.net/
>
> This is just on a staging server but provides sections for asking 
> questions on how to port to other languages, and allows us to create 
> how tos in the wiki. Ben was helping moderate this, and there were a 
> few others that were going to take other sections, like the coldfusion 
> section. If everyone moved over there, we can continue the community. 
> Feel free to keep asking witango questions there, I will be there and 
> will answer. Hopefully ben and the others may also want to still help, 
> and we can keep this community going.
>
> If not, thats ok too. But at least we would all be able to freely 
> communicate. I don't want it to be a witango bashing place, I want it 
> to be a place where we move forward. Some staying with witango, some 
> moving to other platforms, but we can all help each other.  So 
> register and start posting. ;-)
>
> Witango would also be welcome to post announcements about v6 if it is 
> still coming out.
>
> --
>
> 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/ 
> __
> __ 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: Open Letter to Phil and Sophie

[WebDude]

If you guys want, I have several forums online. I could easily set up one
for Witango. If this list goes away, it might be a way for us to still
communicate. Up to you...

WebDude

-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 21, 2008 8:23 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Open Letter to Phil and Sophie

I think this is true. I suspect that Adobe may let this language pass on
also over time and tighten integration with PHP.

I notice Web Assist has announced they will no longer be making products for
ASP or Cold Fusion which might be a sign.
--
--
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


 "It is perfectly safe to stand nowhere."

On Oct 20, 2008, at 12:33 PM, Rick Sanders wrote:

> Hey Webdude,
>
> I'd check out Cold Fusion. It's a pretty easy transition from WiTango.
>
> Taf = cfm
> Tcf = cfc
>
> Best of all, you develop in Dreamweaver. The Cold Fusion app server is 
> free for development. Best of all, you can develop on a Mac and use a 
> PC as the CF server.
>
> Rick Sanders
> Webenergy
> Canada: 902-431-7279
> USA:   919-799-9076
> Canada: www.webenergy.ca
> USA:   www.webenergyusa.com
>
> -Original Message-
> From: WebDude [mailto:[EMAIL PROTECTED]
> Sent: October-20-08 12:42 PM
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Open Letter to Phil and Sophie
>
> Hello all,
>
> Well, I have a problem and maybe some of you could help me. I have 
> been using nothing but Tango and Witango since I started developing 
> many years ago. Started on Mac with Butler and eventually moved to 
> Windows.
> Witango is
> all I have ever used and now I am in a quandry. I see the writing is 
> on the wall and though I have resisted for many years, it seems that I 
> am going to have to take the plunge and figure out what to do for what 
> I have that already exists and for the future. The problem is that I 
> am so comfortable with what I have that moving is going to take a lot 
> of effort. I have been going through the different options out there 
> and I am so confused as to editors, parsers, etc. that I really do not 
> know which direction to turn. I have a very small smattering of ASP 
> which I hacked in order to get a site that was moved to our servers to 
> work, but that is the only other language that I even attempted to 
> try. The real crux of the problem is that everything out there looks 
> very confusing and so far removed from what I currently have. I am 
> fairly adept in SQL, Witango, HTML and CSS but I have never taken the 
> time to learn anything new.
>
> I downloaded some PHP editors, some sample ASP stuff, and to tell you 
> the truth, I just don't get a lot of it. Is there anything out there 
> that gives as visual of an interface as Witango? Or maybe is there a 
> specific place you can go to relearn the logic that it will take to 
> use any of the tools available? I think PHP is probably the place to 
> start, but I am totally confused as to how to go about it. I would 
> prefer to continue using IIS as I am very familiar with it along with 
> the security. I went to the PHP site and it seems that there are pages 
> upon pages of just the install for IIS. Or, how about editors? Are 
> there any that you would recommend? Keep in mind my Witango 
> background. I never went to school for any of this stuff and I have 
> some pretty complicated things running on my sites from forums to 
> streaming PDFs, data access management systems to e-commerce.
>
> This is going to be tough, but I need to take it one step at a time...
>
> 
> 
>  PHP Test
> 
> 
> Hello World'; ?>
> 
> 
>
>
> WebDude
> __
> __ 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: Open Letter to Phil and Sophie

[WebDude]

Yes, there are statements in some of the includes, along with variables. Do
variables and statements not work when using includes for PHP? I think it
would be pretty easy to redo some of the includes... or just not use
includes.  


WebDude

-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 20, 2008 11:08 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Open Letter to Phil and Sophie

Web dude. Did you put any statements into includes, or was everything built
by the editor?

For example, the *text*:

<@IF EXPR=""> translates very well to

 (PHP) or

 (Coldfusion)

But the things built by the editor may need to be translated to "text". Some
of this you'll see if you look at the RAW XML created for the .tafs

If you use custom functions, these, of course have to be recreated.

The "logic/flow" should bascially be the same. A login "taf" can be a login
page(s) with the same forms and processing. The SQL queries can be mostly
the same.

The HTML, CSS, and JavaScript are definitely the same!!

Beverly

On 10/20/08 11:42 AM, "WebDude" <[EMAIL PROTECTED]> wrote in whole or in
part:

> Hello all,
> 
> Well, I have a problem and maybe some of you could help me. I have 
> been using nothing but Tango and Witango since I started developing 
> many years ago. Started on Mac with Butler and eventually moved to 
> Windows. Witango is all I have ever used and now I am in a quandry. I 
> see the writing is on the wall and though I have resisted for many 
> years, it seems that I am going to have to take the plunge and figure 
> out what to do for what I have that already exists and for the future. 
> The problem is that I am so comfortable with what I have that moving 
> is going to take a lot of effort. I have been going through the 
> different options out there and I am so confused as to editors, 
> parsers, etc. that I really do not know which direction to turn. I 
> have a very small smattering of ASP which I hacked in order to get a 
> site that was moved to our servers to work, but that is the only other 
> language that I even attempted to try. The real crux of the problem is 
> that everything out there looks very confusing and so far removed from 
> what I currently have. I am fairly adept in SQL, Witango, HTML and CSS but
I have never taken the time to learn anything new.
> 
> I downloaded some PHP editors, some sample ASP stuff, and to tell you 
> the truth, I just don't get a lot of it. Is there anything out there 
> that gives as visual of an interface as Witango? Or maybe is there a 
> specific place you can go to relearn the logic that it will take to 
> use any of the tools available? I think PHP is probably the place to 
> start, but I am totally confused as to how to go about it. I would 
> prefer to continue using IIS as I am very familiar with it along with 
> the security. I went to the PHP site and it seems that there are pages 
> upon pages of just the install for IIS. Or, how about editors? Are 
> there any that you would recommend? Keep in mind my Witango 
> background. I never went to school for any of this stuff and I have 
> some pretty complicated things running on my sites from forums to
streaming PDFs, data access management systems to e-commerce.
> 
> This is going to be tough, but I need to take it one step at a time...
> 
> 
>  
>   PHP Test
>  
>  
>  Hello World'; ?>
>  
> 
> 
> 
> WebDude
> __
> __ 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: Open Letter to Phil and Sophie

[WebDude]

Hello all,

Well, I have a problem and maybe some of you could help me. I have been
using nothing but Tango and Witango since I started developing many years
ago. Started on Mac with Butler and eventually moved to Windows. Witango is
all I have ever used and now I am in a quandry. I see the writing is on the
wall and though I have resisted for many years, it seems that I am going to
have to take the plunge and figure out what to do for what I have that
already exists and for the future. The problem is that I am so comfortable
with what I have that moving is going to take a lot of effort. I have been
going through the different options out there and I am so confused as to
editors, parsers, etc. that I really do not know which direction to turn. I
have a very small smattering of ASP which I hacked in order to get a site
that was moved to our servers to work, but that is the only other language
that I even attempted to try. The real crux of the problem is that
everything out there looks very confusing and so far removed from what I
currently have. I am fairly adept in SQL, Witango, HTML and CSS but I have
never taken the time to learn anything new. 

I downloaded some PHP editors, some sample ASP stuff, and to tell you the
truth, I just don't get a lot of it. Is there anything out there that gives
as visual of an interface as Witango? Or maybe is there a specific place you
can go to relearn the logic that it will take to use any of the tools
available? I think PHP is probably the place to start, but I am totally
confused as to how to go about it. I would prefer to continue using IIS as I
am very familiar with it along with the security. I went to the PHP site and
it seems that there are pages upon pages of just the install for IIS. Or,
how about editors? Are there any that you would recommend? Keep in mind my
Witango background. I never went to school for any of this stuff and I have
some pretty complicated things running on my sites from forums to streaming
PDFs, data access management systems to e-commerce. 

This is going to be tough, but I need to take it one step at a time...


 
  PHP Test
 
 
 Hello World'; ?> 
 
 


WebDude

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

RE: Witango-Talk: One for the Math Gurus

[WebDude]

Thanks everyone for your help... I got it working...

<@ASSIGN q '<@CALC EXPR="floor(<@ARG quantity>/12)" PRECISION=0>'>
<@ASSIGN r '<@CALC EXPR="<@ARG quantity>%12">'>

<@CALC EXPR="(<@VAR q> * 26)+(<@COLUMN 'shippingprice.price'>)"
PRECISION="2">


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

RE: Witango-Talk: One for the Math Gurus

[WebDude]

Okay, I got it working halfway using this...

<@ASSIGN r "<@CALC EXPR='<@ARG quantity>%12'>">   
<@ASSIGN q "<@CALC EXPR='<@ARG quantity>/12' PRECISION=0>">

<@CALC EXPR="(<@VAR q> * 26)+(<@COLUMN 'shippingprice.price'>)"
PRECISION="2"> 

It calculates correctly until you try any of the following quantities...

6 through 11
18 through 23
30 through 35
Etc.

Makes sense, though because of the <@CALC EXPR='<@ARG quantity>/12'
PRECISION=0> will always round up. Wasn't there a floor that would help with
this?

 

-Original Message-
From: WebDude [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 17, 2008 9:51 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: One for the Math Gurus

Sorry if I am dense, Beverly, but I am not able to get this to work. It kind
of half works.  

Here is what I am doing...

<@ASSIGN r "<@CALC '<@ARG QTY> % 12'>">   
<@ASSIGN q "<@CALC '<@ARG QTY> / 12'>">

<@CALC "(<@VAR q> * 26.00) + ( This is a search for <@VAR r> which returns
the <@COLUMN shipcost.price> )"> 

Now, if I plug in the number 1 (quantity 1) This would look like this...

R = 1
Q = 0.0833

Thus I get...

0.0833 * 26.00 + (14.50) = 16.7 Answer should be
14.50 

And if plug in  the number 13 (quantity 13) I get...

R = 1
Q = 1.08

Thus I get...

1.08 * 26.00 + (14.50) = 42.6 Answer should be 40.50




John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
[EMAIL PROTECTED]
 
http://cipromo.com
 

-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 8:47 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: One for the Math Gurus

Use the MODULO function to get the remainder.

r = QTY % 12

Along with the quotient.

q = QTY / 12

(q * 26.00) + ( {lookup what the price is for "r" items} )



Beverly


On 10/17/08 9:17 AM, "WebDude" <[EMAIL PROTECTED]> wrote in whole or in
part:

> Having a hard time wrapping my head around this one. Any help would be 
> appreciated.
>  
> Let's say we have bottles of perfume for sale. For shipping, we can 
> fit 12 bottles into a box. Each box is sent separately via a courrier.
> The courrier charges x amount for each box plus weight. To make a long 
> story shorter, in this scenario, we have different charges for 
> quantities of bottles within a box. So, for a specific zone, we charge
like so...
>  
> QuantityPrice
> 1  $14.50
> 2  $15.50
> 3  $16.50
> 4  $18.50
> 5  $18.75
> 6  $19.00
> 7  $20.00
> 8  $21.00
> 9  $22.00
> 10  $23.00
> 11  $25.00
> 12  $26.00
>  
> Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50.
> 14th bottle would be 26.00 + 15.50.
> 15th bottle would be 26.00 + 16.50, etc.
> And to continue following this format...
> 24 bottles would be 26.00 + 26.00
> 25 bottles would be 26.00 + 26.00 + 14.50
> 26 bottles would be 26.00 + 26.00 + 15.50
> 27 bottles would be 26.00 + 26.00 + 16.50, etc.
>  
> There is a formula in there somehow, but I am having a devil of a time 
> trying to figure it out. Any help would be appreciated.
>  
> Thanks!
>  
> 
> __
> __ 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: One for the Math Gurus

[WebDude]

Sorry if I am dense, Beverly, but I am not able to get this to work. It kind
of half works.  

Here is what I am doing...

<@ASSIGN r "<@CALC '<@ARG QTY> % 12'>">   
<@ASSIGN q "<@CALC '<@ARG QTY> / 12'>">

<@CALC "(<@VAR q> * 26.00) + ( This is a search for <@VAR r> which returns
the <@COLUMN shipcost.price> )"> 

Now, if I plug in the number 1 (quantity 1) This would look like this...

R = 1
Q = 0.0833

Thus I get...

0.0833 * 26.00 + (14.50) = 16.7
Answer should be 14.50 

And if plug in  the number 13 (quantity 13) I get...

R = 1
Q = 1.08

Thus I get...

1.08 * 26.00 + (14.50) = 42.6
Answer should be 40.50  



John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
[EMAIL PROTECTED]
 
http://cipromo.com
 

-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 17, 2008 8:47 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: One for the Math Gurus

Use the MODULO function to get the remainder.

r = QTY % 12

Along with the quotient.

q = QTY / 12

(q * 26.00) + ( {lookup what the price is for "r" items} )



Beverly


On 10/17/08 9:17 AM, "WebDude" <[EMAIL PROTECTED]> wrote in whole or in
part:

> Having a hard time wrapping my head around this one. Any help would be 
> appreciated.
>  
> Let's say we have bottles of perfume for sale. For shipping, we can 
> fit 12 bottles into a box. Each box is sent separately via a courrier. 
> The courrier charges x amount for each box plus weight. To make a long 
> story shorter, in this scenario, we have different charges for 
> quantities of bottles within a box. So, for a specific zone, we charge
like so...
>  
> QuantityPrice
> 1  $14.50
> 2  $15.50
> 3  $16.50
> 4  $18.50
> 5  $18.75
> 6  $19.00
> 7  $20.00
> 8  $21.00
> 9  $22.00
> 10  $23.00
> 11  $25.00
> 12  $26.00
>  
> Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50.
> 14th bottle would be 26.00 + 15.50.
> 15th bottle would be 26.00 + 16.50, etc.
> And to continue following this format...
> 24 bottles would be 26.00 + 26.00
> 25 bottles would be 26.00 + 26.00 + 14.50
> 26 bottles would be 26.00 + 26.00 + 15.50
> 27 bottles would be 26.00 + 26.00 + 16.50, etc.
>  
> There is a formula in there somehow, but I am having a devil of a time 
> trying to figure it out. Any help would be appreciated.
>  
> Thanks!
>  
> 
> __
> __ 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: One for the Math Gurus

[WebDude]

Having a hard time wrapping my head around this one. Any help would be
appreciated.
 
Let's say we have bottles of perfume for sale. For shipping, we can fit 12
bottles into a box. Each box is sent separately via a courrier. The courrier
charges x amount for each box plus weight. To make a long story shorter, in
this scenario, we have different charges for quantities of bottles within a
box. So, for a specific zone, we charge like so...
 
QuantityPrice
1$14.50 
2$15.50 
3$16.50 
4$18.50 
5$18.75 
6$19.00 
7$20.00 
8$21.00 
9$22.00 
10   $23.00 
11   $25.00 
12   $26.00 
 
Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50.
14th bottle would be 26.00 + 15.50.
15th bottle would be 26.00 + 16.50, etc.
And to continue following this format... 
24 bottles would be 26.00 + 26.00
25 bottles would be 26.00 + 26.00 + 14.50
26 bottles would be 26.00 + 26.00 + 15.50
27 bottles would be 26.00 + 26.00 + 16.50, etc.
 
There is a formula in there somehow, but I am having a devil of a time
trying to figure it out. Any help would be appreciated.
 
Thanks!
 


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

RE: Witango-Talk: Witango 6 update

[WebDude]

Yeah, 700 billion outta do it ;-) 




-Original Message-
From: Tom Ferguson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2008 8:04 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Witango 6 update

Good News... Congress is going to earmark $$ for WiTango as part of its
economic stimulus bailout...  Wooo Hooo! 

> -Original Message-
> From: WebDude [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 01, 2008 08:03
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Witango 6 update
> 
> Yeah... Good news would be great right now... 
> 
> 
> WebDude
> http://myfishingpals.com
> 
> -Original Message-
> From: Wolf, Gene [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 01, 2008 7:36 AM
> To: witango-talk@witango.com
> Subject: RE: Witango-Talk: Witango 6 update
> 
> 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
> __
> __
> 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: Witango 6 update

[WebDude]

Yeah... Good news would be great right now... 


WebDude
http://myfishingpals.com

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2008 7:36 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Witango 6 update

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

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

RE: Witango-Talk: 304 last-modified

[WebDude]

Thanks, Scott,

Yeah, I thought it was going to be complicated ;-/ I actually was looking at
ASP and PHP code to see if I could write something in Witango that would
kind of do the same thing.

I was looking at this from a Googlebot point of view. When Gbot comes, if
the requested page hasn't been modified since the last request it won't
crawl the page. Google recommends that you use this... 

"You should configure your server to return this response (called the
If-Modified-Since HTTP header) when a page hasn't changed since the last
time the requestor asked for it. This saves you bandwidth and overhead
because your server can tell Googlebot that a page hasn't changed since the
last time it was crawled."

'Dude
 

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2008 9:51 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: 304 last-modified

Hey Dude,

Unfortunately HTTP caching takes a lot more consideration than just globally
setting a custom HTTP response header.

When you set a custom header for caching purposes, this process is entirely
dependent on receiving some specific request HTTP header properties (i.e.,
If-Modified-Since and/or If-None-Match), in order to conditionally set a
corresponding expiry date, an ETag number and a
304 response (for the subsequent responses), as opposed to the custom 200
response (on the first response). And depending on the version of tango you
are running - you may not have access to these HTTP properties.

In addition, HTTP caching is managed by matching the entire URL of the file
in question, this includes the argument names and values, so if your GET
arguments are changing, then your caching is overridden. POST requests
generally always override cache checks as well.

And of course it should be mentioned that although browsers and proxies do
adhere to the HTTP standards, these applications and devices are sometimes
unpredictable as to "when" they implement cache rules.

I've built systems with HTTP caching, and I hope I can save you some time by
giving you some advice - don't bother. The headache, unpredictability and
limited results is usually not worth it. There'll be times where you can
easily waste hours chasing your code in circles just to discover that all
the bugs and weird behavior is the result of something happening off the
server (where you have no control).

I would recommend you pursue methods for caching whatever essential data you
need in memory on the Server to save on performance issues - or check out
load balancing. Or possibly an appliance of some kind that handles the
caching outside of your server.

And please note, your tango code example is for deliberately turning "off"
caching.

I hope this helps, good luck.

Scott,




On Aug-22-2008, at 10:55 AM, WebDude wrote:

> Hi All,
>
> I am a bit confused as to how to implement a caching scheme in which I 
> can show whether or not a page has been updated or not. This is for a 
> forum that stores the last update by date. I would like to change the 
> response http to show the last-modified date if possible.
> Unfortunately, I am a novice on http headers and would like some help 
> on how to implement this. If I set the expiry to
>
> <@ASSIGN Local$httpHeader VALUE="Content-Type: text/html<@CRLF>Cache-
> Control: no-cache, max-age=0, must-revalidate,proxy
> revalidate<@CRLF>Pragma: no-
> cache<@CRLF><@USERREFERENCECOOKIE><@CRLF>">
>
> Will this generat what I need for the request? I am looking for the 
> reponse to be something like this...
>
> HTTP/1.0 200 OK
> Server: Microsoft-IIS/5.0
> Content-Location: http://www.xyz.taf
> Date: Fri, 22 Aug 2008 18:22:39 GMT
> Content-Type: text/html
> Accept-Ranges: bytes
> Last-Modified: Wed, 020 Aug 2008 13:30:23 GMT
> ETag: "801395163ec21:8a9"
> Content-Length: 751
>
> And I am confused as to the ETag.
>
> Can I set this globally for all tafs? or would that really take a 
> performance hit?
>
> Can someone shed some light on this, please?
>
> Thanks!
>
>
>
> __
> __ 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: 304 last-modified

[WebDude]

Hi All,
 
I am a bit confused as to how to implement a caching scheme in which I can
show whether or not a page has been updated or not. This is for a forum that
stores the last update by date. I would like to change the response http to
show the last-modified date if possible. Unfortunately, I am a novice on
http headers and would like some help on how to implement this. If I set the
expiry to 
 
<@ASSIGN Local$httpHeader VALUE="Content-Type:
text/html<@CRLF>Cache-Control: no-cache, max-age=0, must-revalidate,proxy
revalidate<@CRLF>Pragma: no-cache<@CRLF><@USERREFERENCECOOKIE><@CRLF>">
 
Will this generat what I need for the request? I am looking for the reponse
to be something like this...
 
HTTP/1.0 200 OK
Server: Microsoft-IIS/5.0
Content-Location:   http://www.xyz.taf
Date: Fri, 22 Aug 2008 18:22:39 GMT
Content-Type: text/html
Accept-Ranges: bytes
Last-Modified: Wed, 020 Aug 2008 13:30:23 GMT
ETag: "801395163ec21:8a9"
Content-Length: 751
 
And I am confused as to the ETag.
 
Can I set this globally for all tafs? or would that really take a
performance hit?
 
Can someone shed some light on this, please?
 
Thanks!



 


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

RE: Witango-Talk: Observations on Survey results

[WebDude]

Thanks for the survey, Scott! 


'Dude

-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 06, 2008 11:39 AM
To: Witango-Talk
Subject: Witango-Talk: Observations on Survey results

Hi All,

The survey has reached 49 responses, a very respectable number.  
Congratulations everyone.

http://freeonlinesurveys.com/viewresults.asp?c=x4jovb5l0cv4h6y469661

Note, I think the survey system only lets you see the first 50 responses.
For more you have to buy a monthly subscription.

An observation that I think is interesting, is that the number of people
coding on a particular platform for their Editor/Studio does not directly
match the Server platform they deploy to. As well, the majority of choice
for an alternate technology platform (Linux) also do not match the platform
most considered stable for Witango (Windows).

I think what that says is that Witango programmers are less concerned about
the Operating System they use, and more interested in stability and options.
Personally I think that's a great attribute for a good programmer or service
provider - by focusing on the solution and not letting yourself get hung up
on the logistics. Of course, some might say the same should be said about
our choice of programming languages too.

Also, I see the interest in Java based options (both current and as an
alternate technology) being very low - yet, a lot of people are planning to
move to version 6 which is apparently java-based. Does that mean we trust
Java more as an application platform than as a coding environment? Just
curious.

In hindsight I know I could have worded things a little differently, but
mostly I wish I had added another option for Question 10 (What do you use or
see as a workable transition platform?) as "Not interested in moving away
from Witango". But for being a spur of the moment thing, I think it all
worked out pretty well. Thank you.

Take care.

Scott,




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

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

RE: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]

[WebDude]

Oh, and something like:

How often do you use Witango?
XX  Everyday, 95% my projects
~ About half of my projects
~ At least once a year
~ No longer code in Witango, I just hang out on the list to annoy people or 
because I can't help myself (check)


Scott,




On Aug-5-2008, at 9:34 AM, Scott Cadillac wrote:

> Good question Rick,
>
> Maybe someone should setup an anonymous Poll somewhere? I'd be very 
> curious to see the results. Although I do know more than one customer 
> running a large number of Windows servers with Witango.
>
> What are some good questions to ask?
>
> What version are you using?
> - 3.x
> - 4.x/2000
> - 5.0
> - 5.5
>
> What platform is your Editor?
> - Windows
> - Mac
>
> Are you using the Java Compiler?
> - Yes
> - No
>
> What platform is your server?
> - Windows
> - Mac
> - Linux
> - Solaris
>
> How many servers do you run?
> - 1
> - 2~5
> - 6~10
> - 11~20
> - 20+
>
> Just a thought...
>
> Scott,
>
>
>
>
> On Aug-5-2008, at 9:22 AM, Rick Sanders wrote:
>
>> Is it just me, or does it seem that a large portion of the existing 
>> WiTango user base is using the Macintosh platform?
>>
>>
>> Rick Sanders
>> Webenergy
>> Canada: 902-431-7279
>> USA:   919-799-9076
>> Canada: www.webenergy.ca
>> USA:   www.webenergyusa.com
>>
>> -Original Message-
>> From: Dan Stein [mailto:[EMAIL PROTECTED]
>> Sent: August-05-08 9:10 AM
>> To: witango-talk@witango.com
>> Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]
>>
>> I have found that to be the case also but a monthly update to the 
>> community would be very important.
>> --
>> 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
>>
>> "The love of one's country is a splendid thing. But why should love 
>> stop at the border? "
>>
>> Pablo Casals
>>
>>
>>
>>> From: Mikal Anderson <[EMAIL PROTECTED]>
>>> Reply-To: "witango-talk@witango.com" 
>>> Date: Mon, 04 Aug 2008 21:54:31 -0700
>>> To: "witango-talk@witango.com" 
>>> Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]
>>>
>>> 
>>> Delays are understandable
>>> and part of the business, but communication is essential.
>>> At least a monthly communication would go a long way with the 
>>> development community and I know I"m not alone in this feeling.
>>> 
>>>
>>> Agreed. Phil does however answer his phone & will reply to your 
>>> email.
>>>
>>> Mikal Anderson
>>> PDX
>>>
>>>
>>> On 8/4/2008 9:29 PM, John Carrieri wrote:
 Hi Christian,

 I too have used witango for 11 years which is hard to believe and 
 also initially on a APPLE AWS 8550. When we first started jokes.com 
 (since sold too Comedy Central/ it sucks now despite the fact that 
 they have still stayed in #1 position on goog) we had three front 
 ends and one back end running Butler and we made it work serving 
 millions of viewers!
 Since I've used tango / witango on everything from Enterprise level 
 Sun servers to the latest Xserves. Through all of this it has been 
 extremely stable through a decade of use, with the exception of 
 running it under 10.5. While I have used it on Mac and Sun 
 platforms I always appreciated that it could also run on Windows 
 and later Linux. Put quite simply it is a great flexible platform.

 I understand the challenges that Witango must have as a small 
 company, with a complex product, but they need to communicate to 
 their customers. Delays are understandable and part of the 
 business, but communication is essential.
 At least a monthly communication would go a long way with the 
 development community and I know I"m not alone in this feeling.

 Please, please communicate with us. I think that is all anyone is 
 asking.

 Sincerely,
 John



 On 8/4/08 8:52 PM, "Christian Platt"  
 <[EMAIL PROTECTED]>
 wrote:

> It would be easy to post this message to the list.
>
> Or at least a person who is in connection with will could make the 
> communication with the still existing community.
>
> I do not know, how many peaple are still on the list or using 
> witango.
>
> I checked that this is my 11th year since starting With Butler/ 
> Tango on an APPLE AWS 8550.
>
> It would be interesting to know, how many people are still using/ 
> developing Witango
>
> Christian
>
>
> Am 04.08.2008 um 21:34 schrieb Mikal Anderson:
>
>> Below is latest from Phil.
>>  Original Message 
>> Subject: Re: [Fwd: Witango-Talk: Version 6?]
>> Date: Mon, 4 Aug 2008 09:57:07 +1000
>> From: Phil Wade <[EMAIL PROTECTED]>
>> To: Mikal Anderson <[EMAIL PROTECTED]>
>> References: <[EMAIL PROTECTED]>
>>
>>
>>
>>