Re: Witango-Talk: Witango Snow Leopard (Mac OS 10.6) compatibility

[Jason Schulz]

Try setting the processor affinity to the first two processors, so it  
doesn't attempt to use all of them.


Regards,

Jason.

On 17/06/2009, at 11:35 PM, Ron Alt wrote:

Dale: those were good instructions.  I was able to modify them for  
Tenon's version of Apache (their version is already 32 bit, which  
leaves out the first step).


Was able to get it to make a connection, but could not run it  
further due to a licensing problem (tried several licenses -  
including a new 30-day trial - which gave an error on a Mac intel  
Quad processor - error says it would only work on two processors).


Ron Alt
FTA



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

Re: Witango-Talk: image files

[Jason Schulz]

Janet,

If you've read the image file in, (either from the filespace, or  
received it via an upload) then you can just store that directly in a  
BLOB column. If you want, you can BASE64 the data via @cipher, which  
will turn it into text, but that typically results in a 15% increase  
in data size, just so that you can use a CLOB (character large object)  
column.


Be aware of your MaxItemBufferSize, which will truncate the data  
retrieved from the database. If you are using BLOBS, it isn't hard to  
then use offsets to retrieve the BLOB in several parts, each less than  
MaxItemBufferSize.


Regards,

Jason.

On 01/05/2008, at 10:55 AM, Janet wrote:


Thank you William
I guess I am stuck because I read that a byte array is used to send  
data to
an Image field. So I was looking for a utility that would convert  
the image
file into a byte file. I found code samples on the web but I was  
hoping to

find a utility. Mostly I use excel files to load data into MS SQL.
I mean I am clueless when I think about getting the image file into  
the

table field.
Janet




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Posting XML

[Jason Schulz]

On 15/04/2008, at 4:44 PM, Wayne Irvine wrote:
What I'm really clueless about is what action or code I use to  
'send' it to

them.



Wayne,

XML & XHTML are file formats. They aren't transport protocols, like  
HTTP, SFTP etc.


The far end will need to tell you what how they want to receive the  
files.


Regards,

Jason.


WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Oracle Connection Issues

[Jason Schulz]

Kent,

DSConfig isn't being used for either. DataSourceLife is the same on  
both.


Thanks,

Jason.


On 02/04/2008, at 3:13 AM, Kent Swisher wrote:


Jason

Check your DSConfig.ini for differences between the two servers.   
Look at single threaded vs multi and max number of connections.   
Also check DataSouceLife in the witango.ini.


-> Kent





WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Witango-Talk: Oracle Connection Issues

[Jason Schulz]

Folks,

We have two Oracle instances that are (as far as we can tell)  
configured the same, 9.2.0.1.0, on Windows 2003 Server. On separate  
servers, we have Witango 5.5.0020 (again each configured the same),  
that connect to one each of the Oracle instances. For one Witango  
server, the DS connections are setup and dropped for every individual  
query (which is killing performance). For the other Witango server, a  
single DS connection gets used repeatedly, which is as it should be.


Does any one have any ideas as to why this is so?

Thanks,

Jason.



WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: cancel a query

[Jason Schulz]

Ted,

Make sure that the following are all indexed;
 - the columns on each side of any join of the underlying view query,
 - the criteria columns for the underlying view query,
 - any view columns that the user's query may use to join to other  
table(s),
 - any view columns that will have criteria applied in the user's  
query.


You specifically want to avoid any full table scans, and any cartesian  
products in the joins.


Ideally the user query should execute in a couple of seconds, while  
Witango's manipulations of the data will take a few seconds as well.


Regards,

Jason.

On 31/03/2008, at 1:31 PM, Ted Wolfley wrote:

A view is being used to link data between 6 tables where the user  
can search at least 10 fields bringing back about 40 columns.




--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Witango Version 6 - Community Update

[Jason Schulz]

Well, if you're in Australia/NZ, or serving the Australian or New  
Zealand market, we're more than happy to host for you...


Regards,

Jason.

On 12/02/2008, at 8:42 AM, WebDude wrote:

I agree with you Robert. The only places I can host Witango apps is  
on my own servers. There really are no other alternatives except  
maybe a few on this list. Funny, I host php, asp,and .net for other  
developers on my servers, yet I could not, without a very difficult  
search, host my apps somewhere else.


Another bone in the craw is the amount we spent on the original. My  
problem is I have not updated. I am still running 2000 and it is so  
stable and I have had no issues that it is very hard for me to move  
on to something newer. I am currently getting around one million  
visitors a month on 2 IIS servers (and one separate db server) and I  
plan on adding another IIS server. SO this would mean I would need  
at least two licenses, probably 3 if I cannot get an upgrade. I  
bought professional 2000 back in the day. You remember how much that  
one cost -- The reason I bought professional is because I could put  
it on as many servers as I wanted. Of course you had to pay for that  
privilage. Now I almost wish I would have purchased individual  
licenses... it would have been a lot, LOT cheaper in the end.



From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Monday, February 11, 2008 3:19 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango Version 6 - Community Update

The thing is, even if the dev studio is great, and cheap, you have  
to have places to host your stuff, and there are very few choices,  
so devs will have to host themselves more than any other platform.  
With .net and php, you can host all over the place, coldfusion, more  
choices, but not as much as php and .net. The .net server, is really  
just windows web edition, or $300. IMHO, the witango server, being  
by far the underdog, needs to be at the highest point, $699.


I think these new prices are great, and I think they will definitely  
help stop the bleeding of devs to other places who already have a  
witango investment. But I don't see them bring in new developers,  
again, just my opinion.


--

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

On Feb 11, 2008, at 1:01 PM, Rick Sanders wrote:


I agree too, cost is high.
CF8 Server is $1299.00 full, and upgrade is $649.00
Visual Studio Pro 2008 $799.00 - Upgrade: $499.00
So, are we looking at Q3 for the full release?
I’ll be interested to see what the new features are, and test the  
beta. Good work Phil!

Rick
From: GK [mailto:[EMAIL PROTECTED]
Sent: February-11-08 3:46 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango Version 6 - Community Update
I agree with Robert. The server cost is still a bit high. The  
strength of WiTango is the studio. It would be great if it could  
export php code. Nonetheless, this is a good breakthrough and hope  
to see the community grow.


George Kassyousef
Phenomena Technologies Inc
www.phenomenatech.com


- Original Message 
From: Robert Garcia <[EMAIL PROTECTED]>
To: witango-talk@witango.com
Sent: Monday, February 11, 2008 12:24:01 PM
Subject: Re: Witango-Talk: Witango Version 6 - Community Update

These are great changes, too late for BigHead, but maybe not for
others. I think the studio price is spot on. I still think the server
should be sub 1000, but just my opinion. Good to see the change to  
one

machine license.

What does "open sourced under its own license" mean?

--

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

On Feb 11, 2008, at 4:59 AM, Phil Wade wrote:

> WITANGO COMMUNITY UPDATE
> 
>
> Th Witango 6 development project is now drawing to a close and in
> the coming weeks a full public beta of both studio and server will
> be released. The full release of Witango 6 will be accompanied by
> significant changes to both pricing and licensing,  we therefore
> take this opportunity to update the community as we move forward.
>
>
> 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 proces

Re: Witango-Talk: Witango Version 6 - Community Update

[Jason Schulz]

To Phil & the team, well done!

It's been a while coming, but hopefully it will be packed full 'o  
features, and well worth the wait. The pricing is certainly welcome.


Regards,

Jason.

On 11/02/2008, at 11:59 PM, Phil Wade wrote:


WITANGO COMMUNITY UPDATE


Th Witango 6 development project is now drawing to a close and in  
the coming weeks a full public beta of both studio and server will  
be released. The full release of Witango 6 will be accompanied by  
significant changes to both pricing and licensing,  we therefore  
take this opportunity to update the community as we move forward.



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.



New Pricing
---
Witango Studio v6 US$199

Witango Studio upgrade - US$99

Witango Server Lite - Free
Witango Server Developer Edition - Free with studio
Witango Server Professional - US$1499

Witango Server Upgrade from v5.5 - US$999
Witango Server Upgrade from pre v5.5 - US$1299

Those customers who own Witango 5.5 professional edition servers  
will have the option at the time of upgrade to upgrade their server  
to two (2) Witango 6 Professional edition licenses for US$1499.


Witango licenses will only be available direct from Witango  
Technologies and no further discount will apply.



Your Enquiries
---
A comprehensive outline of new features will be available on release  
of the beta.  We understand many of you will have questions, please  
direct them off list to [EMAIL PROTECTED] We will compile a FAQ and  
post back to the list.


It has been a long term goal for Witango Technologies to move  
Witango to an Open Source product, with simplified and affordable  
licensing.  Witango v6 therefore represents a major milestone for  
us.  We would also take his opportunity to thank our development  
team who have worked with consistent enthusiasm and considerable  
effort in preparing the code for open source.



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


--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.





WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Force user back to top of page

[Jason Schulz]

Put a small javascript at the end of the page that calls an anchor at  
the top of the page.


J.

On 08/02/2008, at 10:07 AM, Dan Stein wrote:

Does anyone know anyway to force the browser to the top of the page  
on load so if someone is in the checkout and hits update cart they  
get forced back to the top of the page so they can be sure to see  
how it effects shipping etc.




--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: 5.5.020 for Mac

[Jason Schulz]

I would guess that it is because since its release, Mac OS X has been  
a moving target for developers with partially developed (feature  
incomplete) APIs and existing ones being dropped. Even John Siracusa  
says that with the release of Leopard, only now does Mac OS X provide  
a solid foundation for developers.


Jason (a mac head since System 3.0/Finder 5.1).

On 10/01/2008, at 5:19 AM, Robert Garcia wrote:

Why wouldn't they do a universal binary? Or compile a powerpc and  
intel version? That has got to be VERY frustrating for people  
sitting on witango on mac hardware.


On Jan 9, 2008, at 6:45 AM, Robert Shubert wrote:


Is 5.5.009 the LAST powerpc binary?

Yes, as I recall. Between 009 and 020 was the update to the  
complier. I

believe this created the separation.





WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Upload then Import

[Jason Schulz]

Webdude,

Since you are using MS SQL, have a look at BCP.exe, which is a MS db  
utility specifically designed for bulk imports/exports with MS SQL.  
Calling BCP via a batch file is the fastest way for Witango to get  
data into or out of MS SQL.


Regards,

Jason.

On 29/11/2007, at 5:39 AM, WebDude wrote:


Witango 2000
MSSQL 7
W2k Server

I there a way or routine to upload a file (csv, tab delimited, xsl  
or whatever) and then import into an existing table? I am hoping for  
a Witango solution. Anyone ever do something like this?


Thanks!



--
This message has been scanned for viruses and
dangerous content by ESVA, and is believed
to be clean.

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

--
This message has been scanned for viruses and
dangerous content by ESVA, and is believed
to be clean.




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Witango-Talk: New Connection to Oracle for each Query

[Jason Schulz]

Folks,

Witango 5.5.009, on Windows 2003 Server with Oracle ODBC 9.02 towards  
Oracle 9 db. Datasourcelife = 30.


On the Dev host, each query against Oracle is creating a new  
connection, which is killing performance. The Staging and Production  
boxes are running normally (connections last for 30 minutes). What we  
can't find is the difference in the configurations between Dev and  
the others.


Does anyone have any suggestions?

Thanks,

Jason.



WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]




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

Re: Witango-Talk: Load Balanceing

[Jason Schulz]

Each Witango service will need to see the location of the files in  
the same way.


There are two and a half ways to do this.

A) Copied Code (the half method).

On each Witango server, copy the code to the same location (eg, c: 
\inetpub\wwwroot\). Configure IIS to share one of these as the  
website. You will need to manually maintain consistency between the  
copies (think customer file uploads, etc).


Pros:
Good Witango load sharing.
Good for read only sites
Quick and dirty.

Cons:
Manual work involved to ensure code is consistent between all Witango  
instances.
No Witango service redundancy (they 'see' different copies of the  
files).


B) Mapped Drive.

Share wwwroot, and map a drive (eg, 'K:\') against it on _all_  
Witango servers.

Configure IIS to share drive K as the website.

Pros:
Good redundancy across application elements.
Good load sharing.
Easy to update code.
Code is consistent between all Witango instances.
Simple to configure

Cons:
Only works for a single site (you need a new drive letter for each site)
If the mapped drive fails for any reason, manual intervention is  
required to restore the connection.


C) Share Point
Have your code in a shared directory, eg., \\Host\wwwroot\code.taf

Configure IIS in the 'Home Directory' tab so that 'the content for  
this resource should come from [X] A share located on another  
computer', and point it at \\Host\wwwroot\


Ensure that the privileges required to access \\Host\wwwroot are  
available to the account that Witango is running under.


With the above configuration, you can have single or multiple IIS  
front ends, with single or multiple Witango services. The share point  
could be served from any one of them, or an unrelated server (such as  
a NAS box).


