RE: Witango-Talk: FW: year-end update
I would also like to chime in and give kudos to Robert. I am currently preparing to move forward and the help Robert has been giving me is nothing short of stellar. This is far different then any support received in the past and the responses and clarity in which concerns are put to rest is very refreshing. It is clear that Robert cares for this program, its users and the success of us all. Hats off to the new management and I am hoping for Robert great success in the future. Thanks Robert! John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Friday, December 09, 2011 4:28 PM To: Witango-Talk@witango.com Subject: Witango-Talk: FW: year-end update I would like to applaud Robert and his staff. I have worked with Robert on a few issues with TeraScript and he has quickly responded and provided patches, versions, etc. He has been great at offering advice and suggestions to resolve issues. I think everyone would agree Robert's acquisition of Witango has been great. Quick responses to questions on the forum is refreshing. As a side note, we have been running TeraScript Pro on Windows 2008 R2 with four instances using MySQL on a new server (six cores with hyper-threading) and have been adding websites to it every week. Users have been holding their sessions and we haven't had one service crash or lock up in a month. It has been very stable. Our application is an eCommerce app and things are hopping coming into the Christmas season. We are adding our largest traffic site this weekend and I expect great results. I am excited about the future with TeraScript. Merry Christmas to all. Steve Fogelson From: Witango Sales [mailto:sa...@witango.com] Sent: Friday, December 09, 2011 3:43 PM To: Fogelson, Steve Subject: year-end update Dear Customer, Last fall, we released Witango 6.0 for Windows, our first release after purchasing the platform. It's been a year since we took that first step towards our ultimate objective of revitalizing the language and the software, and we'd like to take a moment to share with you some of the goals we've accomplished, lessons we've learned, and our plans for the coming year. One notable decision we've made was to rename the Witango platform to TeraScript, the application server to TeraScript Server and the development studio to TeraScribe. We put a lot of thought into this choice and believe that the Tango/Witango platform will be well represented by this new name into the future. Over the past year we've produced five releases which cumulatively corrected hundreds of bugs. Today the product is more stable and better situated than it has been in many years. We are using modern compilers and fully supporting current releases of Windows, Mac OS X, and Linux. We have the ability to identify and correct customer reported issues quickly and add features in a timely manner. Our hope is that this growth of the platform is translating into better applications, faster web sites, stable servers, and happier developers and clients. One lesson we've learned over this past year is that developing a language, server application and development tool is a challenge beyond just the programming. Our customers are diverse in how they use the platform and have many great ideas, feature requests and requirements. Coalescing this feedback into a coherent, stable and desirable platform is a huge responsibility. Thus far our primary driving force has been to bring stability to a platform that went 5 years since its last major release and provide a convenient upgrade path to users of that, and previous, versions of the product. This way of thinking will soon change, however, as we begin to introduce new features and some new ideas to the platform and the products. In the near future we'll be releasing one more major version of the 6.x series, version 6.2. This version will serve as a stable release during the development of version 7 and will provide a few major improvements such as renewed support for the Oracle native client (OCCI). After that release, we'll begin development of version 7, the next major version of the platform. Development is expected to take at least 6 months; during which we'll be offering a number of preview builds for users to work with, test and provide feedback on. We hope that you've seen our excitement and commitment to the platform over the past year. While we constantly wish we could have done more, we're proud of the product that we've produced to date. Our efforts will not stop here and there is much more to look forward to. We hope everyone has a cheerful holiday season. Thank you, The TeraScript Development Team Tronics Software LLC To contact Tronics Software with questions, please email mailto:supp...@terascript.com supp...@terascript.com or
RE: Witango-Talk: Scoping Variables
thanks Robert... John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 21, 2011 2:01 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Scoping Variables You can probably get away with doing less work to start, and then just cleaning up any bugs you find in testing. Essentially the change is this: In your version, the default scope is user, so when you do @ASSIGN myVar myValue you are effectively creating that variable in the user scope (as if @ASSIGN user$myVar myValue), which is a persistent scope. When you upgrade, the default is changed to request (aka local) and so your unscoped variable assignments will change to the request scope and loose persistency. To correct for this in code, you simply need to add the user scope syntax to your assignments. @ASSIGN myVar myValue becomes @VAR user$myVar myValue or @ASSIGN myVar myValue scope=user It is notable that all versions of Witango and TeraScript support setting the default scope back to the user scope if you wish. It is, therefore, possible to have TeraScript 6.1 operate using the same scoping rules as Tango 2000. This is NOT recommended, however. You should not need to adjust any usages of variables (@VAR myVar, @PURGE myVar, etc) because the scoping rules will search up the scope hierarchy until the variable is found. The only time this will cause a problem for you is if you wish to have two different variables distinguished only by scope: @ASSIGN request$myVar yes @ASSIGN user$myVar no. Now if you just do @VAR myVar you'll get yes because the request scope is more specific than the user scope. To access the value in the user scope, you would need to use @VAR user$myVar. The term 'local' is currently a synonym for the term 'request'. The use of 'local' is not recommended, and the term is officially deprecated. I'm not sure exactly when, but in a future release of TeraScript there will be a new scope which acts like a true local scope, and will use the 'local' syntax. At such time, you will need to make sure all references to the request scope use 'request' rather than 'local', unless of course you wish to have a truly local variable. Note that I often used the dollar-sign syntax for scoping: SCOPE$VARNAME. This is the shorthand syntax for providing a variable name and its scope at the same time. While the long hand @TAG name=VARNAME scope=SCOPE is not going to be removed from the platform, the shorthand is recommended. One easy way to update your applications would be to search for the string @ASSIGN and replace it with @ASSIGN user$. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 21, 2011 2:18 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Scoping Variables Hi Folks, I am currently preparing to upgrade from version 4, probably to version 6 and then up to Terascribe. I remember that syntax and scoping of variables have changed. I am trying to prepare as much of the old files as possible before upgrading. I will probabaly have more questions to come, but I am going to take this a step at a time. First question is concerning scoping variables. Presently, almost all variables are not scoped so I am going through the ardious process of straightening these out. A few questions, if you don't mind... I would assume that you need to scope all @ASSIGNs Most of the applications have no scope assigned to them presently. Of course, the default for this is user in the version I am using, but I am going to go through each assign and scope it appropriately. Almost all are goinmg to be scoped as user, but I have a few that can be scoped as local. Whenever calling on the variable, such as @VAR blah I am also going to assume these need to be scoped as well, as is @VAR blah scope user Do I need to scope any @PURGE variables? When calling a local variable, should these be scoped as well? i.e. @VAR blah scope local What exactly is the request scope? This will be for futue reference. It appears to be the same as the local scope. When I upgrade, will I need to change all local scopes to request scope? Is this just a neam change to avoid confusion Thanks for any help! _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. ci.gif
Witango-Talk: Scoping Variables
Hi Folks, I am currently preparing to upgrade from version 4, probably to version 6 and then up to Terascribe. I remember that syntax and scoping of variables have changed. I am trying to prepare as much of the old files as possible before upgrading. I will probabaly have more questions to come, but I am going to take this a step at a time. First question is concerning scoping variables. Presently, almost all variables are not scoped so I am going through the ardious process of straightening these out. A few questions, if you don't mind... I would assume that you need to scope all @ASSIGNs Most of the applications have no scope assigned to them presently. Of course, the default for this is user in the version I am using, but I am going to go through each assign and scope it appropriately. Almost all are goinmg to be scoped as user, but I have a few that can be scoped as local. Whenever calling on the variable, such as @VAR blah I am also going to assume these need to be scoped as well, as is @VAR blah scope user Do I need to scope any @PURGE variables? When calling a local variable, should these be scoped as well? i.e. @VAR blah scope local What exactly is the request scope? This will be for futue reference. It appears to be the same as the local scope. When I upgrade, will I need to change all local scopes to request scope? Is this just a neam change to avoid confusion Thanks for any help! To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
Witango-Talk: Exact Numeric Character IFs
This has never come up before and I know it's probably a stupid question, but I am trying to write an IF statement where I need to compare characters rather then numbers. I went through the manual and I am a bit confused. I thought that if you used single quotes, it would look at the expression as a character compare rather then a numeric compare. For example... @IF EXPR='0 = '0' TRUE =They really are not the same - one has a lot more zeros then the other FALSE=They are the same I have a client who has numeric codes that can start with multiple zeros and I need to be able to get a true or false depending on the actual characters rather then the numeric value. 0 = 0 would then be false. Probably a stupid fix, I just cannot see it. By the way, the @IFEQUAL tag evaluates the same way. I need a string comparison rather the numeric. Any help would be appreciated. Thanks! John M. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Exact Numeric Character IFs
This is what I need... 0 = 0 True 00 = 0 False Simply changing the TRUE and FALSE values does not work. Both of these equate to TRUE. All of these equate to true too... @IF EXPR='000' = '0' TRUE =true FALSE=false @IF EXPR='0' = '0' TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IFEQUAL 00 true@ELSEfalse/@IF @IFEQUAL 0 0true@ELSEfalse/@IF _ From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, August 15, 2011 9:24 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Exact Numeric Character IFs John, It seems to me like you should reverse your TRUE and FALSE values. Bill On Monday, August 15, 2011, WebDude webd...@cipromo.com wrote: This has never come up before and I know it's probably a stupid question, but I am trying to write an IF statement where I need to compare characters rather then numbers. I went through the manual and I am a bit confused. I thought that if you used single quotes, it would look at the expression as a character compare rather then a numeric compare. For example... @IF EXPR='0 = '0' TRUE =They really are not the same - one has a lot more zeros then the other FALSE=They are the same I have a client who has numeric codes that can start with multiple zeros and I need to be able to get a true or false depending on the actual characters rather then the numeric value. 0 = 0 would then be false. Probably a stupid fix, I just cannot see it. By the way, the @IFEQUAL tag evaluates the same way. I need a string comparison rather the numeric. Any help would be appreciated. Thanks! John M. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Exact Numeric Character IFs
Any ideas? _ From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 9:39 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs This is what I need... 0 = 0 True 00 = 0 False Simply changing the TRUE and FALSE values does not work. Both of these equate to TRUE. All of these equate to true too... @IF EXPR='000' = '0' TRUE =true FALSE=false @IF EXPR='0' = '0' TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IFEQUAL 00 true@ELSEfalse/@IF @IFEQUAL 0 0true@ELSEfalse/@IF _ From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, August 15, 2011 9:24 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Exact Numeric Character IFs John, It seems to me like you should reverse your TRUE and FALSE values. Bill On Monday, August 15, 2011, WebDude webd...@cipromo.com wrote: This has never come up before and I know it's probably a stupid question, but I am trying to write an IF statement where I need to compare characters rather then numbers. I went through the manual and I am a bit confused. I thought that if you used single quotes, it would look at the expression as a character compare rather then a numeric compare. For example... @IF EXPR='0 = '0' TRUE =They really are not the same - one has a lot more zeros then the other FALSE=They are the same I have a client who has numeric codes that can start with multiple zeros and I need to be able to get a true or false depending on the actual characters rather then the numeric value. 0 = 0 would then be false. Probably a stupid fix, I just cannot see it. By the way, the @IFEQUAL tag evaluates the same way. I need a string comparison rather the numeric. Any help would be appreciated. Thanks! John M. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Exact Numeric Character IFs
Appreciate the help from both Robert and Anthony. I did get it to work using Robert's method. I also came up with @IF EXPR='000' = '0' AND 'len(000)' = 'len(0)' TRUE =true FALSE=false which seems to work for what I am trying to do. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, August 15, 2011 10:52 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs I have two: Variables: request$input1 = 00 request$input2 = @IF expr= 'A@VAR input1' = 'A@VAR input2' By placing an arbitrary letter before the variables, you will force TeraScript to internally compare them as strings. This will be False. OR @IF expr= @CIPHER hash md5 @VAR input1 = @CIPHER hash md5 @VAR input2 Since the MD5 hash of 0 is different from 00, this will be False. This trick also allows you to do case sensitive string comparisons, where @IF normally is case insensitive. Robert PS. Both of these short-comings are issues that should be corrected. I'll add them to my to-do list. From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 11:31 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs Any ideas? _ From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 9:39 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs This is what I need... 0 = 0 True 00 = 0 False Simply changing the TRUE and FALSE values does not work. Both of these equate to TRUE. All of these equate to true too... @IF EXPR='000' = '0' TRUE =true FALSE=false @IF EXPR='0' = '0' TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IFEQUAL 00 true@ELSEfalse/@IF @IFEQUAL 0 0true@ELSEfalse/@IF _ From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, August 15, 2011 9:24 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Exact Numeric Character IFs John, It seems to me like you should reverse your TRUE and FALSE values. Bill On Monday, August 15, 2011, WebDude webd...@cipromo.com wrote: This has never come up before and I know it's probably a stupid question, but I am trying to write an IF statement where I need to compare characters rather then numbers. I went through the manual and I am a bit confused. I thought that if you used single quotes, it would look at the expression as a character compare rather then a numeric compare. For example... @IF EXPR='0 = '0' TRUE =They really are not the same - one has a lot more zeros then the other FALSE=They are the same I have a client who has numeric codes that can start with multiple zeros and I need to be able to get a true or false depending on the actual characters rather then the numeric value. 0 = 0 would then be false. Probably a stupid fix, I just cannot see it. By the way, the @IFEQUAL tag evaluates the same way. I need a string comparison rather the numeric. Any help would be appreciated. Thanks! John M. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. att87bba.gif
RE: Witango-Talk: Exact Numeric Character IFs
Actually, Robert... it does make a difference and I switched to your method. These are groups of numbers like... Thanks! John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, August 15, 2011 11:22 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs I doubt that this would be an issue in your case, but your method using len() doesn't force an actual string comparison, so you will still get the incorrect response in the case of: Value1 = 0.01 Value2 - .010 Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 12:16 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs Appreciate the help from both Robert and Anthony. I did get it to work using Robert's method. I also came up with @IF EXPR='000' = '0' AND 'len(000)' = 'len(0)' TRUE =true FALSE=false which seems to work for what I am trying to do. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, August 15, 2011 10:52 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs I have two: Variables: request$input1 = 00 request$input2 = @IF expr= 'A@VAR input1' = 'A@VAR input2' By placing an arbitrary letter before the variables, you will force TeraScript to internally compare them as strings. This will be False. OR @IF expr= @CIPHER hash md5 @VAR input1 = @CIPHER hash md5 @VAR input2 Since the MD5 hash of 0 is different from 00, this will be False. This trick also allows you to do case sensitive string comparisons, where @IF normally is case insensitive. Robert PS. Both of these short-comings are issues that should be corrected. I'll add them to my to-do list. From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 11:31 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs Any ideas? _ From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, August 15, 2011 9:39 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Exact Numeric Character IFs This is what I need... 0 = 0 True 00 = 0 False Simply changing the TRUE and FALSE values does not work. Both of these equate to TRUE. All of these equate to true too... @IF EXPR='000' = '0' TRUE =true FALSE=false @IF EXPR='0' = '0' TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IF EXPR=0 = 0 TRUE =true FALSE=false @IFEQUAL 00 true@ELSEfalse/@IF @IFEQUAL 0 0true@ELSEfalse/@IF _ From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, August 15, 2011 9:24 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Exact Numeric Character IFs John, It seems to me like you should reverse your TRUE and FALSE values. Bill On Monday, August 15, 2011, WebDude webd...@cipromo.com wrote: This has never come up before and I know it's probably a stupid question, but I am trying to write an IF statement where I need to compare characters rather then numbers. I went through the manual and I am a bit confused. I thought that if you used single quotes, it would look at the expression as a character compare rather then a numeric compare. For example... @IF EXPR='0 = '0' TRUE =They really are not the same - one has a lot more zeros then the other FALSE=They are the same I have a client who has numeric codes that can start with multiple zeros and I need to be able to get a true or false depending on the actual characters rather then the numeric value. 0 = 0 would then be false. Probably a stupid fix, I just cannot see it. By the way, the @IFEQUAL tag evaluates the same way. I need a string comparison rather the numeric. Any help would be appreciated. Thanks! John M. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body
RE: Witango-Talk: OT - UTF-8
Thank you Robert... that explains a lot. It also helped form the answer to my client. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Thursday, July 14, 2011 11:47 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - UTF-8 I'm happy to answer your questions, however it's not likely to work well to use Witango. I understand that I need to declare the charset to UTF-8 to display the characters. Do I actually need to install a language pack on the server to display? No. The server just needs to manage data. You may need to install language packs if you want to see the web pages render correctly in IE or have a text editor render correctly - but it's not technically necessary for you to read the content in order to manipulate it. Just keep in mind that if you are manipulating UTF-8 data by hand (like in a text editor) then that text editor must read and write UTF-8 encoded files. Right now I have no language packs installed on any machines so when I get Chinese text it displays as a series of boxes. Can I change the charset to UTF-8 and just cut and paste the boxes? Will that display correctly? It should, as long as you copy and paste with a UTF-8 capable text editor. Keep in mind that the TAF/TCF structure uses 8859-1 encoding and therefore cannot hold UTF-8 characters. You can't copy and paste them into the Studio nor manually into the TAF/TCF. Also, you can't put them into an include file because the Server will not strip out the BOM, although it will pass the encoded characters unaltered to the webpage (I think - untested). I think I can display both English and Chinese on the same page, is this correct? Of course, the first 128 characters of the UTF-8 character set are the exact same characters as ASCII. What you can't do is use any high-bit characters from the 8859-1 encoding without first re-encoding them into UTF-8. This would be true for most accented characters. I will more then likeyy be adding this text via email into the Witango editor, is there a problem with this? As I noted before, you cannot copy UTF-8 encoded content into the Witango Studio. It will be corrupted. I take it that using MS SQL for data would be a bit more complicated? Yes, you may recall seeing that most data types in MS SQL have a variant that begins with an 'n', such as char has nchar. Well, the n means that the column can hold UTF-8 encoded characters. It's also true that you need to signal in the SQL query when you are passing UTF-8 encoded content. It works like this: UPDATE table SET column = N'My UTF-8 Encoded Text' WHERE primary_key = 1 Note the N preceding the UTF-8 encoded string. Is this as easy as it seems to be? I don't believe it's easy, no. Is there a simple step by step doc/webpage/place I could go for more information? Not that I am aware of, but Google is your friend. Sorry for all the questions, but I would like to respond to the client with at least a very base knowledge of how this will work without getting egg on my face. Right now they have supplied me with artwork of some very base translations for some of the headers on certain pages and I think they are wondering if we could take the next step and actually use the language. You should be able to get this to work if you follow these 2 steps. Although note that I have never tried this myself, so I could be completely wrong: 1) Force your current English pages to have UTF-8 encoding - this is simply done by setting the Meta information on the HTML document accordingly. If any characters look incorrect (probably question marks) on the web page, then you must correct these first. You can use the @CIPHER tag to convert from 8859-1 to UTF-8. 2) Then place all of the Chinese text into the SQL server. Use proper UTF-8 aware tools to do so, so that you SQL Server has properly encoded content in it. Now, the trick is that when Witango reads data out of the database and puts it onto the webpage it should not alter it. This is the part I'm not 100% about. If I'm right then the UTF-8 encoded content will go onto the webpage without issue and your browser will display it properly. Note that you can not do ANY manipulation of the content in Witango. Robert _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
Witango-Talk: ODBC via IP to OpenBase
Hi folks, I am hoping someone could help me. Granted, I am using an old version of Witango, 2000, but hopefully someone a bit more knowledgable might be able to point me in the right direction. I need to connect via IP to an OpenBase database. I downloaded the recommended ODBC driver, Actual OpenBase and installed it on a Win 2003 server. After install, instructions state to create a user DSN, then I should be ready to go. When I create a User DSN, I can load the tables and view the columns in the Editor. But when I try doing a simple search, I get The specified data source cannot be found. and Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. When I create a System DSN, I also can load the tables and view the columns in the Editor. I can also search and return data, but whenever I try to update, I get a Witango crash... Client Error. The server refused connection. I go to the Witango logs and get the following... Fatal error at 0285aa11: Write EXCEPTION_ACCESS_VIOLATION at f133c6dd. And then Witango goes through the restart stuff. So I guess one question would be, am I supposed to be using a User DNS or a System DSN? If a User DSN, is there something else I am supposed to be doing to get this to work past the Editor? I can view and load tables in the Editor, but cannot run an application through a browser. And the System DSN seems to get me a bit closer, but it seems very buggy and I cannot update the tables. Would a crash happen if a user on the other end did not have the correct permissions? Sorry for all the questions. I am not sure whet exactly the difference is between User and System. Also, I have made similar types of connections to MSSQL databases and have not had these types of problems, but this was several years ago. Thanks for any insight! To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Looking For a Developer
Hi Norm, Thanks for answering my email. Unfortunately, we are looking for a full time employee who resides in our area. A lot of this work would require being local. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: n...@no-worries.net [mailto:n...@no-worries.net] Sent: Wednesday, April 06, 2011 3:48 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Looking For a Developer Hi, I'm interested. I began working with Tango way, way back but work has been somewhat sporadic. I've worked with php, Mysql, MSsql, credit cards, ftp, email and a few others. But I'm in San Francisco. Let me inow if you're nterested. thanks Norm Wheatley Original Message Subject: Witango-Talk: Looking For a Developer From: WebDude webd...@cipromo.com Date: Wed, April 06, 2011 12:20 pm To: Witango-Talk@witango.com Hi Folks, I am looking for someone who would like to get into a start-up position with the opportunity to grow. Not sure if any of you are in the Minneapolis/St. Paul area, but thought I would give this list a shot before going to a more traditional search. I fell into a situation with another company that's going to keep me very busy for the next couple of years. Last month I billed over 230 hours and quite frankly, I am getting a bit overworked. All programming I have been doing has been done in Witango. We are planning on upgrading servers and software. We have been working with very large retail corporations on the certification of packaging companies both here in the states and overseas. Along with the certification process is another component where packaging is measured, evaluated and data stored in separate databases for these retail corporations. They use the data to evaluate the packaging suppliers and the products they produce. All of the data input and output is done via the Web. There are many facets to these projects and each retail corporation changes the criteria just enough to keep the individual websites unique. We also have about 50 other sites that are not related to the packaging certification process, some of these with large companies as well. Ultimately, what we are looking for could go in two directions, after much discussion... 1. A seasoned developer in Witango and PHP who is already established and would bring expertise to the table along with established clients that he or she would move into our hosting environment. This person would have the ability to bring in more business and also be able to handle pretty much anything we threw at them. A good working knowledge of MSSQL, DNS, CC processing, FTP, Routers, email servers and firewalls would be a plus. 2. A person just starting out who is well versed in PHP and would like to learn Witango on his or her own. This person would need to be a self-starter who would take the bull by the horns, so to speak, and have the ability to problem solve to advance their knowledge in programming in Witango. I won't have time for too much handholding. No body ever held my hand and I would expect the same of people who are truly interested in something like this. (Well... the only hand holding I got was from all you good people on the list who have taught me a lot over the years) All our servers used for Web applications are Windows based. Some of the internal stuff is MAC, but we would really be concentrating on the Web stuff. Granted, our platforms are fairly old (Win2000 and 2003) and we are still working with Witango 2000, but we are looking for upgrades across the board as the work is being ramped up. Some of the work will involve these upgrades and moving sites to more recent software and platforms. We plan on upgrading to the latest Witango, and to upgrade all platforms while leaving the old in place so we can migrate and test as time allows. The only reason I am throwing PHP into the mix is because we feel it might attract a wider customer base by offering programming in a more popular language. We would be willing to buy the server(s) in order for us to expand into this arena. PHP may or may not play a role in the hiring, but may be a plus that we could discuss. I personally am a novice with PHP and for the type of work we do; the language of my choice has never been an issue. Most of my clients could care less what I am using, just so the job gets done. If any of this sounds interesting to you, email me and I will send you a list of current clients and links and we could possibly start a dialogue. I would list the clients here, but feel that dropping names on the list would be in poor taste. Thanks! John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body
Witango-Talk: Looking For a Developer
Hi Folks, I am looking for someone who would like to get into a start-up position with the opportunity to grow. Not sure if any of you are in the Minneapolis/St. Paul area, but thought I would give this list a shot before going to a more traditional search. I fell into a situation with another company that's going to keep me very busy for the next couple of years. Last month I billed over 230 hours and quite frankly, I am getting a bit overworked. All programming I have been doing has been done in Witango. We are planning on upgrading servers and software. We have been working with very large retail corporations on the certification of packaging companies both here in the states and overseas. Along with the certification process is another component where packaging is measured, evaluated and data stored in separate databases for these retail corporations. They use the data to evaluate the packaging suppliers and the products they produce. All of the data input and output is done via the Web. There are many facets to these projects and each retail corporation changes the criteria just enough to keep the individual websites unique. We also have about 50 other sites that are not related to the packaging certification process, some of these with large companies as well. Ultimately, what we are looking for could go in two directions, after much discussion... 1. A seasoned developer in Witango and PHP who is already established and would bring expertise to the table along with established clients that he or she would move into our hosting environment. This person would have the ability to bring in more business and also be able to handle pretty much anything we threw at them. A good working knowledge of MSSQL, DNS, CC processing, FTP, Routers, email servers and firewalls would be a plus. 2. A person just starting out who is well versed in PHP and would like to learn Witango on his or her own. This person would need to be a self-starter who would take the bull by the horns, so to speak, and have the ability to problem solve to advance their knowledge in programming in Witango. I won't have time for too much handholding. No body ever held my hand and I would expect the same of people who are truly interested in something like this. (Well... the only hand holding I got was from all you good people on the list who have taught me a lot over the years) All our servers used for Web applications are Windows based. Some of the internal stuff is MAC, but we would really be concentrating on the Web stuff. Granted, our platforms are fairly old (Win2000 and 2003) and we are still working with Witango 2000, but we are looking for upgrades across the board as the work is being ramped up. Some of the work will involve these upgrades and moving sites to more recent software and platforms. We plan on upgrading to the latest Witango, and to upgrade all platforms while leaving the old in place so we can migrate and test as time allows. The only reason I am throwing PHP into the mix is because we feel it might attract a wider customer base by offering programming in a more popular language. We would be willing to buy the server(s) in order for us to expand into this arena. PHP may or may not play a role in the hiring, but may be a plus that we could discuss. I personally am a novice with PHP and for the type of work we do; the language of my choice has never been an issue. Most of my clients could care less what I am using, just so the job gets done. If any of this sounds interesting to you, email me and I will send you a list of current clients and links and we could possibly start a dialogue. I would list the clients here, but feel that dropping names on the list would be in poor taste. Thanks! John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. ci.gif
RE: Witango-Talk: Forcing jpg Download
Well folks, I never did get this to work. I tried everything and could never get a jpg or gif that wasn't corrupted somehow. I even compared file sizes and they were exactly the same from the original. I went as far as thinking that the read function was corrupting the file so I created a read, loaded a variable and then wrote that variable to a different directory to see if the jpg would corrupt and guess what?... that worked fine... in other words, this does not seem to be a Witango problem because a can read and write without any corruption whatsoever. It appears to be an IIS problem. All of these were tested on MAC and PC using IE and Firefox... none of them worked. So I decided to bite the bullet and I created a directory structure and changed the mime types in those directories in IIS for gif and jpg to x-application/attachment and it works flawlessly for both gifs and jpgs. Oh well. Guess I'll have to update the images in 2 places rather then one. Not a big deal... there are only about 3000 images. I appreciate the help anyway. I have done header rewrites in the past for purging cache and such and never had a problem, I just couldn't get this to work and the amount of time I was spending on this for the client was a bit beyond what the client was going to pay. Here are the 4 header rewrites that I tried to no avail, if anyone is interested... @purgeresults@ASSIGN local$httpHeader VALUE=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-Type: application/jpg@CRLFContent-Disposition: attachment; filename=@VAR filename@CRLF@USERREFERENCECOOKIE@CRLF@CRLF@VAR FileData scope=local @assign name=httpHeader scope=local value=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-type: application/jpg@crlfContent-Disposition: attachment; filename=@VAR filename@crlfContent-Length: @VARINFO NAME=FileData size@crlf@crlf@purgeresults@VAR FileData scope=local @purgeresults@assign local$httpHeader 'HTTP/1.0 200 OK@crlfContent-Type: image/jpeg; filename=@VAR filename@CRLFContent-Disposition: attachment; filename=@VAR filename@CRLF@CRLF'@var local$FileData encoding=none @ASSIGN httpHeader VALUE=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-Type: image/jpeg@CRLFContent-Disposition: attachment; filename=@VAR filename@CRLF@CRLF@var local$FileData encoding=none Thanks again! _ From: Robert Garcia [mailto:rgar...@bighead.net] Sent: Wednesday, March 30, 2011 1:18 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Forcing jpg Download So I found a taf from one of the more recent applications I had done in witango. First, I have a data action that gets data from db, this is in the results for that action: @assign local$image @column hiRez.image encoding=none @assign local$cLength @column hiRez.data_size encoding=none Then a results only action to assign header, notice use of @exclude to allow nice formatting, but not add anything to the result buffer: @exclude @ifempty @arg filename    @assign local$fileName image.jpg @else    @assign local$fileName @arg fileName /@if @assign local$httpHeader 'HTTP/1.1 200 OK@crlfServer: WiTango Server 4.05.047@crlfMIME-Version: 1.0@crlfContent-Type: application/download@crlfContent-disposition: attachment; filename=@var local$fileName@crlfContent-length: @var local$cLength@crlfExpires: -1@crlf@crlf' @assign local$encodehttpresponse False /@exclude And then a final results only results page for the image data: @purgeresults@var local$image encoding=none A couple of notes. 1. I am aware of deprecation of local scope, this is not in service anymore. 2. Before we started storing the content-length in the DB, we would get it like this: @assign local$cLength @length @column hiRez.image encoding=none This worked reliably, this was not for eventpix, but for a large image library website, stock photography and such. The only issue with the above was that sometimes @length would be 1 byte off, and cause an issue. On 3/29/2011 4:18 PM, Robert Garcia wrote: Also Disposition inline will not download, must be attachment. -- Robert Garcia BigHead Technology 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - http://bighead.net/ Sent with Sparrow http://bit.ly/sigsprw On Tuesday, March 29, 2011 at 3:49 PM, Ben Johansen wrote: There alway needs to be 2 CRLF's after header info. So in your first example you only have one and the 2nd you have the extra @purge. also, I don't there there is a mime type called application/jpeg it should be image/jpeg here is what I did for jpegs @purgeresults@assign request$httpHeader 'HTTP/1.1 200 OK@crlfContent-Type: image/jpeg; filename=mithumb.jpg@CRLFContent-Disposition: inline; filename=mithumb.jpg@CRLF@CRLF'@var request$imagedata encoding=none On Mar 29, 2011, at 2:54 PM, WebDude wrote: I appreciate the help so far. I feel I am 95% there. I have tried this with these 2 header rewrites (all on one line, of course)... @purgeresults@ASSIGN local$httpHeader VALUE
Witango-Talk: Forcing jpg Download
PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).
I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?
@purgeresults@ASSIGN local$httpHeader
VALUE=Content-Type:application/jpg@CRLFContent-Disposition: attachment,
filename='@COLUMN images.LargerImage'@CRLFreadfile('@COLUMN
images.LargerImage')@CRLF@USERREFERENCECOOKIE@CRLF
Thanks for your thoughts...
WebDude
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: Forcing jpg Download
M wondering if I need the oimage path anywhere in the header
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 11:45 AM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Forcing jpg Download
PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).
I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?
@purgeresults@ASSIGN local$httpHeader
VALUE=Content-Type:application/jpg@CRLFContent-Disposition: attachment,
filename='@COLUMN images.LargerImage'@CRLFreadfile('@COLUMN
images.LargerImage')@CRLF@USERREFERENCECOOKIE@CRLF
Thanks for your thoughts...
WebDude
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: Forcing jpg Download
@COLUMN images.LargerImage is the name of the file.
-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Tuesday, March 29, 2011 12:06 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download
What is in the database column @COLUMN images.LargerImage? Is this the
name of the image file or the binary JPEG data?
Robert
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 12:45 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Forcing jpg Download
PHP has a handy header rewrite for forcing a jpg download. I was wondering
if anyone has ever done this in Witango. I've been able to get this to work
on IIS by changing the directory header, the problem being is that I have 2
sites that reference the same images and one needs to force a download and
the other to view the image in a browser (same images in the same
directories).
I've been dabbling but can't seem to get it to work right. Of course when I
add header change to the top of the taf file, it tries to download the taf
file itself rather then the jpg file. This is stupid I know, but what is the
best way to force a download of a jpg and get it to work? This is what I
have so far. Am I missing something fundamental in trying to do this?
@purgeresults@ASSIGN local$httpHeader
VALUE=Content-Type:application/jpg@CRLFContent-Disposition: attachment,
filename='@COLUMN images.LargerImage'@CRLFreadfile('@COLUMN
images.LargerImage')@CRLF@USERREFERENCECOOKIE@CRLF
Thanks for your thoughts...
WebDude
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: Forcing jpg Download
What do you mean by Then you dump out the contents of the jpeg AFTER the
header. Do I read the jpg using the Read File Action as in what the other
Robert suggested? Is that what the @VAR Request$FileData is?
M... I'll give it a shot...
-Original Message-
From: Robert Garcia [mailto:rgar...@bighead.net]
Sent: Tuesday, March 29, 2011 1:28 PM
To: Witango-Talk@witango.com
Cc: Robert Shubert
Subject: Re: Witango-Talk: Forcing jpg Download
We have done that many times before in witango. That is the correct header
you need to use, and attachment is the correct way. However, it looks like
you are trying to put the contents of the file in the filename part, that
header just takes the filename, and it should end in JPG or JPEG, or match
the mime of the content with the extension, or it may not work on all
browsers. Then you dump out the contents of the jpeg AFTER the header. Here
is an example I found from a TAF that I know we had working:
@assign name=httpHeader scope=request value=HTTP/1.0 200
OK@crlfMIME-Version: 1.0@crlfContent-type:
application/download@crlfContent-Disposition: attachment;
filename=downloadreport.xls@crlfContent-Length: @length
@@request$FileData@crlf@crlf@purgeresults@VAR Request$FileData
It is important to know that you must NOT have ANY returns in this results
page where you use this code, it should be on one line. We do this in other
places with JPEGs, but we use image/jpeg for content-type, and a variable
usually for filename. Content-length is also important, but can be a big
buggy in witango.
On 3/29/2011 11:09 AM, Robert Shubert wrote:
In that case, I think you have the header correct. What you need to do
afterwards is use a Read File Action to bring the content of the JPEG
into Witango and then simply display it as the response. It's
important that you don't get any additional characters (like extra
returns or spaces in the result)
Robert
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 1:49 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download
@COLUMN images.LargerImage is the name of the file.
-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Tuesday, March 29, 2011 12:06 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Forcing jpg Download
What is in the database column@COLUMN images.LargerImage? Is this
the name of the image file or the binary JPEG data?
Robert
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, March 29, 2011 12:45 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Forcing jpg Download
PHP has a handy header rewrite for forcing a jpg download. I was
wondering if anyone has ever done this in Witango. I've been able to
get this to work on IIS by changing the directory header, the problem
being is that I have 2 sites that reference the same images and one
needs to force a download and the other to view the image in a browser
(same images in the same directories).
I've been dabbling but can't seem to get it to work right. Of course
when I add header change to the top of the taf file, it tries to
download the taf file itself rather then the jpg file. This is stupid
I know, but what is the best way to force a download of a jpg and get
it to work? This is what I have so far. Am I missing something fundamental
in trying to do this?
@purgeresults@ASSIGN local$httpHeader
VALUE=Content-Type:application/jpg@CRLFContent-Disposition:
attachment, filename='@COLUMN
images.LargerImage'@CRLFreadfile('@COLUMN
images.LargerImage')@CRLF@USERREFERENCECOOKIE@CRLF
Thanks for your thoughts...
WebDude
To unsubscribe from this list, please send an email to
lists...@witango.com with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to
lists...@witango.com with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to
lists...@witango.com with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to
lists...@witango.com with unsubscribe witango-talk in the body.
--
Robert Garcia
BigHead Technology
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net - http://bighead.net/
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: Forcing jpg Download
I appreciate the help so far. I feel I am 95% there. I have tried this with these 2 header rewrites (all on one line, of course)... @purgeresults@ASSIGN local$httpHeader VALUE=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-Type: application/jpg@CRLFContent-Disposition: attachment; filename=@VAR filename@CRLF@USERREFERENCECOOKIE@CRLF@VAR FileData scope=local @assign name=httpHeader scope=local value=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-type: application/jpg@crlfContent-Disposition: attachment; filename=@VAR filename@crlfContent-Length: @VARINFO NAME=FileData size@crlf@crlf@purgeresults@VAR FileData scope=local I am assigning the filename from a search and writing the data to FileData It actually finds the filename and downloads the file. The problem is that the file seems to be corrupt. It will not display in a browser and when I try to open it in PhotoShop I get the following error (I tried this in multiple browsers) Could not open the document because a JPEG marker segment length is too short (the file may be truncated or incomplete). Is there something else I may be missing? I appreciate the help! -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 29, 2011 1:57 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Forcing jpg Download Yes - you have that correct. -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 29, 2011 2:58 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Forcing jpg Download What do you mean by Then you dump out the contents of the jpeg AFTER the header. Do I read the jpg using the Read File Action as in what the other Robert suggested? Is that what the @VAR Request$FileData is? M... I'll give it a shot... -Original Message- From: Robert Garcia [mailto:rgar...@bighead.net] Sent: Tuesday, March 29, 2011 1:28 PM To: Witango-Talk@witango.com Cc: Robert Shubert Subject: Re: Witango-Talk: Forcing jpg Download We have done that many times before in witango. That is the correct header you need to use, and attachment is the correct way. However, it looks like you are trying to put the contents of the file in the filename part, that header just takes the filename, and it should end in JPG or JPEG, or match the mime of the content with the extension, or it may not work on all browsers. Then you dump out the contents of the jpeg AFTER the header. Here is an example I found from a TAF that I know we had working: @assign name=httpHeader scope=request value=HTTP/1.0 200 OK@crlfMIME-Version: 1.0@crlfContent-type: application/download@crlfContent-Disposition: attachment; filename=downloadreport.xls@crlfContent-Length: @length @@request$FileData@crlf@crlf@purgeresults@VAR Request$FileData It is important to know that you must NOT have ANY returns in this results page where you use this code, it should be on one line. We do this in other places with JPEGs, but we use image/jpeg for content-type, and a variable usually for filename. Content-length is also important, but can be a big buggy in witango. On 3/29/2011 11:09 AM, Robert Shubert wrote: In that case, I think you have the header correct. What you need to do afterwards is use a Read File Action to bring the content of the JPEG into Witango and then simply display it as the response. It's important that you don't get any additional characters (like extra returns or spaces in the result) Robert -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 29, 2011 1:49 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Forcing jpg Download @COLUMN images.LargerImage is the name of the file. -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 29, 2011 12:06 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Forcing jpg Download What is in the database column@COLUMN images.LargerImage? Is this the name of the image file or the binary JPEG data? Robert -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 29, 2011 12:45 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Forcing jpg Download PHP has a handy header rewrite for forcing a jpg download. I was wondering if anyone has ever done this in Witango. I've been able to get this to work on IIS by changing the directory header, the problem being is that I have 2 sites that reference the same images and one needs to force a download and the other to view the image in a browser (same images in the same directories). I've been dabbling but can't seem to get it to work right. Of course when I add header change to the top of the taf file, it tries to download the taf file itself rather then the jpg file. This is stupid I know, but what is the best way to force a download of a jpg and get it to work? This is what I have so far. Am I missing something fundamental
RE: Witango-Talk: Print on javascript
On one page, add something like this...
FORM METHOD=POST ACTION=print-this-doc.taf onClick=print1()
TARGET=print-this-doc
INPUT TYPE=SUBMIT VALUE=Print /FORM
In the header of that page or as a linked JS script, use this for a pop-up
window...
function print1() {
window.open(,suppliers1,width=1,height=1,resizable=no,toolbar=no,locati
on=no,directories=no,scrollbars=no,top=1,left=2000)
}
left=2000 will pop the window open off screen. Kind of annoying to have it
pop up on screen.
On the page you want to print, us this in the body tag...
body onload=window.print();setTimeout('window.close()',500);
Setting the window close to 500 is important because on on some browsers,
most notably on Safari for the Mac, the print will error if not all the
information is loaded on the print page and that page is trying to close,
thus time out to load the page before closing it.
You could also use something like this...
body onload=window.print();setTimeout('window.close()',500);
onunload=opener.location=(another-page-or-confirmation-page.taf?_function=p
rintdone')
to load a different page like a conformation page in the original location
that had the print button.
Hope this helps.
_
From: Anthony Humphreys [mailto:anth...@humphreys.org]
Sent: Monday, February 21, 2011 11:08 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Print on javascript
For security reasons, you cannot take control of my printer, nor change
it's settings (like force duplex, or turn off colour, or print 100 copies)
All you can do is offer the user a convenient link to print with
window.print() and let the user decide to press OK, or whatever.
I, for one, would not want to be surprised to find that some web page has
randomly taken over my printer. However, there are other products which do
allow more control (and offer usually better quality) for printing. However,
the quantity printed is generally on the honour system, and limited by
licence. PDF is one such mechanism, but there are others.
With CSS you do have some control over what does, and does not, get sent to
the printer (or screen). This allows you to, for instance, turn off menus
that aren't part of the main content that a user would want printed; or,as
another example, place a different style of banner ad on the printed page,
as opposed to the version of the same ad which appears on the screen -- this
printed version may even include a coupon or discount for a product or a
store. If available in the browser, CSS may even suggest where the page
break should go. But -- again -- it cannot change the settings of, or even
the number of copies on, the printer.
However, some browsers (and/or some browser plug-ins) do allow users to turn
on/off CSS -- or even use a user-supplied CSS. Developers (like myself)
often use tools like these to help them test their pages for certain things.
Anthony -
On Mon, Feb 21, 2011 at 4:41 PM, MC Tay sm...@media88.com wrote:
Hi:
We are looking for an alternative print page javascript that would
print once only and without displaying the print dialog. Any one has
any script that can share please?
We use window.print() currently.
Thanks!
MC
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
_
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: Print on javascript
ooops,
Sorry, I didn't see the without displaying the print dialogue. Anthony is
right. To open up javascript to be able to get into and influence system
apps and files would open up serious security issues.
_
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, February 22, 2011 7:10 AM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Print on javascript
On one page, add something like this...
FORM METHOD=POST ACTION=print-this-doc.taf onClick=print1()
TARGET=print-this-doc
INPUT TYPE=SUBMIT VALUE=Print /FORM
In the header of that page or as a linked JS script, use this for a pop-up
window...
function print1() {
window.open(,suppliers1,width=1,height=1,resizable=no,toolbar=no,locati
on=no,directories=no,scrollbars=no,top=1,left=2000)
}
left=2000 will pop the window open off screen. Kind of annoying to have it
pop up on screen.
On the page you want to print, us this in the body tag...
body onload=window.print();setTimeout('window.close()',500);
Setting the window close to 500 is important because on on some browsers,
most notably on Safari for the Mac, the print will error if not all the
information is loaded on the print page and that page is trying to close,
thus time out to load the page before closing it.
You could also use something like this...
body onload=window.print();setTimeout('window.close()',500);
onunload=opener.location=(another-page-or-confirmation-page.taf?_function=p
rintdone')
to load a different page like a conformation page in the original location
that had the print button.
Hope this helps.
_
From: Anthony Humphreys [mailto:anth...@humphreys.org]
Sent: Monday, February 21, 2011 11:08 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Print on javascript
For security reasons, you cannot take control of my printer, nor change
it's settings (like force duplex, or turn off colour, or print 100 copies)
All you can do is offer the user a convenient link to print with
window.print() and let the user decide to press OK, or whatever.
I, for one, would not want to be surprised to find that some web page has
randomly taken over my printer. However, there are other products which do
allow more control (and offer usually better quality) for printing. However,
the quantity printed is generally on the honour system, and limited by
licence. PDF is one such mechanism, but there are others.
With CSS you do have some control over what does, and does not, get sent to
the printer (or screen). This allows you to, for instance, turn off menus
that aren't part of the main content that a user would want printed; or,as
another example, place a different style of banner ad on the printed page,
as opposed to the version of the same ad which appears on the screen -- this
printed version may even include a coupon or discount for a product or a
store. If available in the browser, CSS may even suggest where the page
break should go. But -- again -- it cannot change the settings of, or even
the number of copies on, the printer.
However, some browsers (and/or some browser plug-ins) do allow users to turn
on/off CSS -- or even use a user-supplied CSS. Developers (like myself)
often use tools like these to help them test their pages for certain things.
Anthony -
On Mon, Feb 21, 2011 at 4:41 PM, MC Tay sm...@media88.com wrote:
Hi:
We are looking for an alternative print page javascript that would
print once only and without displaying the print dialog. Any one has
any script that can share please?
We use window.print() currently.
Thanks!
MC
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
_
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
_
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
RE: Witango-Talk: OT - FTP interactions
Okay, so let's talk about command line tools and forget about diplaying thumbs. Sorry, I have never tried using/firing command line tools from Witango. Any hints on how to get started with this? Let's say I just want to be able to list the contents (filenames) of a directory via ftp and possibly parse that data out into a text file or an array. I am not sure where to start. Any hints? p.s. Windows OS... Thanks! _ From: Robert Garcia [mailto:wita...@bighead.net] Sent: Monday, November 22, 2010 2:44 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: OT - FTP interactions I used to use witango pretty successfully with FTP, but I was using a special FTP server that came with a com object that worked with witango. It was TitanFTP. Another way, is just working with command line tools. Once you get it working, you can make an ftp class with chdir, ls, put, get routines, etc. Thumbnails are going to be a b*tch if you are going to try to to make the thumb represent the content. I would say this is probably NOT doable unless you have an FTP server that does this for you, and you have a webservice to call. If it doesn't, you would have to traverse the site, cache your own thumbs on a regular basis, very prohibitive. A simple way of doing thumbs, is use OS X or windows thumbnails for the TYPES of file that it is. So you just check if its extension is JPG, and use a thumb for that, PDF, you get the idea. Then have a generic FILE thumbnail for all else, and over time you can build up how many extensions you recognize. Good luck! -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Nov 22, 2010, at 6:01 AM, WebDude wrote: This is way off topic, but I have a client who is asking some questions that I am having a hard time answering. I was hoping some of you with more knowledge then I can give me some direction. I see all sorts of probems with this, but am trying to figure out what to say to him. I believe the files he is talking about are pfd files. I would think, first off, that you would need at least to have the directory structure along with filenames loaded into the DB before you could do anything he is asking me to do. In other words, it sounds like he wants to crawl the ftp site and load the information into a db. And then just display the files via thumbs, probably clicking them to add to a basket system, etc. Don't shoot me on this, I am just the messenger, but below is what is being asked for word for word from the client... I have a couple of key questions, one is how can a database interact with a FTP? Could a DB pull thumbnails from an FTP and display them on the web? Could a DB understand from a folder location on a sever what value to assign to it? For example if the DB searched the server for a file, and file's location was in folder 1, could it assign a price to it, if the DB understood all items in folder 1 have a $10 value? My head hurts. I think he wants to be able to have the client find these files, add them to a basket system, and download them when done. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: OT - FTP interactions
Thanks... I will take a hack at this. I contacted the client and might be able to get them to pay to upgrade to 6. I like it when clients are like that, eh? _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, November 23, 2010 9:38 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Over the years I've built tools for my hosting customers, one of them being FTP. Attached is the raw code from that tool, and below are the instructions: I'm sorry that I can't work this up more, but I'm tied up with Witango 6 release, and once that's out all of this will be moot anyway. Note that this is intended for Witango 5.5 so you might have to hack around with it. It's also tested on Windows 2003, using the included FTP client. Robert This method provides basic FTP functions on-the-fly from within your application. You can quickly upload and download files to any remote FTP server. Keep in mind that the transfer time is counted towards your request execution time and large transfers will likely timeout, although they should complete. Action: (Required) GET (download) | PUT (upload) | LIST (get a directory listing). File_Name: (Required for GET and PUT) This is the name of the file that you wish to transfer. File_Path: (Required for GET and PUT) This is the local directory in your web folder that you want to transfer the file from or to. Remote_Server: (Required) This can either be a host name (ftp.tronics.com) or IP address. Username: (Required for authentication) The username used to login to the remote server. Password: (Required for authentication) The password used to login to the remote server. Remote_Directory: (optional) You can specify a directory to change to on the remote server after login but before the action. Directory_Listing: (Out Parameter) Array. Only populated when using the LIST action. The method will return a transcript of the session with the remote server. This is useful for debugging, but should be considered sensitive and should not be stored or displayed except for debugging purposes. You can only execute one action per call. The File_Path will automatically be forced to your web site's root level. You can specify additional folders if needed (path1\path2). The remote server can also accept a port number after a colon such as 23.123.123.123:456. The Remote_Directory can also have multiple levels defined at once (path1/path2). From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, November 23, 2010 8:09 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Okay, so let's talk about command line tools and forget about diplaying thumbs. Sorry, I have never tried using/firing command line tools from Witango. Any hints on how to get started with this? Let's say I just want to be able to list the contents (filenames) of a directory via ftp and possibly parse that data out into a text file or an array. I am not sure where to start. Any hints? p.s. Windows OS... Thanks! _ From: Robert Garcia [mailto:wita...@bighead.net] Sent: Monday, November 22, 2010 2:44 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: OT - FTP interactions I used to use witango pretty successfully with FTP, but I was using a special FTP server that came with a com object that worked with witango. It was TitanFTP. Another way, is just working with command line tools. Once you get it working, you can make an ftp class with chdir, ls, put, get routines, etc. Thumbnails are going to be a b*tch if you are going to try to to make the thumb represent the content. I would say this is probably NOT doable unless you have an FTP server that does this for you, and you have a webservice to call. If it doesn't, you would have to traverse the site, cache your own thumbs on a regular basis, very prohibitive. A simple way of doing thumbs, is use OS X or windows thumbnails for the TYPES of file that it is. So you just check if its extension is JPG, and use a thumb for that, PDF, you get the idea. Then have a generic FILE thumbnail for all else, and over time you can build up how many extensions you recognize. Good luck! -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Nov 22, 2010, at 6:01 AM, WebDude wrote: This is way off topic, but I have a client who is asking some questions that I am having a hard time answering. I was hoping some of you with more knowledge then I can give me some direction. I see all sorts of probems with this, but am trying to figure out what to say to him. I believe the files he is talking about are pfd files. I would think, first off, that you would need at least to have the directory structure along with filenames loaded into the DB before you
Witango-Talk: OT - FTP interactions
This is way off topic, but I have a client who is asking some questions that I am having a hard time answering. I was hoping some of you with more knowledge then I can give me some direction. I see all sorts of probems with this, but am trying to figure out what to say to him. I believe the files he is talking about are pfd files. I would think, first off, that you would need at least to have the directory structure along with filenames loaded into the DB before you could do anything he is asking me to do. In other words, it sounds like he wants to crawl the ftp site and load the information into a db. And then just display the files via thumbs, probably clicking them to add to a basket system, etc. Don't shoot me on this, I am just the messenger, but below is what is being asked for word for word from the client... I have a couple of key questions, one is how can a database interact with a FTP? Could a DB pull thumbnails from an FTP and display them on the web? Could a DB understand from a folder location on a sever what value to assign to it? For example if the DB searched the server for a file, and file's location was in folder 1, could it assign a price to it, if the DB understood all items in folder 1 have a $10 value? My head hurts. I think he wants to be able to have the client find these files, add them to a basket system, and download them when done. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: OT - FTP interactions
M... This FTP site is not in my control. It is housed by a third party and as far as I know it has no http capabilities. We will not be able to add meta-data or control the directory/file structure in any way. Nor will we know ahead of time what the file structure is or the filenames within any of the directories. All we will be getting is a list of the directories (maybe multiple levels) and a username and password. From this they want to display thumbs of pdf files within these directories and when a thumb (pdf file) is clicked, add the thumb (filename, I would suspect) into a basket built on our end along with the price via the directory the pdf file happened to be in. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 8:46 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions This doesn't seem too hard. I think I would first try using the FTP site as if it were a database. This may be too slow, however, depending on the amount of content in the FTP server and the load on the site, but I would probably add simple memory caching rather than trying to sync a db. Witango 6 will be able to implement something easily as it directly supports server-side FTP now. The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10) You could even put meta-data files in each directory (or for each file) with descriptions and prices. Doesn't sound altogether unreasonable. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 9:02 AM To: Witango-Talk@witango.com Subject: Witango-Talk: OT - FTP interactions This is way off topic, but I have a client who is asking some questions that I am having a hard time answering. I was hoping some of you with more knowledge then I can give me some direction. I see all sorts of probems with this, but am trying to figure out what to say to him. I believe the files he is talking about are pfd files. I would think, first off, that you would need at least to have the directory structure along with filenames loaded into the DB before you could do anything he is asking me to do. In other words, it sounds like he wants to crawl the ftp site and load the information into a db. And then just display the files via thumbs, probably clicking them to add to a basket system, etc. Don't shoot me on this, I am just the messenger, but below is what is being asked for word for word from the client... I have a couple of key questions, one is how can a database interact with a FTP? Could a DB pull thumbnails from an FTP and display them on the web? Could a DB understand from a folder location on a sever what value to assign to it? For example if the DB searched the server for a file, and file's location was in folder 1, could it assign a price to it, if the DB understood all items in folder 1 have a $10 value? My head hurts. I think he wants to be able to have the client find these files, add them to a basket system, and download them when done. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: OT - FTP interactions
Well, call me dumb, but where could I get information on how to do this. I am having a hard enough time just trying to display a directory of images thorugh the http protocol. Are you saying that we could let the customer traverse the ftp site via the ftp protocol (i.e. ftp://test1/test2/test3/file.pdf ftp://test1/test2/test3/file.pdf ) ? I get that part, but when they click, how do you capture that filepath and file and insert the info into a db? or am I missing something here... By the way... thanks... _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 9:28 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Well, I'm not sure how you would generate a thumb of a specific PDF. I suppose your could use a tool that renders PDF to JPEG, but that could get a little complex. Other than that, this is straight forward. Simply traverse the FTP structure through the FTP protocol. Think of it like working with an XML file. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 10:11 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions M... This FTP site is not in my control. It is housed by a third party and as far as I know it has no http capabilities. We will not be able to add meta-data or control the directory/file structure in any way. Nor will we know ahead of time what the file structure is or the filenames within any of the directories. All we will be getting is a list of the directories (maybe multiple levels) and a username and password. From this they want to display thumbs of pdf files within these directories and when a thumb (pdf file) is clicked, add the thumb (filename, I would suspect) into a basket built on our end along with the price via the directory the pdf file happened to be in. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 8:46 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions This doesn't seem too hard. I think I would first try using the FTP site as if it were a database. This may be too slow, however, depending on the amount of content in the FTP server and the load on the site, but I would probably add simple memory caching rather than trying to sync a db. Witango 6 will be able to implement something easily as it directly supports server-side FTP now. The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10) You could even put meta-data files in each directory (or for each file) with descriptions and prices. Doesn't sound altogether unreasonable. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 9:02 AM To: Witango-Talk@witango.com Subject: Witango-Talk: OT - FTP interactions This is way off topic, but I have a client who is asking some questions that I am having a hard time answering. I was hoping some of you with more knowledge then I can give me some direction. I see all sorts of probems with this, but am trying to figure out what to say to him. I believe the files he is talking about are pfd files. I would think, first off, that you would need at least to have the directory structure along with filenames loaded into the DB before you could do anything he is asking me to do. In other words, it sounds like he wants to crawl the ftp site and load the information into a db. And then just display the files via thumbs, probably clicking them to add to a basket system, etc. Don't shoot me on this, I am just the messenger, but below is what is being asked for word for word from the client... I have a couple of key questions, one is how can a database interact with a FTP? Could a DB pull thumbnails from an FTP and display them on the web? Could a DB understand from a folder location on a sever what value to assign to it? For example if the DB searched the server for a file, and file's location was in folder 1, could it assign a price to it, if the DB understood all items in folder 1 have a $10 value? My head hurts. I think he wants to be able to have the client find these files, add them to a basket system, and download them when done. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: OT - FTP interactions
Well I am hosed then since I am working with Witango 2000. Maybe that was why I was so confused. Very cool with this new functionality in 6.0. I am going back to the client to see of the importance of this. I may be upgrading sooner then I thought! _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 10:46 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Here's the part that I think you missing: Your user goes to the page: www.yoursite.com/ftp_cart.taf ftp_cart.taf in turn logs into the FTP server, reads the root directory and displays an HTML page of options (files and folders) to the user. The user then clicks a folder (say folder1) which looks like this: www.yoursite.com/ftp_cart.taf?browse=/folder1 ftp_cart.taf, now with a path argument, logs into the FTP server and retrieves the path given and displays it to the user as a nice HTML page. Now let's say the user clicks a file to add to his cart: www.yoursite.com/ftp_cart.taf?add=/folder1/file2.pdf now, you know folder1 so you can derive $10.00. And you know the full path and filename so you can download the file and present it to the user with a Witango script. Hopefully that gives you some idea of how your Witango application will act as a window to the FTP site and allow you to apply all the necessary logic. This is similar to building an HTML email client in Witango, or perhaps accessing information stored in XML files or on remote sites through web services (eg. RSS). In this case, the remote data source just happens to be an FTP site. Unfortunately, Witango 5/5.5 doesn't help you here at all. I'm working hard to get Witango 6 out soon, and the server-side FTP functions should help you to develop this functionality easily. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 10:42 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Well, call me dumb, but where could I get information on how to do this. I am having a hard enough time just trying to display a directory of images thorugh the http protocol. Are you saying that we could let the customer traverse the ftp site via the ftp protocol (i.e. ftp://test1/test2/test3/file.pdf ftp://test1/test2/test3/file.pdf ) ? I get that part, but when they click, how do you capture that filepath and file and insert the info into a db? or am I missing something here... By the way... thanks... _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 9:28 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions Well, I'm not sure how you would generate a thumb of a specific PDF. I suppose your could use a tool that renders PDF to JPEG, but that could get a little complex. Other than that, this is straight forward. Simply traverse the FTP structure through the FTP protocol. Think of it like working with an XML file. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 10:11 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions M... This FTP site is not in my control. It is housed by a third party and as far as I know it has no http capabilities. We will not be able to add meta-data or control the directory/file structure in any way. Nor will we know ahead of time what the file structure is or the filenames within any of the directories. All we will be getting is a list of the directories (maybe multiple levels) and a username and password. From this they want to display thumbs of pdf files within these directories and when a thumb (pdf file) is clicked, add the thumb (filename, I would suspect) into a basket built on our end along with the price via the directory the pdf file happened to be in. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, November 22, 2010 8:46 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: OT - FTP interactions This doesn't seem too hard. I think I would first try using the FTP site as if it were a database. This may be too slow, however, depending on the amount of content in the FTP server and the load on the site, but I would probably add simple memory caching rather than trying to sync a db. Witango 6 will be able to implement something easily as it directly supports server-side FTP now. The rest is just logic. (@IF foldername=folder1 @ASSIGN price 10) You could even put meta-data files in each directory (or for each file) with descriptions and prices. Doesn't sound altogether unreasonable. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, November 22, 2010 9:02 AM To: Witango-Talk@witango.com Subject: Witango-Talk: OT - FTP interactions This is way off topic, but I have a client who is asking some questions that I am having
RE: Witango-Talk: What's in a name?
I also agree... especially the rolling off the tongue part. I always had a problem saying w - i - tango... er... um... or is it why Tango? _ From: Rich [mailto:r...@ogdengroup.com] Sent: Wednesday, October 20, 2010 8:20 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: What's in a name? I agree, time to leave the bad taste in everyone's mouth Witango. A relaunch with the Tango is a great idea. Rich _ From: Steve Smith [mailto:ssm...@oakbridge.ca] Sent: Wednesday, October 20, 2010 8:35 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: What's in a name? I second the idea of a name change and agree that I'd like to see the product's name return to Tango. Perhaps I'm biased because I was a employee of EveryWare and Pervasive, (1995-2000 and I go back to version 1.0 of Tango) but I still refer to it today as Tango whenever it comes up in conversation. Tango rolls off the tongue, Witango never did. And it was never as easy to explain what a .taf or .tcf file was after the name change. For those that aren't aware of the origins, .taf is Tango Application File and .tcf is Tango Class File. Steve Smith Oakbridge Information Solutions Oakville Office: (416) 628-0793 Cambridge Office: (519) 489-0142 Email: ssm...@oakbridge.ca Web: http://www.oakbridge.ca/ www.oakbridge.ca Certified http://www.oakbridge.ca/daylite.tml DayLite Master Partner Certified http://www.oakbridge.ca/daylite.tml DayLite Trainer Billings http://www.billingsapp.com/ Consultant FileMaker Business http://www.filemaker.com/ Alliance Member MoneyWorks http://www.moneyworks.ca/ Consultant LightSpeed http://www.xsilva.com/ Authorized Reseller On 2010-10-20, at 5:14 AM, Wayne Irvine wrote: A rose would smell as sweet, yadda yadda. Just wondering about the name 'Witango'. I knew the product when it was called Tango, which had a nice ring to it and brought about images of serious gentlemen and ravishing ladies entwined in something that was midway between a dance and a domestic. I believe the name change was force on 'With Imagination' (there's a clue to where the WI came from) when they negotiated rights to the product from Everywhere (IIRC). I wonder if this requirement is still valid? I for one would love a return to the old name now that With Imagination (who proved to be 'without' at least as far as Tango went) are no longer part of the equation. Might also make the logo design a bit simpler. Wayne irvine To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
Witango-Talk: Feature Request - Multiple Line replace
I don't know if anyone else remembers this, but way back when EveryWare had Tango, the find and replace function worked differently then is does now. Back then, you could find and replace multiple lines of code rather then just a string. Would this be something that could be easy to impliment? I found this very useful. Just a thought... To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Feature Request - Multiple Line replace
Perfect! Thanks Robert! _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, October 20, 2010 12:07 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Feature Request - Multiple Line replace Studio 6 allows for blocks of text in the find and replace functions. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Wednesday, October 20, 2010 12:59 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Feature Request - Multiple Line replace I don't know if anyone else remembers this, but way back when EveryWare had Tango, the find and replace function worked differently then is does now. Back then, you could find and replace multiple lines of code rather then just a string. Would this be something that could be easy to impliment? I found this very useful. Just a thought... _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Standard and Advanced
Sorry, I am a bit confused. What if I have 3 servers... One single instance on each server for Standard? Or would that require 3 Standards. How about Advanced... One advanced on 3 servers? 3 advanced for 3 servers? Sorry, I have the corporate which allows multiple installs on multiple servers and was wondering if there is something similar. Thanks! webd...@cipromo.com -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, October 13, 2010 9:10 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Standard and Advanced Wayne, We just updated this section of the website yesterday: https://www.witango.com/products/licensing As it shows, there are 2 restrictions on the Standard Edition: - You can only run it on a server with 4 or fewer CPU cores. - You can only run a single instance on each server. The Advanced Edition removes these two limitations. Also, future versions of the v6 product line will add some features to the Advanced server only. These features will be mostly geared towards better server pooling support for high traffic websites. The Standard Edition is being sold for use on workstations, entry-level servers, older hardware, and virtual servers. In all cases, the Witango server will use all addressable CPUs. Affinity has been removed from the product. Robert -Original Message- From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Tuesday, October 12, 2010 11:39 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Standard and Advanced I'm guessing this has been covered before but in my cursory glance over the archives I didn't see it. What is the difference between the Standard and Advanced Servers in version 6? Wayne Irvine To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Standard and Advanced
Actually, That sounds rather reasonable since the corporate license I have cost in excess of $20,000. If I needed to include the editor for all 3, would that be another $900? webd...@cipromo.com -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, October 13, 2010 9:38 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Standard and Advanced The Corporate (and Site and other large scale, multi-system) licenses have been discontinued. They may have been supported for version 5.0, but I do not believe they were sold for version 5.5 and we will not be supporting them for version 6. Each operating system requires a Witango Server license. This usually means that each physical server needs a license, but in the case of virtualization, each virtualized OS that you wish to run Witango on would require a license. So in your case, since you have 3 physical servers, you would purchase 3 Witango licenses. You can get any combination of Standard and Advanced that fits your hardware. For example, let's say that you have two Intel 3000 class servers each with a single quad-core CPU, and a newer Intel 5000 class server with dual quad-cores with HT (8 cores, 16 threads). You would purchase two Standard Editions for the 3000s and one Advanced Edition for the larger server. We offer a 10% volume discount for orders over 2 licenses. Therefore, you could pre-order now for 20% of the price as such: 2x 999 (-20%) = 1,598.40 1x 2499 (-20%) = 1,999.20 Total to license all 3 servers: $3,597.60 Robert -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Wednesday, October 13, 2010 10:20 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Standard and Advanced Sorry, I am a bit confused. What if I have 3 servers... One single instance on each server for Standard? Or would that require 3 Standards. How about Advanced... One advanced on 3 servers? 3 advanced for 3 servers? Sorry, I have the corporate which allows multiple installs on multiple servers and was wondering if there is something similar. Thanks! webd...@cipromo.com -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, October 13, 2010 9:10 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Standard and Advanced Wayne, We just updated this section of the website yesterday: https://www.witango.com/products/licensing As it shows, there are 2 restrictions on the Standard Edition: - You can only run it on a server with 4 or fewer CPU cores. - You can only run a single instance on each server. The Advanced Edition removes these two limitations. Also, future versions of the v6 product line will add some features to the Advanced server only. These features will be mostly geared towards better server pooling support for high traffic websites. The Standard Edition is being sold for use on workstations, entry-level servers, older hardware, and virtual servers. In all cases, the Witango server will use all addressable CPUs. Affinity has been removed from the product. Robert -Original Message- From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Tuesday, October 12, 2010 11:39 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Standard and Advanced I'm guessing this has been covered before but in my cursory glance over the archives I didn't see it. What is the difference between the Standard and Advanced Servers in version 6? Wayne Irvine To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Witango 6 Question
yeah... you know... sleep! Sleep? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 5, 2010, at 10:44 AM, Ben Johansen wrote: humm, I have worked with both the Roberts and noticed, this don't sleep phenomenon I wonder is it in the name ;-) On Oct 5, 2010, at 4:53 AM, Dan Stein wrote: but not surprising given the mazing speed of response and service that Tronics has provided as a hosting service and Witango hosting service all these years. I know for a fact that Robert is in fact a very friendly Zombie who in fact never sleeps. Or so it would seem. -- Dan Stein MSN, CPNP FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 303 W. Chestnut St Souderton PA 18964 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango,MSSQL, MySQL,PHP d...@dss-db.com www.dss-db.com http://www.dss-db.com/ It is perfectly safe to stand nowhere. On Oct 4, 2010, at 6:54 PM, Robert Garcia wrote: It really is amazing to see the quick response to the questions Robert. You may resurrect this thing yet, at least enough to restore a small but vibrant development community. Who knows where it can go after that, good job. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com http://eventpix.com/ 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 4, 2010, at 2:55 PM, Robert Shubert wrote: Kaustav, There are no security issues in Witango at this time (that I am aware of) and after hosting 5.5 for many years now, I have yet to see a situation occur on my servers where a breach has happened through Witango. Of course, should anything like this be brought to my attention, I will implement a fix ASAP. One other notable item is that I am working to update what dependencies I can for the v6 release. This is done mostly to ensure that bug and security fixes that have been made to the underlying libraries are included in Witango. I am deprecating some minor functionality, such as the @DOCS tag, which can be considered a security issue. I am keeping the save as run only (encryption) functionality, and am planning to implement more host-friendly features for site segregation and isolation of log and error data. Version 6 will have a completely reworked @URL functionality. It is now implemented as an Action in the studio and has drag-and-drop access to all aspects of the HTTP protocol. Robert From: Kaustav Acharya [mailto:kacha...@colleges.com] Sent: Monday, October 04, 2010 5:15 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Witango 6 Question Hi Robert, John and I were actually wondering about whether Witango 6 had any updated security fixes that were worthy of mentioning. Also another aspect which you've mentioned is the inability for Witango 5.5 Server on Windows to post via SSL using the @URL metatag. You mentioned that the best way to work around this is to use Win HTTP 5.1. Has this been an additional feature been addressed in the new version? Installing another object to do something so rudimentary is just an inconvenience so we were just wondering. Thanks very much! Kaustav Acharya Web Developer U. Inc. 12264 El Camino Real, Suite #401 San Diego, CA. 92130 Office: (858) 847-3350 x1004 Fax: (858) 847-3340 email: kacha...@colleges.com http://www.colleges.com http://www.colleges.com/ Power to the People - http://www.campaign.com http://www.campaign.com/ Important Note: This e-mail may contain privileged, undisclosed or confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform kacha...@colleges.com Immediately and permanently destroy the original transmittal. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. Ben Johansen http://www.webspinr.com http://www.webspinr.com/ b...@webspinr.com Phone: 360-597-3372 Mobile: 360-600-7775 _ To unsubscribe from this list, please send an email to
RE: Witango-Talk: Chat or IM
http://myfishingpals.com/ Check the chatroom... must be a member to view, but it's free. The chatroom script is free too. The whole thing runs in javascript/css/asp. _ From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Friday, September 17, 2010 10:13 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Chat or IM Hey all. I have a dating site written in WiTango. I need to add a live chat or IM capability to the site. Something like Facebook or Plenty of Fish. I'm not looking to have a 3rd party host the chat for me as I need to link it to my database so when users login they get logged into the chat as well. Java would be ideal, but through my searching I haven't found much. If anyone has done this before and can recommend something please let me know. Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca/ http://www.webenergy.ca _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. image001.jpg
RE: Witango-Talk: Chat or IM
I just missed ya in there. Login again and we can chat a bit. I'm in there now. I'll dig up the code for ya... John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Friday, September 17, 2010 11:44 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Chat or IM That is a really sweet chatroom! How do I find the source code? Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca/ http://www.webenergy.ca From: WebDude [mailto:webd...@cipromo.com] Sent: Friday, September 17, 2010 1:13 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Chat or IM http://myfishingpals.com/ Check the chatroom... must be a member to view, but it's free. The chatroom script is free too. The whole thing runs in javascript/css/asp. _ From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Friday, September 17, 2010 10:13 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Chat or IM Hey all. I have a dating site written in WiTango. I need to add a live chat or IM capability to the site. Something like Facebook or Plenty of Fish. I'm not looking to have a 3rd party host the chat for me as I need to link it to my database so when users login they get logged into the chat as well. Java would be ideal, but through my searching I haven't found much. If anyone has done this before and can recommend something please let me know. Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca http://www.webenergy.ca/ _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. ci.gifimage001.jpgimage002.jpg
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Ben and Robert,
Thank you very much. Direct DBMS was the ticket and it is working great.
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com
http://cipromo.com/ http://cipromo.com
_
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 3:04 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
Ben and Robert,
Unfortunately, I have to run to a meeting right now. I really appreciate the
input. I'll pick this up again tomorrow early.
Thanks you guys!
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com
http://cipromo.com/ http://cipromo.com
_
From: Ben Johansen [mailto:b...@webspinr.com]
Sent: Monday, September 13, 2010 2:18 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
wrapping the value in @SQ wont work if you are not using DirectDBMS
you need to set Quote Value to True to get rid of the {ts ...
On Sep 13, 2010, at 12:12 PM, WebDude wrote:
Okay,
By the way... thanks for your help...
I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.
Also note in the debug, it shows...
site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...
The variable loads fine. I am using...
@IFEMPTY @ARG site_eval_completed
@ASSIGN user$site_eval_completed NULL
@ELSE
@ASSIGN user$site_eval_completed @SQ@ARG
site_eval_completed@SQ
/@IF
It shows the variable loaded correctly in debug...
[ElseIf Action] [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars] [50]user$site_eval_completed=NULL
[Update Action] [50]Update1
[Query] [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals] [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200
hugo_camb...@gt.shr2shr.comcesar_montes@gt.shr2shr.com'; v7='07.24.2009';
v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment received 7.14.10';
v11='CN0097, 7.16.10, test sheets received 8.9'; v12='9.23.10'; v13='Open']
[Error] [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error] [66]-101 General error during data source operation.
Path:/admin/
File Name: status.taf
Position:Update1
Class: DBMS
Main Error Number: 241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008
_
Path:/admin/
File Name: status.taf
Position:Update1
Class: Internal
Main Error Number: -101
General error during data source operation.
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
This is no problem
First, setup a variable as such:
@IFEMPTY @ARG date
@ASSIGN request$sql_date_value NULL
@ELSE
@ASSIGN request$sql_date_value @SQ@ARG DATE@SQ
/@IF
Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the @SQs) rather than attempting to format the date
automatically.
Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.
Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm
Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)
The point is that by turning off Quote Value, formatting of the value
Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Hello, Can this be done? I have a table where they need to sort by date. The column is a datetime filed to sort dates correctly. we also need to be able to update the date, delete the date (make null) or keep the date null on an insert. Keeping the dat null on insert is fairly easy, but what if they want to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db. Can an insert of NULL be written in SQL? I tried he obvious... @IFEMPTY @ARG dateNULL@ELSE@ARG date/@IF, @IFEMPTY @ARG dateDbNull.value@ELSE@ARG date/@IF, etc... Has anyone done this before? Thanks! To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
That works fine on the initial insert. What about an update where a date existed before and now we want to delete the date? Only thing MSSQL will let you do is change to NULL. If you go into the Enterprise Manager, you can change the dates to NULL by doing a control 0. I am trying to write a statement that allows a NULL to be written as an update to the datetime field. _ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Monday, September 13, 2010 1:05 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field If the date form field is blank don't include the date insert section as part of the insert statement. Best way is to use the Direct DBMS action. Ted From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, September 13, 2010 1:46 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field Hello, Can this be done? I have a table where they need to sort by date. The column is a datetime filed to sort dates correctly. we also need to be able to update the date, delete the date (make null) or keep the date null on an insert. Keeping the dat null on insert is fairly easy, but what if they want to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db. Can an insert of NULL be written in SQL? I tried he obvious... @IFEMPTY @ARG dateNULL@ELSE@ARG date/@IF, @IFEMPTY @ARG dateDbNull.value@ELSE@ARG date/@IF, etc... Has anyone done this before? Thanks! _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Okay,
By the way... thanks for your help...
I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.
Also note in the debug, it shows...
site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...
The variable loads fine. I am using...
@IFEMPTY @ARG site_eval_completed
@ASSIGN user$site_eval_completed NULL
@ELSE
@ASSIGN user$site_eval_completed @SQ@ARG
site_eval_completed@SQ
/@IF
It shows the variable loaded correctly in debug...
[ElseIf Action] [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars] [50]user$site_eval_completed=NULL
[Update Action] [50]Update1
[Query] [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals] [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200 hugo_camb...@gt.shr2shr.com
cesar_mon...@gt.shr2shr.com'; v7='07.24.2009'; v8='YES.'; v9='08.10.09,
0809-1003'; v10='Wire payment received 7.14.10'; v11='CN0097, 7.16.10, test
sheets received 8.9'; v12='9.23.10'; v13='Open']
[Error] [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error] [66]-101 General error during data source operation.
Path:/admin/
File Name: status.taf
Position:Update1
Class: DBMS
Main Error Number: 241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008
_
Path:/admin/
File Name: status.taf
Position:Update1
Class: Internal
Main Error Number: -101
General error during data source operation.
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
This is no problem
First, setup a variable as such:
@IFEMPTY @ARG date
@ASSIGN request$sql_date_value NULL
@ELSE
@ASSIGN request$sql_date_value @SQ@ARG DATE@SQ
/@IF
Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the @SQs) rather than attempting to format the date
automatically.
Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.
Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm
Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)
The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.
Robert
PS. The value of NULL does not get quoted.
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 1:46 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Hello,
Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able to
update the date, delete the date (make null) or keep the date null on an
insert. Keeping the dat null on insert is fairly easy, but what if they want
to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db.
Can an insert of NULL be written in SQL? I tried he obvious... @IFEMPTY
@ARG dateNULL@ELSE@ARG date/@IF, @IFEMPTY @ARG
dateDbNull.value@ELSE@ARG date/@IF, etc...
Has anyone done this before?
Thanks!
_
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
_
To unsubscribe from this list, please send an email to lists...@witango.com
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
I guess I am hosed then, eh?
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 2:19 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
I think I just remembered that you are using Tango2000..
I suspect that my notes will only apply to the newer SQL Generator found in
5.x (possibly only 5.5).
Robert
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 3:13 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
Okay,
By the way... thanks for your help...
I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.
Also note in the debug, it shows...
site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...
The variable loads fine. I am using...
@IFEMPTY @ARG site_eval_completed
@ASSIGN user$site_eval_completed NULL
@ELSE
@ASSIGN user$site_eval_completed @SQ@ARG
site_eval_completed@SQ
/@IF
It shows the variable loaded correctly in debug...
[ElseIf Action]
[50]
ElseIfUpdate
[Results Action]
[50]
Results4
[Changed Vars]
[50]
user$site_eval_completed=NULL
[Update Action]
[50]
Update1
[Query]
[50]
UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals]
[50]
[v1='Shore To Shore'; v2='Central America'; v3='Shore To Shore Lacar,
Ltda.'; v4='Boulevard Industrial Norte, No 440 Zona 4 de Mixco, El Naranjo,
Guatemala City, Guatemala 01057'; v5='Hugo Cambran/Cesar Montes';
v6='502-2422-0200 hugo_camb...@gt.shr2shr.com cesar_mon...@gt.shr2shr.com';
v7='07.24.2009'; v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment
received 7.14.10'; v11='CN0097, 7.16.10, test sheets received 8.9';
v12='9.23.10'; v13='Open']
[Error]
[66]
241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string. 22008
[Error]
[66]
-101 General error during data source operation.
Path:
/admin/
File Name:
status.taf
Position:
Update1
Class:
DBMS
Main Error Number:
241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string.
22008
_
Path:
/admin/
File Name:
status.taf
Position:
Update1
Class:
Internal
Main Error Number:
-101
General error during data source operation.
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
This is no problem
First, setup a variable as such:
@IFEMPTY @ARG date
@ASSIGN request$sql_date_value NULL
@ELSE
@ASSIGN request$sql_date_value @SQ@ARG DATE@SQ
/@IF
Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the @SQs) rather than attempting to format the date
automatically.
Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.
Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm
Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)
The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.
Robert
PS. The value of NULL does not get quoted.
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 1:46 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Hello,
Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able to
update the date, delete the date (make null) or keep the date null on an
insert
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Ben and Robert,
Unfortunately, I have to run to a meeting right now. I really appreciate the
input. I'll pick this up again tomorrow early.
Thanks you guys!
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
webd...@cipromo.com
http://cipromo.com/ http://cipromo.com
_
From: Ben Johansen [mailto:b...@webspinr.com]
Sent: Monday, September 13, 2010 2:18 PM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
wrapping the value in @SQ wont work if you are not using DirectDBMS
you need to set Quote Value to True to get rid of the {ts ...
On Sep 13, 2010, at 12:12 PM, WebDude wrote:
Okay,
By the way... thanks for your help...
I gave this a shot and still have problems. It does not let me insert
anything, whether a date or not. I have this with a bunch of other fields,
yet on an update, I can only toggle between True or False for the Quote
Value of the whole insert, not just a particular column. Notice that the
only field I have set up as a datetime filed is site_eval_completed.
Also note in the debug, it shows...
site_eval_completed={ ts '2000-01-00 00:00:00' } - not sure why this is
popping in there...
The variable loads fine. I am using...
@IFEMPTY @ARG site_eval_completed
@ASSIGN user$site_eval_completed NULL
@ELSE
@ASSIGN user$site_eval_completed @SQ@ARG
site_eval_completed@SQ
/@IF
It shows the variable loaded correctly in debug...
[ElseIf Action] [50]ElseIfUpdate
[Results Action] [50]Results4
[Changed Vars] [50]user$site_eval_completed=NULL
[Update Action] [50]Update1
[Query] [50]UPDATE dbo.status SET
IPMG=?,Country=?,Factory_Name=?,Factory_Address=?,Contact_Name=?,Contact_Det
ails=?,Self_Eval_Submit_Date=?,Meet_Minimum_Req=?,Invoice_num_Date_Issued=?,
Payment_Status=?,Print_Test_Kit_num_Date_Sent=?,Site_Eval_Schedule=?,site_ev
al_completed={ ts '2000-01-00 00:00:00' },site_eval_status='',openclosed=?
WHERE (ID=3)
[BoundVals] [50][v1='Shore To Shore'; v2='Central America';
v3='Shore To Shore Lacar, Ltda.'; v4='Boulevard Industrial Norte, No 440
Zona 4 de Mixco, El Naranjo, Guatemala City, Guatemala 01057'; v5='Hugo
Cambran/Cesar Montes'; v6='502-2422-0200
hugo_camb...@gt.shr2shr.comcesar_montes@gt.shr2shr.com'; v7='07.24.2009';
v8='YES.'; v9='08.10.09, 0809-1003'; v10='Wire payment received 7.14.10';
v11='CN0097, 7.16.10, test sheets received 8.9'; v12='9.23.10'; v13='Open']
[Error] [66]241 [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
error converting datetime from character string. 22008
[Error] [66]-101 General error during data source operation.
Path:/admin/
File Name: status.taf
Position:Update1
Class: DBMS
Main Error Number: 241
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.
22008
_
Path:/admin/
File Name: status.taf
Position:Update1
Class: Internal
Main Error Number: -101
General error during data source operation.
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, September 13, 2010 1:09 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime
field
This is no problem
First, setup a variable as such:
@IFEMPTY @ARG date
@ASSIGN request$sql_date_value NULL
@ELSE
@ASSIGN request$sql_date_value @SQ@ARG DATE@SQ
/@IF
Then use the variable in the Update SQL action (Insert and Select also
work). The trick is that you must set the Quote Value on this column to
False. This tells Witango to use the variable content as is (which explains
the need for the @SQs) rather than attempting to format the date
automatically.
Note that if the argument date is human enterable, you'll want to do a few
checks on the value first to ensure that it's a valid date, in the correct
format that your SQL server expects, etc. Explicitly stripping single-quotes
would be a good idea.
Also, this would effectively create the value '9/13/2010' which most SQL
servers can deal with, however it is more appropriate to use native formats.
If I remember MS SQL properly date format is: -mm-ddTHH:MM:SS:mmm
Another good idea is to use the ODBC date literal format: { d '-mm-dd' }
(this is what Witango converts dates to behind the scenes)
The point is that by turning off Quote Value, formatting of the value is
turned over to you and you must ensure that it is correct.
Robert
PS. The value of NULL does not get quoted.
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, September 13, 2010 1:46 PM
To: Witango-Talk@witango.com
Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
Hello,
Can this be done? I have a table where they need to sort by date. The column
is a datetime filed to sort dates correctly. we also need to be able
RE: Witango-Talk: Still using Tango 2000?
Thanks Robert... _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Thursday, August 12, 2010 3:17 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Still using Tango 2000? WebDude anyone else still using Tango 2000. I've updated the page on the Witango.com site (Products What's New) so that it has working links to the two What's New documents. The top part of the page talks about migration from Tango 2000 to Witango 5. The bottom part is about moving from 5.0 to 5.5. I strongly recommend that you read both documents carefully, as there are a few major differences, as we've pointed out, and they are explained in detail here. Let me know if you have any problems with the PDFs. As for advice regarding upgrading, I'm of two minds here. On the one hand, the file format in version 6 will be compatible with 5.5, therefore you can begin working on your migration now (moving to 5.5) knowing that you won't be wasting your time. However, moving to the 5.5 platform may have its own issues, especially for OS X users, JDBC users, and those wishing to use the newest hardware and software. In other words, I do recommend using 5.5 as a tool in your migration, but you may want to wait until 6 is out before upgrading your production environment. The one caveat to this rule is that if you are using older hardware and software (or can do so with virtualization) then v5.5 can still be quite effective. Any v5.5 licenses which are purchased from now on will automatically get a free upgrade to v6. So if you are committed to moving to v6 when it comes out, then there is no risk in getting an early start on that process. Robert Witango From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, August 10, 2010 3:28 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Windows 7 Server Folks... I am so excited about the latest developments, I almost peed myself. I have been holding out for years on upgrading... pretty much because I spent so much on the Corporate Server. But, since there seems to be new life being pumped into the product, I am seriuosly considering buying, at the minimum, 2 professional servers. The reason for this post is I have some concerns. I am still using Witango 2000 and very happy with it. I have it installed on 3 servers and never really had any issues. 2 of the servers are Win2k and one is a 2003. We run about 70 websites, some getting about a half million visits per month. I also have some very important corporate clients that are very critical when it comes to uptime, speed, etc. (yeah, I know... but corporate america can be kind of dumb when it comes to this stuff... still running such an old version). Nothing is clustered, all servers are dedicated to specific sites. All tie into a single database server. Anyway, I am going to be purchasing a few Windows Servers and would like to load the new platform on them. I know there are some adjustments that will need to be made. I believe that one of these is setting the default scope of all unscoped variables to user... is that correct? What I need to know is any other caveats that some of you may have run into. (i.e. do I actually have to open and save each taf before they will work with a new server?) I am thinking of porting 1 site at a time. I will have the luxury of having new servers configured and ready to go along with the old servers. Any help would be greatly appreciated. I just landed some pretty hefty contracts and would like to keep using Witango as it is my program of choice for almost all of our development. I also would like to try to get Witango into the mainsteam a bit more, too. Not sure how to do this, but I would think if we could put our collective heads together, we might be able to come up with something. I do work for some very big corporations and, though I don't want to drop any names here, I might be able to get them to support the product a bit. Not sure how to approach them, just thinking out loud. Endoresements maybe? I am not sure how this stuff works. Thanks! _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
Witango-Talk: Windows 7 Server
Folks... I am so excited about the latest developments, I almost peed myself. I have been holding out for years on upgrading... pretty much because I spent so much on the Corporate Server. But, since there seems to be new life being pumped into the product, I am seriuosly considering buying, at the minimum, 2 professional servers. The reason for this post is I have some concerns. I am still using Witango 2000 and very happy with it. I have it installed on 3 servers and never really had any issues. 2 of the servers are Win2k and one is a 2003. We run about 70 websites, some getting about a half million visits per month. I also have some very important corporate clients that are very critical when it comes to uptime, speed, etc. (yeah, I know... but corporate america can be kind of dumb when it comes to this stuff... still running such an old version). Nothing is clustered, all servers are dedicated to specific sites. All tie into a single database server. Anyway, I am going to be purchasing a few Windows Servers and would like to load the new platform on them. I know there are some adjustments that will need to be made. I believe that one of these is setting the default scope of all unscoped variables to user... is that correct? What I need to know is any other caveats that some of you may have run into. (i.e. do I actually have to open and save each taf before they will work with a new server?) I am thinking of porting 1 site at a time. I will have the luxury of having new servers configured and ready to go along with the old servers. Any help would be greatly appreciated. I just landed some pretty hefty contracts and would like to keep using Witango as it is my program of choice for almost all of our development. I also would like to try to get Witango into the mainsteam a bit more, too. Not sure how to do this, but I would think if we could put our collective heads together, we might be able to come up with something. I do work for some very big corporations and, though I don't want to drop any names here, I might be able to get them to support the product a bit. Not sure how to approach them, just thinking out loud. Endoresements maybe? I am not sure how this stuff works. Thanks! To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Sum of Square Root
pong _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, August 02, 2010 12:02 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Sum of Square Root Ping? From: WebDude [mailto:webd...@cipromo.com] Sent: Thursday, July 22, 2010 10:49 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Sum of Square Root Excellent... thank you... _ From: Paul Wilson [mailto:pwilson@gmail.com] Sent: Tuesday, July 20, 2010 7:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Sum of Square Root Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson pwilson@gmail.com wrote: I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude webd...@cipromo.com wrote: I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf _ To unsubscribe to this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Announcement - Witango under new ownership
Whoo Hoo Does this mean I can keep on keeping on? _ From: Kaustav Acharya [mailto:kacha...@colleges.com] Sent: Monday, August 02, 2010 1:55 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Announcement - Witango under new ownership Congratulations on the acquisition Robert and we wish you all the success. Hopefully we can focus on getting WiTango back on the map :) Kaustav Kaustav Acharya Web Developer U. Inc. 12264 El Camino Real, Suite #401 San Diego, CA. 92130 Office: (858) 847-3350 x1004 Fax: (858) 847-3340 email: kacha...@colleges.com http://www.colleges.com Power to the People - http://www.campaign.com Important Note: This e-mail may contain privileged, undisclosed or confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform kacha...@colleges.com Immediately and permanently destroy the original transmittal. On Aug 2, 2010, at 11:43 AM, supp...@witango.com wrote: To the Witango community: Tronics Software LLC has purchased the Witango product suite from Witango Technologies Pty Ltd. We at Tronics Software are extremely excited to launch this new chapter for Witango, and we are dedicated to the ongoing support and development of the Witango products. Over the next few days and weeks we will be releasing further information about our plans for Witango, the timing of the version 6.0 release, and pricing details. We are also committed to supporting and expanding the Witango community, and we will be launching community forums and a development blog shortly. We will post all announcements to the list and to the witango.com http://www.witango.com website - please check back often! Thank you all for your continued support of Witango, Tronics Software LLC Tronics Software LLC is a software development company in New Jersey, part of the Tronics group of companies founded by Robert Shubert. Robert has been a part of the Witango community since 1998 and owns Tronics, the leading Witango web hosting provider. To contact Tronics Software with questions, please email mailto:supp...@witango.com supp...@witango.com or call (570) 647-4370. _ To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body. _ To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Sum of Square Root
Excellent... thank you... _ From: Paul Wilson [mailto:pwilson@gmail.com] Sent: Tuesday, July 20, 2010 7:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Sum of Square Root Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson pwilson@gmail.com wrote: I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude webd...@cipromo.com wrote: I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Sum of Square Root
I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Print a page automatically
Unfortunately, these are system calls and you cannot pass those parameters to the print function via javascript, as far as I know. Notice, you also cannot get rid of the URL at the bottom of the page, the date, the page 1of 1 or any of the other parameters that are set up in various types of browsers. These are all stored in options/preferences of the individual browser. Not only that, different browsers will print different headers and footers. _ From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Monday, June 28, 2010 1:20 PM To: witango-talk@witango.com Subject: Witango-Talk: Print a page automatically Hi, I found that I can use the following javascript in the Body tag to open the print window when a web page loads body style=background-color: white onload=window.print(); window.close() Is there a way in Witango I can I pass the printer name to print to and select Print to save some clicks? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Muxed variable on a hard crash
Anyone? _ From: WebDude [mailto:webd...@cipromo.com] Sent: Friday, June 04, 2010 12:58 PM To: witango-talk@witango.com Subject: Witango-Talk: Muxed variable on a hard crash Hey Everyone, I got a wierd thing happening... it has happened twice so far. When one of our servers crashes (i.e. a power outage), on reboot, everything comes up fine except for the applications.ini file. Typically, one of the settings is Path=/ But on a hard crash, the Path is changed to Path=top/archive/history/flavors/creamy/ After the hard crash, I go and change the ini file back to Path=/, stop Witango and restart it and everything is fine. What is wierd is that this path does not exist on the server, though it does exist as a user scoped variable that loads breadcrumb navigation on one of our sites. I searched everything on the server for this string of text, including the registry and cannot find it. I am wondering on a hard crash where Witango gets this value. Does anyone have any clue as to what is happening? No, the server is not hacked. It is only noticeable on one site in which I use an application scoped variable. It is the only place on this server in which an application scoped variable is used... and it's not even the same site as where the breadcrumb navigation is?!?!?! Wierd... TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Muxed variable on a hard crash
Witango 2000 Windows 2000 Fully patched There are actually 2 variables that hold the breadcrumb. It is configured like this... top/archive/@VAR q/@VAR mc/ Note, the whole path ends up in the ini file (Path=top/archive/history/creamy/). No crash event dump, just s restart. I will try changing the persistentrestart=false Witango version? OS version? Name of variable that holds the breadcrumb nav? Does witangoevents.log report a crash event (a dump?) You can try editing Witango.ini, set persistentrestart=false and see if it continues with that setting. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Friday, June 04, 2010 1:58 PM To: witango-talk@witango.com Subject: Witango-Talk: Muxed variable on a hard crash Hey Everyone, I got a wierd thing happening... it has happened twice so far. When one of our servers crashes (i.e. a power outage), on reboot, everything comes up fine except for the applications.ini file. Typically, one of the settings is Path=/ But on a hard crash, the Path is changed to Path=top/archive/history/flavors/creamy/ After the hard crash, I go and change the ini file back to Path=/, stop Witango and restart it and everything is fine. What is wierd is that this path does not exist on the server, though it does exist as a user scoped variable that loads breadcrumb navigation on one of our sites. I searched everything on the server for this string of text, including the registry and cannot find it. I am wondering on a hard crash where Witango gets this value. Does anyone have any clue as to what is happening? No, the server is not hacked. It is only noticeable on one site in which I use an application scoped variable. It is the only place on this server in which an application scoped variable is used... and it's not even the same site as where the breadcrumb navigation is?!?!?! Wierd... TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Muxed variable on a hard crash
Hey Everyone, I got a wierd thing happening... it has happened twice so far. When one of our servers crashes (i.e. a power outage), on reboot, everything comes up fine except for the applications.ini file. Typically, one of the settings is Path=/ But on a hard crash, the Path is changed to Path=top/archive/history/flavors/creamy/ After the hard crash, I go and change the ini file back to Path=/, stop Witango and restart it and everything is fine. What is wierd is that this path does not exist on the server, though it does exist as a user scoped variable that loads breadcrumb navigation on one of our sites. I searched everything on the server for this string of text, including the registry and cannot find it. I am wondering on a hard crash where Witango gets this value. Does anyone have any clue as to what is happening? No, the server is not hacked. It is only noticeable on one site in which I use an application scoped variable. It is the only place on this server in which an application scoped variable is used... and it's not even the same site as where the breadcrumb navigation is?!?!?! Wierd... TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: date sent on mail actions is off
I had this same problem last year. I stopped and started the Witango service and it corrected itself. I noticed that all my cron jobs were firing an hour off... _ From: Roland Dumas [mailto:radu...@mac.com] Sent: Sunday, April 11, 2010 12:32 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: date sent on mail actions is off wait a minute. DST started on the first sunday in april as of 1986 (in the US). THe system clock knows the time, time zone, and that it's daylight saving. witango is off. I don't recall this happening last year or the year before. The witango log is stamping the right time, just emails get pushed forward an hour. On Apr 11, 2010, at 9:16 AM, Steve Smith wrote: Remember that this should go away in a couple of weeks. My guess is that if there is a problem with the code, it is because the rules were created when DST started on the last Sunday in April. Steve Smith Oakbridge Information Solutions Oakville Office: (416) 628-0793 Cambridge Office: (519) 489-0142 Email: mailto:ssm...@oakbridge.ca ssm...@oakbridge.ca Web: http://www.oakbridge.ca/ www.oakbridge.ca http://www.oakbridge.ca/ Certified DayLite Master Partner Certified DayLite Trainer Billings Consultant FileMaker Solutions Alliance Member MoneyWorks Consultant LightSpeed Authorized Reseller Sent from my iPad On 2010-04-11, at 11:34 AM, Roland Dumas radu...@mac.com wrote: Thanks. I'm running two servers with witango 5 and they both have the same problem. I'm using the services of a witango server 5.5, and it's giving me correct datetime on emails. Now to figure out a workaround... On Apr 11, 2010, at 12:15 AM, D. Richardy wrote: It looks like Witango's daylight time handling code is wrong. ... Not only this. Just my 1 Cent from Europe. _ PS: ANY NEWS ABOUT WITANGO 6. Or is it a really WIT(h)-ON-GO Mail from Phil (29-04-2008): Hi all, Before this thread gets a life of its own let me just say that there is more to this release as we move to commercial open source model than just software. We have basically finished the engineering but there are still some legal and business issues we are continuing to work through. It all takes time and we are not just sitting here idly. While we have been waiting for these issue to be resolved we have been adding extra features to the studio. As soon as I can release v6 I will. Regards Phil - Original Message - From: Anthony Humphreys mailto:anth...@humphreys.org To: mailto:witango-talk@witango.com witango-talk@witango.com Cc: Roland Dumas mailto:radu...@mac.com Sent: Sunday, April 11, 2010 6:48 AM Subject: Re: Witango-Talk: date sent on mail actions is off Witango shouldn't have its own Timezone rules; Witango should use the server's local time and offset (from GMT). However, Witango does need to reformat the time to specific SMTP format. However, this reformat is the ONLY thing that Witango should be doing. PDT stands for Pacific Daylight Time and has an offset of -0700. PST stands for Pacific Standard Time and has an offset of -0800. 13:43:47 -0700 PDT is not equivalent to 2:43:47 PM PDT It looks like Witango's daylight time handling code is wrong. On Sat, Apr 10, 2010 at 12:29 PM, Roland Dumas mailto:radu...@mac.com radu...@mac.com wrote: does the tango server had its own date rules? I didn't see anything in witango.ini that set the time zone. On Apr 10, 2010, at 9:27 AM, Steve Smith wrote: Could it have something to do with the fact that the Witango code was created before the new rules came into effect for Daylite Savings Time in 2007? Steve Smith Oakbridge Information Solutions Oakville Office: (416) 628-0793 Cambridge Office: (519) 489-0142 Email: mailto:ssm...@oakbridge.ca ssm...@oakbridge.ca Web: http://www.oakbridge.ca/ www.oakbridge.ca http://www.oakbridge.ca/ Certified DayLite Master Partner Certified DayLite Trainer Billings Consultant FileMaker Solutions Alliance Member MoneyWorks Consultant LightSpeed Authorized Reseller Sent from my iPad On 2010-04-10, at 12:19 PM, Roland Dumas mailto:radu...@mac.com radu...@mac.com wrote: Anyone have a clue why witango mail action gets timestamp off an hour? On Apr 9, 2010, at 2:11 PM, Roland Dumas wrote: This is an example: Note the date field says 2:43 PM while the header correctly shows 1:43 PM. This discrepancy happens only for witango mail action generated messages. DateApril 9, 2010 2:43:47 PM PDT To: Roland Dumas mailto:radu...@servqual.com radu...@servqual.com Received: from Imagineworks.localhost ( http://mail.imagineworks.com/ mail.imagineworks.com http://mail.imagineworks.com/ [64.151.109.164]) BY http://imagineworks.com/ imagineworks.com http://imagineworks.com/ ([64.151.109.164]) WITH ESMTP (4D WebSTAR V Mail (5.4.1)); Fri, 09 Apr 2010 13:43:47 -0700 Received: from myunknowndomain (localhost [127.0.0.1]) by
RE: Witango-Talk: Multiple Sorts
Well... That's the way I do it. But it seems that you cannot have a blank variable or multiple sorts within 1 variable... Or am I missing something here. Do you have an example? -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Monday, March 01, 2010 10:13 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts I found it better and faster to do the sort after the results are returned in the Results Action. Use a user variable and keep appending to the beginning, then use the variable in the sort tag. Remember to have a way to clear the sort and the variable Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Mon 3/1/2010 7:29 PM To: witango-talk@witango.com Subject: Witango-Talk: Multiple Sorts Typically in the past, I load a sort into a variable and then add that variable as a sort in the search function... I then use an argument to change the sorts... @IFEQUAL @ARG sort 1@ASSIGN sort company_info.company/@IF @IFEQUAL @ARG sort 2@ASSIGN sort company_info.lname/@IF @IFEQUAL @ARG sort 3@ASSIGN sort company_info.state/@IF @IFEQUAL @ARG sort 4@ASSIGN sort company_info.customer_id/@IF I've been going around and around on this... is there anyway to hold onto the sorts so, let's say, they click on Company first, and then click on last name, they get a sort by lname, company. An thus, if they click next on State, they get a sort of state, lname, company... and so on. I'm sure this has comeup before... I just can't find the answer. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Multiple Sorts
Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN
RE: Witango-Talk: Multiple Sorts
bummer... Yes... we are using an SQL server... any suggestions? _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 12:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and @ROWS start=/stop= only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This will usually work, but can be deadly if you are working with many thousands of rows or more. Robert _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder
RE: Witango-Talk: Multiple Sorts
SET ROWCOUNT n? Where is this? date desc;? no date here John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 12:45 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL SERVER you can actually use both. Set the number of results to be returned using the SET ROWCOUNT n option; Then use the ORDER BY SQL to retrieve the latest n records. Remember to use SET ROWCOUNT 0 to turn off the option. In DirectDBMS: SET ROWCOUNT 100; Select * from table order by date desc; SET ROWCOUNT 0; You now have the Resultset available for sorting. Ted From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 1:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and @ROWS start=/stop= only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This will usually work, but can be deadly if you are working with many thousands of rows or more. Robert _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned
Witango-Talk: Multiple Sorts
Typically in the past, I load a sort into a variable and then add that variable as a sort in the search function... I then use an argument to change the sorts... @IFEQUAL @ARG sort 1@ASSIGN sort company_info.company/@IF @IFEQUAL @ARG sort 2@ASSIGN sort company_info.lname/@IF @IFEQUAL @ARG sort 3@ASSIGN sort company_info.state/@IF @IFEQUAL @ARG sort 4@ASSIGN sort company_info.customer_id/@IF I've been going around and around on this... is there anyway to hold onto the sorts so, let's say, they click on Company first, and then click on last name, they get a sort by lname, company. An thus, if they click next on State, they get a sort of state, lname, company... and so on. I'm sure this has comeup before... I just can't find the answer. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action
Interesting... Thanks for the link, Ben. -Original Message- From: Ben Johansen [mailto:b...@webspinr.com] Sent: Sunday, February 07, 2010 1:22 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action users, gotta love'm FYI, (you might know this, but thought i would mention it) you can have SUBJECT and BCC in the mailto I don't like to just throw up a mail thing without a subject, they might not mail it right off, (see first statement ;-) I split the email and use first mail as main mailto and subequent as bcc, actually saves on email server a href=mailto:us...@mail.com?bcc=user2@mail.com,us...@mail.comsubject=newlet ter for some company you can see all the possibilities here http://www.ianr.unl.edu/internet/mailto.html But, the reason it worked as comma separated in mailto was comma is the standard separator, but in Witango mail action, it is treated as an array, and that is why you needed the semi-colon, to separate the email addresses, when witango sends the mail to mail server it will comma separate the addresses On Feb 7, 2010, at 9:29 AM, Webdude wrote: You're trying to create a hyperlink, not insert the address in a mail action, ok. No... I am trying to do both. The links that are displayed in results to the user are hyperlinks when searching on the site. The table is also used for a bulkemail program and newsletter I have set up. Each string (with multiple email addresses) are loaded in one field (stupid I know, but users who felt they needed to add more then one email address added more emails using a comma to seperate them. In other words, I had a field set up to take 150 characters and the users added multiple email addresses in that field). Look... it's not a big deal. I can replace all the commas with a semicolon in the table. In the newsletter and bulkemail program, I can simply use @replace and can get it to work just fine. I should have been more stringent in what the users were inputting. The probelm is most of the users are from China and and there seems to have been a problem with a translation. Live and learn, eh? -Original message- From: Roland Dumas radu...@mac.com Date: Sat, 6 Feb 2010 11:39:13 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action You're trying to create a hyperlink, not insert the address in a mail action, ok. You can either create a one-row array with the column delimiter=; or you can spin your string with an @ROWS@COL NUM=X;/@ROWS On Feb 6, 2010, at 9:32 AM, Webdude wrote: The reason is simple... most email clients seperate multiple addresses by semicolon. If you load a db table with a string of emails that are comma delimited, you cannot create a hyperlink that will load the emails into the email client automatically. For example, a string of emails returned from a table like thus... us...@mail1.com,us...@mail2.com,us...@mail3.com when usung a hyperlink like this... a href=mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com;user1@ mail1.com ,us...@mail2.com,us...@mail3.com/a will not work, but it works fine using the Witango email action. But when using a string like this... us...@mail1.com;us...@mail2.com;us...@mail3.com And using a hyperlink like this... a href=mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com;user1@ mail1.com ,;us...@mail2.com;us...@mail3.com/a Works for the email client, but not the email action in Witango. -Original message- From: Ben Johansen b...@webspinr.com Date: Fri, 5 Feb 2010 15:31:54 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action at a loss for why?, but according to RFC 2822 comma is the only separator allowedThe destination fields of a message consist of three possible fields, each of the same form: The field name, which is either To, Cc, or Bcc, followed by a comma-separated list of one or more addresses Read more: http://www.faqs.org/rfcs/rfc2822.html#ixzz0ehQZoxaH On Feb 5, 2010, at 8:35 AM, WebDude wrote: Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. in the Mail Action. I know I can do a replace character... Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Ben Johansenhttp://www.webspinr.comb...@webspinr.comphone: 360-597-3372Mobile: 360-600-7775 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action
You're trying to create a hyperlink, not insert the address in a mail action, ok. No... I am trying to do both. The links that are displayed in results to the user are hyperlinks when searching on the site. The table is also used for a bulkemail program and newsletter I have set up. Each string (with multiple email addresses) are loaded in one field (stupid I know, but users who felt they needed to add more then one email address added more emails using a comma to seperate them. In other words, I had a field set up to take 150 characters and the users added multiple email addresses in that field). Look... it's not a big deal. I can replace all the commas with a semicolon in the table. In the newsletter and bulkemail program, I can simply use @replace and can get it to work just fine. I should have been more stringent in what the users were inputting. The probelm is most of the users are from China and and there seems to have been a problem with a translation. Live and learn, eh? -Original message- From: Roland Dumas radu...@mac.com Date: Sat, 6 Feb 2010 11:39:13 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action You're trying to create a hyperlink, not insert the address in a mail action, ok. You can either create a one-row array with the column delimiter=; or you can spin your string with an @ROWS@COL NUM=X;/@ROWS On Feb 6, 2010, at 9:32 AM, Webdude wrote: The reason is simple... most email clients seperate multiple addresses by semicolon. If you load a db table with a string of emails that are comma delimited, you cannot create a hyperlink that will load the emails into the email client automatically. For example, a string of emails returned from a table like thus... us...@mail1.com,us...@mail2.com,us...@mail3.com when usung a hyperlink like this... a href=mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com;us...@mail1.com,us...@mail2.com,us...@mail3.com/a will not work, but it works fine using the Witango email action. But when using a string like this... us...@mail1.com;us...@mail2.com;us...@mail3.com And using a hyperlink like this... a href=mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com;us...@mail1.com,;us...@mail2.com;us...@mail3.com/a Works for the email client, but not the email action in Witango. -Original message- From: Ben Johansen b...@webspinr.com Date: Fri, 5 Feb 2010 15:31:54 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action at a loss for why?, but according to RFC 2822 comma is the only separator allowedThe destination fields of a message consist of three possible fields, each of the same form: The field name, which is either To, Cc, or Bcc, followed by a comma-separated list of one or more addresses Read more: http://www.faqs.org/rfcs/rfc2822.html#ixzz0ehQZoxaH On Feb 5, 2010, at 8:35 AM, WebDude wrote: Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. in the Mail Action. I know I can do a replace character... Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Ben Johansenhttp://www.webspinr.comb...@webspinr.comphone: 360-597-3372Mobile: 360-600-7775 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action
The reason is simple... most email clients seperate multiple addresses by semicolon. If you load a db table with a string of emails that are comma delimited, you cannot create a hyperlink that will load the emails into the email client automatically. For example, a string of emails returned from a table like thus... us...@mail1.com,us...@mail2.com,us...@mail3.com when usung a hyperlink like this... a href=mailto:us...@mail1.com,us...@mail2.com,us...@mail3.com;us...@mail1.com,us...@mail2.com,us...@mail3.com/a will not work, but it works fine using the Witango email action. But when using a string like this... us...@mail1.com;us...@mail2.com;us...@mail3.com And using a hyperlink like this... a href=mailto:us...@mail1.com;us...@mail2.com;us...@mail3.com;us...@mail1.com,;us...@mail2.com;us...@mail3.com/a Works for the email client, but not the email action in Witango. -Original message- From: Ben Johansen b...@webspinr.com Date: Fri, 5 Feb 2010 15:31:54 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Changing comma delim to semicolon delim in the Mail Action at a loss for why?, but according to RFC 2822 comma is the only separator allowedThe destination fields of a message consist of three possible fields, each of the same form: The field name, which is either To, Cc, or Bcc, followed by a comma-separated list of one or more addresses Read more: http://www.faqs.org/rfcs/rfc2822.html#ixzz0ehQZoxaH On Feb 5, 2010, at 8:35 AM, WebDude wrote: Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. in the Mail Action. I know I can do a replace character... Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Ben Johansenhttp://www.webspinr.comb...@webspinr.comphone: 360-597-3372Mobile: 360-600-7775 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Changing comma delim to semicolon delim in the Mail Action
Is this possible? I mean, when adding multiple emails in the To:, CC:, etc. in the Mail Action. I know I can do a replace character... Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Calendar
http://myfishingpals.com/minnesota-fishing-buddy-up.taf?function=monthcalda te=01/08/2010 -Original Message- From: William Conlon [mailto:b...@tothept.com] Sent: Friday, January 08, 2010 12:29 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Calendar I don't think I released this to the public, since it has the To the Point copyright embedded in it [see: http://www.tothept.com/software/cal/calendar.taf?_function=readme ] contact me directly. On Jan 7, 2010, at 12:45 PM, Roland Dumas wrote: I'm in need of a calendar taf Does this or any other exist as a shared app? On Apr 25, 2006, at 10:03 AM, William M Conlon wrote: http://www3.tothept.com/examples/calendar.taf I was planning on contributing this, probably under the GNU license, on sourceforge. bill On Apr 25, 2006, at 7:46 AM, Rick Sanders wrote: Hello list, I'm just wondering if anyone has created a calendar in WiTango. I'm doing an events calendar for a client. I can program it myself, but it's much easier if someone has one to share. Thanks in advance, image001.jpg Rick Sanders President 902-401-7689 www.webenergy-sw.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Bill William M. Conlon, P.E., Ph.D. To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:b...@tothept.com web: http://www.tothept.com _ ___ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Deleting empty Rows in Array
Okay, the problem is I need blanks in the middle. In other words, if I have... 1; 2; 3; 4; ; 5; 6; ; ; ; I would need the array to end up like this... 1; 2; 3; 4; ; 5; 6; ??? http://cipromo.com/ _ From: Ben Johansen [mailto:b...@webspinr.com] Sent: Wednesday, December 30, 2009 3:25 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Deleting empty Rows in Array you may be able to use tokenize on your string 1 ;2 ;3 ;4 ;5 ; ; ; ; ; @TOKENIZE VALUE=1 ;2 ;3 ;4 ;5 ; ; ; CHARS=; NULLTOKENS=false NULLTOKENS are when you have a blank cell as a result of the tokenize. for example if you tokenize one,two,,four on comma: if you have NULLTOKENS = true then the resulting array will have 4 elements with the 3rd being empty if you have NULLTOKENS = false then the resulting array will have 3 elements, skipping the 3rd you can use the NULLTOKENS to deal with the empty spots, so that filter will not break Ben On Dec 30, 2009, at 6:13 AM, WebDude wrote: Hi Folks, I have another one I have been working on and I am having a devil of a time trying to get either @filter or any type of filtering on text strings to work correctly. I would appreciate any help. I have an app that let's you copy and paste text from an XLS file into a textarea field. I then take the text and bust it out into columns and rows and populate input type=text fields and then loop through an insert routine. It works well, but I am trying to delete rows that have no values. The reason for no values is from multiple returns from the user without text, or when I present the text back into the textarea for editing after the input type=text fields have been edited. I am doing something like this (using just 1 column for simplicity sake)... From the textarea name=text1... @ASSIGN text11 @REPLACE STR='@ARG text1' FINDSTR='@CHAR 10' REPLACESTR=';' @ASSIGN text11 @REPLACE STR='@VAR text11' FINDSTR='@CHAR 9' REPLACESTR=',' I the assign the results to an array... @ASSIGN NAME=initValue VALUE=@VAR text11 @ASSIGN NAME=array1 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN column1@CURROW @VAR NAME='array1[@CURROW,1]' The array1 will look something like this when done using @VAR array1 APrefix='' ASuffix='' RPrefix='' RSuffix=';' CPrefix='' CSuffix=''... 1 ;2 ;3 ;4 ;5 ; But sometimes, when a user inputs incorrectly or goes back and edits values, I may end up with an array that looks like this... 1 ;2 ;3 ;4 ;5 ; ; ; ; ; What I am trying to do is filter out the empty rows at the end - (; ; ;) Now when I use @FILTER I am totally confused. I can't seem to get it to work at all. Even a simple filter that I know should work. Examples... @FILTER ARRAY=array1 SCOPE=local EXPR=#1=1 I get... An Array was expected as a parameter OR @FILTER ARRAY=@VAR array1 SCOPE=local EXPR=#1=1 I get... Error during expression evaluation. Illegal symbol in statement [@__REF name=array1 userref=...@3605a6082eac17134b3b591b[1,1]=1] BUT @FILTER ARRAY=@VAR array1 SCOPE=local EXPR= does not throw an error, but I am filtering nothing. I also tried to use any type of string manipluation to get rid of the empty rows but using anything like @CHAR 10; or just ; does not seem to work either. Any insight would be greatly appreciated. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Ben Johansen http://www.webspinr.com b...@webspinr.com Phone: 360-597-3372 Mobile: 360-600-7775 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Deleting empty Rows in Array
Hi Folks, I have another one I have been working on and I am having a devil of a time trying to get either @filter or any type of filtering on text strings to work correctly. I would appreciate any help. I have an app that let's you copy and paste text from an XLS file into a textarea field. I then take the text and bust it out into columns and rows and populate input type=text fields and then loop through an insert routine. It works well, but I am trying to delete rows that have no values. The reason for no values is from multiple returns from the user without text, or when I present the text back into the textarea for editing after the input type=text fields have been edited. I am doing something like this (using just 1 column for simplicity sake)... From the textarea name=text1... @ASSIGN text11 @REPLACE STR='@ARG text1' FINDSTR='@CHAR 10' REPLACESTR=';' @ASSIGN text11 @REPLACE STR='@VAR text11' FINDSTR='@CHAR 9' REPLACESTR=',' I the assign the results to an array... @ASSIGN NAME=initValue VALUE=@VAR text11 @ASSIGN NAME=array1 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN column1@CURROW @VAR NAME='array1[@CURROW,1]' The array1 will look something like this when done using @VAR array1 APrefix='' ASuffix='' RPrefix='' RSuffix=';' CPrefix='' CSuffix=''... 1 ;2 ;3 ;4 ;5 ; But sometimes, when a user inputs incorrectly or goes back and edits values, I may end up with an array that looks like this... 1 ;2 ;3 ;4 ;5 ; ; ; ; ; What I am trying to do is filter out the empty rows at the end - (; ; ;) Now when I use @FILTER I am totally confused. I can't seem to get it to work at all. Even a simple filter that I know should work. Examples... @FILTER ARRAY=array1 SCOPE=local EXPR=#1=1 I get... An Array was expected as a parameter OR @FILTER ARRAY=@VAR array1 SCOPE=local EXPR=#1=1 I get... Error during expression evaluation. Illegal symbol in statement [@__REF name=array1 userref=...@3605a6082eac17134b3b591b[1,1]=1] BUT @FILTER ARRAY=@VAR array1 SCOPE=local EXPR= does not throw an error, but I am filtering nothing. I also tried to use any type of string manipluation to get rid of the empty rows but using anything like @CHAR 10; or just ; does not seem to work either. Any insight would be greatly appreciated. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Array and Left
Could you give me an example? -Original Message- From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, December 21, 2009 11:04 AM To: witango-talk Subject: Re: Witango-Talk: Array and Left WebDude, Put an @ROWS array='array3' pair of tags around your assign promoid statement. Bill On Mon, Dec 21, 2009 at 12:02 PM, WebDude webd...@cipromo.com wrote: Mmmm... Interesting. I cannot get it to work. Full code... @ASSIGN NAME=initValue VALUE=123456789,123456789,123456789 @ASSIGN NAME=array3 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN promoid@CURROW '@LEFT STR=@VAR array3[@CURROW,1] NUMCHARS=3' @ROWS ARRAY=@VAR array3 @VAR array3[@CURROW,1] /@ROWS bror br @VAR array3[1,1] -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, December 21, 2009 10:02 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left It 100% does work in that situation - there must be something else off. -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, December 21, 2009 10:36 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left Like I said, I can use left in the input file like thus... INPUT NAME=promoid@CURROW TYPE=text SIZE=4 MAXLENGTH=6 value=@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3 I was wondering if there was a way to use @left when creating the array. Something like this... @ASSIGN promoid@CURROW '@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3' It doesn't seem to work on the @assign. -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, December 21, 2009 9:15 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left I can confirm that little quick in HTML about over-populating a text input with a maxlength. It's always been the way it's worked for some reason. As for your code, that looks fine and should work, assuming you are executing inside a @ROWS or @FOR block so that the @CURROW evaluates. I @LEFT and @RIGHT things all the time without issue. Robert -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, December 21, 2009 9:52 AM To: witango-talk@witango.com Subject: Witango-Talk: Array and Left I am having a bit of a problem. I noticed that when I create a variable and load that variable into an HTML text form input, the MAXLENGTH attribute is ignored. It seems that if you set the input field to MAXLENGTH=5, you cannot type more then 5 characters into the field, however, when loading a variable into the field, the MAXLENGTH is ignored. M... The values I am loading into the input form are from an array. Seems it would be simple enough, but I cannot seem to get it to work. Currently, I have something like this (using just on column for clarity sake). @ASSIGN NAME=initValue VALUE=@VAR text11 @ASSIGN NAME=array2 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN promoid@CURROW '@VAR array2[@CURROW,1]' I tried changing the promoid to @ASSIGN promoid@CURROW '@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3' But I get no love. Am I missing something here? I just want to be able to limit the number of characters to 3. Yes, I can use this on the form page, but was interested in a more elegant way of doing this. Thanks! __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Array and Left
Mmmm... Still doesn't work. I cut and pasted directly into a taf file. Witango 2000? Could that be a problem? Maybe that's why I am having these problems. _ From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, December 21, 2009 12:14 PM To: witango-talk Subject: Re: Witango-Talk: Array and Left On Mon, Dec 21, 2009 at 1:08 PM, WebDude webd...@cipromo.com wrote: Could you give me an example? Your code shown, with my addition in bold blue highlighted: @ASSIGN NAME=initValue VALUE=123456789,123456789,123456789 @ASSIGN NAME=array3 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @rows array='array3' @ASSIGN promoid@CURROW '@LEFT STR=@VAR array3[@CURROW,1] NUMCHARS=3' /@rows @ROWS ARRAY=@VAR array3 @VAR array3[@CURROW,1] /@ROWS bror br @VAR array3[1,1] -Original Message- From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Monday, December 21, 2009 11:04 AM To: witango-talk Subject: Re: Witango-Talk: Array and Left WebDude, Put an @ROWS array='array3' pair of tags around your assign promoid statement. Bill On Mon, Dec 21, 2009 at 12:02 PM, WebDude webd...@cipromo.com wrote: Mmmm... Interesting. I cannot get it to work. Full code... @ASSIGN NAME=initValue VALUE=123456789,123456789,123456789 @ASSIGN NAME=array3 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN promoid@CURROW '@LEFT STR=@VAR array3[@CURROW,1] NUMCHARS=3' @ROWS ARRAY=@VAR array3 @VAR array3[@CURROW,1] /@ROWS bror br @VAR array3[1,1] -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, December 21, 2009 10:02 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left It 100% does work in that situation - there must be something else off. -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, December 21, 2009 10:36 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left Like I said, I can use left in the input file like thus... INPUT NAME=promoid@CURROW TYPE=text SIZE=4 MAXLENGTH=6 value=@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3 I was wondering if there was a way to use @left when creating the array. Something like this... @ASSIGN promoid@CURROW '@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3' It doesn't seem to work on the @assign. -Original Message- From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, December 21, 2009 9:15 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array and Left I can confirm that little quick in HTML about over-populating a text input with a maxlength. It's always been the way it's worked for some reason. As for your code, that looks fine and should work, assuming you are executing inside a @ROWS or @FOR block so that the @CURROW evaluates. I @LEFT and @RIGHT things all the time without issue. Robert -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, December 21, 2009 9:52 AM To: witango-talk@witango.com Subject: Witango-Talk: Array and Left I am having a bit of a problem. I noticed that when I create a variable and load that variable into an HTML text form input, the MAXLENGTH attribute is ignored. It seems that if you set the input field to MAXLENGTH=5, you cannot type more then 5 characters into the field, however, when loading a variable into the field, the MAXLENGTH is ignored. M... The values I am loading into the input form are from an array. Seems it would be simple enough, but I cannot seem to get it to work. Currently, I have something like this (using just on column for clarity sake). @ASSIGN NAME=initValue VALUE=@VAR text11 @ASSIGN NAME=array2 VALUE=@ARRAY VALUE=@@initValue CDELIM=',' RDELIM=';' @ASSIGN promoid@CURROW '@VAR array2[@CURROW,1]' I tried changing the promoid to @ASSIGN promoid@CURROW '@LEFT STR=@VAR array2[@CURROW,1] NUMCHARS=3' But I get no love. Am I missing something here? I just want to be able to limit the number of characters to 3. Yes, I can use this on the form page, but was interested in a more elegant way of doing this. Thanks! __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 6 Update
Scenario 1 - Phil is letting the product die... Perhaps we could group together and purchase the code and then we could have truly Open Source Licensing and rework the code ourselves. Scenario 2 - Phil is in over his head and is trying to find someone to purchase the product to pick up where he left off. Scenario 3 - Phil wants to claim bankruptcy and the only way he can is by showing massive losses on the product (not sure if this is feasible in Australia). Scenario 4 - Phil is still wrangling through the legal process and got fed up with all the negativity on this list. Scenario 5 - Phil is dead. -Original Message- From: Robert Garcia [mailto:wita...@bighead.net] Sent: Tuesday, September 22, 2009 6:11 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Witango 6 Update I really never liked the fact that they used the term Open Source. If you look back at the updates from phil, it was not going to be open source. It was still paid software, where if you agreed to the restrictions, you could download the source and modify it yourself and then submit back to witango. So it still costs money, you still pay for it, but you can modify the code, and if they like it, they own the modification and then sell it to others. So its not Open Source. Its a way for them to try to have unpaid developers. From Phil New Licensing - Once the beta testing has been completed and version 6 goes into release, the source code for both the server and studio will be open sourced under its own license. Witango will continue to be a commercial product and a license will need to be purchased. There will be 3 editions of the Server: The Lite edition - no change to current license conditions The Developer edition - no change to current license conditions. The Professional edition - single machine license, with no limitation on number of processes or CPUs. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Sep 22, 2009, at 2:44 PM, Michael Heth wrote: On Sep 22, 2009, at 2:27 PM, Stefan Gonick wrote: My guess is that they stopped working on replacing the licensed code so that the situation hasn't changed much since the last message. So they could figure out what the cost per license is for the licensed code, and charge that amount plus 10% forward it on to the licensor and be done. Not open source but last official release never to be updated. If it was reasonable and ran on our current systems it would be worth paying some money for. I keep a last version Titanium Powerbook around just to run old OS9 software that doesn't like classic. The above would cure all the issues except for support which they could charge for or someone on this list could charge for. Thanks, M./ Michael Heth tangopo...@serversmiths.com __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Expired Variables and Forms
That's what I do on some forms... but imagine a forum where you get a big textbox to write in your info. If you don't get all the info you want written within 30 minutes, you're outta luck. I have one forum that lets users submit a story. Some of the users have been getting half-way through and then the variables expire and when they post, they lose everything they have been working on. Now that can be a pain. I just need to hold on to the user variables while they are on that particular forms page. It isn't a matter of how many input fields there are, it's how long does it take the user to fill out a box... _ From: Roland Dumas [mailto:radu...@mac.com] Sent: Wednesday, July 22, 2009 12:07 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Expired Variables and Forms how come you don't parse the form into smaller sets of fields and just accumulate the responses in user scope, and then submit it all at the end? I had much better user experience by having one question/form and letting the user tick through the questions with a you are at 3 of 20 kind of message with each. On Jul 17, 2009, at 12:05 PM, WebDude wrote: I have always had a problem with long forms and having user info expire before the forms were filled. I have done long forms in sections with a submit for every page. I have done timed javascripts that calls a pop-up after 25 minutes telling the user to save and continue. Yada Yada Yada. I am in the middle of putting together a very long form for a client and decided to try a different approach. I load a taf into an iframe with height and width attributes set to 1. The taf doesn't return anything, it's just a header with a meta-refresh every 25 minutes (1500 seconds). Now call me dumb, but this works perfectly, as far as I can tell. I've tested it on many forms, forums, in-house blogs, etc., and I cannot get it to break. Every refresh refreshes the variables and holds onto all the user info. A really simple solution to what I thought was a vexing problem. I just updated a bunch of stuff by adding the iframe at the bottom of a bunch of form pages. I cannot find any drawbacks to this... I hope I am not missing something. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Expired Variables and Forms
I have always had a problem with long forms and having user info expire before the forms were filled. I have done long forms in sections with a submit for every page. I have done timed javascripts that calls a pop-up after 25 minutes telling the user to save and continue. Yada Yada Yada. I am in the middle of putting together a very long form for a client and decided to try a different approach. I load a taf into an iframe with height and width attributes set to 1. The taf doesn't return anything, it's just a header with a meta-refresh every 25 minutes (1500 seconds). Now call me dumb, but this works perfectly, as far as I can tell. I've tested it on many forms, forums, in-house blogs, etc., and I cannot get it to break. Every refresh refreshes the variables and holds onto all the user info. A really simple solution to what I thought was a vexing problem. I just updated a bunch of stuff by adding the iframe at the bottom of a bunch of form pages. I cannot find any drawbacks to this... I hope I am not missing something. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: OT... sort of - Topic Notification for Forum
I was trying to make the mailing taf seemless with the user experience... I have a bulk email program I use for other clients that sends an email every .5 seconds (using a redirect and a @CALC @ARG start+1)... works great and I was hoping to do the same with the notification. Short of time stamping the post and seeing if there was a response and running a cron job to send the notifications, I was thinking of firing off the bulk email when a post was made. The problem is that a branch or @URL takes the user through the redirects and then back to the post. Very clunky which is why I was toying with the idea of firing the external bulk email taf during the post without taking the user there... M... Ben, what (how) do you mean by wrapped in an IF block? _ From: Ben Johansen [mailto:b...@webspinr.com] Sent: Tuesday, June 30, 2009 3:04 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: OT... sort of - Topic Notification for Forum ah, maybe an include wrapped in an IF block On Jun 30, 2009, at 12:59 PM, WebDude wrote: Another qustion... may be easy, I don't know... Is there any way to trigger a taf within another taf not using @URL John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com ci.gif http://cipromo.com/ http://cipromo.com _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, June 30, 2009 11:23 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS feed... the forums already have that, but very few people actually use them. It seesm they would rather check a box then deal with readers. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, June 30, 2009 10:28 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum You need a subscriptions table of sorts: which contains just the member_id and the master_thread_id You can add rows when people signup to get a thread emailed and remove them when they opt-out. Additional columns that come to mind are: Primary key ID (not completely necessary for this type of table, but always helpful) Active/Inactive flag so that you can turn subscriptions on and off (as opposed to deleting the row) Number of emails sent: a counter for how many emails this subscription created, which would be interesting statistically Then when a new post comes in for thread #483, you simply look up all the people that have subscribed to thread #483 and send them an email. Also (and a little off-topic) you many want to consider adding RSS capabilities. It solves basically the same thing, but with less traffic. Robert _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, June 30, 2009 8:58 AM To: witango-talk@witango.com Subject: Witango-Talk: OT... sort of - Topic Notification for Forum Hey all, I was wondering if some of you bright bulbs may be able to help me. I have a forum I built that is 100% Witango. It has close to 8,000 members and is fairly busy. I have several tables set up for the forum which include usertable (login, email, password, etc.), forummastertable (table of topics, threadnum, startdate, views, etc.) and threadtable (individual posts, masterthreadnum, postdate, user, etc). This forum is rock solid and has been operating for over 5 years. I have built many bells and whistles into it and decided it would be nice to add an opt in email notification. I've seen this on other forums (a checkbox where you can get an email notification if someone replies to a particular thread), but I am having trouble trying to figure out just where to start and how to do this. I don't mean the programming specifically, but more the theory on how to set this up. I have been looking at other forums but cannot find any particular clue as to how this is done. Would I set up a table with the masterthreadnum and email address and when a topic is reponded to, query that table and send an email? This does not seem like a very efficient way to do this. Any ideas would be appreciated. Thanks! WebDude image001.gif http://myfishingpals.com/ MyFishingPals.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Ben Johansen http://www.webspinr.com b...@webspinr.com Phone: 360-597-3372 Mobile: 360-600-7775
Witango-Talk: OT... sort of - Topic Notification for Forum
Hey all, I was wondering if some of you bright bulbs may be able to help me. I have a forum I built that is 100% Witango. It has close to 8,000 members and is fairly busy. I have several tables set up for the forum which include usertable (login, email, password, etc.), forummastertable (table of topics, threadnum, startdate, views, etc.) and threadtable (individual posts, masterthreadnum, postdate, user, etc). This forum is rock solid and has been operating for over 5 years. I have built many bells and whistles into it and decided it would be nice to add an opt in email notification. I've seen this on other forums (a checkbox where you can get an email notification if someone replies to a particular thread), but I am having trouble trying to figure out just where to start and how to do this. I don't mean the programming specifically, but more the theory on how to set this up. I have been looking at other forums but cannot find any particular clue as to how this is done. Would I set up a table with the masterthreadnum and email address and when a topic is reponded to, query that table and send an email? This does not seem like a very efficient way to do this. Any ideas would be appreciated. Thanks! WebDude http://myfishingpals.com/ MyFishingPals.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafsmalllogo.gif
RE: Witango-Talk: OT... sort of - Topic Notification for Forum
Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS feed... the forums already have that, but very few people actually use them. It seesm they would rather check a box then deal with readers. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, June 30, 2009 10:28 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum You need a subscriptions table of sorts: which contains just the member_id and the master_thread_id You can add rows when people signup to get a thread emailed and remove them when they opt-out. Additional columns that come to mind are: Primary key ID (not completely necessary for this type of table, but always helpful) Active/Inactive flag so that you can turn subscriptions on and off (as opposed to deleting the row) Number of emails sent: a counter for how many emails this subscription created, which would be interesting statistically Then when a new post comes in for thread #483, you simply look up all the people that have subscribed to thread #483 and send them an email. Also (and a little off-topic) you many want to consider adding RSS capabilities. It solves basically the same thing, but with less traffic. Robert _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, June 30, 2009 8:58 AM To: witango-talk@witango.com Subject: Witango-Talk: OT... sort of - Topic Notification for Forum Hey all, I was wondering if some of you bright bulbs may be able to help me. I have a forum I built that is 100% Witango. It has close to 8,000 members and is fairly busy. I have several tables set up for the forum which include usertable (login, email, password, etc.), forummastertable (table of topics, threadnum, startdate, views, etc.) and threadtable (individual posts, masterthreadnum, postdate, user, etc). This forum is rock solid and has been operating for over 5 years. I have built many bells and whistles into it and decided it would be nice to add an opt in email notification. I've seen this on other forums (a checkbox where you can get an email notification if someone replies to a particular thread), but I am having trouble trying to figure out just where to start and how to do this. I don't mean the programming specifically, but more the theory on how to set this up. I have been looking at other forums but cannot find any particular clue as to how this is done. Would I set up a table with the masterthreadnum and email address and when a topic is reponded to, query that table and send an email? This does not seem like a very efficient way to do this. Any ideas would be appreciated. Thanks! WebDude http://myfishingpals.com/ MyFishingPals.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafimage001.gif
RE: Witango-Talk: OT... sort of - Topic Notification for Forum
Another qustion... may be easy, I don't know... Is there any way to trigger a taf within another taf not using @URL John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com/ http://cipromo.com _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, June 30, 2009 11:23 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS feed... the forums already have that, but very few people actually use them. It seesm they would rather check a box then deal with readers. _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, June 30, 2009 10:28 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum You need a subscriptions table of sorts: which contains just the member_id and the master_thread_id You can add rows when people signup to get a thread emailed and remove them when they opt-out. Additional columns that come to mind are: Primary key ID (not completely necessary for this type of table, but always helpful) Active/Inactive flag so that you can turn subscriptions on and off (as opposed to deleting the row) Number of emails sent: a counter for how many emails this subscription created, which would be interesting statistically Then when a new post comes in for thread #483, you simply look up all the people that have subscribed to thread #483 and send them an email. Also (and a little off-topic) you many want to consider adding RSS capabilities. It solves basically the same thing, but with less traffic. Robert _ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, June 30, 2009 8:58 AM To: witango-talk@witango.com Subject: Witango-Talk: OT... sort of - Topic Notification for Forum Hey all, I was wondering if some of you bright bulbs may be able to help me. I have a forum I built that is 100% Witango. It has close to 8,000 members and is fairly busy. I have several tables set up for the forum which include usertable (login, email, password, etc.), forummastertable (table of topics, threadnum, startdate, views, etc.) and threadtable (individual posts, masterthreadnum, postdate, user, etc). This forum is rock solid and has been operating for over 5 years. I have built many bells and whistles into it and decided it would be nice to add an opt in email notification. I've seen this on other forums (a checkbox where you can get an email notification if someone replies to a particular thread), but I am having trouble trying to figure out just where to start and how to do this. I don't mean the programming specifically, but more the theory on how to set this up. I have been looking at other forums but cannot find any particular clue as to how this is done. Would I set up a table with the masterthreadnum and email address and when a topic is reponded to, query that table and send an email? This does not seem like a very efficient way to do this. Any ideas would be appreciated. Thanks! WebDude http://myfishingpals.com/ MyFishingPals.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafci.gifimage001.gif
Re: Witango-Talk: Testing: List still up? V6?
yes... still up... And waiting... -Original message- From: Mikal Anderson mi...@digitalshore.com Date: Fri, 1 May 2009 21:56:55 -0500 To: witango-talk@witango.com Subject: Witango-Talk: Testing: List still up? V6? Any news on v6? -- Mikal Anderson www.LakeOMedia.com What has your website done for you lately? This message, including any attachments, is confidential and intended solely for the person(s) or organization to whom it is addressed. If you are not the intended recipient, or have received this message by mistake, please notify Mikal Anderson, the original sender, and delete this message from your system. Any unauthorised use, forwarding, or other dissemination of this message, in whole or in part, is strictly prohibited. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: PDF Form submission
I have been using ActivePDF and it works well. I use a combination of Witango and asp to get the job done. I load all data as variables and pass them to an asp page and then create and stream the data into a pdf. As for streaming out the data, I am not sure what you mean. If the data is being changed, you could change the variables and reinsert the data back into the db. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. [EMAIL PROTECTED] http://cipromo.com -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 7:48 AM To: witango-talk@witango.com Subject: Witango-Talk: PDF Form submission I have a client who has applications set up as PDF forms. We want to be able to pre=populate these from the database and also write the data back out. The forms are all set with field ID's and we have a dictionary. Has anyone done this already? Best tools? Can we use witango? Dan -- Dan Stein FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 6 Update
Good news, Phil... Thank you! WebDude -Original Message- From: Phil Wade [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2008 5:37 AM To: witango-talk@witango.com Subject: Witango-Talk: Witango 6 Update Contrary to the rumours started on the list version 6 is on the way and is not dead. The hold up is all legal issues and related to locating and isolating 3rd part code that has been used in the server under license and replacing it with open API calls so we can go open source. This is taking a lot longer than we thought. We understand that some developers have out grown the platform and have moved on to other platforms, that is their prerogative. We have plans to keep supporting Witango while there are people out there wanting to use it. To this end, can I ask that the you take up Robert's offer and move the porting to PHP discussion to his forum - http://devcom.bighead.net/ . And yes we do have a lot of holidays down here minimum of 30 days leave a year which is 4 weeks statutory leave plus New Years Day, Australia Day, Anzac Day, Easter Friday and Monday, Queen's Birthday, Labour Day, Melbourne Cup Day, Christmas and Boxing Day, etc. Keeps us a happy and family oriented business. The Witango portion of our business is running above expectations albeit a little behind schedule. Apart from that we are just moving ahead at a steady pace. If you have any specific issues or questions contact me off list. Regards Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Open Letter to Phil and Sophie
Janet, I feel your pain. I have been busy downloading stuff and poking around. I have read hundreds of pages on just the install stuff for Apache, MySQL, PHP, ColdFusion, .NET... I even spent a day on nothing but open source. I have a spare server I have been thinking of using just to try some stuff out. What is really daunting is the pages upon pages and gotchyas on just an installation... not to mention the additional downloads needed to make it work in Windows. Funny... I have about 60 sites, some getting well more then 100,000 page views per day... well over 1,000,000 visitors per month in all - all on one MSSQL dedicated server and two dedicated Witango servers runninng Witango 2000. Never a slowdown and has been rock solid for over 8 years. 16 e-commerce sites, 2 Data Access Managements sites, 4 forums, 12 internal employee sites for some very large corporations, one very large directory site, 2 online streaming PDF sites and a smattering of... well, justwebsites. Now I am losing sleep because I am so worried about what direction to go. I spent a very large amount on the corporate license thinking that this was the way to go and have spent much time and resources in developing all I have going. I never upgraded because of the 20,000 plus I dished out and I remember the days when it was discussed that the editor would be able to output ASP and possibly PHP code... but that never happened or was just a pipe dream. Frankly, I thought it would have been a great idea to port output of the editor to more popular languages. Anyway... enough crying in my beer. I went this route and now I am going to have to do something about it. I just spent most of the day trying to install PHP and getting the hello world to work. Tomorrow, I might try to see if I can actually connect to a database. This is going to take me a little while... -Original message- From: janet [EMAIL PROTECTED] Date: Thu, 23Oct 2008 15:55:41 -0500 To: witango-talk@witango.com Subject: RE: Witango-Talk: Open Letter to Phil and Sophie I was wondering what to say until I saw this email from Webdude Well, I have a problem and maybe some of you could help me. I have been using nothing but Tango and Witango since I started developing many years ago Yes this is my story also. Pretty good at SQL ( MS SQL) triggers, stored procedure, views, groupings , maxvalues etc just a happy place for me, also HTML and Witango. I found that if I had good array results then the Witango stuff was easy. So I have looked at other RAD visual products. With ASP.net you end up with blocks of code either in VB or C+, there is s Borland PHP RAD, Cold fusion and Dreamweaver etc. But it seems that the builder tools all create either PHP, VB, C+ or something. How come Witango shielded me from all of these languages? I know Witango is an XML code generator so why isn't there any other products creating XML? I am asking the wrong question? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Open Letter to Phil and Sophie
If you guys want, I have several forums online. I could easily set up one for Witango. If this list goes away, it might be a way for us to still communicate. Up to you... WebDude -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 8:23 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Open Letter to Phil and Sophie I think this is true. I suspect that Adobe may let this language pass on also over time and tighten integration with PHP. I notice Web Assist has announced they will no longer be making products for ASP or Cold Fusion which might be a sign. -- -- Dan Stein FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com It is perfectly safe to stand nowhere. On Oct 20, 2008, at 12:33 PM, Rick Sanders wrote: Hey Webdude, I'd check out Cold Fusion. It's a pretty easy transition from WiTango. Taf = cfm Tcf = cfc Best of all, you develop in Dreamweaver. The Cold Fusion app server is free for development. Best of all, you can develop on a Mac and use a PC as the CF server. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: WebDude [mailto:[EMAIL PROTECTED] Sent: October-20-08 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Open Letter to Phil and Sophie Hello all, Well, I have a problem and maybe some of you could help me. I have been using nothing but Tango and Witango since I started developing many years ago. Started on Mac with Butler and eventually moved to Windows. Witango is all I have ever used and now I am in a quandry. I see the writing is on the wall and though I have resisted for many years, it seems that I am going to have to take the plunge and figure out what to do for what I have that already exists and for the future. The problem is that I am so comfortable with what I have that moving is going to take a lot of effort. I have been going through the different options out there and I am so confused as to editors, parsers, etc. that I really do not know which direction to turn. I have a very small smattering of ASP which I hacked in order to get a site that was moved to our servers to work, but that is the only other language that I even attempted to try. The real crux of the problem is that everything out there looks very confusing and so far removed from what I currently have. I am fairly adept in SQL, Witango, HTML and CSS but I have never taken the time to learn anything new. I downloaded some PHP editors, some sample ASP stuff, and to tell you the truth, I just don't get a lot of it. Is there anything out there that gives as visual of an interface as Witango? Or maybe is there a specific place you can go to relearn the logic that it will take to use any of the tools available? I think PHP is probably the place to start, but I am totally confused as to how to go about it. I would prefer to continue using IIS as I am very familiar with it along with the security. I went to the PHP site and it seems that there are pages upon pages of just the install for IIS. Or, how about editors? Are there any that you would recommend? Keep in mind my Witango background. I never went to school for any of this stuff and I have some pretty complicated things running on my sites from forums to streaming PDFs, data access management systems to e-commerce. This is going to be tough, but I need to take it one step at a time... html head titlePHP Test/title /head body ?php echo 'pHello World/p'; ? /body /html WebDude __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: community
I registered. I am still waiting... Still in moderation queue to be added to the forum webdude -Original Message- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 10:22 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: community I guess registration is disabled, I will have that resolved today. Keep trying. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Oct 21, 2008, at 8:12 AM, Robert Garcia wrote: I would hate to see the community die. A while ago, a few of us started to build a community that was not list based, but in a searchable forum with a wiki and such. It never went anywhere, because we couldn't agree on if it was a negative thing to witango the company. That seems all moot now. And since this list may go away soon, I thought I would post up. http://devcom.bighead.net/ This is just on a staging server but provides sections for asking questions on how to port to other languages, and allows us to create how tos in the wiki. Ben was helping moderate this, and there were a few others that were going to take other sections, like the coldfusion section. If everyone moved over there, we can continue the community. Feel free to keep asking witango questions there, I will be there and will answer. Hopefully ben and the others may also want to still help, and we can keep this community going. If not, thats ok too. But at least we would all be able to freely communicate. I don't want it to be a witango bashing place, I want it to be a place where we move forward. Some staying with witango, some moving to other platforms, but we can all help each other. So register and start posting. ;-) Witango would also be welcome to post announcements about v6 if it is still coming out. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Open Letter to Phil and Sophie
Hello all, Well, I have a problem and maybe some of you could help me. I have been using nothing but Tango and Witango since I started developing many years ago. Started on Mac with Butler and eventually moved to Windows. Witango is all I have ever used and now I am in a quandry. I see the writing is on the wall and though I have resisted for many years, it seems that I am going to have to take the plunge and figure out what to do for what I have that already exists and for the future. The problem is that I am so comfortable with what I have that moving is going to take a lot of effort. I have been going through the different options out there and I am so confused as to editors, parsers, etc. that I really do not know which direction to turn. I have a very small smattering of ASP which I hacked in order to get a site that was moved to our servers to work, but that is the only other language that I even attempted to try. The real crux of the problem is that everything out there looks very confusing and so far removed from what I currently have. I am fairly adept in SQL, Witango, HTML and CSS but I have never taken the time to learn anything new. I downloaded some PHP editors, some sample ASP stuff, and to tell you the truth, I just don't get a lot of it. Is there anything out there that gives as visual of an interface as Witango? Or maybe is there a specific place you can go to relearn the logic that it will take to use any of the tools available? I think PHP is probably the place to start, but I am totally confused as to how to go about it. I would prefer to continue using IIS as I am very familiar with it along with the security. I went to the PHP site and it seems that there are pages upon pages of just the install for IIS. Or, how about editors? Are there any that you would recommend? Keep in mind my Witango background. I never went to school for any of this stuff and I have some pretty complicated things running on my sites from forums to streaming PDFs, data access management systems to e-commerce. This is going to be tough, but I need to take it one step at a time... html head titlePHP Test/title /head body ?php echo 'pHello World/p'; ? /body /html WebDude TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Open Letter to Phil and Sophie
Yes, there are statements in some of the includes, along with variables. Do
variables and statements not work when using includes for PHP? I think it
would be pretty easy to redo some of the includes... or just not use
includes.
WebDude
-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2008 11:08 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Open Letter to Phil and Sophie
Web dude. Did you put any statements into includes, or was everything built
by the editor?
For example, the *text*:
@IF EXPR=/@IF translates very well to
?php if( ) { ; } ? (PHP) or
CFIF () /CFIF (Coldfusion)
But the things built by the editor may need to be translated to text. Some
of this you'll see if you look at the RAW XML created for the .tafs
If you use custom functions, these, of course have to be recreated.
The logic/flow should bascially be the same. A login taf can be a login
page(s) with the same forms and processing. The SQL queries can be mostly
the same.
The HTML, CSS, and JavaScript are definitely the same!!
Beverly
On 10/20/08 11:42 AM, WebDude [EMAIL PROTECTED] wrote in whole or in
part:
Hello all,
Well, I have a problem and maybe some of you could help me. I have
been using nothing but Tango and Witango since I started developing
many years ago. Started on Mac with Butler and eventually moved to
Windows. Witango is all I have ever used and now I am in a quandry. I
see the writing is on the wall and though I have resisted for many
years, it seems that I am going to have to take the plunge and figure
out what to do for what I have that already exists and for the future.
The problem is that I am so comfortable with what I have that moving
is going to take a lot of effort. I have been going through the
different options out there and I am so confused as to editors,
parsers, etc. that I really do not know which direction to turn. I
have a very small smattering of ASP which I hacked in order to get a
site that was moved to our servers to work, but that is the only other
language that I even attempted to try. The real crux of the problem is
that everything out there looks very confusing and so far removed from
what I currently have. I am fairly adept in SQL, Witango, HTML and CSS but
I have never taken the time to learn anything new.
I downloaded some PHP editors, some sample ASP stuff, and to tell you
the truth, I just don't get a lot of it. Is there anything out there
that gives as visual of an interface as Witango? Or maybe is there a
specific place you can go to relearn the logic that it will take to
use any of the tools available? I think PHP is probably the place to
start, but I am totally confused as to how to go about it. I would
prefer to continue using IIS as I am very familiar with it along with
the security. I went to the PHP site and it seems that there are pages
upon pages of just the install for IIS. Or, how about editors? Are
there any that you would recommend? Keep in mind my Witango
background. I never went to school for any of this stuff and I have
some pretty complicated things running on my sites from forums to
streaming PDFs, data access management systems to e-commerce.
This is going to be tough, but I need to take it one step at a time...
html
head
titlePHP Test/title
/head
body
?php echo 'pHello World/p'; ?
/body
/html
WebDude
__
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: One for the Math Gurus
Having a hard time wrapping my head around this one. Any help would be appreciated. Let's say we have bottles of perfume for sale. For shipping, we can fit 12 bottles into a box. Each box is sent separately via a courrier. The courrier charges x amount for each box plus weight. To make a long story shorter, in this scenario, we have different charges for quantities of bottles within a box. So, for a specific zone, we charge like so... QuantityPrice 1$14.50 2$15.50 3$16.50 4$18.50 5$18.75 6$19.00 7$20.00 8$21.00 9$22.00 10 $23.00 11 $25.00 12 $26.00 Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50. 14th bottle would be 26.00 + 15.50. 15th bottle would be 26.00 + 16.50, etc. And to continue following this format... 24 bottles would be 26.00 + 26.00 25 bottles would be 26.00 + 26.00 + 14.50 26 bottles would be 26.00 + 26.00 + 15.50 27 bottles would be 26.00 + 26.00 + 16.50, etc. There is a formula in there somehow, but I am having a devil of a time trying to figure it out. Any help would be appreciated. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: One for the Math Gurus
Sorry if I am dense, Beverly, but I am not able to get this to work. It kind
of half works.
Here is what I am doing...
@ASSIGN r @CALC '@ARG QTY % 12'
@ASSIGN q @CALC '@ARG QTY / 12'
@CALC (@VAR q * 26.00) + ( This is a search for @VAR r which returns
the @COLUMN shipcost.price )
Now, if I plug in the number 1 (quantity 1) This would look like this...
R = 1
Q = 0.0833
Thus I get...
0.0833 * 26.00 + (14.50) = 16.7
Answer should be 14.50
And if plug in the number 13 (quantity 13) I get...
R = 1
Q = 1.08
Thus I get...
1.08 * 26.00 + (14.50) = 42.6
Answer should be 40.50
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
[EMAIL PROTECTED]
http://cipromo.com
-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 8:47 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: One for the Math Gurus
Use the MODULO function to get the remainder.
r = QTY % 12
Along with the quotient.
q = QTY / 12
(q * 26.00) + ( {lookup what the price is for r items} )
Beverly
On 10/17/08 9:17 AM, WebDude [EMAIL PROTECTED] wrote in whole or in
part:
Having a hard time wrapping my head around this one. Any help would be
appreciated.
Let's say we have bottles of perfume for sale. For shipping, we can
fit 12 bottles into a box. Each box is sent separately via a courrier.
The courrier charges x amount for each box plus weight. To make a long
story shorter, in this scenario, we have different charges for
quantities of bottles within a box. So, for a specific zone, we charge
like so...
QuantityPrice
1 $14.50
2 $15.50
3 $16.50
4 $18.50
5 $18.75
6 $19.00
7 $20.00
8 $21.00
9 $22.00
10 $23.00
11 $25.00
12 $26.00
Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50.
14th bottle would be 26.00 + 15.50.
15th bottle would be 26.00 + 16.50, etc.
And to continue following this format...
24 bottles would be 26.00 + 26.00
25 bottles would be 26.00 + 26.00 + 14.50
26 bottles would be 26.00 + 26.00 + 15.50
27 bottles would be 26.00 + 26.00 + 16.50, etc.
There is a formula in there somehow, but I am having a devil of a time
trying to figure it out. Any help would be appreciated.
Thanks!
__
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: One for the Math Gurus
Okay, I got it working halfway using this...
@ASSIGN r @CALC EXPR='@ARG quantity%12'
@ASSIGN q @CALC EXPR='@ARG quantity/12' PRECISION=0
@CALC EXPR=(@VAR q * 26)+(@COLUMN 'shippingprice.price')
PRECISION=2
It calculates correctly until you try any of the following quantities...
6 through 11
18 through 23
30 through 35
Etc.
Makes sense, though because of the @CALC EXPR='@ARG quantity/12'
PRECISION=0 will always round up. Wasn't there a floor that would help with
this?
-Original Message-
From: WebDude [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 9:51 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: One for the Math Gurus
Sorry if I am dense, Beverly, but I am not able to get this to work. It kind
of half works.
Here is what I am doing...
@ASSIGN r @CALC '@ARG QTY % 12'
@ASSIGN q @CALC '@ARG QTY / 12'
@CALC (@VAR q * 26.00) + ( This is a search for @VAR r which returns
the @COLUMN shipcost.price )
Now, if I plug in the number 1 (quantity 1) This would look like this...
R = 1
Q = 0.0833
Thus I get...
0.0833 * 26.00 + (14.50) = 16.7 Answer should be
14.50
And if plug in the number 13 (quantity 13) I get...
R = 1
Q = 1.08
Thus I get...
1.08 * 26.00 + (14.50) = 42.6 Answer should be 40.50
John Muldoon
Corporate Incentives
3416 Nicollet Ave S
Minneapolis, MN 55408-4552
612.822.
[EMAIL PROTECTED]
http://cipromo.com
-Original Message-
From: Beverly Voth [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 8:47 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: One for the Math Gurus
Use the MODULO function to get the remainder.
r = QTY % 12
Along with the quotient.
q = QTY / 12
(q * 26.00) + ( {lookup what the price is for r items} )
Beverly
On 10/17/08 9:17 AM, WebDude [EMAIL PROTECTED] wrote in whole or in
part:
Having a hard time wrapping my head around this one. Any help would be
appreciated.
Let's say we have bottles of perfume for sale. For shipping, we can
fit 12 bottles into a box. Each box is sent separately via a courrier.
The courrier charges x amount for each box plus weight. To make a long
story shorter, in this scenario, we have different charges for
quantities of bottles within a box. So, for a specific zone, we charge
like so...
QuantityPrice
1 $14.50
2 $15.50
3 $16.50
4 $18.50
5 $18.75
6 $19.00
7 $20.00
8 $21.00
9 $22.00
10 $23.00
11 $25.00
12 $26.00
Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50.
14th bottle would be 26.00 + 15.50.
15th bottle would be 26.00 + 16.50, etc.
And to continue following this format...
24 bottles would be 26.00 + 26.00
25 bottles would be 26.00 + 26.00 + 14.50
26 bottles would be 26.00 + 26.00 + 15.50
27 bottles would be 26.00 + 26.00 + 16.50, etc.
There is a formula in there somehow, but I am having a devil of a time
trying to figure it out. Any help would be appreciated.
Thanks!
__
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: One for the Math Gurus
Thanks everyone for your help... I got it working... @ASSIGN q '@CALC EXPR=floor(@ARG quantity/12) PRECISION=0' @ASSIGN r '@CALC EXPR=@ARG quantity%12' @CALC EXPR=(@VAR q * 26)+(@COLUMN 'shippingprice.price') PRECISION=2 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 6 update
Yeah, 700 billion outta do it ;-) -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 8:04 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Witango 6 update Good News... Congress is going to earmark $$ for WiTango as part of its economic stimulus bailout... Wooo Hooo! -Original Message- From: WebDude [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 08:03 To: witango-talk@witango.com Subject: RE: Witango-Talk: Witango 6 update Yeah... Good news would be great right now... WebDude http://myfishingpals.com -Original Message- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 7:36 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Witango 6 update I agree with you folks. I can't imagine a better week in which good news would be welcomed! -Original Message- From: Beverly Voth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 8:13 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Witango 6 update This would be a week for good information. :) Beverly On 9/30/08 7:44 PM, Roland Dumas [EMAIL PROTECTED] wrote in whole or in part: y'know. I think you're right. This is a very good week for information. On Sep 30, 2008, at 5:22 AM, Dan Stein wrote: This week would be a good time to here about the progress or lack of progress in moving forward. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: 304 last-modified
Hi All, I am a bit confused as to how to implement a caching scheme in which I can show whether or not a page has been updated or not. This is for a forum that stores the last update by date. I would like to change the response http to show the last-modified date if possible. Unfortunately, I am a novice on http headers and would like some help on how to implement this. If I set the expiry to @ASSIGN Local$httpHeader VALUE=Content-Type: text/html@CRLFCache-Control: no-cache, max-age=0, must-revalidate,proxy revalidate@CRLFPragma: no-cache@CRLF@USERREFERENCECOOKIE@CRLF Will this generat what I need for the request? I am looking for the reponse to be something like this... HTTP/1.0 200 OK Server: Microsoft-IIS/5.0 Content-Location: http://www.xyz.taf http://www.xyz.taf Date: Fri, 22 Aug 2008 18:22:39 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Wed, 020 Aug 2008 13:30:23 GMT ETag: 801395163ec21:8a9 Content-Length: 751 And I am confused as to the ETag. Can I set this globally for all tafs? or would that really take a performance hit? Can someone shed some light on this, please? Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: 304 last-modified
Thanks, Scott, Yeah, I thought it was going to be complicated ;-/ I actually was looking at ASP and PHP code to see if I could write something in Witango that would kind of do the same thing. I was looking at this from a Googlebot point of view. When Gbot comes, if the requested page hasn't been modified since the last request it won't crawl the page. Google recommends that you use this... You should configure your server to return this response (called the If-Modified-Since HTTP header) when a page hasn't changed since the last time the requestor asked for it. This saves you bandwidth and overhead because your server can tell Googlebot that a page hasn't changed since the last time it was crawled. 'Dude -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2008 9:51 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: 304 last-modified Hey Dude, Unfortunately HTTP caching takes a lot more consideration than just globally setting a custom HTTP response header. When you set a custom header for caching purposes, this process is entirely dependent on receiving some specific request HTTP header properties (i.e., If-Modified-Since and/or If-None-Match), in order to conditionally set a corresponding expiry date, an ETag number and a 304 response (for the subsequent responses), as opposed to the custom 200 response (on the first response). And depending on the version of tango you are running - you may not have access to these HTTP properties. In addition, HTTP caching is managed by matching the entire URL of the file in question, this includes the argument names and values, so if your GET arguments are changing, then your caching is overridden. POST requests generally always override cache checks as well. And of course it should be mentioned that although browsers and proxies do adhere to the HTTP standards, these applications and devices are sometimes unpredictable as to when they implement cache rules. I've built systems with HTTP caching, and I hope I can save you some time by giving you some advice - don't bother. The headache, unpredictability and limited results is usually not worth it. There'll be times where you can easily waste hours chasing your code in circles just to discover that all the bugs and weird behavior is the result of something happening off the server (where you have no control). I would recommend you pursue methods for caching whatever essential data you need in memory on the Server to save on performance issues - or check out load balancing. Or possibly an appliance of some kind that handles the caching outside of your server. And please note, your tango code example is for deliberately turning off caching. I hope this helps, good luck. Scott, On Aug-22-2008, at 10:55 AM, WebDude wrote: Hi All, I am a bit confused as to how to implement a caching scheme in which I can show whether or not a page has been updated or not. This is for a forum that stores the last update by date. I would like to change the response http to show the last-modified date if possible. Unfortunately, I am a novice on http headers and would like some help on how to implement this. If I set the expiry to @ASSIGN Local$httpHeader VALUE=Content-Type: text/html@CRLFCache- Control: no-cache, max-age=0, must-revalidate,proxy revalidate@CRLFPragma: no- cache@CRLF@USERREFERENCECOOKIE@CRLF Will this generat what I need for the request? I am looking for the reponse to be something like this... HTTP/1.0 200 OK Server: Microsoft-IIS/5.0 Content-Location: http://www.xyz.taf Date: Fri, 22 Aug 2008 18:22:39 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Wed, 020 Aug 2008 13:30:23 GMT ETag: 801395163ec21:8a9 Content-Length: 751 And I am confused as to the ETag. Can I set this globally for all tafs? or would that really take a performance hit? Can someone shed some light on this, please? Thanks! __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Observations on Survey results
Thanks for the survey, Scott! 'Dude -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 11:39 AM To: Witango-Talk Subject: Witango-Talk: Observations on Survey results Hi All, The survey has reached 49 responses, a very respectable number. Congratulations everyone. http://freeonlinesurveys.com/viewresults.asp?c=x4jovb5l0cv4h6y469661 Note, I think the survey system only lets you see the first 50 responses. For more you have to buy a monthly subscription. An observation that I think is interesting, is that the number of people coding on a particular platform for their Editor/Studio does not directly match the Server platform they deploy to. As well, the majority of choice for an alternate technology platform (Linux) also do not match the platform most considered stable for Witango (Windows). I think what that says is that Witango programmers are less concerned about the Operating System they use, and more interested in stability and options. Personally I think that's a great attribute for a good programmer or service provider - by focusing on the solution and not letting yourself get hung up on the logistics. Of course, some might say the same should be said about our choice of programming languages too. Also, I see the interest in Java based options (both current and as an alternate technology) being very low - yet, a lot of people are planning to move to version 6 which is apparently java-based. Does that mean we trust Java more as an application platform than as a coding environment? Just curious. In hindsight I know I could have worded things a little differently, but mostly I wish I had added another option for Question 10 (What do you use or see as a workable transition platform?) as Not interested in moving away from Witango. But for being a spur of the moment thing, I think it all worked out pretty well. Thank you. Take care. Scott, TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]
Using Windoze here. Started with Mac and Butler a long... Long time ago A 8500 if I remember correctly. 'Dude -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 7:22 AM To: witango-talk@witango.com Subject: RE: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] Is it just me, or does it seem that a large portion of the existing WiTango user base is using the Macintosh platform? Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: August-05-08 9:10 AM To: witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] I have found that to be the case also but a monthly update to the community would be very important. -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals From: Mikal Anderson [EMAIL PROTECTED] Reply-To: witango-talk@witango.com witango-talk@witango.com Date: Mon, 04 Aug 2008 21:54:31 -0700 To: witango-talk@witango.com witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] quote Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. /quote Agreed. Phil does however answer his phone will reply to your email. Mikal Anderson PDX On 8/4/2008 9:29 PM, John Carrieri wrote: Hi Christian, I too have used witango for 11 years which is hard to believe and also initially on a APPLE AWS 8550. When we first started jokes.com (since sold too Comedy Central/ it sucks now despite the fact that they have still stayed in #1 position on goog) we had three front ends and one back end running Butler and we made it work serving millions of viewers! Since I've used tango / witango on everything from Enterprise level Sun servers to the latest Xserves. Through all of this it has been extremely stable through a decade of use, with the exception of running it under 10.5. While I have used it on Mac and Sun platforms I always appreciated that it could also run on Windows and later Linux. Put quite simply it is a great flexible platform. I understand the challenges that Witango must have as a small company, with a complex product, but they need to communicate to their customers. Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. Please, please communicate with us. I think that is all anyone is asking. Sincerely, John On 8/4/08 8:52 PM, Christian Platt [EMAIL PROTECTED] wrote: It would be easy to post this message to the list. Or at least a person who is in connection with will could make the communication with the still existing community. I do not know, how many peaple are still on the list or using witango. I checked that this is my 11th year since starting With Butler/Tango on an APPLE AWS 8550. It would be interesting to know, how many people are still using/ developing Witango Christian Am 04.08.2008 um 21:34 schrieb Mikal Anderson: Below is latest from Phil. Original Message Subject: Re: [Fwd: Witango-Talk: Version 6?] Date: Mon, 4 Aug 2008 09:57:07 +1000 From: Phil Wade [EMAIL PROTECTED] To: Mikal Anderson [EMAIL PROTECTED] References: [EMAIL PROTECTED] Mikal, The major issue we have is that we have to make sure that the code is OK to go open source and the license protects WT's rights. Without these being finished we cannot release. We were also advised to not issue any more betas until this was completed. When the lawyers give us the OK we will get it out. Regards Phil On August 1st, 2008, at 4:37 AM, Mikal Anderson wrote: Phil, the list has not heard a peep from you. What's up with version 6? Mikal Anderson PDX Original Message Subject: Witango-Talk: Version 6? Date: Thu, 31 Jul 2008 14:27:00 -0400 From: Stefan Gonick [EMAIL PROTECTED] Reply-To: witango-talk@witango.com To: witango-talk@witango.com A while back someone predicted that version 6 was coming out last week, though it was obviously not from With. Was that a completely mistaken notion, or was there something to it? Is version 6 coming out any time soon? Stefan ___ _ TO
RE: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]
What version are you using? - 3.x XX 4.x/2000 - 5.0 - 5.5 What platform is your Editor? XX Windows - Mac Are you using the Java Compiler? - Yes XX No What platform is your server? XX Windows - Mac - Linux - Solaris How many Witango servers do you run? - 1 XX 2~5 - 6~10 - 11~20 - 20+ Just a thought... Scott, On Aug-5-2008, at 9:22 AM, Rick Sanders wrote: Is it just me, or does it seem that a large portion of the existing WiTango user base is using the Macintosh platform? Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: August-05-08 9:10 AM To: witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] I have found that to be the case also but a monthly update to the community would be very important. -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals From: Mikal Anderson [EMAIL PROTECTED] Reply-To: witango-talk@witango.com witango-talk@witango.com Date: Mon, 04 Aug 2008 21:54:31 -0700 To: witango-talk@witango.com witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] quote Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. /quote Agreed. Phil does however answer his phone will reply to your email. Mikal Anderson PDX On 8/4/2008 9:29 PM, John Carrieri wrote: Hi Christian, I too have used witango for 11 years which is hard to believe and also initially on a APPLE AWS 8550. When we first started jokes.com (since sold too Comedy Central/ it sucks now despite the fact that they have still stayed in #1 position on goog) we had three front ends and one back end running Butler and we made it work serving millions of viewers! Since I've used tango / witango on everything from Enterprise level Sun servers to the latest Xserves. Through all of this it has been extremely stable through a decade of use, with the exception of running it under 10.5. While I have used it on Mac and Sun platforms I always appreciated that it could also run on Windows and later Linux. Put quite simply it is a great flexible platform. I understand the challenges that Witango must have as a small company, with a complex product, but they need to communicate to their customers. Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. Please, please communicate with us. I think that is all anyone is asking. Sincerely, John On 8/4/08 8:52 PM, Christian Platt [EMAIL PROTECTED] wrote: It would be easy to post this message to the list. Or at least a person who is in connection with will could make the communication with the still existing community. I do not know, how many peaple are still on the list or using witango. I checked that this is my 11th year since starting With Butler/ Tango on an APPLE AWS 8550. It would be interesting to know, how many people are still using/ developing Witango Christian Am 04.08.2008 um 21:34 schrieb Mikal Anderson: Below is latest from Phil. Original Message Subject: Re: [Fwd: Witango-Talk: Version 6?] Date: Mon, 4 Aug 2008 09:57:07 +1000 From: Phil Wade [EMAIL PROTECTED] To: Mikal Anderson [EMAIL PROTECTED] References: [EMAIL PROTECTED] Mikal, The major issue we have is that we have to make sure that the code is OK to go open source and the license protects WT's rights. Without these being finished we cannot release. We were also advised to not issue any more betas until this was completed. When the lawyers give us the OK we will get it out. Regards Phil On August 1st, 2008, at 4:37 AM, Mikal Anderson wrote: Phil, the list has not heard a peep from you. What's up with version 6? Mikal Anderson PDX Original Message Subject: Witango-Talk: Version 6? Date: Thu, 31 Jul 2008 14:27:00 -0400 From: Stefan Gonick [EMAIL PROTECTED] Reply-To: witango-talk@witango.com To: witango-talk@witango.com A while back someone predicted that version 6 was coming out last week, though it was obviously not from With. Was that a completely mistaken notion, or was there something to it? Is version 6 coming out any time soon? Stefan
RE: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]]
Oh, and something like: How often do you use Witango? XX Everyday, 95% my projects ~ About half of my projects ~ At least once a year ~ No longer code in Witango, I just hang out on the list to annoy people or because I can't help myself (check) Scott, On Aug-5-2008, at 9:34 AM, Scott Cadillac wrote: Good question Rick, Maybe someone should setup an anonymous Poll somewhere? I'd be very curious to see the results. Although I do know more than one customer running a large number of Windows servers with Witango. What are some good questions to ask? What version are you using? - 3.x - 4.x/2000 - 5.0 - 5.5 What platform is your Editor? - Windows - Mac Are you using the Java Compiler? - Yes - No What platform is your server? - Windows - Mac - Linux - Solaris How many servers do you run? - 1 - 2~5 - 6~10 - 11~20 - 20+ Just a thought... Scott, On Aug-5-2008, at 9:22 AM, Rick Sanders wrote: Is it just me, or does it seem that a large portion of the existing WiTango user base is using the Macintosh platform? Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: August-05-08 9:10 AM To: witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] I have found that to be the case also but a monthly update to the community would be very important. -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals From: Mikal Anderson [EMAIL PROTECTED] Reply-To: witango-talk@witango.com witango-talk@witango.com Date: Mon, 04 Aug 2008 21:54:31 -0700 To: witango-talk@witango.com witango-talk@witango.com Subject: Re: [Fwd: Re: [Fwd: Witango-Talk: Version 6?]] quote Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. /quote Agreed. Phil does however answer his phone will reply to your email. Mikal Anderson PDX On 8/4/2008 9:29 PM, John Carrieri wrote: Hi Christian, I too have used witango for 11 years which is hard to believe and also initially on a APPLE AWS 8550. When we first started jokes.com (since sold too Comedy Central/ it sucks now despite the fact that they have still stayed in #1 position on goog) we had three front ends and one back end running Butler and we made it work serving millions of viewers! Since I've used tango / witango on everything from Enterprise level Sun servers to the latest Xserves. Through all of this it has been extremely stable through a decade of use, with the exception of running it under 10.5. While I have used it on Mac and Sun platforms I always appreciated that it could also run on Windows and later Linux. Put quite simply it is a great flexible platform. I understand the challenges that Witango must have as a small company, with a complex product, but they need to communicate to their customers. Delays are understandable and part of the business, but communication is essential. At least a monthly communication would go a long way with the development community and I know Im not alone in this feeling. Please, please communicate with us. I think that is all anyone is asking. Sincerely, John On 8/4/08 8:52 PM, Christian Platt [EMAIL PROTECTED] wrote: It would be easy to post this message to the list. Or at least a person who is in connection with will could make the communication with the still existing community. I do not know, how many peaple are still on the list or using witango. I checked that this is my 11th year since starting With Butler/ Tango on an APPLE AWS 8550. It would be interesting to know, how many people are still using/ developing Witango Christian Am 04.08.2008 um 21:34 schrieb Mikal Anderson: Below is latest from Phil. Original Message Subject: Re: [Fwd: Witango-Talk: Version 6?] Date: Mon, 4 Aug 2008 09:57:07 +1000 From: Phil Wade [EMAIL PROTECTED] To: Mikal Anderson [EMAIL PROTECTED] References: [EMAIL PROTECTED] Mikal, The major issue we have is that we have to make sure that the code is OK to go open source and the license protects WT's rights. Without these being finished we cannot release. We were also advised to not issue any more betas until this was completed. When the lawyers give us the OK we will get it out. Regards Phil On August 1st, 2008, at 4:37 AM, Mikal Anderson wrote: Phil, the list has not heard a peep from
RE: Witango-Talk: Adobe PDF Generation using Witango?
I have. I use a combination of ActivePDF Toolkit, a smattering of ASP and Witango. I use mostly Witango for data calls and such and when I need to generate the PDF, I pass the values to ASP via hidden post arguements and load variables on the ASP side. I have been using this for customized business cards, sell sheets and realtor signs. I tried to use the ASP as includes but could never get the combination of applications to work correctly. ActivePDF Toolkit has modules built already for ASP and PHP. http://www.activepdf.com/products/ToolKitV4-60x55.gif http://www.activepdf.com/images/clear.gif activePDF Toolkit is the Swiss Army Knife for PDF - virtually any PDF manipulation task can be automated through Toolkit's robust API. With activePDF Toolkit you can: http://www.activepdf.com/images/clear.gif * Apply watermarks and stamp images and text into PDF files. * Merge multiple PDF documents into a single PDF file, adding bookmarks for easy navigation. * Dynamic PDF http://www.activepdf.com/products/serverproducts/toolkit/overview.cfm form-filling - populate PDF forms with database data and generate form fields on the fly. * Detect PDF tampering through Toolkit's fingerprint technology. * Generate over 20 standard barcode types without requiring third-party utilities or individual barcode fonts. * Add dynamic headers, footers and page numbering to PDF documents. * Convert http://www.activepdf.com/products/serverproducts/toolkit/overview.cfm to PDF from over 40 image types on the fly and embed FlashR files within PDFs. * Digitally sign PDF files and secure documents through PDF encryption. http://www.activepdf.com/products/serverproducts/toolkit/ http://cipromo.com/ _ From: Kaustav Acharya [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2008 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: Adobe PDF Generation using Witango? Hi to everyone on the list, Has any had any experience generating a PDF from a Witango application? If so, how did you go about it? Kaustav Acharya Technical Customer Service Manager U. Inc. 12250 El Camino Real, Suite #100 San Diego, CA. 92130 Office: (858) 847-3350 x1004 Fax: (858) 847-3340 email: [EMAIL PROTECTED] http://www.colleges.com All the News. No Ink. - http://www.onlinetimes.com Power to the People - http://www.campaign.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafToolKitV4-60x55.gifclear.gif
RE: Witango-Talk: Revisiting http headers
I see... I was doing some testing using header checker tools and you are right, they all show 404 except for the tool at webmasterworld... I was trying to figure out why they showed a 200. It appears that google is seeing the 404s, though... That is what I was concerned about. Just as an aside, Gbot is doing some creative crawling and adding in various numbers and words In queries to try to mine data that normally users wouldn't find. Others have noted this same problem. Whether G thinks it is a problem or not, remains to be seen. This has caused a bit of a problem with one of my sites. An example... @APPFILE?a=111b=222c=3 - this would be my normal query... Googlebot is inserting random numbers and rearranging the order of the queries. The c value is not necessary to return the page (it is now, though). So I show in the logs... @APPFILE?b=222a=111c=8 @APPFILE?c=9a=111b=222 @APPFILE?a=111c=10b=222 All pointing to the same content. Currently this created over 6600 duplicate pages in the SERPs. I am trying to get this straightened out via robots.txt, no-follows, ISAPI and cleaning up the code. What next, eh? -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 12:10 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Revisiting http headers Hey Dude, Remember, IIS handles the request before Tango does, so technically speaking IIS did find your page, otherwise the TAF would not have executed your code. What counts is that the browser got a 404 response from the server. Hope that helps. Scott, On Jul-1-2008, at 1:21 PM, WebDude wrote: I understand that when I assign this to the not found file, it works correctly when the actual file does not exist. However, is it possible to get this to work on a no results page? I tried this at the head of a no results page, yet IIS5 logs show it as being found. Any way around this? This is what I have... @purgeresults@assign httpheader HTTP/1.0 404 Not Found@CRLF@CRLF scope=local Thanks! __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Revisiting http headers
I understand that when I assign this to the not found file, it works correctly when the actual file does not exist. However, is it possible to get this to work on a no results page? I tried this at the head of a no results page, yet IIS5 logs show it as being found. Any way around this? This is what I have... @purgeresults@assign httpheader HTTP/1.0 404 Not Found@CRLF@CRLF scope=local Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: ping
And what's wrong with my ping? I have a very nice ping! John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. [EMAIL PROTECTED] http://cipromo.com -Original Message- From: Beverly Voth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2008 6:44 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: ping Ah. The message from webdude just showed up in my Barracuda spam list this morning. The rest went through from here, so my guess is that webdude has something 'cuda didnt like in the 'ping'. ;) -- Beverly Voth mailto:[EMAIL PROTECTED] tel:(606) 864-0041 -- On Jun 12, 2008, at 12:23 AM, Mark Weiss [EMAIL PROTECTED] wrote: The new open source community may be selective. Maybe that's it. Mark On Jun 11, 2008, at 1:56 PM, Beverly Voth wrote: No. That's why I say something's amiss... :) Beverly On 06/11/08 4:46 PM, Ben Johansen [EMAIL PROTECTED] wrote in whole or in part: you didn't see the email from webdude? Ben On Jun 11, 2008, at 1:41 PM, Beverly Voth wrote: On 06/11/08 4:31 PM, Ben Johansen [EMAIL PROTECTED] wrote in whole or in part: I'll pong it Ben I didn't see the ping. Something's amiss... Beverly _ ___ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Mark Weiss http://trustthechildren.blogspot.com __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: List you can checkout anytime you want, but you can never leave
I agree wholeheartedly... ;-) -Original message- From: Michael R. Young [EMAIL PROTECTED] Date: Thu, 8 May 2008 07:30:12 -0500 To: witango-talk@witango.com Subject: RE: Witango-Talk: List you can checkout anytime you want, but you can never leave How true it is! Mike _ From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 07, 2008 7:37 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: going green Hey, Bill, this list is like Hotel California... you can checkout anytime you want, but you can never leave Take Care Ben On May 6, 2008, at 3:43 PM, William M Conlon wrote: Hi all, I'll be leaving the software world and returning to my roots in the energy business at Ausra, a startup here in Palo Alto. Thanks to everyone for the suggestions and help over the years. Best of Luck! Bill William M. Conlon, P.E., Ph.D. To the Point 2330 Bryant Street Palo Alto, CA 94301 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: getting a new userreference
You can change to port 443 (https). This resets the cookie. It might change
when going to a subdomain too, but I haven't checked this. I have also seen
instances when the cookie was trashed going into ASP pages and back again.
Just some rambling thoughts.
-Original message-
From: William M Conlon [EMAIL PROTECTED]
Date: Sat, 15 Mar 2008 11:17:53 -0500
To: witango-talk@witango.com
Subject: Re: Witango-Talk: getting a new userreference
I wrote a test taf to see what purging the various scopes would do,
and the USERREFERENCE is unchanged. So to change it, I would need to
generate a new one to replace the cookie from the browser.
What I was looking for was a hook into the witango USERREFERENCE
generation scheme. Anyway, it's just a curiousity, I re-worked my
thinking.
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
On Mar 15, 2008, at 4:17 AM, Robert Garcia wrote:
I think the only way, is to CLEAR the userref cookie, and let
witango gen.
--
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 Mar 14, 2008, at 5:48 PM, William M Conlon wrote:
BUT ... userreference WAS received via cookie 'abc'
Bill
On Mar 14, 2008, at 5:46 PM, Ben Johansen wrote:
NO
in the manual
If no user reference number was received
(via the _userReference search argument or an HTTP cookie) when
the application file was called, a new number is generated;
otherwise, the
number passed in is returned.
so you clear the cookie and when you call a page without a
userreference arg it will gen a new one
On Mar 14, 2008, at 5:39 PM, William M Conlon wrote:
No, that would not be a NEW userreference, rather the same
userreference that was passed in by cookie.
Here's the flow;
userreference cookie 'abc' is passed to taf
@@user$id and @@user$somedata is known from user reference 'abc'
assign @@request$id == @@user$id
purge user scope variables
get new user refernence 'def'
assign user$id = @@request$id and user$somedata = user's new data
setcookie
Now on subsequent requests the cookie 'def' is used
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
On Mar 14, 2008, at 5:30 PM, Ben Johansen wrote:
that would be
@USERREFERENCE
@ASSIGN SCOPE=cookie NAME=Witango_UserReference
VALUE=@USERREFERENCE.
On Mar 14, 2008, at 5:22 PM, William M Conlon wrote:
I want to tear down a user's session (purging all their
variables) and give the user a new session with new user
variables and a new userreference.
I'll need to @ASSIGN SCOPE=cookie
NAME=Witango_UserReference VALUE=@@request$newUserReference.
How do I generate @@request$newUserReference on the server so
I can set the cookie?
I would like the new UserReference to be generated by the
server, rather than by my own home-grown approach, so it isn't
subject to replay cracking attempts. For example if I just
generated a hash from things I new about the user, someone
could conceivably work out the algorithm and generate their
own userreference to hijack a session (admittedly unlikely).
I don't want to know how the server generates a new
userReference -- I just want to get one.
thanks.
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
_
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
__
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
___
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
_
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
__
__
TO UNSUBSCRIBE: Go to
RE: Witango-Talk: Sigh. STILL having issues with XML not being returned (webservices)
I am by no means an expert here, and I am not sure what you are trying to do... but I have set up variuos rss feeds in xml and I have had to rewrite all the headers to the following before I could get it to work... @purgeresults@ASSIGN local$httpHeader VALUE=Content-Type:text/xml@CRLF@USERREFERENCECOOKIE@CRLF (no returns in the above) This may not even apply to you... just thought I would throw it out there. _ From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2008 5:20 AM To: Witango-Talk list Subject: Witango-Talk: Sigh. STILL having issues with XML not being returned (webservices) I have been using various tools (SOAPclient and HTTPtester) and here's what I am getting Request is OK, as follows User-Agent: Mac OS X; WebServicesCore.framework (1.0.0) Content-Type: text/xml Soapaction: http://localhost/nees.wws Host: localhost But **response** is in error, sending back Content-Type: text/html instead of text/xml HTTP/1.1 200 OK Connection: close Server: Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.7l DAV/2 Content-Type: text/html Date: Wed, 05 Mar 2008 11:15:54 GMT Set-Cookie: Witango_UserReference=F4E923AA5841685247CE80EA; path=/ Transfer-Encoding: Identity What I can't figure out is how to set up Witango (and/or Apache 2.2.6) to send back the RESPONSE to a .wws call as XML The WSDL file starts out with ?xml version=1.0 encoding=UTF-8 ? so I presumed that would be enough I tried to add content-type headers for the tcfs providing the data, but that corrupted the process I experimented with the mime.types but only succeeded in killing all webservices Any ideas or solutions? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Suggestion
I don't see what the big deal is about moderating. My forum has 6 moderators and we seem to do just fine. And trust me, I think the likelyhood of an errant post from a bunch of beer-swilling fishermen is much more likely then from Witango developers. As for the search engine stuff, I have been into SEO and web marketing for many years, as some of you know, and if there is any help I can do from that end, I would be more then happy to put in my 2 cents. It would be nice to get Witango a fighting chance against some of the big boys. If any of you would like examples of SEO and some of my sites, please email me off the list and I will send them to you. I have always said the proof is in the pudding. I think there are some definite advantages to be had by placing the ball in our court instead of relying on a single entitiy to provide the push. A lot of people have complained in the past, my self included, on the marketing and worth of this product. Well folks, maybe it's about time we put together our collective heads and do something about it. What better group to do this then the devlopers who actually use and know the worth of the product? It is much easier to sell something that you believe in then to sell a widget you know nothing about. Some of the past users just oozed with enthusiasm over the product, and that enthusiasm was evident in there posts. We need to capture that enthusiasm and reflect it into, hopefully, a growing community of users. Wouldn't it be nice to get excited about something again? WebDude -Original message- From: Robert Garcia [EMAIL PROTECTED] Date: Sat, 23 Feb 2008 00:07:01 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Suggestion It won't be a witango site. It would be a small community of developers. Witango, or whatever. Ben has volunteered to moderate, I would help, and I am sure there will be other volunteers. I am also going to put code in a subversion repository. For instance, I just wrote some very cool code, class based for dynamic content caching in witango. We still have one very big client where php is not scheduled until around the summer. -- 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 22, 2008, at 6:30 PM, Rick Sanders wrote: Hello Robert, I can remember actually doing this idea about 7 years ago. I had a complete WiTango site with a message board and a component zone. The idea was great in the beginning, then it fizzled away. You'd also have to get authorization from With Enterprises to do a site like this using the WiTango name. Otherwise it'll be an unauthorized WiTango site and discredited by With. Daniel Richardy in Germany had a similar setup, but all that went by the wayside when With canned the distributors. I feel that a message board should have been one of the first things that With did when they took over the product. Put it on a different domain, and it would also boost search engine ranking. The other problem is moderation. With would want to moderate your board, or someone approved by them would moderate it. Believe it or not, there would be certain things that you couldn't say about the product without With's consent. Personally, I don't think they had the resources available to moderate such a board, and the WiTango talk list is much easier to control, and there's no risk of bots and hacks. The board would have to be monitored constantly, and this alone would be a full time job. In all honesty, I think it's a little late to be putting up a board. Rick -Original Message- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: February-22-08 6:33 PM To: witango-talk@witango.com Subject: Witango-Talk: Suggestion I think this has been bought up before, but I will bring up again. Looking at Bill's request, made me want to suggest. Technically feature requests are supposed to go to the witango site, but I think we all feel like nothing happens to them, this isn't a b*tch session, so we will leave it at that. So we post here, and everyone reads them, and we hope by more responses witango may see and make more of a priority, but the nature of the list, they also end up in oblivion. There there was the other night, ben and I were building a cache system, and were looking at serverstatus memory values, and they don't seem right. We both remembered this being discussed on the list sometime ago, but who knows when, and the witango list search works most of the time, but not all, and cumbersome. This list has become a great and manageable (not to big) community of developers that help each other out, and I enjoy
Re: Witango-Talk: Suggestion
I would be willing to donate one of my apps. It isn't very complicated, but would work. I have one running with over 5000 users. It is located here... http://myfishingpals.com/Minnesota-Fishing-Forum.taf Just a thought... and it is 100% Witango ;-) John -Original message- From: William M Conlon [EMAIL PROTECTED] Date: Fri, 22 Feb 2008 15:47:51 -0600 To: witango-talk@witango.com Subject: Re: Witango-Talk: Suggestion Hi Robert, As you said, I am posting feature requests here mostly to make sure they are visible to the community. I like the idea of a semi-structured repository for bug reports, feature requests, code samples, etc., and appreciate your offer to host something. Bill On Feb 22, 2008, at 2:32 PM, Robert Garcia wrote: I think this has been bought up before, but I will bring up again. Looking at Bill's request, made me want to suggest. Technically feature requests are supposed to go to the witango site, but I think we all feel like nothing happens to them, this isn't a b*tch session, so we will leave it at that. So we post here, and everyone reads them, and we hope by more responses witango may see and make more of a priority, but the nature of the list, they also end up in oblivion. There there was the other night, ben and I were building a cache system, and were looking at serverstatus memory values, and they don't seem right. We both remembered this being discussed on the list sometime ago, but who knows when, and the witango list search works most of the time, but not all, and cumbersome. This list has become a great and manageable (not to big) community of developers that help each other out, and I enjoy it, as you all probably do too. There has been talk of building a more bulletin board like community, but who is going to write it, and is it going to be as good as something like VBulletin? I would be willing to donate a vbulletin license, and put it on my server farm. We could have sections, and stickys for important stuff. You can subscribe to a thread you want, ignore others, attache sample files, click NEW POSTS and just see new posts since your last visit, send private messages, the list is endless. VBulletin is my favorite, from using it with other communities. I would also like to have OFF TOPIC section, and sections for porting code to and from other technologies, like .net, php, and coldfusion. I don't have any problem NOT being the sole admin, and would be happy to let others do that. More neutral people like Scott would be a good choice. Let me know what you think, this mail list thing is not the best method. Just think, instant search, threads on important aspects of witango, code porting help to and from, stickys of stuff that get asked all the time. Let me know what you think. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