Pros:
Good redundancy across application elements.
Good load sharing.
Easy to update code.
Code is consistent between all Witango instances.
Single hardware installation can support multiple sites

Cons:
Pain to get going.
More to go wrong.
More to look after.

Regards,

Jason.



On 04/10/2007, at 3:32 PM, Fogelson, Steve wrote:


Andre and others,

I have done some testing with the following setup

Server A will run one Witango service and the databases will reside  
here.

Server B will run IIS, Witango Client and one Witango service

I assumed you had to have copies of all the taf, tml, tcf, images  
and html
files on both servers. Is this true or do you only have to have the  
files on

the IIS and Witango Client server (B)?




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Witango-Talk: Translating between XML Character sets

[Jason Schulz]

We're running 5.5.0020, and having an issue with inserting UTF8 from  
an Ajax front end into the database via Witango.


Witango appears to be converting the double byte characters into two  
Latin1 characters, which breaks things.


Does anyone have a way of handling this?

Thanks,

Jason.



WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: Replacing one or more URLs within a block of text

[Jason Schulz]

Off the top of my head,

<@REPLACE STR="http://www.example.com"; FINDSTR="http://";  
REPLACESTR="http://www.mywebsite.com/click.taf?vurl=http://";  
POSITION="1">


You might want to tweak the string arguments, but it should do what  
you want.


Regards,

Jason.

On 13/08/2007, at 6:35 PM, MC Tay wrote:

http://www.websiteone.com/app1.taf? 
para1=100¶2=200¶3=300" target="_blank">

becomes
http://www.mywebsite.com/click.taf?vurl=http:// 
www.websiteone.com/app1.taf?para1=100¶2=200¶3=300"  
target="_blank">


http://www.websitetwo.com/app2.taf?p1=aaa&p2=bbb";>
becomes
http://www.mywebsite.com/click.taf?vurl=http:// 
www.websitetwo.com/app2.taf?p1=aaa&p2=bbb">




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]




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

Re: Witango-Talk: Re: Using Mapped Drive for Local File processes.

[Jason Schulz]

Run Witango under an account with rights against the UNC share and it  
works like a treat (Witango doesn't have to be local system).


Regards,

Jason.

On 25/03/2007, at 10:57 AM, Willochell, Mike wrote:

The most reliable way to reference local or network shares is via  
UNC paths




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]




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

Re: Witango-Talk: Save to pdf

[Jason Schulz]

We're been trialling ConvertDoc   from Softinterface  
for a couple of months, and are about to put it to production.


The customer has an ordering site. They upload a word document as a  
'template', with tokens as placeholders in various parts of the  
document. When the end user clicks submit, the tokens are dynamically  
swapped out for quote/order specific details, the document is  
rendered as a PDF and then emailed to the end user.


ConvertDoc doesn't require either Word or Acrobat to be installed on  
the servers. We're using it via command line execution, but it can be  
accessed via COM/ActiveX. It supports PDF to RTF/DOC, PDF to TXT, PDF  
to HTML, DOC to PDF, RTF to PDF, HTML to PDF.


Regards,

Jason.


On 09/03/2007, at 2:36 AM, Brian Domine -X ((bdomine - Artsource,  
Inc. at Cisco)) wrote:


Does anyone have any experience in saving a witango served up page  
as a PDF?


Thanks,
Brian




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]




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

Re: Witango-Talk: Upgrading from Witango 5.0 to Witango 5.5 - Syntax Errors

[Jason Schulz]

We use the shorthand @@ pretty much everywhere unless we need to  
specify encoding or formatting. We use <@var> a lot when generating  
files - as was pointed out, sometimes you need the space on the front  
of the @@ to get through the parser, but then you don't want that  
space char in the file.


In general the language is fairly verbose, and it is fairly easy to  
have metatags nested six or seven times deep (ever written a function  
call with a dozen parameters in text? it can easily fill half a  
screen with solid text). My choice is readability (ie, it can be  
understood and supported easily) over ultimate speed. Generally our  
code is commented and has plenty 'white space' (empty lines, spaces  
etc) to make it easier for the programmers to figure out what is  
going on. If you are on a bug hunt through something written by a  
team of people a year or two ago, there is no point in it being any  
harder than it has to be.


We've run everything cached, so the only performance hit is the first  
time the code hits the parser. After that, writing styles don't matter.


As far as 'bugs' go, we scope and quote _everything_. If you do that,  
the language pretty much works as advertised.


J.

On 09/02/2007, at 6:11 AM, William M. Conlon wrote:


I see the shorthand as a developer aid,




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.

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

Re: Witango-Talk: Email Verifier for WiTango

[Jason Schulz]

Email (smtp) is by design a best effort delivery system. There is no  
guarantee of delivery, and although you can 'request' a delivery  
receipt it is up to the receiving mail program to decide if it wants  
to send a 'received' or 'read' receipt.


If you really need to verify that an email has been read, you can do  
one of two things. Firstly, write the email in html, with a reference  
to an image on your server. Then when the mail is opened, the image  
will be loaded. Using unique image names, url arguments and trapping  
errors on the server are left as an exercise for the reader. Be aware  
that this is a common technique for spammers to verify an email  
address, so some spam systems will rate your email. The second way is  
to include a url in the email for the end reader to click on.


Can you tell us a little more about the problem you are trying to solve?

Regards,

Jason.


On 16/12/2006, at 3:26 PM, MC Tay wrote:


Hi:

Does anyone know any scripts or products that verifies emails (not  
syntax, but to check the delivery results) and can be integrated  
with WiTango?


Thanks!

MC


__ 
__

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

--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.





WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]




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

Re: Witango-Talk: Studio Beta?

[Jason Schulz]

Phil,

That's good to hear.

Thanks,

Jason.

On 13/12/2006, at 11:16 PM, Phil Wade wrote:


On 13/12/2006, at 9:16 AM, Dan Stein wrote:

I have heard from reliable source it is not EOL of the release of  
5.5 beta and 6 are forthcoming. That said it would seem that the  
community is way way overdue for an update.


Yes there is another release of the 5.5 server coming before  
Christmas.  It is a maintenance release and will include a version  
for OS X on Intel Macs.  We had a few internal issues with the  
build that we had to rectify before we released it.


The rewritten Dev Studio v6 is currently in private testing and we  
are making good progress on the v6 server which will be released in  
Q2 2007.



Regards

Phil




WITH IMAGINATION
Planning, Implementation and Management of Web Applications

Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email -  [EMAIL PROTECTED]



--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.



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

Re: Witango-Talk: BLOG

[Jason Schulz]

Once upon a long time ago, Phil wrote one...I've got no idea what it can do, but the link still works.Regards,J.On 01/12/2004, at 8:27 AM, Phil Wade wrote:A little more info.For all those who could not find the online demo, the link is in the middleof the home page.  You can access it directly at http://blog.witango.com .You need to register before you can log in.  Just click on the register linkon the right.I would like to see the blog demo as a community project (hopefully thefirst of many) as everyone will benefit.  I am happy to do the merging ofchanges, fixes and new features into a single stream of code.PhilTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafOn 02/11/2006, at 11:38 AM, Wayne Irvine wrote:In the same week I have been asked by two clients to set up BLOG software.I'm not al that familiar with the functionality of a BLOG but I assume itallows public submission with centralised admin and approval. The resultsshowed in a some chronological order on a page.I've got several systems pretty close to this but was wondering if anyoneelse has some BLOG code I could look at or use?Wayne Irvine                  Byte Services Pty Ltd               http://www.byteserve.com.au/                  [EMAIL PROTECTED]   Ph 02 9960 6099   Mob 0409 960 609   Fax 02 9960 6088TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf  WITH IMAGINATIONPlanning, Implementation and Management of Web Applications Level 1, 44 Miller Street North Sydney NSW Australia 2060phone + 612 9929 9229 fax + 612 9460 4770 web - www.wi.com.au email -  [EMAIL PROTECTED] 


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

Re: Witango-Talk: [OT] Recommend a Project Manager Tool?

[Jason Schulz]

Scott,We're trialling Trac  as a lightweight pm. It supports multiple projects in one installation, has integration with Subversion and the ticketing side is fairly straightforward, and so won't frighten customers who will end up using it to report issues via the web. It is oss, php based and can talk to a number of backend databases. It also has milestones (with ticket/build integration).J.On 08/09/2006, at 12:56 AM, Scott Cadillac wrote:Hi Folks,Can anyone recommend a good Project/Task Manager system?I'd love to build one myself, but don't have the luxury of time. It would need to support:~ Multiple Tasks, with Subject, Body, Due Dates, etc... ~ Track potential and actual hours work, Status etc...~ Group Task by Project/Categories/Customers etc...~ View Projects and Tasks in a filtered List, Tree (hierarchical) Gant Chart and/or Calendar.~ Ability to add comments or extra data to each Task.~ Easily manage milestones and goals.~ Support multiple user logons and delegate to same.~ Web-based or shareable in a Terminal Services environment (users are spread all over North America).At the moment I'm not concerned about the technology it's built on, or if it's hosted or installer based. Having access to Source-code is a bonus of course, but not critical.This is for a large Software project of course, and after having spent considerable time searching the net, I have found many potential solutions, test driven some, but most have either been too simplistic, or too complex and geared toward specific markets.Some systems have come close, but not close enough to give me that warm-and-fuzzy.Any suggestions would be appreciated. Thank you for your time.Scott Cadillac, Email: [EMAIL PROTECTED] http://scott.cadillac.bz TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf   WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: [OT] Safari and meta refreshes

[Jason Schulz]

Alan,Which version of Safari, and with what headers?http://www.whs.sta.wi.com.au/modules/serverstatus.taf?display=true refreshes quite nicely in Safari v2.0.3 (417.9.3) using http://www.whs.sta.wi.com.au/modules/serverstatus.taf?display=true&last_hs=79749120">Regards,Jason.On 17/06/2006, at 6:23 AM, Alan Wolfe wrote:Hey everyone,   Just wanted to give everyone a headsup, as far as i can tell, the latest version of safari does not like meta refrehses!   We are going to do some more testing to find out for sure but right now it looks like safari just will not do meta refreshes. 
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Migrating from W2K to Linux

[Jason Schulz]

Michael,This will be a combination of upgrades + new licenses. We're still in the planning stage at the moment. The customer may choose to stay on windows, but they've asked that we tell them what is involved.Regards,Jason.PS. Thanks to everyone who has responded so far.On 05/06/2006, at 11:37 PM, Michael Dittbrenner wrote:Did you have to buy a new witango license for linux or did with allow you to move over. I have contacted [EMAIL PROTECTED] and NEVER got a response. I have emailed it twice actually and never got a response either time.     WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Witango-Talk: Migrating from W2K to Linux

[Jason Schulz]

Folks,Does anyone have any tips that they can share about migrating a Witango app from windows to linux (specifically Red Hat)?Thanks,Jason.  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Direct DBMS

[Jason Schulz]

I usually leave a space character on the end of each line. Without line returns or a space character, some sql statements don't parse very well: "FROMcis_test ct1, "Regards,Jason.On 31/05/2006, at 6:08 AM, Tola Oyenusi wrote:but besides the annoyance factor. it will still function just fine  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Parsing DOM Response for element by name

[Jason Schulz]

Rob,I don't mind you writing on the list about anything Witango related. I just don't think what you wrote yesterday is the best way to get Witango to change how they do things (which is something I'd like).Yesterday struck me as a "I'm leaving and I'm burning my bridges as I go" kind of message. If you didn't mean it that way, then I apologise.Regards,Jason.On 27/04/2006, at 6:06 PM, Robert Garcia wrote:And for the record (jason), I am moving to php, that is true, but I have several clients on this list, that use witango everyday, and pay me to help them work through these issues.  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Sales for a month

[Jason Schulz]

TrySELECT MONTH(SHIPDATE), SUM(SHIPPED * DATE)FROMORDERSGROUP BY MONTH(SHIPDATE)J.On 09/04/2006, at 8:16 AM, Mark Weiss wrote:Hi,I have a table of sales. 3 sales for Jan, 4 for Feb, 10 for march, etc, for the entire year.I couldsum stuff where shipdate between "01/01/2006" and "01/31/2006"sum stuff where shipdate between "02/01/2006" and "02/28/2006"etc...I am trying to come up with some kind of sql that will sum the sales total for a month, without having to do date ranges.select month(shipdate), sum(shipped * price) from orders where shipdate = month(shipdate) group by shipdateor something like that.It would end up with1 4562 3253 5554 2345 2226 8487 3958 2949 92010 53511 43212 123if I selected all the records for a year beginning Jan 1 and ending December 31Basically sum by month.I have been trying for about 2 hours different things, sub queries, group by having, without much luck.Can anyone give me an idea if this is even possible?TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf   WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: bug in <@URL> with null POST arguments?

[Jason Schulz]

Bill,Page 56 of O'Reilly's HTTP: The Definitive Guide has a nice little diagram of this.A results action that contains a request$httpheader followed by a blank line, followed by each of your arguments on a new line (or <@crlf> separated) in your preferred order would do.You would need to define request$httpheader, but that isn't hard.Regards,Jason.On 15/03/2006, at 9:51 AM, William M Conlon wrote:The packet analyser shows my post back is now the same as what paypal sends me, except for the order of the arguments.  Does anyone know how I can get them in actual order?WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Shopping Carts

[Jason Schulz]

you know, 'people who bought web carts also bought the following application servers'.J.On 18/02/2006, at 7:45 AM, Roland Dumas wrote:On Feb 17, 2006, at 11:53 AM, Dan Stein wrote: Does anyone have a list of eCommerce website running witango or at least afew with the more sophisticated web carts. Particularly interested in onesthat might have some up sell built in. up sell?TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf   WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Crontab Windows

[Jason Schulz]

i have crontab set up to * * * * * http://www.beepbeep.com/test.taf

But so far no go.


That should cause the cron job to be called every minute of every  
hour of every day of every month.


Can Witango resolve www.beepbeep.com to a host, and is test.taf  
available at the root of the website on that host?


Jason.


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

Re: Witango-Talk: help

[Jason Schulz]

...if you give us some details, we probably can.  :-)

J.


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

Re: Witango-Talk: State of the Union address

[Jason Schulz]

Phil,It's good to hear this, and best of all it doesn't sound as if you're too steamed up by it...J.On 25/10/2005, at 2:43 PM, Phil Wade wrote:Hi all.For those that do not read my essays - Witango Technologies remains profitable and is currently working on version 6 of the Dev Studio, Server and J2EE Framework which will be released in the future (no dates set yet).Many years ago when my life was simple and I was in primary school my School moto was "Truth Above All".  It sort of stuck with me over the years and I try to live to it the best I can.  The moto however regularly comes back to bite me in the ass as many people do not handle the truth all that well and to some people the truth just scares the hell out of them.  It is always interesting to see how people react to the cold hard truth but I think it is worth taking the risk to publicly let you know where we are today.  That being said, I will not be turning this topic into or participating in an open public forum on Witango Technologies Pty Ltd or Witango technology and its future features.  So do not try to read between the lines of the email - it simply is what it is, where we are today.So here is the naked truth ...Witango Technologies is a niche web middleware provider and as many of you know is not your typical US tech company operating by burning venture capital (aka MySQL and PHP) to build a brand that can some day be floated on a stock market to make it's investors rich or a multi billion dollar merger like Adobe/Macromedia.  Witango Technologies is an independent software developer run like any profitable business should be - profitably.We have watched the .com boom come and because we had good management and business practices we saw it go, along with many of our competitors who didn't.  I have an article I keep in my desk to remind me that we are a business foremost which happens to build software.  The 1998 article featured With Imagination (now Witango Technologies) and 5 other busineses that were amongst the premier Web Developers in Australia at the time based on clients and the size and complexity of the systems we built.  We were the only private company not running with venture capital and amazingly we are the only one still in business.We believe that stability and longevity is important to a customer when choosing a service or product regardless of whether it is software or some other product.  Customers like to know that whatever they choose will be available to them for the long term.  Witango Technologies has been in business for over 13 years and is planning on being in business for many more years to come.  We continues to power along thanks to the support of all of you and we continue to grow with a steady stream of sales from both current and new customers.  It was 4 years on June 30 2005 that we purchased T2K with all its warts, illnesses and cooperatively threaded secrets from Pervasive (I think we are approaching the time when WT will have owned the technology as long as Everyware had it) and it has at times been a bumpy ride but it is calmer waters ahead and smooth sailing from here.With 5.0 and 5.5 we added the most commonly requested features, updated to the latest standards and rewrote all the subsystems, plumbing and engine that runs Witango.  One of our early milestones was the eradication of Server Watcher (T2K's perceived stability) which we have aspired to replace with actual server stability.  I am not saying the server is perfect, but as those that send us their stack traces can verify, we prioritise fixing crashes above all other bugs, stability is priority #1.  A few of the subsystems that have been rewritten and replaced are the datasource pooling, ODBC interface, caching, SQL generator, XML parser, XML tags, tag processor, encoding subsystems, etc.  In the server we have also removed all dependancies on external libraries that are not open source and we now have a single common code base across all platforms.  All this has been in preparation for version 6 which we are currently working on and will be released in the future at the next Dev Conference (no dates set yet so please do not ask).  We now have a solid foundation for the server to build upon.The new Server 6 and J2EE Framework 6 will have many new features including a lot more actions and it will be based on unicode instead of assuming Latin-1 is the charset of the OS it runs on.  The new server will have new actions for Web Services, Reading Mail, Directory Manipulation, LDAP and TCFs have been enhanced to allow multiple classes per TCF as well as private TCFs that expose only the method interface and not the logic within them.  The builder actions have also been merged and enhanced.  It is not too late to ask for features so if you have an idea for a new action or tag let us know - log into the developer site, go to the Utilities and log a new feature.We are nearing the completion of a total rewrite of the Dev Studios for version 6 and has man

Re: Witango-Talk: State of the Union address

[Jason Schulz]

We are different companies. We do different things, have different staff, premises and owners. Our offices are five minutes walk from theirs though (North Sydney is a bit of an IT hub in Sydney).With Enterprise develops Witango, where as With IT Pty Ltd develops Witango solutions. With IT also owns the brand name 'With Imagination', so it shouldn't really be showing up on credit card transactions for With Enterprise - I'll take it up with Soph.Thanks,Jason.On 25/10/2005, at 7:37 AM, Scott Cadillac wrote:Hi Robert,I think you're right about With Imagination, I kinda forgot about that.There was a name change at some point. Anyway...Maybe they still share office space and few other things, or something, Iguess.-Original Message-From: Robert Garcia [mailto:[EMAIL PROTECTED]] HOWEVER, when Witango charges my credit card, it still says With  Imagination as company that charged me for the license. So go figure.  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Witango-Talk: [OT] FileMaker Devcon

[Jason Schulz]

I'm off to the FileMaker Devcon next week, if anyone else is going and would like to meet up, can you contact me offlist please.Regards,Jason.  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: mysql and witango

[Jason Schulz]

In general, you can't write a single SQL query that uses multiple databases. You can however write queries that use multiple tables. You haven't written why you need run the query across two databases or why those tables are in separate databases when they are going to be used together, so I'll leave that for another time and answer your question...There are two relatively simple ways to handle this, each with its own benefits and trade offs.You can copy the table of DB2 to DB1, and then run the query (excellent performance on the query, takes little time to migrate data for each execution, but no real change in execution time as data grows), or you can write two queries and merge them in Witango (quick performance on queries, quick and easy to get going, performance slows drastically as data grows beyond a couple of thousand rows due to repetition of queries).  For the SQL query you could use something like:SELECTt1.namet1.categoryt1.detailcount(t2.iddest) as 'Count'FROMdb1.table1 t1,db1.table2 t2WHEREt1.category = "A"AND t1.id = t2.iddestFor the Witango you could:1/ Query Table 1 for all category A records and assign to table_1_results2/ execute an <@rows> loop for each row in table_1_results and query table 2 for a count of records where iddest equals the id of the current row Regards,Jason.On 20/07/2005, at 5:00 AM, Isabelle wrote:Hi everybodyi have a problem of programmation and i don't know how to resolve it :i have 2 mysql db :DB 1)id : 1name : totocategory : Adetail : blueid : 2name : titicategory : Adetail : pinkid : 3name : rosiecategory : Bdetail : yellowid : 4name : petercategory : Adetail : yellowDB 2)id2 : 1iddest : 1idexp : 2catdest : Aid2 : 2iddest : 1idexp : 3catdest : Aid2 : 3iddest : 2idexp : 3catdest : Ai would like to list the first mysql db with criteria category = A. that is easy, but i wnat to list too the count of searches in db number 2 with the same category and iddest = the id of the first db...i don't know if my explication is easy to  understand.maybe an exemple  of the result i want :name  categorie  detail         counttoto        A        blue        2 (id2 = 1 +  id2 = 2)titi        A        pink        1 (id2 = 3)peter    A        yellow    0of course rosie isn't in the list because she is in category B.Anyone knows how to do that? is it possible ?thanksIsabelleTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf   WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Scopes Local and Request

[Jason Schulz]

Peter,Which plugin is being referenced in the website definition? (look in 'Properties/Home Directory/Configuration/Mappings') You can have any number of Tango/Witango application servers installed, but Witango code will only be executed if a request is delivered by the web server to the correct application server.Solving your problem of Witango 5.5 not working will probably be easier without T2K involved, but it can be done - the two of them aren't mutually exclusive. What are the errors that you get with Witango 5.5?Regards,Jason.When I installed 5.5, I was under the inpression that the installationprocess would somehow resolve the conflict caused by having two Tangoservers running. Apparently that is not the case.Now I am stuck. I do not know how to remove Tango 2000 Personal Server andconfigure 5.5 correctly. If I disable the Tang 2000 Personal Serverservice and restart my computer, 5.5 does not start correctly, producingmultiple messages visible in the Event Viewer.Help resolving this delima will be greatly appreciated.  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Other SF Project possibilities

[Jason Schulz]

Now I like open source as much as the next guy, but Oracle and MS SQL pay the bills.I'd ask for, and be happy to contribute for, Oracle, MS SQL and MySQL.Now I know that those first two are going to raise some hackles, but I do a lot of work in them. So how about we pick an SQL standard (SQL:2003, SQL200n etc), and reference that, rather than a specific implementation of an RDBMS?J.On 22/05/2005, at 10:30 AM, Bill Conlon wrote:Also, someone needs to choose the database(s) that would be supported, which I think should be open source as well.   WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: .NET vs Witango vs. Oracle

[Jason Schulz]

Robert,One of our larger customers gets regularly told by the company IT dept that our 'non-compliant' solution has to be redeveloped according to the company standard tools. Every single time they do this he tells them to do a cost benefit analysis of recoding, and Witango romps home. The solution only remains in place because it delivers value for the customer at a price that the other solutions can't match. Which at the end of the day, is what all solutions should be considered on (which they aren't, but more of that later). Our man has to defend the solution regularly, and he does, much to his credit. He could make his life considerably easier by letting IT have their way, but then he would have to spend more for less, and his end users/customers would suffer.We get customers and keep them because Witango lets us ordinary things on stunning timelines (swap those two around if you wish). It has an unusual risk profile because of this, but flip side is that big payoff. Our entry is often based on fulfilling a tactical goal (even when it apparently goes against strategic goals). Getting IT to see that Witango is not contrary to their strategic goals isn't easy, since the non-conformance judgement is usually emotionally based. Once we have a solution in place, IT have to change their SOE definitions to accept something that was illegal (or not explicitly permitted) when implemented, but is now OK. They _hate_ that. You've just shown them in front of the business that their SOE is wrong/incomplete, that they can't proactively enforce it, and that what is on the SOE isn't delivering what the business needs, all of which are core deliverables for IT.IT departments are conservative and untrusting, since getting it wrong can be expensive if not fatal for the company. So they get reassurance from second opinions. From what you've written, something needs to be done about educating those consultants and the opportunity is directly in front of them. FileMaker has faced the same issue for years and is making headway because it is great at what it does (killing workgroup flat file dbs written in Excel) and because they are been persistent.Regards,Jason.


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

Re: Witango-Talk: OSX 5.5 questions

[Jason Schulz]

Mark,This is from the Mac OS X Install guide.Start the Witango Server via the startup script sudo SystemStarter start WITANGO5 Stop the Witango Server via the startup script sudo SystemStarter stop WITANGO5 Regards,Jason.On 19/05/2005, at 3:34 PM, Mark Weiss wrote:Second Question: What lines to I type in terminal, to stop and restart the witango app server?  WITH IMAGINATION Planning, Implementation and Management of Web Applications   160 Pacific Highway North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770  web - www.wi.com.au email -  [EMAIL PROTECTED]  


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

Re: Witango-Talk: Zip Codes into a CSV Excel file

[Jason Schulz]

Steve,

Are the zip codes you are working with fixed length, or is the pad length (number of zeros on the front) fixed?

If you can generate an html file for Excel then CSS can be applied to tell Excel to treat the numbers correctly. If you want to stay away from styles, then 001 will force the Excel parser to treat the cell as if '001 had been entered manually. 

I know that I'm suggesting HTML as the internal format of the file when you are using CSV, but if you target is Excel and you want to preserve leading zeros into Excel, this is one way to do it.

Regards,

Jason.

PS: Tip o' the hat to Scott Cadillac for coming up with the original that this example is based on.



xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">





table

{

mso-displayed-decimal-separator:"\.";

mso-displayed-thousand-separator:"\,";

}

.zip_fixed_length

{

mso-number-format:"000-000";

}

.zip_fixed_pad

{

mso-number-format:'"000"#';

}





Zip

001
0877
012877
958877
1958877
NSW
0877
012877
958877
1958877
NSW





On 06/05/2005, at 3:18 AM, Fogelson, Steve wrote:

I am writing an array into a csv file with the following:
 
<@var request$Labels aprefix="" asuffix="" rprefix="" rsuffix="<@crlf>" cprefix="" csuffix=",">
 
Everything works great except when I open it with excel, it removes leading zeros for zip codes. Evidently it thinks it is a numeric field. If you open the csv file with NotePad, it is fine.
 
Any suggestions how to handle this?
 
Thanks
 
Steve Fogelson
Internet Commerce Solutions

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


WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: OSX 10.4, Dev Studio, ODBC DSNs

[Jason Schulz]

Admin != root, and root has the real rights.
Use sudo when you change httpd.conf, which does contain about two pages 
of comments at the start of it.

Once you go to tiger, the apple installer will rename your httpd.conf 
file to something like httpd.conf,applesaved and replace it with a new 
httpd.conf, so you will need to revisit your changes.

Regards,
Jason.
On 01/05/2005, at 12:27 PM, Steve Smith wrote:
I'm terrible at modifying files in Terminal. I'm trying to do a cp to 
make a backup of the httpd.conf file before I modify it and I'm 
getting permissions denied even though I'm the Admin user.

Also when I was able to open up the file using VI, all I saw were a 
bunch of comment lines, nothing that looks like configuration. Any 
ideas?

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

Re: Witango-Talk: Excel file?

[Jason Schulz]

Make sure that <@var request$exceldata encoding="none"> has something in it.

J.

On 22/04/2005, at 3:03 AM, Brian Domine ((bdomine)) wrote:

I am able to get an excel file created with nothing in it, but I am
obviously confused on how I populate the excel sheet with my array? Thanks,

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Client Error

[Jason Schulz]

Paul,

What happens with plain text or html files, are they served to the public or only to authorised users?
Is Witango defined as a Web Service Extension?
What are the settings in Web Site Properties>Directory Security?

J.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Witango 5.5 / JDBC / MySQL

[Jason Schulz]

What happens when you use a third tool to query the data - does the data returned to it match Witango or the MySQL CC? 

It's not clear from what you've written, but are you sure that MySQL CC is committing its transactions? 

J.

On 24/03/2005, at 10:11 AM, John McGowan wrote:

I think I may have stumbled across a problem with Witango, JDBC and MySQL

I was hitting a page in my application listing the contents of a table and it wasn't listing everything, specifically it wasn't listing the record that i had just manually added via the MySQL Control Center.  What I was able to determine was that it wasn't showing up because the JDBC connection was getting an Old snapshot of the data.  Probably because Witango began a transaction, but never commited it, thereby causing the connection in the pool to have an Old view of the database.

I confirmed this by hitting the page again after hitting another taf file that had actual begin and end transaction actions in it.  Now it shows the new data, but will not show newly added items.  I have to go pickup dinner for my family so I haven't had a chance to make a very simple test case to reproduce, but I will, and I just was wondering if anybody else out there is using this type of configuration Witango 5, JDBC, MySQL.

/John



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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Witango Server on OS X 10.3

[Jason Schulz]

Pain as in each of the components involved behave as if they are part of a dysfunctional project team where each member hoards what they know and won't lift a finger to do anything in case it results in someone else looking good to the PM.

Mac point and click? I'd settle for it _working_ like it does on windows. I don't mind using terminal and text files, so why tempt me with an ODBC utility breaks things and makes the whole process slower? Like I need a gui to give me six blank label/value pair fields when I can open the config file, copy the whole block and then change the three field values that need changing. 



J. 

On 21/03/2005, at 12:57 PM, Customer Support wrote:
Pain as in crashes all the time or pain as in Apple/OS X do not make it easy to configure them in a Mac point and click way?

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Witango Server on OS X 10.3

[Jason Schulz]

I'll second data sources as a source of pain. We only have one OS X server box in production at a customer site with light traffic though.

Regards,

Jason.

On 21/03/2005, at 11:45 AM, Wayne Irvine wrote:
Customer Support at [EMAIL PROTECTED] wrote:
Can any OS X 10.3 users that have experiences where "Witango crashes a
lot" please contact us off or on list if you prefer.

I had heaps of problems but some judicious work on my datasources and a
defibrillator style script triggered by the cron and we're running nicely.



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Auto a href

[Jason Schulz]

On a more useful note that my previous:

<@assign request$str "visit http://www.google.com/modules/default.taf now">
<@assign request$expr "http?://[^ ]*">
<@regex str="@@request$str" expr="@@request$expr" type="e">

will return 

http://www.google.com/modules/default.taf

Since the expression is looking for the first space to terminate the url, it will include any punctuation (think url at end of sentence, the full stop will be included) and if the url spans multiple lines, the line returns will also be included.

J.


On 16/02/2005, at 11:39 PM, [EMAIL PROTECTED] wrote:

The challenge is to find the string that represents an URL, which begins
with http:// and ends with the first space after that.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Auto a href

[Jason Schulz]

I found the expression below at 
http://www.foad.org/~abigail/Perl/url3.regex

You can read the story of it at 
http://www.foad.org/~abigail/Perl/url2.html.

I haven't tested it, because I think it's pathological enough to get 
posted as is!

J.
Think this came up once before. Worth a look through the archives.
The challenge is to find the string that represents an URL, which 
begins
with http:// and ends with the first space after that.

Tricky.
(?:http://(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.
)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)
){3}))(?::(?:\d+))?)(?:/(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F
\d]{2}))|[;:@&=])*)(?:/(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{
2}))|[;:@&=])*))*)(?:\?(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{
2}))|[;:@&=])*))?)?)|(?:ftp://(?:(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?
:%[a-fA-F\d]{2}))|[;?&=])*)(?::(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-
fA-F\d]{2}))|[;?&=])*))?@)?(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-
)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?
:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?))(?:/(?:(?:(?:(?:[a-zA-Z\d$\-_.+!
*'(),]|(?:%[a-fA-F\d]{2}))|[?:@&=])*)(?:/(?:(?:(?:[a-zA-Z\d$\-_.+!*'()
,]|(?:%[a-fA-F\d]{2}))|[?:@&=])*))*)(?:;type=[AIDaid])?)?)|(?:news:(?:
(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;/?:&=])+@(?:(?:(
?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[
a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3})))|(?:[a-zA-Z](
?:[a-zA-Z\d]|[_.+-])*)|\*))|(?:nntp://(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[
a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d
])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?)/(?:[a-zA-Z](?:[a-zA-Z
\d]|[_.+-])*)(?:/(?:\d+))?)|(?:telnet://(?:(?:(?:(?:(?:[a-zA-Z\d$\-_.+
!*'(),]|(?:%[a-fA-F\d]{2}))|[;?&=])*)(?::(?:(?:(?:[a-zA-Z\d$\-_.+!*'()
,]|(?:%[a-fA-F\d]{2}))|[;?&=])*))?@)?(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a
-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d]
)?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?))/?)|(?:gopher://(?:(?:
(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:
(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+
))?)(?:/(?:[a-zA-Z\d$\-_.+!*'(),;/?:@&=]|(?:%[a-fA-F\d]{2}))(?:(?:(?:[
a-zA-Z\d$\-_.+!*'(),;/?:@&=]|(?:%[a-fA-F\d]{2}))*)(?:%09(?:(?:(?:[a-zA
-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;:@&=])*)(?:%09(?:(?:[a-zA-Z\d$
\-_.+!*'(),;/?:@&=]|(?:%[a-fA-F\d]{2}))*))?)?)?)?)|(?:wais://(?:(?:(?:
(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:
[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?
)/(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))*)(?:(?:/(?:(?:[a-zA
-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))*)/(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(
?:%[a-fA-F\d]{2}))*))|\?(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]
{2}))|[;:@&=])*))?)|(?:mailto:(?:(?:[a-zA-Z\d$\-_.+!*'(),;/?:@&=]|(?:%
[a-fA-F\d]{2}))+))|(?:file://(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]
|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:
(?:\d+)(?:\.(?:\d+)){3}))|localhost)?/(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'()
,]|(?:%[a-fA-F\d]{2}))|[?:@&=])*)(?:/(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(
?:%[a-fA-F\d]{2}))|[?:@&=])*))*))|(?:prospero://(?:(?:(?:(?:(?:[a-zA-Z
\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)
*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?)/(?:(?:(?:(?
:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:@&=])*)(?:/(?:(?:(?:[a-
zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:@&=])*))*)(?:(?:;(?:(?:(?:[
a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:@&])*)=(?:(?:(?:[a-zA-Z\d
$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:@&])*)))*)|(?:ldap://(?:(?:(?:(?:
(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:
[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?
))?/(?:(?:(?:(?:(?:(?:(?:[a-zA-Z\d]|%(?:3\d|[46][a-fA-F\d]|[57][Aa\d])
)|(?:%20))+|(?:OID|oid)\.(?:(?:\d+)(?:\.(?:\d+))*))(?:(?:%0[Aa])?(?:%2
0)*)=(?:(?:%0[Aa])?(?:%20)*))?(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F
\d]{2}))*))(?:(?:(?:%0[Aa])?(?:%20)*)\+(?:(?:%0[Aa])?(?:%20)*)(?:(?:(?
:(?:(?:[a-zA-Z\d]|%(?:3\d|[46][a-fA-F\d]|[57][Aa\d]))|(?:%20))+|(?:OID
|oid)\.(?:(?:\d+)(?:\.(?:\d+))*))(?:(?:%0[Aa])?(?:%20)*)=(?:(?:%0[Aa])
?(?:%20)*))?(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))*)))*)(?:(
?:(?:(?:%0[Aa])?(?:%20)*)(?:[;,])(?:(?:%0[Aa])?(?:%20)*))(?:(?:(?:(?:(
?:(?:[a-zA-Z\d]|%(?:3\d|[46][a-fA-F\d]|[57][Aa\d]))|(?:%20))+|(?:OID|o
id)\.(?:(?:\d+)(?:\.(?:\d+))*))(?:(?:%0[Aa])?(?:%20)*)=(?:(?:%0[Aa])?(
?:%20)*))?(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))*))(?:(?:(?:
%0[Aa])?(?:%20)*)\+(?:(?:%0[Aa])?(?:%20)*)(?:(?:(?:(?:(?:[a-zA-Z\d]|%(
?:3\d|[46][a-fA-F\d]|[57][Aa\d]))|(?:%20))+|(?:OID|oid)\.(?:(?:\d+)(?:
\.(?:\d+))*))(?:(?:%0[Aa])?(?:%20)*)=(?:(?:%0[Aa])?(?:%20)*))?(?:(?:[a
-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))*)))*))*(?:(?:(?:%0[Aa])?(?:%2
0)*)(?:[;,])(?:(?:%0[Aa])?(?:%20)*))?)(?:\?(?:(?:(?:(?:[a-zA-Z\d$\-_.+
!*'(

Re: Witango-Talk: compound CDelim value

[Jason Schulz]

We've used '' in cdelim without difficulty on 5.0.1.065 in the past. 

Jason.

On 15/02/2005, at 9:33 AM, MJPinckard wrote:
The default delimiter used for CDelim is a comma. I know it is possible to use another value (a "*" for example) instead of the comma. Is it possible to use a specific set of characters (instead of just one single character) as a delimeter in the cdelim paramter?

For example could I use the string "*|" instead of just "*" or "|"?


WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Writing & Reading Metagtags

[Jason Schulz]

Aha. Thanks.
J.
On 01/02/2005, at 2:38 PM, Scott Cadillac wrote:
Hi Jason,
Try putting everything inside an <@LITERAL> metatag.
Hope this helps

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

Witango-Talk: Writing & Reading Metagtags

[Jason Schulz]

I have a tml file that I write to disk via Witango that contains the meta tag <@CGIPARAM name='SERVER_NAME'>, amongst others.

How can I escape the tag so that it is only evaluated by Witango when the file is served to the user, and not evalutated when the file is written to disk?

Thanks,

Jason.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Download to excel

[Jason Schulz]

If you pass Excel your data in a table layout, of valid html, and tell it that the file extension is '.xls' in the headers, Excel's parser will do the rest.

If you want styles, you will needs to do things locally (ie, within each table cell), as it doesn't get style sheets. 

J.

On 01/02/2005, at 12:58 PM, Roland Dumas wrote:

There is a nice taf in the component zone that shows how to download a
result set into an excel file.

What's the format of the resultset that will cause each field to fall into a
column and for each row to fall into an excel row?




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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: DBMS vs. Search action

[Jason Schulz]

You may get some mileage out of passing the query through the query optimiser for your rdms, as it can report on execution times and what will give a better result after indexing etc has been applied. 

J.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Re: [OT]mysql logs

[Jason Schulz]

Is the log being created by MySQL or by ODBC?
J.
On 05/01/2005, at 11:02 AM, Roland Dumas wrote:
Does anyone know how to manage these things?

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

Re: Witango-Talk: URGENT: MS-SQL hanging -processnon-yielding

[Jason Schulz]

What, if anything, is the dbms logging while this is happening?
J.
On 10/12/2004, at 10:07 AM, Dave Machin wrote:
[Warning] Existing data source no longer alive, disposing...
I literally got hundreds of these messages (logging level is set to 3) 
and
the server was only up from 13:39:09 through 13:53:14

Why should a data source expire that often given our datasourcelife 
setting?
Or does this message mean something else?


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

Re: [spam?] Re: Witango-Talk: URGENT: MS-SQL hanging - processnon-yielding

[Jason Schulz]

Dave,

Can you tell us a little about what the query is trying to achieve, as it should probably be re-written to optimise it a little.

Jason.

On 10/12/2004, at 8:04 AM, Dave Machin wrote:

The 150K is the size of the query itself not the results.  I've attached it.
However, even after this .taf was disabled the site became unresponsive
after about an hour.  So, it may have nothing to do with it.  I am worried
about the number of new database connections that get made - we seem
to average one or two per second.


WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Witango 5.5 encoding

[Jason Schulz]

 Is there a server setting, such as OldEncoding = true or some other method of working with the same application on both versions simultaneously? Is this possible?
Chuck,

Set up the witango.ini file with some custom system configuration variables as appropriate on each server.

ENCODINGNONE=NONE
ENCODINGMETAHTML=METAHTML
etc...

Then in your code use ...encoding='@@system$encodingmetahtml'...

It's a bit of a kludge, but easy to get working via search and replace in your code, will work server wide and you don't need to do any version detection. You also don't have to bother with any startupurls or assigns within lesser scopes.

J.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Editor forgetting registration and preferences

[Jason Schulz]

Check the application privileges. Which user ran the install?

You may also need to repair privileges using the disk utility.

J.

On 25/10/2004, at 11:35 AM, Wayne Irvine wrote:

I fired up Witango Editor Lite on one of our OS X workstations the other day
and it had forgotten its registration. I looked it up and re-entered it and
it ran fine but seemed to have forgotten preferences.

I edited the prefs a bit but couldn't seem to apply a decent colour for
comments, nor would it remember the settings after quit.

I assumed the prefs were corrupted but deleting them and re-registering
didn't change anything.

I'm currently downloading another copy but has anyone seen this problem
before and is there a known cause/solution?

Wayne Irvine

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


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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: scroll mouse - OS X

[Jason Schulz]

Got a couple of different wheel mice (logitech/microsoft) that get used depending on where the laptop (10.3.5) is, and none of them will scroll in studio 5.5.

Not scrolling, forgetful column widths, and having to single click, pause, then click+hold to drag are my pet peeves for studio on os x.

J.

On 28/08/2004, at 4:08 PM, Jonah Simpson wrote:

Hey All!

Anybody had problems with scroll mice in both 5.0 and 5.5 in OS X
10.3.5? I bought myself a nice little wireless, two-button mouse with
a scroll wheel, and while it scrolls a window for every other
application, it doesn't do it for the WiTango studio.

Not a big deal, but if anybody knows any tricks to make my mouse wheel
work in the studio I'd love to hear them.

Cheers,
Jonah Simpson

PS-Sorry Apple, the one-button, no scroll-wheel mouse is dead. Get over it. ; >

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Large data exports with WiTango

[Jason Schulz]

Dave,

You don't want 1,000,000 rows being returned to resultset. You can use custom sql to create an 'export' table with as many columns as is required, plus an export_status column. Use a second query to fill the table with the required data. Within a transaction block, retrieve 1 records, mark the export_status column, and close the transaction block. Write the data to disk Repeat. The number of records you retrieve will need to be tuned to the capabilities of the server.

It may be suitable to consider a cron job that runs every few minutes and builds the file and when the export table is completely exported, send an email to the user to say the file is ready for pickup. Alternatively, have the user sit on a page that refreshes every so often with the file size/ export progress. In general, once the chunks of data that you are processing get 'large', you need to move users expectations away from 'on demand' (ie, within 20 seconds), and towards scheduled processing. It also helps to not make the server totally unresponsive for other users. 'Large' is just a little more than what the server can cope with while still meeting service levels.

Be aware of your settings for QUERYTIMEOUT and ITEMBUFFERSIZE.

You can also use the various bulk export/import utilities to handle the movement of the data out the database to the file system. You won't be able to do any processing of the data though. Once you have a file in the file system, it should be trivial for the user to download it.

On MS SQL you have either BCP or DTS Import/Export, and on Oracle, SQL Loader.

Use a batch file to call the utility, and once it has returned, you can then update the user's html page.

Regards,

Jason.

On 19/08/2004, at 10:24 AM, Dave Machin wrote:

I need to write a witango app to export a data set of unknown size and width.  I'm expecting that the export might be 100,000 to 1,000,000 rows and 20 to 40 columns.  The client wants an online application to use to request the data and then have the resulting .csv file download to his/her computer.

I would like to write an application that could wait indefinitely for the export to be completed by the database (giving the user an option to cancel waiting) and when the export completes the application points the browser to a URL of the exported data.  Has anyone done anything like this before? 


Dave Machin 


E-Mail. [EMAIL PROTECTED]
Tel.  805.614.0123 x 30
Address: 3201 Airpark Drive, Suite 104
Santa Maria, CA 93455TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Rounding

[Jason Schulz]

I didn't know of precision until you pointed it out, and even then when I read the following in the programmers guide, I thought of truncate rather than rounding. 

 The optional PRECISION attribute is an integer that controls the number of decimal places displayed in the result. The default precision is the maximum required for accuracy of the result.

But still, two rounding methods are better than none.

J.

On 06/08/2004, at 1:50 PM, John McGowan wrote:
That's kind of a "hack" There is a more appropriate way of doing that using the "precision" attribute.

I think <@CALC expr="expression" Precision="0"> is what you want

the precision attribute specifies the number of decimal places, so I'm pretty sure you would use 0 to round to the nearest integer...

I use it all the time when calculating monetary values with precision=2

/John

Jason Schulz wrote:
Works like a charm.

Thanks,

J.

On 06/08/2004, at 11:42 AM, Bill Downall wrote:
On 6 Aug 2004 at 11:36, Jason Schulz wrote:

Is there a tag/expression that will round a number in the normal
manner (ie, if >=0.5, round up, if >0.5 round down)?

@calc ceil will force round up, and @calc floor will force round down,
but I need the traditional rounding.

Jason,

Try @CALC floor of (value + .5)

Bill

Re: Witango-Talk: Replace special characters in a resultset

[Jason Schulz]

John,

You can use @regex to locate the invalid characters (I'm assuming you only want US/ASCII), do a distinct on the returned matching characters, then use the resulting array with @replace to clean them up.

You would have to loop, but only once for each invalid character, and not for each time that character appears in the resultset.

Is the result set unicode or just high ascii? There are conversion routines for the databases that would probably solve this better...

Regards,

Jason.
On 06/08/2004, at 9:32 AM, John Newsom wrote:

We have a resultset from a sql server query that contains foreign
letters such as umlauts, etc.  These are fouling up our active
directory.  We'd like to do a search and replace on the resultset.  It
there a way to replace all occurances in an entire result at once
without doing iterations, or rows loops?

Thanks,

John Newsom
Lakeside School

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Array Subsets

[Jason Schulz]

@for isn't that bad.
If @filter doesn't do what you want, use @delrows.
It'd be nice if @@request$variable[x,y] could accept lists for x or y,  
or if @filter exp would accept #0

J.
On 06/08/2004, at 10:20 AM, Wayne Irvine wrote:
Is there a simple way of assigning a subset of an array to a new array?
Suppose I have an array that contains 100 records and I wish to make a  
new
array containing the first 3.

Or conversely, just use the first three records?
Only way I know of is to use a FOR loop and CURROW as the row number.  
Is
there an easier way? I hate writing clunky code.

Wayne Irvine
  Byte Services Pty Ltd
   http://www.byteserve.com.au/
  [EMAIL PROTECTED]
   Ph 02 9960 6099   Mob 0409 960 609   Fax 02 9960 6088
___ 
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



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

Re: Witango-Talk: datetime formatting

[Jason Schulz]

Try writing a hard coded date query and once that works, use the format arguments to format @arg accordingly.

I haven't used Crystal Reports, but a common date format in queries is -MM-DD, rather than MM/DD/.

Jason.

On 03/08/2004, at 3:01 AM, Barbara McCormick wrote:

Hello,

I need to send a datetime variable from Witango to a crystal report based on a stored procedure.

Can you help me out?

I’ve tried many variations of

@startdate=<@DQ><@arg NAME='startdate' Format='datetime:%m/%d/%Y %H:%M:%S'><@DQ>

 

Can you please help me with the formatting of this?

Barb

 

Barbara McCormick

MIS Department/Extranet

Capital Pacific Homes, Inc.

480-777-2400

[EMAIL PROTECTED]

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Mail Attachments

[Jason Schulz]

T2K won't parse a single variable with multiple rows on its own, so @@local$attachments as a single entry in the attachments section of the mail action won't work.

However, you can use the format @@local$attachments[n,1] in each line of the attachments section (where n is from 1 to as many attachments as you think you'll ever send).

If, for example, the @@local$attachments only has two rows, T2K will log an error about not finding attachments 3, 4, 5, 6... but the mail will go out with the defined attachments.

J.


On 31/07/2004, at 2:39 AM, Witango wrote:

I will try this.

Thanks so much Roland.

- Vic

-Original Message-
From: Roland Dumas [mailto:[EMAIL PROTECTED] 
Sent: July 30, 2004 12:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Mail Attachments

attaching an arbitrary number is a little more difficult.

Maybe creating a routine that actually writes a taf and then calls it. 
You'd write the XML and the <@rows Array=xxx> writes the parameterItem 
list. Then the next step calls this taf.  a bit of a kludge, but you'd 
end up with the ability to have a variable number of attachments.




[EMAIL PROTECTED]
[EMAIL PROTECTED]
subject line

text/plain
iso-8859-1
72

file1.txt
file2.txt














On Jul 30, 2004, at 9:09 AM, Witango wrote:

So would W5 let me somehow loop through an array 'n' number of times 
and
attach 'n' number of files within a single mail action? If yes, I will
upgrade.

Re: Witango-Talk: Formatting HTML Output

[Jason Schulz]

CSS has a page break property to do this.

http://www.codeave.com/css/code.asp?u_log=4016 has a nice sample.

http://www.w3.org/TR/REC-CSS2/page.html#page-breaks has all the dirty details.

J.

On 30/07/2004, at 12:36 PM, <[EMAIL PROTECTED]> wrote:

Right, but how can you format this so that it prints out 
nicely without a row or rows being truncated by the margin at 
the bottom/top of a page boundary.  The .css stylesheet seems 
to be the way to go, but I have never used them.


 Original message 
Date: Thu, 29 Jul 2004 20:04:44 -0600
From: "Troy Sosamon" <[EMAIL PROTECTED]>  
Subject: RE: Witango-Talk: Formatting HTML Output  
To: <[EMAIL PROTECTED]>

Take a look at help for @rows @cols @col.
I would do it like this with your result set.

I replaced the opening angles brackets with square ones so 
the e-mail will
display the html.

[Table>	-- start the table
[EMAIL PROTECTED]>	-- loop through the rows from your result set
[tr> 		-- start the row
[EMAIL PROTECTED]>	-- loop through the columns
[td>[EMAIL PROTECTED]>[/td>-- put each column in a td
[/@cols>
[/tr>
[/@rows>


This will put your output into a table.

Troy


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
it.com] 
Sent: Thursday, July 29, 2004 7:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Formatting HTML Output

That appears to be where I should be headed; for a simple 








setting which gets automatically generated in Witango, how 
do 
you integrate what is being discussed in the URL you gave?  
My HTML and CSS skills are weak... an example is worth a 
1000 
words!


 Original message ----
Date: Fri, 30 Jul 2004 11:12:25 +1000
From: Jason Schulz <[EMAIL PROTECTED]>  
Subject: Re: Witango-Talk: Formatting HTML Output  
To: [EMAIL PROTECTED]

Depending upon the browser in use, you could define a print 
stylesheet.  
 has 
more.
J.


On 30/07/2004, at 11:03 AM, <[EMAIL PROTECTED]> 
wrote:
Nope, its not a timeout issue at all.  Its just that if 
the
HTML report has 25 or more rows and spans a couple of 
pages,
then the print out chops up some of the output.  I was
wondering if there is some easy technique to make the 
HTML
data print out nicer from a cosmetic point of view.


 Original message 
Date: Thu, 29 Jul 2004 18:23:05 -0600
From: "Troy Sosamon" <[EMAIL PROTECTED]>
Subject: RE: Witango-Talk: Formatting HTML Output
To: <[EMAIL PROTECTED]>

Sounds like maybe a datasource timeout issue.



If it always cuts off at exactly 25 rows, I would go
in and look at how the command was done, maybe there
is something controlling paging and only selecting
25 rows.



Troy





From: Jason Schulz [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Formatting HTML Output



Is this in a browser, a report downloaded in exce,
or a printed page?

(I'm not going to mention the scrollbar...)

J.

On 30/07/2004, at 12:47 AM,
<[EMAIL PROTECTED]> wrote:

Hello.

We have a client who is complaining that reports
generated from Witango
are getting clipped at the bottom of page when the
table output exceeds 25
rows or more. Is there a simple way to control this?

Tom Roberts

Re: Witango-Talk: Formatting HTML Output

[Jason Schulz]

Depending upon the browser in use, you could define a print stylesheet.  has more.

J.


On 30/07/2004, at 11:03 AM, <[EMAIL PROTECTED]> wrote:

Nope, its not a timeout issue at all.  Its just that if the 
HTML report has 25 or more rows and spans a couple of pages, 
then the print out chops up some of the output.  I was 
wondering if there is some easy technique to make the HTML 
data print out nicer from a cosmetic point of view.


 Original message 
Date: Thu, 29 Jul 2004 18:23:05 -0600
From: "Troy Sosamon" <[EMAIL PROTECTED]>  
Subject: RE: Witango-Talk: Formatting HTML Output  
To: <[EMAIL PROTECTED]>

Sounds like maybe a datasource timeout issue.



If it always cuts off at exactly 25 rows, I would go
in and look at how the command was done, maybe there
is something controlling paging and only selecting
25 rows.



Troy



----

From: Jason Schulz [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Formatting HTML Output



Is this in a browser, a report downloaded in exce,
or a printed page?

(I'm not going to mention the scrollbar...)

J.

On 30/07/2004, at 12:47 AM,
<[EMAIL PROTECTED]> wrote:

Hello.

We have a client who is complaining that reports
generated from Witango
are getting clipped at the bottom of page when the
table output exceeds 25
rows or more. Is there a simple way to control this?

Tom Roberts

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

WITH IMAGINATION
Planning, Implementation and Management of Web
Applications

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web - www.wi.com.au email - [EMAIL PROTECTED]


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

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Formatting HTML Output

[Jason Schulz]

Is this in a browser, a report downloaded in exce, or a printed page?

(I'm not going to mention the scrollbar...)

J.

On 30/07/2004, at 12:47 AM, <[EMAIL PROTECTED]> wrote:

Hello.

We have a client who is complaining that reports generated from Witango 
are getting clipped at the bottom of page when the table output exceeds 25 
rows or more.  Is there a simple way to control this?

Tom Roberts

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Maximum field length

[Jason Schulz]

I don't think they are the same - or they didn't use to be in T2K. I haven't explicitly checked this in W5, but variables effectively have an unlimited size. I've frequently read files into a variable that are several mb in size. 

<@varinfo> will return the size of a variable. What encoding is being used?

Regards,

Jason.

On 24/07/2004, at 6:25 AM, Ben Johansen wrote:

Yes

 

Ben Johansen - http://www.pcforge.com
 Authorized Witango & MDaemon Reseller
 Available for Witango Developement

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
 Sent: Friday, July 23, 2004 1:15 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Maximum field length

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

-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 4:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Maximum field length

Check the configuration variable

itemBufferSize System scope only

 Specifies the size, in bytes, of the largest column value that can be retrieved from a data source. You need to increase this value only if you need to retrieve large values. The default value is  (64K).

    Ben Johansen - http://www.pcforge.com
 Authorized Witango & MDaemon Reseller
 Available for Witango Developement

-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
 Sent: Friday, July 23, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Maximum field length

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

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

   Thanks for your reply. Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida  32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED]  
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

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

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


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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: [OT] RSS primer please

[Jason Schulz]

Roland,

http://www.diveintomark.org/ may have something to interest you - this guy has had a bit to do with Atom, which tries to unify the various feed standards.

Regards,

Jason.


On 09/07/2004, at 10:27 AM, Scott Cadillac wrote:

Hi Roland,

RSS is the XML format used to describe Weblog content.

Here is some code:

http://witango.org/webpage.taf?show=code

And here is some info:

http://xmlx.ca/category/25.aspx

Note: there is no one single source for definitive RSS standards - they
vary.

Hope this helps.

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

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

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

IExtranet ~ http://iextranet.ca
Witango ~ http://witango.org
EasyXSLT ~ http://easyxslt.ca
IIS Watcher ~ http://iiswatcher.ca

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


-Original Message-
From: Roland Dumas [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 08, 2004 6:14 PM
To: WiTango List
Subject: Witango-Talk: [OT] RSS primer please

I'm seeing chatter about RSS and don't know what it is other 
than some kind of summary news feed. Anyone here have a 
primer on what it is, format and perhaps witango approach to creating?

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




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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Tango to Witango conversion

[Jason Schulz]

The 'Witango Server 5 What's New pdf' has details on the changes between Witango 5 and Tango2000.

It isn't a checklist as such, but it is comprehensive.

Jason.

On 23/06/2004, at 4:14 AM, Wilcox, Jamileh (HSC) wrote:

I swear I remember a guide for converting apps that Phil had on the website (it was something like a list of things to remember & doublecheck) that was mentioned here.  But I can't find it on the website nor any mention in the list archives.

Does anyone have a link to this, or did I hallucinate the whole thing? 

Thanks. j 

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: DBMS Action Select with Limit # or Rows

[Jason Schulz]

Steve,

You are probably better doing this with a custom SQL action. What SQL server are you using?

J.


On 09/03/2004, at 3:12 PM, Fogelson, Steve wrote:

I am trying to construct a DBMS Select action that will limit the number of
rows retrieved.


WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Dev studio on Panther

[Jason Schulz]

You might want to send an email to witango support. Panther seems to have moved a number of things around - Phil wrote about the changes a while ago:

On Oct 24, 2003, at 5:02 PM, Phil Wade wrote:

There have been some significant changes under the hood especially in term
of extra libraries, api calls, file permissions and the way permissions of a
process are handled.  You can install the Dev Studio 5.5 on Panther and the
installer will work.  The journey to the Panther release version saw the
installed Dev Studio work on some seeds and not on others.  The 5.5.3 build
does work on Panther but you have to play with the permissions to allow the
app to create the initial preference files.  We are just finalizing an
installer that will sense the OS X version and install with different
privileges and user/group for Jaguar and Panther.

This is just from my own personal experience but you would have to be brave
to use Panther on a production system at this stage.  I think that Panther
was released a little prematurely to be able to get it on machines for the
Christmas buying season.  I would be waiting for the first or second update
which I think will be released quite quickly.

Phil


On 23/01/2004, at 10:46 AM, Trevor Green wrote:

Hi

I have just switched platforms, because where I work now use Macs. I have a virgin install powerbook with 10.3.2 and tried to install the 5.0 Dev studio. When I try and launch the dev studio I get the dreaded “The application Witango Dev Studio 5.0 has unexpectedly quit”.

Does Dev Studio 5.0 work on Panther? If so any ideas on what the problem could be?
 
Trevor Green



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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: (OT) Website Statistics

[Jason Schulz]

Webtrends, which reports everything but takes pricing to a new level, so we only use it for a couple of sites. For others analog is useful.

Jason.

On 14/01/2004, at 11:10 AM, Robert Shubert wrote:

I've been looking at http://www.urchin.com/ but I haven't purchased it
yet.

-Original Message-
From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 6:54 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: (OT) Website Statistics

That does look terrific.  A bit pricey for us, but maybe someday...

-Original Message-
From: Tom Ferguson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 4:57 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: (OT) Website Statistics


I've used a product called Live Stats from a Canadian company 
named Media House for years.  It is rock solid, accurate, and 
their tech support is superb.

www.mediahouse.com


-Original Message-
From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 5:28 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: (OT) Website Statistics


I think this has been discussed before, but I've not found it in the 
archives.

What are youse guys using to track your web statistics?  I need to set

up to look at hits per site, per page, browser types, etc.

Thanks.

jamileh


__
__
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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: updating a field whose name contains a space

[Jason Schulz]

If the update action isn't quoting the field name, you may need to write a custom SQL action for the update so that you can explicitly quote the field name.

J.
On Thursday, Dec 11, 2003, at 10:50 Australia/Sydney, Barbara McCormick wrote:

Hello,

I have Witango 5 application that displays data from a table using the results from a search action in a form. One of the field names in this table contains a space: ‘Home Address’. The data displays correctly, but won’t update. I get an invalid syntax error on that field.

I’ve dragged that field over from the table(under datasources) into an update action. If I view that update as a SQL query, the statement in questions appears  as 

 home Address='<@arg homeaddress>'  

 

In debug, I get an invalid syntax error and this is how the field displays in the query statement

  Address='30024 Live Oak Trail'

How do I get this field name quoted in an Update Action, so it will recognize the space in the field name?

Thank you very much.

 

Barbara McCormick

Capital Pacific Homes, Inc.

[EMAIL PROTECTED]

480-777-2400 ext 211

 



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: <@RELOADCONFIG>

[Jason Schulz]

The ini file should only be edited while the server is stopped. While it is running, it can and does change the ini file contents.

STARTUPURL is in the SYSTEM and APPLICATION scopes, and so can be updated with an assign - you will need the CONFIGPASSWORD to do it though.

J.

On Thursday, Dec 11, 2003, at 11:01 Australia/Sydney, Storey, Paul wrote:

It seems that the application is writing its current settings to the ini
file before it reloads.  Am I creating this problem by editing the ini file
using notepad.
The only solution that I can think of is to stop the witango process, make
the change in the ini file, and then restart the witango process.

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Variable/String Limits

[Jason Schulz]

I have a feeling that a variable is only limited by available memory. I say this having read in files over 2MB into variables.

I'd also recommend not reading big files into variables if you can avoid it :)

J.

On Thursday, Dec 11, 2003, at 10:00 Australia/Sydney, Scott Cadillac wrote:

From the Manual, for ItemBufferSize:

-
"Specifies the size, in bytes, of the largest column value that can be
retrieved from a data source. You need to increase this value only if you
need to retrieve large values. The default value is 65535 (64K)."
-

This "ItemBufferSize" limitation is specifically about how much data can be
retrieved from a single column (cell) from a datasource lookup.

If this is how you are supplying the string value for your variable, then
this is the setting. 

But...if you are supplying the string value from some other process, then
the variable store size is not limited by, or associated with, this setting.
So, if there is a limit, then it is controlled by something else.

Hope this helps. Cheers.

Scott Cadillac,
Witango.org - http://witango.org
403-281-6090 - [EMAIL PROTECTED]
--
Information for the Witango Developer Community
-

XML-Extranet - http://xmlx.ca
403-281-6090 - [EMAIL PROTECTED]
--
Well-formed Development (for hire)
-


-Original Message-
From: Stefan Gonick [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 10, 2003 3:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Variable/String Limits

I may be wrong, but I think that it is the same as the 
configuration variable called "ItemBufferSize", which is 
defaulted to 64K.

Stefan

At 05:24 PM 12/10/2003, you wrote:
Does anybody know how many characters a variable can hold in 
Tango 2000 
or Witango 5? In other words, what is the maximum string 
size possible? 
I can't find any references in the manuals, but my tests so 
far shows 
that it is quite large.

Thanks in advance!

Erik

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


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

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



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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Losing E-mail Text

[Jason Schulz]

where in the email is the period lost from?

A single period on a line of its own indicates the end of the message body. RFC 822, amongst others, will give you the full story. Witango Man is right though - if you set an encoding for the message, it should help.

J. 


On Tuesday, Dec 9, 2003, at 09:34 Australia/Sydney, witango man wrote:

What type of encoding (if any) do you have on the
message body?

Also are you sending the mail as Plain Text or HTML
(set within the options tab...)


--- "Vlasse, Alex" <[EMAIL PROTECTED]> wrote:
I was hoping someone would be able to help me with
this problem. I've got an
action reminder taf file set to run every night. In
it I've hard coded a URL
into an e-mail and it works fine for almost all the
e-mails sent out by this
taf file. However there are a few emails which are
sent out that the URL
loses a ".". This is a very consistent problem as
the same people always
have the "." missing.



Does anyone have any idea what the problem could be?



I'm using Tango 2000, the emails are going to people
using Mac's and PC's
with the PC's running Windows 2000 (I don't know
about the Mac's). I don't
know what type of email server is being used, but I
do know that the emails
have lost the text before being received by any the
recipient email server.
The emails are Bcc to me and they also contain
broken links so I assume the
email is losing the "." before being sent out be the
sending mail server.



Any help with this problem would be appreciated,

Alexander




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


__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

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



WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Serial number for OS X Server 5.0.1.065

[Jason Schulz]

Eric,

You don't need to apply for a serial number for the server. It will  
generate a 30 day serial number for itself if a valid serial number is  
not found in the witango.ini file.

When the server runs with a self generated serial number, you will get  
the following at the bottom of all your pages:

This page was served by an unregistered version of
Witango Server
   Witango Technologies Pty Ltd
 www.witango.com
At the end of the thirty days you will get the following message:

Application server not licensed
The license for this server is invalid or has expired. Please stop the  
server and enter a valid license in the LICENSE line of the server's  
configuration file.
Regards,

Jason.

On Tuesday, Nov 25, 2003, at 05:45 Australia/Sydney, Eric Weidl wrote:

Hi,

I recently downloaded and installed the .065 server preview for OS X.  
I tried to apply for a 30 day serial number, but the only option on  
the form is for OS X Studio.

Can someone update the form to allow me to request a serial number for  
.065 or tell me how I can get one? Also, can anything be done to speed  
up the serial number generation process? The current licensing process  
is frustrating.

Eric

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


WITH IMAGINATION
Planning, Implementation and Management of Web Applications
160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web - www.wi.com.au email -  [EMAIL PROTECTED]

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

Re: Witango-Talk: upgrade issues.

[Jason Schulz]

test

What does a simple html page return, and what does a simple taf that only has results html with basic html inside it return? Have you set any text encodings? 

Regards,

Jason.

PS: Your tags should also be the same case (preferably lowercase), but that won't cause the problems you've described.

On Saturday, Nov 15, 2003, at 16:04 Australia/Sydney, Brad Robertson wrote:

I in the process of upgrading my t2k application to witango5 and am encountering a couple issues;
(1)my cookies don’t appear to be assigning correctly, are there config file settings that could affect this?
(2)I created some simple test tafs from scratch and the files are outputting in HTML, ie., test is not showing as “test” in bold but appearing as test
Any guidance is much appreciated.

Bradley J. Robertson

WITH IMAGINATION
Planning, Implementation and Management of Web Applications 

160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770 
web -  email -  [EMAIL PROTECTED]

Re: Witango-Talk: Error Files

[Jason Schulz]

Stephen,

At what level is the error being generated, and how do you want to  
handle it? If you just want to catch 404s and similar errors, then in  
IIS you can configure the custom errors to point to an error.taf within  
the relevant domain/website.

That way the browser gets a redirect and you can handle it gracefully.

Regards,

Jason.

On Sunday, Nov 9, 2003, at 17:44 Australia/Sydney, Stephen Su wrote:

Alan,

Thank you for your response, however, I know about this setting. I had  
wanted to use differt error or responses for different domains using  
the same witango server.

This witango.ini setting is system based so applies to all the exact  
same way.

Thank you for your assistance,
Stephen


On Saturday, November 8, 2003, at 06:54  PM, Alan Wolfe wrote:

Yeah, in witango.ini theres a setting:

DEFAULTERRORFILE=

an example of how to set it is like this:

DEFAULTERRORFILE=C:\\inetpub\\wwwroot\\error.html

note the double slashes (:

try that, i hope it works for you!

- Original Message -
From: "Stephen Su" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 08, 2003 3:19 PM
Subject: Witango-Talk: Error Files

Anyone?

I was trying to setup different master, default error files for the
different websites sitting on the same server? Does anyone know the
most effective way to do this? I had assigned a
"Application$defaultErrorFile" var in each of the root directories  
but
no luck. Is there something else I have to do or other files that I
have to delete or alter on the server? Is there a better way?

Thank you all ahead of time and I hope everyone is having a nice
weekend,
Stephen
_ 
___
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
__ 
__
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
___ 
_
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


 With Imaginationwww.wi.com.au   [EMAIL PROTECTED]
  P 02 9929 9229 M 0411 288 596   F 02 9460 4770
 Planning, Implementation and Management of Web Applications

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

Re: Witango-Talk: database on another server

[Jason Schulz]

> Does splitting the db to another server save resources on the Witango
> server?
>
> I would assume it saves disk reads, but would it save cpu usage? For example
> , if the search action has "ordered by" columns or a join?

Web servers and database servers have different performance patterns, so
separating them allows each to use the available system resources
appropriately.

> I don't know anything about ODBC. Not sure if the DB engine is part of OBDC.

ODBC ('Open Database Connectivity') is a Microsoft standard that is widely
accepted as a way to talk to databases. Microsoft now calls it 'MDAC', and
they have more on their website about it.

> Is there a way to locate the DB Engine on the second server to move that
> processing to the 2nd server?

ODBC does this, as does JDBC.
 
> What is the tradeoff of having to transmit the results back to the web and
> Witango server assuming over the network?

On current network standards, not a lot. Most of your query results will be
quite small, and in typical internet hosting installations, the bottleneck
will be your user's connection. Corporate LANs are a different beast, but
you won't find many where userland has a faster network than the data
center. Across most applications, the web server will have more work to do
than the database server.

In general there are significant performance and operational
(management/redundancy etc) benefits.
 
Regards,

Jason.


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

Re: Witango-Talk: Timbuktu and TAFs

[Jason Schulz]

> By the way, when are you guys going to change the extension from taf to waf?

With Imagination != With Enterprise, so it isn't up to us.

We are independent developers, so we have as much say about what With
Enterprise do with Witango as you do.

Regards,

Jason. 
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


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

Re: Witango-Talk: Timbuktu and TAFs

[Jason Schulz]

Rick,

Services For Mac is does two things - AppleTalk File Protocol and file
resource fork management. Since TAFs are just text files (and don't have
resource forks) isn't SFM a bit of overkill?

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Rick Sanders" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 28 Oct 2003 15:51:58 -0500
> To: <[EMAIL PROTECTED]>
> Subject: Re: Witango-Talk: Timbuktu and TAFs
> 
> Hello,
> 
> For it to work properly, you need to install file services for Macintosh on
> the Win2k machine. Before this, your drive must be formatted in NTFS before
> you can install the file services for Macintosh.
> 
> Then, put your taf in the folder on the Win2k machine that is being used for
> file sharing with the Macintosh. Then, exchange files in Timbuktu with your
> Win2k machine, and it'll work.
> 
> Timbuktu uses the file system, where ftp just transfers raw data.
> 
> Rick Sanders
> 
> 
> 
>> Windows 2000 to Mac OS X
>> 
>> 
>> 
>> 
>>> is this dowloading from windows onto Mac or onto windows?
>>> 
>>> there's no file mapping in tb2
>>> 
>>> On Oct 28, 2003, at 10:18 AM, Steve Briggs wrote:
>>> 
 Anyone using OS X and Timbuktu v6 have the problem where TAFs
 downloaded from a Windows box won't open in the editor? FTP is
 fine,  as are earlier versions of Timbuktu. I'm wondering if there
 is a way  to set the file mapping in Timbuktu for them.
 
 Thanks!
 
 -- Steve
 
 ___
> _
 TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
 
>>> 
>>> 
>>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>> 
>> 
>> -- 
>> **
>> Steve Briggs  http://www.wowpages.com
>> President
>> Wow Pages Internet Technology Partners 1.800.WOW.1032
>> Web Development and Hosting  207.761.2450
>> 
>> [EMAIL PROTECTED]
>> 
>> **
>> 
>> 
>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>> 
> 
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Re: Witango-Talk: Secure Content Publishing (SCP) Sample Code Module

[Jason Schulz]

Dan,

I've been converting it for Mac OS X in my spare time. Once I get it done,
I'll put it somewhere accessible for downloading.

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: Dan Urlich <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Fri, 24 Oct 2003 11:14:52 +0200
> To: [EMAIL PROTECTED]
> Subject: Witango-Talk: Secure Content Publishing (SCP) Sample Code Module
> 
> G'day,
> 
> Has anyone converted the bats in the SCP to shell scripts so SCP can
> run on MacOS X. (SCP is one of the example modules on the Witango
> site and I would think it would be a killer app with the new free 5.5
> server).
> 
> Looks like a great piece of code.  I would like to test it out for
> our schools Intranet site.
> 
> If no one else has ported them, do you have any pointers or examples
> on how to do it?
> 
> Cheers,
> 
> Dan Urlich
> 
> 
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Witango-Talk: Witango 5 & Oracle upgrade problem

[Jason Schulz]

Folks,

I have a box running the following that has been upgraded to Witango server
5.

NT4 sp6, Oracle 8.1.5, MDAC 2.7, Oracle OCI 8.1.7.8

The problem is that witango server can't connect to the database running on
the same machine.

I can connect to the database from another machine, so the database is up
and running.

The debug is (dynamic datasource is used, but the problem is still there if
I define a static datasource):

> [Search Action] [133] check_username_and_pwd
> [Notice] [133] No existing connection to the data source found, creating a new
> connection. DSN: odbc.CIS_Admin; User: @@user$DS_Username;
> [Error] [197] 160 Specified driver could not be loaded due to system error
> 127 (Oracle in OraHome81). IM003
> [Error] [198] -4 Unable to connect to the specified data source.
> [Error] [199] -4 Unable to connect to the specified data source. Verify that
> data source is properly configured and that database server is online.

The error from the Oracle logs is:

> ORA-12224: TNS No listener

I've searched through comp.databases.oracle.misc group without any thing
useful on 'TNS No listener'.

Has anyone come across this?

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |



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

Re: Witango-Talk: Dev Studio 5.5 on OSX

[Jason Schulz]

Also installed fine. It isn't hogging the CPU either. :)

> From: Dan Stein <[EMAIL PROTECTED]>
> Installed fine for me.
> 
> on 10/23/03 12:03, Shannon Henderson at [EMAIL PROTECTED] wrote:
> 
>> Has anyone downloaded and installed the 5.5 Dev Studio for OS X from
>> the Witango site?  When we run the installer, we get a error message
>> saying, "The Bill of Materials for this package was not found."
>> 

 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


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

Re: Witango-Talk: creating HTML email with form for submission?

[Jason Schulz]

Michael,

If you are writing the emails as files, you will need to do the line wraps
yourself, which means for each message, the last thing you do before writing
each file out to the SMTP server is to replace all instances of '=' with
'=3D', and wrap the long lines with the last character on the wrapped lines
being an equals sign. (You should not send email messages with lines longer
than 72 characters).

Depending on how you keen you are about protecting your data, mark each your
records with a large random number. When you send your mail, include this
number as a hidden field in the form. Use the random number as the record
key for when the form is posted - don't use the database record id. Record
id's are generally sequential, and you don't want some script kiddie
updating all of your records, because they worked out your database record
id's.
 
Once a record has been updated you can then mark it as stale, which means
that the users will need to login before making further changes. That way
you only allow one update from the email.

Regards,

Jason.

| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: ServerSmiths Tango Development <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 16 Oct 2003 21:29:22 -0700
> To: [EMAIL PROTECTED]
> Subject: Witango-Talk: creating HTML email with form for submission?
> 
> Say Folks,
> 
> I thought I had a post flagged that talked about the correct email
> header for Tango to use to create a valid HTML email but cannot find
> it. Anyone have any input/tips/advice? I need to create a valid HTML
> email and then write it to a folder on my disk where my SMTP server
> will take it and send it out.
> 
> But here's the twist, this client wants to have a form embedded in the
> HTML which is pre-populated with data from his database. The email will
> tell his recipient to verify his data or change the data in the form
> fields and then to submit the form, either confirming the data or
> updating it.
> 
> He doesn't want to have them have to open their browser via a link.
> 
> I think is is pretty much do-able but would like to hear from anyone
> who has tried to cross this bridge and fell in the river instead.
> 
> Thanks,
> 
> Michael Heth
> Web Information Architect
> 
> 
> __S E R V E R S M I T H S__
> 
> http://www.serversmiths.com/
> 
> Technology Infrastructure Provider
> 
> I N T E R N E T  P R E S E N C E  S O L U T I O N S
> 
> | EWordSmith | LightningSite | Enigma.Engine |
> 
> M A R I N  C O U N T Y  C A L I F O R N I A
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Re: Witango-Talk: Windows 2003 Server

[Jason Schulz]

Steve,

Witango 5, IIS 6, MS SQL 2003, on Windows 2003 Enterprise Edition.

You have to enable wiis.dll explicitly as a Web Service Extension, but other
than that it is fairly straight forward.

Internet Explorer Enhanced Security is a pain in the rear, but it is there
for a reason... Basically IE refuses to load any non-local website unless
you specifically add it to the authorised list.

The combination runs really well. The only reason it gets restarted is to
install the latest security update, so the uptimes don't go past a couple of
weeks.

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: Campbell Steve <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 02 Oct 2003 14:09:24 -0500
> To: <[EMAIL PROTECTED]>
> Subject: Re: Witango-Talk: Windows 2003 Server
> 
> Hello
> 
> From what I heard,  a few of you on the list has ran the new version of
> Windows Server, 2003.  How has this ran with WiTango App Server?
> 
> Anyone have any first hand knowledge?  Well it run with Windows 2003, Tango
> 2K App. Server?
> 
> 
> Thanks in advance
> 
> Steve
> 
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Re: Witango-Talk: Is it possible?

[Jason Schulz]

Gene,

You might want to look at SVG, which is a W3C org backed specification. It
is XML based, and allows very dynamic graphics to be created. There is a lot
open source software that has been developed around it.



The more recent versions of Flash can be integrated to work with database
back ends, so if you are happy working with Flash, you can get good mileage
out of it this way.

There are also numerous COM and JAVA based graphics solutions out there.

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Wolf, Gene" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 02 Oct 2003 07:27:56 -0400
> To: [EMAIL PROTECTED]
> Subject: Witango-Talk: Is it possible?
> 
> Some of you may have already done this, or maybe no one has, but I
> thought I'd give it a shot. We're finding we are outgrowing the capabilities
> of our current graphing package with Witango. The users needs are getting
> too sophisticated. We have found that we can do what is required using Excel
> and exporting to a web page. Problem is we need it to also be dynamic, for
> example, some graphs have to be refreshed on a 15 minute interval.
> 
> Now, Excel also has a built in Webquery that allows just that, but only
> as long as Excel is running. What that means is, you can ask Excel to query
> the database and display the new chart every 15 minutes, but only from
> within Excel. Once you save the chart it becomes static.
> 
> Has anyone tied Witango to Excel in such a way that what we're looking to
> accomplish is possible? Or is someone using a more sophisticated charting
> package with Witango that allows you to specify bar colors, place the bar
> values on the bars themselves, etc?
> 
> Our environment is Windows 2000, Witango 5 and SQL. Thanks for your help!
> 
> Gene Wolf
> Business Systems Analyst, TLMN
> DRS Optronics, Inc.
> 2330 Commerce Park Drive
> Palm Bay, Florida  32905
> Phone: 321-309-0685
> E-mail: [EMAIL PROTECTED]
> 
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Re: Witango-Talk: A great new browser

[Jason Schulz]

Safari is based on KHTML/Konqueror, and not Gecko/Mozilla. This caused much
consternation amongst the Mozilla crowd at the time.



Lynx is also really good, as it shows you how your site appears to most
search engines (think of them as blind users, with screen scrapers/readers,
and you are halfway there).

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Jim Kass" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 1 Oct 2003 17:12:49 -0700
> To: <[EMAIL PROTECTED]>
> Subject: RE: Witango-Talk: A great new browser
> 
> Also, OSX's Safari is based on Mozilla's "raptor" engine and was built largely
> from the Mozilla source.  The idea with Mozilla is to support as many
> open-standards as possible, and have as few proprietary specifics as possible.
> It is under constant development, and for a developer of any scale, it is a
> must-have tool... even if it is just so that you can have two entirely
> different Tango sessions open on the same machine.


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

Witango-Talk: About the Conference

[Jason Schulz]

Perhaps everyone is still travelling home, but I'd like to congratulate
Phil, Sophie, Fergal & Andrew and the rest of the With Enterprise team on
their efforts running the conference, and the various presenters who put so
much in to make it worthwhile.

As programmers we'd understand that for something to work effortlessly, a
huge amount of preparation has to occur. Which is pretty much what did
happen.

So to Phil, thank you for answering all our inane questions with how a
change to our code or config would make things work.

To Soph, for the thinking, planning and doing, to simply get it to all to
happen in the four days that mattered.

To Fergal & Andrew, for presentations with knowledge & detail and just a
little humour.

To everyone who stood up in front of the rest of us to share what they knew,
thank you.

I've been to other developer conferences, but where ever the next Corroboree
is, I look forward to being there.

Jason. 

| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |



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

Re: Witango-Talk: OT: SMTP server

[Jason Schulz]

Jamileh,

For each email, you will have three messages queued - one for the TO, and
one each for the BCC, so if you sent 17 messages, that means 51outbound
messages were queued at your mail server. Of those 51, 17 were sent to you,
and 34 were sent to other addresses.

I'd check the mail logs to see which foreign mail server was not available
immediately for message transfer.

Regards,

Jason.
- Original Message - 
From: "Wilcox, Jamileh (HSC)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 6:23 AM
Subject: Witango-Talk: OT: SMTP server


OK, I've got these puppies set up and am starting to do the mailings.

This is an html-formatted email with a pdf attachment.  One email
address in the TO (recipient from database), two emails in the BCC
(TheDoctor, Me).

I just sent the first batch out  -  only 17 emails.  I received all 17,
but one still shows up in the C:\InetPub\mailroot\Queue\ directory of
the server.  It shows a modified filedate of 3.07 (it's currently 3.21
on that machine).  I double-checked, and I did receive a copy of the
email to this person.

Can anyone give me a clue as to what the problem is, or what I should
do?  I've been checking around and am not finding much help on this.

Thanks very much! j



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


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

Re: Witango-Talk: server OS's

[Jason Schulz]

Atrix,



This is for the Action Pack, which will get you a copy of almost all
Microsoft software. Generally the server type products are provided with a
single license, and the desktop products with 10 licenses, which makes it
all worthwhile. As noted in other posts, all of the licenses are for
internal evaluation use, and not for production environments.

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Tom Ferguson" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 5 Aug 2003 17:59:22 -0400
> To: <[EMAIL PROTECTED]>
> Subject: RE: Witango-Talk: server OS's
> 
> Atrix,
> 
> I'm currently using Win2000 Adv. Server and it's been bulletproof for me.
> They just released SP4 for it recently, so support may go away, but I don't
> know how soon.
> 
> That said, M$ is investing a lot of time and resources into the Win2003
> Server product.  I know they found a couple of security holes already, but
> heck, if it was too clean, what would the hackers do?  If I was in your
> position I'd sign up for that M$ Developer program and for $299 subscription
> fee you get one license for each I think.  Check with Ben and/or Dan - they
> had the link.
> 
> Tom Ferguson
> -Original Message-
> From: Atrix Wolfe [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 05, 2003 5:45 PM
> To: [EMAIL PROTECTED]
> Subject: Witango-Talk: server OS's
> 
> 
> Hi List,
> 
> we are getting a new server and i was wondering what people recomend for
> windows OS's?
> 
> we are kind of debating between win2000 pro, win2000 server and win2003
> server.
> 
> i heard the win2000 stuff is getting phased out so security
> updates/patches arent going to be available too much longer so i know thats
> a consideration too.
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
> 
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf


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

Re: Witango-Talk: RE: Reusing the UserReference key

[Jason Schulz]

Folks,

While session hijacking is a concern, I'd suggest that for most people, the
reuse of userref via search engines is a greater problem.

This leads me to the following couple of questions.

1) Can the referrer header be put to any use - is there a case where we'd
want to maintain the userref for a visitor from an external site?

Would it be useful to have witango able to check on a per domain basis that
if the referrer is not empty then flush the userref?

2) Can robots.txt be used in a creative way to prevent indexing of dynamic
content?

3) If the the user session is expired, can the userref be treated as stale
and flushed as well - ie, if it is seen and there is no session that can be
associated with it, then a new userref is returned to the user agent.

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Scott Cadillac" <[EMAIL PROTECTED]>
> Organization: XML-Extranet
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 6 Aug 2003 15:54:15 -0600
> To: <[EMAIL PROTECTED]>
> Subject: RE: Witango-Talk: RE: Reusing the UserReference key
> 
> Sorry, I accidentally hit send before I finished formulating completely what
> I was trying to say.
> 
> The issue is all about being granted access to User Variables that you are
> not allowed, and this is still possible on that very first hit (before the
> redirect). 
> 
> Although you are successfully changing the value later, it's the first hit
> that concerns me.
> 
> Because everybody writes there code differently, and for different purposes,
> a more "global" solution is needed, because I'm not sure this solution will
> work for everybody.
> 
> Thank you Atrix, and like I said, you are very very close
> 
> Scott Cadillac,
> Witango.org - http://witango.org
> 403-281-6090 - [EMAIL PROTECTED]
> --
> Information for the Witango Developer Community
> -
> 
> XML-Extranet - http://xml-extra.net
> 403-281-6090 - [EMAIL PROTECTED]
> --
> Well-formed Development (for hire)
> -
> 
> 
>> -Original Message-
>> From: Scott Cadillac [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 06, 2003 3:33 PM
>> To: [EMAIL PROTECTED]
>> Subject: RE: Witango-Talk: RE: Reusing the UserReference key
>> 
>> 
>> I think you're very close Atrix,
>> 
>> You've got the right idea, but I believe if the user is
>> hitting the TAF to
>> begin with, with something like:
>> 
>> http://www.mydomain.com/userref.taf?_UserReference=F207B47F39D
>> AE223F3167B9
>> 
>> Than your new <@USERREFERENCE> value will be still the old
>> key value, even
>> though you are redirecting them on the first step. Which is
>> the problem.
>> 
>> Remember, this key assignment stuff is happening on the very
>> "FIRST" TAF
>> request, so it's all done before your file does the Redirect.
>> 
>> Butif your redirect was bouncing them to a non-Witango
>> file (HTML) and
>> then back again - a new key should be issued because both the
>> _UserReference
>> argument and session-cookie would be missing.
>> 
>> ...
>> 
>> 
>> 
>>> -Original Message-
>>> From: Atrix Wolfe [mailto:[EMAIL PROTECTED]
>>> Sent: Wednesday, August 06, 2003 3:06 PM
>>> To: [EMAIL PROTECTED]
>>> Subject: Re: Witango-Talk: RE: Reusing the UserReference key
>>> 
>>> 
>>> ok i think i have a solution to the problem.
>>> 
>>> If you go into this taf with a non-valid user reference, it
>>> will assign you
>>> a new one.  If you keep clicking the link w/ the non-valid
>>> user reference,
>>> you get a new user ref each time.
>>> 
>>> If you go into this taf with a VALID user ref (by clicking
>>> the link on the
>>> "Page" part for instance) you keep your user ref as youd expect.
>>> 
>>> best part is, it doesnt have to store a domain scope table of
>>> valid user
>>> references or anything, it just relies on a user scope
>>> variable being set
>>> for valid users (:
>>> 
>>> basicly how this would work is this construct would go at the
>>> top of all of
>>> your tafs with the if and else if and all your code going
>> in the else
>>> statement.
>>> 
>>> you an also do something cool like changing where it
>>> redirects invalid users
>>> so you could make them go to your main page or a timeout page
>>> or whatever
>>> you want.
>>> 
>>> 
>>> - Original Message -
>>> From: "Ben Johansen" <[EMAIL PROTECTED]>
>>> To: <[EMAIL PROTECTED]>
>>> Sent: Wednesday, August 06, 2003 1:53 PM
>>> Subject: RE: Witango-Talk: RE: Reusing the UserReference key
>>> 
>>> 
 Ok, some more here.
 
 I took the copied address into a text editor and changed the
 userreference value manually. I opened a new browser pasted
>>> the address
 with the changed key (to simulate user vars timed out)
 
 And the user variable was blank and no session cookie was created.
 
 Interesting :-b
 
 Ben Johansen - http://www.

Re: Witango-Talk: RE: Reusing the UserReference key

[Jason Schulz]

Well that's two votes for userRefReset then :)

For visitors coming in via search engines, we get REFERER with 'good'
contents, usually the search URI that was used.

Further to what Atrix reported earlier with R:Tango 5, I've tested on NT4.0
server with IIS 4 & T2K, if the same userref is presented by a multiple
browsers while a session is current, then the user scope is common amongst
those clients.

Anyone want to chip in with W5 062 results?

Regards,

Jason.
 
| With Imaginationwww.wi.com.au   [EMAIL PROTECTED] |
|  P 02 9929 9229 M 0411 288 596   F 02 9460 4770 |
| Planning, Implementation and Management of Web Applications |


> From: "Ben Johansen" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 6 Aug 2003 21:28:16 -0700
> To: <[EMAIL PROTECTED]>
> Subject: RE: Witango-Talk: RE: Reusing the UserReference key
> 
> Hi,
> 
> I see where your going here, I have a couple of comments on
> 
> your question 1.
> 1. Ironically I am working on a project that uses referrer to pay on
> referral leads.
> 2. I have found very few times where REFERER = <@CGIPARAM REFERER> has
> anything in it.
> 
> your question 3.
> 1. this is would be great new feature like a configuration variable like
> "userRefReset"
> 
> Ben Johansen - http://www.pcforge.com
> -Authorized WiTango Reseller
> http://www.pcforge.com/WitangoGoodies.htm
> -Authorized Alt-N Reseller
> http://www.pcforge.com/AltN.htm
> 


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