Witango-Talk: Client connection error
I am using Win2K sp3 server with R:Tango 2000 Unbeknownst to me yesterday afternoon, all my witango apps started issuing "client connection error" when requested by a browser. Tonight I discovered this (as I was out of town) and restarted the witango server, no change. I just restarted the server, now when I request a witango app, it requests a user login. It does this on all my apps. I looked in the Tango logs in the log.Tango_2000_Server folder and I see there are no entries since yesterday afternoon. Nothing unusual in the server event logs. I was working on permissions on that drive, so that is probably how I messed it up. All my databases, InetPub, and RBTI folders are located on this drive. I have the Internet Guest Account assigned to the Databases and InetPub folders with Read & Execute, List Folder Contents, and Read permissions. The RBTI folder has Domain Admins and SYSTEM with full permissions. Sorry I have to bother the list for something I probably messed up. Anybody have any ideas? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Client Error
Hi, Can someone tell me what this error means? Client Error. configuration file is missing. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: Client Error
Steve, Thanks for the quick response. I use Win2K server sp3, R:Tango 2000. The file is there. Could it be related to permissions on this file or this folder? If so, do you know what the permissions should be? Thanks Steve -Original Message- From: Steve Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 11:37 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Client Error Chances are that your t4client.ini (Tango 2000) or clients.ini (Witango 5) configuration file is missing or that the listener ports are not set up the same in that file and the server configuration file which is t4server.ini (Tango 2000) or witango.ini (Witango 5). Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA:(416) 606-3885 Fax:(519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web:http://www.oakbridge.ca > -Original Message- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: March 4, 2003 12:12 PM > To: Witango User Group (E-mail) > Subject: Witango-Talk: Client Error > > > Hi, > > Can someone tell me what this error means? > > Client Error. > > configuration file is missing. > > Steve Fogelson > Internet Commerce Solutions > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Permissions - (OT)
Some of you may remember I had some permission issues the other day. Well I bit the bullet and called Microsoft. A tech there told me about a utility that I thought some of you may be interested in. This utility is called Filemon. If you run it on a server, it tells you of any file activity taking place. It also tells you if there are any problems when the access is taking place. IE: Access Denied It told us where we had the permission issues so we could correct them. If you think this may help you someday, you can download this utility from http://www.sysinternals.com Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: URL Problem
I have a URL as follows: &CatCount=-1&<@UserReferenceArgument>"><@var user$CatHistory>> If <@var user$CatHistory> has an & contained within it, I have problems. I added encoding="url" , but that doesn't fix it. Is there a way around this or do I just have to not allow & Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: URL Problem
After some further testing, it wasn't the &. It causes problems when there are commas (,) in the variable. The variable pulls from a table and can contain commas. Is there a way around this? Steve -Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 3:14 PM To: Witango User Group (E-mail) Subject: Witango-Talk: URL Problem I have a URL as follows: &CatCount=-1&<@UserReferenceArgument>"><@var user$CatHistory>> If <@var user$CatHistory> has an & contained within it, I have problems. I added encoding="url" , but that doesn't fix it. Is there a way around this or do I just have to not allow & Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: URL Problem
Thanks for the suggestion. Didn't work though. I may have to relook at my logic. I was trying to save additional searches. Steve [Fogelson, Steve] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, March 10, 2003 4:37 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: URL Problem What will happen if you single quote the argument ? '&CatCount=-1&<@UserReferenceArgument>"><@var user$CatHistory>> regards Daniel - Original Message - From: "Alexander Zatko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 10:36 PM Subject: RE: Witango-Talk: URL Problem > I am not sure, but URL encoding (,) the comma might help.> > > -Original Message-> > From: Fogelson, Steve [mailto:[EMAIL PROTECTED]> > Sent: Monday, March 10, 2003 4:39 PM> > To: '[EMAIL PROTECTED]'> > Subject: RE: Witango-Talk: URL Problem> > > > > > After some further testing, it wasn't the &. It causes > > problems when there> > are commas (,) in the variable. The variable pulls from a > > table and can> > contain commas. Is there a way around this?> > > > Steve> > > > -Original Message-> > From: Fogelson, Steve [mailto:[EMAIL PROTECTED]> > Sent: Monday, March 10, 2003 3:14 PM> > To: Witango User Group (E-mail)> > Subject: Witango-Talk: URL Problem> > > > > > I have a URL as follows:> > > > &CatCount=-1&<@UserReferenceArgument>"><@var> > user$CatHistory>>> > > > If <@var user$CatHistory> has an & contained within it, I > > have problems.> > > > I added encoding="url" , but that doesn't fix it.> > > > Is there a way around this or do I just have to not allow &> > > > Thanks> > > > Steve Fogelson> > Internet Commerce Solutions> > __> > __> > TO UNSUBSCRIBE: send a plain text/US ASCII email to > > [EMAIL PROTECTED]> > with unsubscribe witango-talk in the message body> > __> > __> > TO UNSUBSCRIBE: send a plain text/US ASCII email to > > [EMAIL PROTECTED]> > with unsubscribe witango-talk in the message body> > > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]> with unsubscribe witango-talk in the message body> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: SMTP server for outgoing email
I have seen a lot of discussion about writing email to the outgoing folder of your SMTP server vs. using Witango's mail action. I use MS Exchange 5.5 on Win2K sp3. Do you know if this strategy will work with Exchange as well? If so, should the email be written to the "Out" sub-folder of the "imcdata" folder under "exchsrvr" or would it be the "Pickup" folder? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: SMTP server for outgoing email
Perfect Scott. Just what I needed. Other good MS links in the article as well. Sounds like I can do it. Appreciate it. Steve -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:02 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: SMTP server for outgoing email Hi Steve, Checkout the following link (in German): http://www.msexchangefaq.de/code/pickup.htm The English translation is here: http://translate.google.com/translate?sourceid=navclient&hl=en&u=http%3A%2F% 2Fwww%2Emsexchangefaq%2Ede%2Fcode%2Fpickup%2Ehtm (Above URL will likely word-wrap) Here's an excerpt: "A special feature is a listing named "PICKUP", which both Exchange offers 5,5 and Exchange 2000. This listing belongs to the Smtp Connector and/or to the Windows of 200 smtp servers. If one gives this listing to writes freely, then a Mail can be dispatched simply by the placing of a file in a certain format. Completely without DLLs, TCP/IP knowledge or others program-cheat. In the simplest case in addition a quantity is enough to "ECHO" lines in a batch file. But from the outset." Run a test to make it works first, by saving a simple text file to the folder - and see what happens. The article shows a simple file example for testing. Hope this helps. Cheers.. Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xml-extra.net 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) ----- ----- Original Message - From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "Witango User Group (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 9:38 AM Subject: Witango-Talk: SMTP server for outgoing email > I have seen a lot of discussion about writing email to the outgoing folder > of your SMTP server vs. using Witango's mail action. > > I use MS Exchange 5.5 on Win2K sp3. Do you know if this strategy will work > with Exchange as well? > > If so, should the email be written to the "Out" sub-folder of the "imcdata" > folder under "exchsrvr" or would it be the "Pickup" folder? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Problems with search action
Win2K server IIS 5.0 (all patches applied) - R:Tango 2000 - R:Base 6.5 I have a taf that I generated with the Search Builder. I am having trouble with the search action that lists the products to select from. I indicated a "Number of Rows To Retrieve Limited to 20" I use the same taf on 2 different databases. It works fine on the first DB with the "Next" and "Previous" buttons showing when they should. On the second DB, it display the first set of links correctly with the "Next" button. When I select "Next", it displays the next set of links, but only the "Next" button. No "Previous" button. And it indicates "Displaying matches 1 through 20". It should be "Displaying matches 21 through 40" with a "Previous" button. When I select "Next" again, it redisplayed the second set of links. I have displayed the variables and button links involved. The first and subsequent "Next" button URL is as follows: /Admin/modifyproduct.taf?_function=list&_start=21&_UserReference=C5B4BCD21F8 76DA83E8503CA Notice _start=21. Any ideas what my problem might be? Maybe a DB problem? Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Input problem
I have a table user$DBTable with one column that is created in the List Function of a taf. This column contains many rows of Record IDs. List Function <@! "Reset Table"> <@assign user$DBTable value="@@resultSet"> <@! "Copy record IDs to new table" > <@assign user$DBTable value="<@array rows='<@numrows array=<@var user$DBTable>>' cols='1' value='<@var user$DBTable[*,1]>'>"> I have the following code to create a form to allow the user to input the number of the row they wish to view detail. I need somehow to translate that row number to a record id from table user$DBTable to be included as arg Categories_uid1. I am getting the row number not the record id transfered. Is there a way to do this or do I need different program logic? Detail Function <@assign local$DBRows value="<@numrows array=user$DBTable>"> <@for start="1" step="1" stop="<@var local$DBRows>"> <@assign local$CurrentRow "<@currow>"> <@if expr="<@var user$DBTable[<@currow>,1]> = <@column 'Categories.Cat_ID'>"> <@break> Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: Problems with search action
Thanks for the response Bill. Both databases are on the same server. Still no idea what is causing this. I could provide links or tafs if anyone is interested in looking at this. Thanks Steve -Original Message- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 10:47 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Problems with search action Steve, Are both databases on the same R:Tango server? If not, could one be a later patch/release of R:Tango, with a different file time/date on OT2K_DLL, The Oterro database engine? Somewhere along the way, Oterro was modified to enable it to work with the Witango next/previous builders. Bill On Sat, 29 Mar 2003 00:28:48 -0600, Fogelson, Steve wrote: >R:Tango 2000 - R:Base 6.5 > >I have a taf that I generated with the Search Builder. I am having trouble >with the search action that lists the products to select from. I indicated a >"Number of Rows To Retrieve Limited to 20" TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Possible Syntax Problem
The following statement is not executing. Can someone tell me why? Maybe the & or the = <@assign method$AddLink value="&<@var method$AddLinkName>=<@var method$AddLinkValue encoding=url>"> Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: <@choicelist>
Is there a way to limit the width of a <@choicelist> IE: This row is to long. I would like it to be on 2 lines This row is to long. I would like it to b e on 2 lines I tried inserting <@crlf>, , or into rows that are longer than desired in the array. Is this even possible? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: <@choicelist>
Thank you for all the great ideas. Steve -Original Message- From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:39 PM To: [EMAIL PROTECTED] Cc: Dale Graham Subject: Re: Witango-Talk: <@choicelist> Where I have options in a choice list that are going to be too long, I truncate some of the information using something like <@left str="<@var this[<@currow>,12]>" numchars="30"> which looks something like this in the select The title for this article is relatively lo does NOT work in a select (whether from Witango or any other html) On Tuesday, April 1, 2003, at 12:49 PM, Fogelson, Steve wrote: > Is there a way to limit the width of a <@choicelist> IE: > > This row is to long. I would like it to be on 2 lines > > This row is to long. I would like it to b > e on 2 lines > > I tried inserting <@crlf>, , or into rows that are longer > than > desired in the array. > > Is this even possible? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > ___ > _ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: JavaScript as a Variable
Is their a way to assign Javascript to a variable? IE: <@assign local$OtherHeader value=" "> The problem I see are all the special characters <, >, ", ', etc. Anyone do this and find a way around it? Thanks in advance Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: <@choicelist>
I'm having trouble with the following statement: <@CHOICELIST NAME="APM_ID" TYPE=SELECT OPTIONS="<@var local$SelectList[*,2]> - <@var local$SelectList[*,2]>" VALUES="<@var local$SelectList[*,1]>" SIZE="1" SELECTED=""> It only places <@var local$SelectList[*,2]> in the options instead of <@var local$SelectList[*,2]> - <@var local$SelectList[*,2]> I don't quit understand the documentation: The OPTIONS attribute specifies an array of option names to appear in the selection list or radio button group. The array may have either a single column (one option name in each row) or a single row (one option name in each column). Do I need to combine column 3 with column 2 and then just list column 2 before I do the <@choicelist>? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
RE: Witango-Talk: <@choicelist>
Thanks Ben Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: <@choicelist> The options will only take 1 array You will need to combine the values somehow prior to the SelectList var creation If you go to http://www.witango.ws helps and look at the @choicelist help it shows how you can combine values within select action Hope this helps :-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:58 AM To: Witango User Group (E-mail) Subject: Witango-Talk: <@choicelist> I'm having trouble with the following statement: <@CHOICELIST NAME="APM_ID" TYPE=SELECT OPTIONS="<@var local$SelectList[*,2]> - <@var local$SelectList[*,2]>" VALUES="<@var local$SelectList[*,1]>" SIZE="1" SELECTED=""> It only places <@var local$SelectList[*,2]> in the options instead of <@var local$SelectList[*,2]> - <@var local$SelectList[*,2]> I don't quit understand the documentation: The OPTIONS attribute specifies an array of option names to appear in the selection list or radio button group. The array may have either a single column (one option name in each row) or a single row (one option name in each column). Do I need to combine column 3 with column 2 and then just list column 2 before I do the <@choicelist>? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Witango-Talk: Upgrade
I presently use Win2K Server, R:Tango 2000, R:Base 6.5+ I am going to upgrade to Witango 5 and am looking for some advice. I anticipate that in the near future I will need more than one server or CPU to host my sites. Is it best to buy the professional version and run on a multi CPU server or buy multiple standard versions and run on individual servers? I would like to consider performance, cost, and redundancy. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk:
I presently use Win2K Server, R:Tango 2000, R:Base 6.5+ I am going to upgrade to Witango 5 and am looking for some advice. Considering that I have purchased R:Tango 2000, if I upgrade using the R:Tango route to version 5.0 of Witango 1) Is the Free 2 user Development Server License available to me? There is a possibility in the future that I might want to develop an application with a different database. I have some potential customers that are using databases other than R:Base and I would want to interface with their existing DB. As I understand it, I can presently only connect to R:Base. Should I and can I upgrade my current R:Tango license to Witango 5.0 instead? Am I wrong in assuming this is just a ODBC driver and licensing issue? What would this do for my Oterro upgrades? Any advice would be appreciated? Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: <@TOTALROWS>
Win2k server, R:Tango 2000, R:Base 6.5 Does <@TOTALROWS> work in a Direct DBMS action? Is so, how do I tell is to obtain this number? If not, is there any other way to obtain this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: including snippets of code
Ben, I have had that trouble in the past as well. You might want to check it out. I was going to buy a Witango update from you on the day before the price increases, but couldn't get through you email server. Have made the update since. Steve Fogelson -Original Message- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 3:13 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: including snippets of code Ben, I tried to send this post to you off the list, but your mail server doesn't seem to be accepting any thing from my mail server. Anyway, see my comments below about nested @includes. Ben Johansen wrote: >Off List, > >Now, I remember (coffee finally kicked in) > >The reason your sub-include of the TML works is because TML is one of >the extensions setup in the web server to tell the web server that >Witango is responsible to process this file. > > No, the @include tag doesn't interact at all with the web server. It also doesn't care about file extensions. When the app server comes across an @include, it doesn't care what file extension it is... it simply includes the file and evaluates any meta code it comes across. >In the case where an included HTML file calling a SUB-HTML file this is >not the case. The SUB would not have its metatags processed > > Yes they are... See the enclosed example... I just tested this out. test.taf does an @include of test1.html test1.html does an @include of test2.html test2.html does an @include of test3.html test3.html executes @currentdate. /John TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Class Files
Win2K sp3 server, R:Tango 2000, R:Base 6.5 I setup a class file with : Return Value as "Method Variable" Parameters: one variable in (StateID), two variables out (StateName, StateAbbrev) I understand that I have to reference the "in" variable with a "method" scope within the class file. I assume within the class file I assign the "out" variables with a scope of "method". How do I read the variables coming out of the class file within the calling taf file? Is there something I am missing with the Return Value setting of "Method Variable"? Sorry for this question, I read the manual and it didn't make sense to me. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Class Files
Ben, Thanks for the reply. I'm still having a little trouble. I setup the class file (SelectState) with : Return Value as "Method Variable", returnValue, Array Parameters: in (StateID), out (StateName, StateAbbrev) I have a search action that executes properly and then a html action with the following code: <@assign method$State_Name "<@var local$resultSet[1,State_Name]>"> <@assign method$State_Abbrev "<@var local$resultSet[1,State_Abbrev]>"> <@assign method$returnValue[1,1] "<@var method$State_Name>"> <@assign method$returnValue[1,2] "<@var method$State_Abbrev>"> I taking one step at a time to debug, so I call the object with the following: <@CALLMETHOD domain$Common "SelectState(<@var user$ArgBillToState>)" ENCODING=NONE> but I get the following error: [Search Action] [333] SearchState [Query] [333] SELECT S1.State_Name,S1.State_Abbrev FROM State S1 WHERE (S1.State_ID=1) [ActionResults] [350] Minnesota MN [Changed Vars] [366] method$returnValue[1,1]=Minnesota method$returnValue[1,2]=MN method$State_Abbrev=MN method$State_Name=Minnesota [Error] [366] -10 Invalid or empty variable name. [Error] [366] -800 An error occurred while preparing the parameters for this method invocation. [Error] [366] -806 An unspecified method call error occurred. SelectState [Error] [366] -801 An error occurred while invoking this method. SelectState Any ideas Thanks Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:08 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Class Files This got me for the longest time. the best way to think the "return variable" is it is defining the variable to use within the method. So within you method do a final assign to this variable -example- <@ASSIGN NAME="returnValue" VALUE="@@method$AttribValue[1,@@Method$Attribute]" SCOPE="method"> NOTE: change the type to match what your returning and when you call your method in the TAF do so within an -example- <@ASSIGN NAME="Protect" SCOPE="local" VALUE='<@CALLMETHOD OBJECT="OOobj" SCOPE="local" METHOD="GetStyle(@@local$StyVal,style:cell-protect)" METHODTYPE="invoke">'> Then just use the values in the newly assigned variable. Hope this helps ;-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 8:12 AM To: Witango User Group (E-mail) Subject: Witango-Talk: Class Files Win2K sp3 server, R:Tango 2000, R:Base 6.5 I setup a class file with : Return Value as "Method Variable" Parameters: one variable in (StateID), two variables out (StateName, StateAbbrev) I understand that I have to reference the "in" variable with a "method" scope within the class file. I assume within the class file I assign the "out" variables with a scope of "method". How do I read the variables coming out of the class file within the calling taf file? Is there something I am missing with the Return Value setting of "Method Variable"? Sorry for this question, I read the manual and it didn't make sense to me. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Class Files
Thanks for the help Ben. I got it to work with the following: CLASS Return Value as "Method Variable", returnValue, Array Parameters: "in", StateID, Any Search Action <@assign method$returnValue "@@resultSet>"> TAF <@assign local$ArgBillToState "<@callmethod domain$Common 'SelectState(<@var user$ArgBillToState>)' ENCODING=NONE>"> I couldn't specify any "out" parameters or else it would error out. I still don't get what "out" parameters are used for. Thanks Steve -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 2:18 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Class Files Ben, Thanks for the reply. I'm still having a little trouble. I setup the class file (SelectState) with : Return Value as "Method Variable", returnValue, Array Parameters: in (StateID), out (StateName, StateAbbrev) I have a search action that executes properly and then a html action with the following code: <@assign method$State_Name "<@var local$resultSet[1,State_Name]>"> <@assign method$State_Abbrev "<@var local$resultSet[1,State_Abbrev]>"> <@assign method$returnValue[1,1] "<@var method$State_Name>"> <@assign method$returnValue[1,2] "<@var method$State_Abbrev>"> I taking one step at a time to debug, so I call the object with the following: <@CALLMETHOD domain$Common "SelectState(<@var user$ArgBillToState>)" ENCODING=NONE> but I get the following error: [Search Action] [333] SearchState [Query] [333] SELECT S1.State_Name,S1.State_Abbrev FROM State S1 WHERE (S1.State_ID=1) [ActionResults] [350] Minnesota MN [Changed Vars] [366] method$returnValue[1,1]=Minnesota method$returnValue[1,2]=MN method$State_Abbrev=MN method$State_Name=Minnesota [Error] [366] -10 Invalid or empty variable name. [Error] [366] -800 An error occurred while preparing the parameters for this method invocation. [Error] [366] -806 An unspecified method call error occurred. SelectState [Error] [366] -801 An error occurred while invoking this method. SelectState Any ideas Thanks Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:08 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Class Files This got me for the longest time. the best way to think the "return variable" is it is defining the variable to use within the method. So within you method do a final assign to this variable -example- <@ASSIGN NAME="returnValue" VALUE="@@method$AttribValue[1,@@Method$Attribute]" SCOPE="method"> NOTE: change the type to match what your returning and when you call your method in the TAF do so within an -example- <@ASSIGN NAME="Protect" SCOPE="local" VALUE='<@CALLMETHOD OBJECT="OOobj" SCOPE="local" METHOD="GetStyle(@@local$StyVal,style:cell-protect)" METHODTYPE="invoke">'> Then just use the values in the newly assigned variable. Hope this helps ;-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 8:12 AM To: Witango User Group (E-mail) Subject: Witango-Talk: Class Files Win2K sp3 server, R:Tango 2000, R:Base 6.5 I setup a class file with : Return Value as "Method Variable" Parameters: one variable in (StateID), two variables out (StateName, StateAbbrev) I understand that I have to reference the "in" variable with a "method" scope within the class file. I assume within the class file I assign the "out" variables with a scope of "method". How do I read the variables coming out of the class file within the calling taf file? Is there something I am missing with the Return Value setting of "Method Variable"? Sorry for this question, I read the manual and it didn't make sense to me. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: MX Reverse Lookup - (OT)
Just a note from last weeks discussions about this. I did some further checking thanks to the link that I believe Ben provided and found another link http://www.dnsstuff.com/ On this site there is a tool called Reverse DNS Lookup that I used to test a few of my ip addresses. Anyway I received an error indicating no ptr record. I called my bandwidth provider and they discovered that they had not informed the Internic that I should be designated as "Authoritative" for my Class C of addresses. All reverse lookups on my class C were failing and terminating at their servers. They are now correcting this with the Internic and hopefully I should be up and running on my reverse lookup shortly. I don't know if this might be a problem that some of you are having, but I thought I would mention it just in case because of the large thread on this topic. Thanks to this group for all the help you have provided for me in the past. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk:
I have the following code to select a payment method. With each payment record is a field indicating whether to validate the credit card or not. The name of the field is CC_Validate in the array local$Payment. I was hoping to set form.ValidateCC.value equal to CC_Validate in the row selected in the <@choicelist> tag (indicated by xxx). Can't figure it out. It will save me a search action if I can get this to work. Thanks Steve Fogelson Internet Commerce Solutions <@choicelist name="PaymentMethod" type=select options="<@var local$Payment[*,CC_Name]>" values="<@var local$Payment[*,CC_ID]>" size="1" selected="<@var user$ArgPaymentMethod>"> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Array Problem - Resent without >
I have the following code to select a payment method. With each payment record is a field indicating whether to validate the credit card or not. The name of the field is CC_Validate in the array local$Payment. I was hoping to set form.ValidateCC.value equal to CC_Validate in the row selected in the <@choicelist> tag (indicated by xxx). Can't figure it out. It will save me a search action if I can get this to work. Thanks Steve Fogelson Internet Commerce Solutions <@choicelist name="PaymentMethod" type=select options="<@var local$Payment[*,CC_Name]>" values="<@var local$Payment[*,CC_ID]>" size="1" selected="<@var user$ArgPaymentMethod>"> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: test
Please ignore. I sent an email to the list and it did not show up. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Array Problem
> I have the following code to select a payment method. With each payment > record is a field indicating whether to validate the credit card or not. > The name of the field is CC_Validate in the array local$Payment. I was > hoping to set form.ValidateCC.value equal to CC_Validate in the row > selected in the <@choicelist> tag (indicated by > xxx). > > Can't figure it out. It will save me a search action if I can get this to > work. > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > > > > > > > > <@choicelist name="PaymentMethod" type=select options="<@var > local$Payment[*,CC_Name]>" values="<@var local$Payment[*,CC_ID]>" size="1" > selected="<@var user$ArgPaymentMethod>"> > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Zip code Validator
Hi, Looking for some simple US or Canada zip code validation. Either a snippet of code or a TCF. Could include any or all of the following: 1) Valid US 5 or 9 digit zip code 2) Valid Canada 6 digit code 3) Valid zip code for the selected state Also is anyone doing anything with address validation by using one of the services available in the US? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Zip code Validator
Thanks to everyone for the ideas. Steve Fogelson Internet Commerce Solutions -Original Message-From: Steve Smith [mailto:[EMAIL PROTECTED]Sent: Saturday, July 19, 2003 11:44 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Zip code Validator Canada Post (www.canadapost.ca) has a monthly subscription service available. I drilled down through the Business Products section to this page: http://www.canadapost.ca/business/offerings/address_management/can/other_data-e.asp where it provides more information. I think that Radio Shack is using this in their Point of Sale devices in their stores. Canadian Postal codes are 6 characters that are letter-number-letter space number-letter-number. The first three characters are the Forward Sorting Address which designates the general area of the address. The first character designates the Province or Territory and the second and third designate the location within a town or city. Ontario is the largest Province and has postal codes starting with either K, L, M, N, or P. Most Provinces have only one letter. So far I've only written routines that check to see that the data entered only contains letters and numbers, and that the length of the data is 6 characters. I use the <@KEEP> tag to strip out spaces and dashes that some people might enter. I suppose that it wouldn't be that difficult to add a routine to check for valid FSA's based on the user's selection for Province. Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca On Thursday, July 17, 2003, at 03:11 PM, Fogelson, Steve wrote: Hi, Looking for some simple US or Canada zip code validation. Either a snippet of code or a TCF. Could include any or all of the following: 1) Valid US 5 or 9 digit zip code 2) Valid Canada 6 digit code 3) Valid zip code for the selected state Also is anyone doing anything with address validation by using one of the services available in the US? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: SSL
Windows 2000 sp3 server, R:Tango 2000, Rbase 6.5 I have my SSL cert loaded and working properly. I have used the strategy of using domain variables AppRootUrl (exit to http) and SecureAppRootUrl (https) for moving back and forth. domain$AppRoot is http://<@CGIPARAM NAME=SERVER_NAME> domain$SecureAppRootUrl is https://<@CGIPARAM NAME=SERVER_NAME> I use the http redirect method in a class file: Location: <@VAR method$URL ENCODING=METAHTML><@CRLF><@SETCOOKIES><@USERREFERENCECOOKIE><@CRLF><@CRLF> In my logon taf everything works great on the redirect if I use a link similar to the following: here I also have a form command as follows that cycles back into the login taf upon submit: Appears to works good. But at the end of the code to search and find the shopper, I redirect back (to http) by passing the following to method$URL: <@var domain$AppRootUrl><@var domain$CGI><@var domain$RootPath><@ARG _target>?_action=<@ARG _action>&P_ID=<@ARG P_ID>&Quantity=<@ARG Quantity>&<@USERREFERENCEARGUMENT> I get the following message from the browser "You are about to be redirected to a connection that is not secure. The information you .." What do I have to change to get rid of this message? Thanks Steve Fogelson Internet Commerce Solutions PS: I am using some of the old store front app to build my shopping cart application TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: SSL
Steve, Thanks for the response. I don't think this is the message I am getting. I am getting a popup message. The title bar says "Security Alert". The message content says "You are about to be redirected to a connection that is not secure. The information you are sending to the current site might be retransmitted to a nonsecure site. Do you wish to continue?" Links work fine, but it seems like the redirects have a problem. Is there a different way I should do this? Thanks Steve Fogelson -Original Message-From: Steve Smith [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 5:48 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: SSL Look for a file called 403-4.htm which contains this message. Modify it to what you want it to say and save it in the same location. Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca On Wednesday, July 23, 2003, at 05:20 PM, Fogelson, Steve wrote: Windows 2000 sp3 server, R:Tango 2000, Rbase 6.5 I have my SSL cert loaded and working properly. I have used the strategy of using domain variables AppRootUrl (exit to http) and SecureAppRootUrl (https) for moving back and forth. domain$AppRoot is http://<@CGIPARAM NAME=SERVER_NAME> domain$SecureAppRootUrl is https://<@CGIPARAM NAME=SERVER_NAME> I use the http redirect method in a class file: Location: <@VAR method$URL ENCODING=METAHTML><@CRLF><@SETCOOKIES><@USERREFERENCECOOKIE><@CRLF><@CRLF> In my logon taf everything works great on the redirect if I use a link similar to the following: here I also have a form command as follows that cycles back into the login taf upon submit: Appears to works good. But at the end of the code to search and find the shopper, I redirect back (to http) by passing the following to method$URL: <@var domain$AppRootUrl><@var domain$CGI><@var domain$RootPath><@ARG _target>?_action=<@ARG _action>&P_ID=<@ARG P_ID>&Quantity=<@ARG Quantity>&<@USERREFERENCEARGUMENT> I get the following message from the browser "You are about to be redirected to a connection that is not secure. The information you .." What do I have to change to get rid of this message? Thanks Steve Fogelson Internet Commerce Solutions PS: I am using some of the old store front app to build my shopping cart application TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Another questions about SSL (Maybe OT)
I have a taf that collects credit card info. It is loaded as an https. Should the form link to a secure page? Does the current https setting transmit the data securely? The next process probably doesn't need to be secure. What about <@arg > and <@var >? Could a hacker pull the values? If so maybe the subsequent pages need to be secure until I issue a <@purge user> Thanks for the help. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Remote Buffer Overrun in Witango Application Server Patch for Tan go 2000 & R:Tango 2000go 2000 & R:Tango 2000
Is With Ent going to issue a patch for for the above? Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk:
I am having trouble with a DBMS When I put single quotes around <@currentdate>, the Where clause in my DBMS comes out with 2 singles quotes on either end of the <@currentdate>. If I remove the single quotes, I don't get any single quotes or double quotes. Both conditions give me an "Invalid TEXT error". <@assign local$Select "( (o1.C_ID=<@var domain$CompanyID>) and (o1.Ord_OrderNumber='<@currentdate format="%Y%m%d">') ) "> DBMS Where <@var local$Select> With single quotes, Gives (o1.Ord_OrderNumber=''20030809'') Without single quotes, Gives (o1.Ord_OrderNumber=20030809) Any suggestions? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Probably SQL ?
Win2K Server, R:Tango 2000, R:Base 6.5
I create a field in a table with the following witango code:
<@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs
<@currenttimestamp>>">
Later I want to do a search based strictly on the first 8 characters of the
field. I use the following code to set up the Where variable for DBMS
<@assign local$DateSelect "( (o1.Ord_OrderNumber >= '<@arg StartYear
encoding=sql><@arg StartMonth encoding=sql><@arg StartDay encoding=sql>')
AND ('<@arg EndYear encoding=sql><@arg EndMonth encoding=sql><@arg EndDay
encoding=sql>' <= o1.Ord_OrderNumber) )">
I then use the following in the DBMS:
Where
<@var local$Select encoding=none>
Some how I have to do something with o1.Ord_OrderNumber
Maybe I am going to have to create a field with just the date
Thanks
Steve Fogelson
Internet Commerce Solutions
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: RE: Witango-Talk:
Scott and Ben, Thanks for the advice. That was the problem. Steve -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Saturday, August 09, 2003 1:30 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: RE: Witango-Talk: Hi Steve, By default, Variables called inside a Direct DBMS Action have the ENCODING=SQL attribute applied, which turns a single-quote into two single-quotes (SQL escaping). There is more than one way to get around this, but the following is probably the simplest solution: Where <@var local$Select ENCODING=NONE> But of course, that also means if you are dynamically building your own SQL Statements, you should be careful to make sure you use SQL escaping. In the following example, I turned your date value into a string value for demonstration purposes: <@assign local$Select "( (o1.C_ID=<@var domain$CompanyID>) and (o1.Ord_OrderDesc='<@VAR local$Desc ENCODING=SQL>') ) "> The Variable local$Desc now has ENCODING=SQL because if the string had contained a single-quote as part of the text, and ENCODING=SQL was not used - it would have broken the SQL Statement. Of course, when the finished Variable is called in the Direct DBMS Action, again call it with ENCODING=NONE. Hope this helps. Cheers. Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xml-extra.net 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) - > -----Original Message- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 09, 2003 12:18 AM > To: Witango User Group (E-mail) > Subject: Witango-Talk: > > > I am having trouble with a DBMS > > When I put single quotes around <@currentdate>, the Where > clause in my DBMS > comes out with 2 singles quotes on either end of the > <@currentdate>. If I > remove the single quotes, I don't get any single quotes or > double quotes. > Both conditions give me an "Invalid TEXT error". > > <@assign local$Select "( (o1.C_ID=<@var domain$CompanyID>) and > (o1.Ord_OrderNumber='<@currentdate format="%Y%m%d">') ) "> > > DBMS > Where > <@var local$Select> > > With single quotes, Gives > (o1.Ord_OrderNumber=''20030809'') > > Without single quotes, Gives > (o1.Ord_OrderNumber=20030809) > > Any suggestions? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > __ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Probably SQL ?
I tried the following with the SGET function.
<@assign local$DateSelect "( (SGET(o1.Ord_OrderNumber,8,1) >= '<@arg
StartYear encoding=sql><@arg StartMonth encoding=sql><@arg StartDay
encoding=sql>') AND ('<@arg EndYear encoding=sql><@arg EndMonth
encoding=sql><@arg EndDay encoding=sql>' <= SGET(o1.Ord_OrderNumber,8,1))
)">
Got the following error:
Syntax is incorrect for the command TEXT
Any ideas?
Steve Fogelson
-Original Message-
From: Fogelson, Steve [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 09, 2003 10:57 AM
To: Witango User Group (E-mail)
Subject: Witango-Talk: Probably SQL ?
Win2K Server, R:Tango 2000, R:Base 6.5
I create a field in a table with the following witango code:
<@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs
<@currenttimestamp>>">
Later I want to do a search based strictly on the first 8 characters of the
field. I use the following code to set up the Where variable for DBMS
<@assign local$DateSelect "( (o1.Ord_OrderNumber >= '<@arg StartYear
encoding=sql><@arg StartMonth encoding=sql><@arg StartDay encoding=sql>')
AND ('<@arg EndYear encoding=sql><@arg EndMonth encoding=sql><@arg EndDay
encoding=sql>' <= o1.Ord_OrderNumber) )">
I then use the following in the DBMS:
Where
<@var local$Select encoding=none>
Some how I have to do something with o1.Ord_OrderNumber
Maybe I am going to have to create a field with just the date
Thanks
Steve Fogelson
Internet Commerce Solutions
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Probably SQL ?
Atrix and Ben,
Thanks for the reply. I got rid of the text error. It is working now.
But I will tell you what I am doing. In case you are interested. The SGET
function appears to be what will do this.
I have a field in my OrderSummary table called Ord_OrderNumber.
I assign a unique value to the field with the following:
<@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs
<@currenttimestamp>>">
This tag yields a 18 digit value.
Later on I want to print orders for today or within a range of dates.
I thought I should be able select rows from the table based on the first 8
characters of this field. I create a "Where" clause for the DBMS with the
following when looking for todays orders.
<@assign local$Select "( ((SGET(o1.Ord_OrderNumber,8,1))='<@currentdate
format="%Y%m%d" encoding=sql>') ) ">
Thanks for the help.
Steve
-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 09, 2003 10:00 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Probably SQL ?
Hey, Steve can you throw me a bone here :-)
I still don't see what you are trying to do :-P
R:Base has some function you can use to deal with datetime data type
(DEXTRACT(datetime))
Returns the date portion of a value that has a DATETIME data type.
In the following example, the value of vdextract is 06/12/93.
SET VAR vdextract = (DEXTRACT('06/12/93 12:15:30.123'))
(TEXTRACT(datetime))
Returns the time portion of DATETIME.
In the following example, the value of vtextract is 12:15:30.123.
SET VAR vtextract = (TEXTRACT('08/09/95 12:15:30.123'))
select * from table where (DEXTRACT(DateTimeColumn)) = 'MM/DD/YY'
---
also in my experience with R:Tango you need to treat dates like text and
quote them.
Ben Johansen - http://www.pcforge.com
-Authorized WiTango Reseller
http://www.pcforge.com/WitangoGoodies.htm
-Authorized Alt-N Reseller
http://www.pcforge.com/AltN.htm
-Original Message-
From: Fogelson, Steve [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 09, 2003 7:44 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Witango-Talk: Probably SQL ?
I tried the following with the SGET function.
<@assign local$DateSelect "( (SGET(o1.Ord_OrderNumber,8,1) >= '<@arg
StartYear encoding=sql><@arg StartMonth encoding=sql><@arg StartDay
encoding=sql>') AND ('<@arg EndYear encoding=sql><@arg EndMonth
encoding=sql><@arg EndDay encoding=sql>' <= SGET(o1.Ord_OrderNumber,8,1))
)">
Got the following error:
Syntax is incorrect for the command TEXT
Any ideas?
Steve Fogelson
-Original Message-
From: Fogelson, Steve [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 09, 2003 10:57 AM
To: Witango User Group (E-mail)
Subject: Witango-Talk: Probably SQL ?
Win2K Server, R:Tango 2000, R:Base 6.5
I create a field in a table with the following witango code:
<@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs
<@currenttimestamp>>">
Later I want to do a search based strictly on the first 8 characters of the
field. I use the following code to set up the Where variable for DBMS
<@assign local$DateSelect "( (o1.Ord_OrderNumber >= '<@arg StartYear
encoding=sql><@arg StartMonth encoding=sql><@arg StartDay encoding=sql>')
AND ('<@arg EndYear encoding=sql><@arg EndMonth encoding=sql><@arg EndDay
encoding=sql>' <= o1.Ord_OrderNumber) )">
I then use the following in the DBMS:
Where
<@var local$Select encoding=none>
Some how I have to do something with o1.Ord_OrderNumber
Maybe I am going to have to create a field with just the date
Thanks
Steve Fogelson
Internet Commerce Solutions
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Literal question
I know this probably simple. But I must be brain dead from the weekend. I have the following statement: <@assign local$header "Todays Orders"> I want to add an apostrophy in today's, but it errs out. <@literal> doesn't seem to work. Should I use <@CHAR CODE=39> or is there a better way to do this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Literal question
Perfect. Thanks guys. Steve -Original Message- From: Eric Pridham [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 2:08 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Literal question There is a tag <@SQ> (for Single Quote). - Eric On Monday, August 18, 2003, at 03:02 PM, Fogelson, Steve wrote: > I know this probably simple. But I must be brain dead from the weekend. > > I have the following statement: > <@assign local$header "Todays Orders"> > I want to add an apostrophy in today's, but it errs out. > > <@literal> doesn't seem to work. > > Should I use <@CHAR CODE=39> or is there a better way to do this? > Thanks > Steve Fogelson > Internet Commerce Solutions > > ___ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Wow Pages, Inc. http://www.wowpages.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Domain Variables
Win2K sp3 server, R:Tango 2000, R:Base 6.5 I'll try to explain this as best I can. I am having trouble with my domain variables. When I restart Witango services or it restarts itself, my domain variables are reset to old values, not the current ones. The current values are stored in a database table. Are domain variables stored in a cache that reloads if the service restarts? This is how my application works. FYI: I have patterned it after James Carroll's Storefront. Every time a visitor hits the home page, Default.taf, it checks to see if the Object Instance Variable <@VAR domain$Common> for catalog.tcf is empty. If it is, it calls catalog.tcf. The On_Create method calls the method within itself called InitializeSystemVariables. This method checks a domain variable <@VAR Domain$Initialized> to see if it is empty. If it is empty, it reads the database table and resets the variables. I can manually reset the variables with a method in catalog.tcf called ReloadSystemVariables which reads a database table of these variables and sets them up as domain variables. When I run that method, the domain variables are reset to the current variables in the table. I assume when the service restarts, that is clears all domain variables. In particular Domain$Initialized, so when the first visitor hits Default.taf, the application would reset the variables from the current values in the table. Any help would be appreciated. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Domain Variables
Title: RE: Witango-Talk: Domain Variables John, Does this setting affect domain and application variables only? Or does it affect user variables as well? IE: Does Witango's dump file restore user and local variables as well? Also where is this setting stored? Thanks Steve -Original Message-From: John Hotaling [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 19, 2003 12:01 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Domain Variables Steve: If you have the configuration variable persistent restart set to on, then Witango will read the domain vars from the dump file upon restart. If the server goes down "improperly" the dump file is not recorded with the latest domain vars. Therefore, when you restart Witango, it reads the old domain vars instead of the current ones that were never recorded. We have had this problem for a long time and decided to turn off persistent restart and let the "restore" logic take over. That way Witango does not try to read a "bad" set of variables from the dump file and instead gets them from your db. Hope I understood your problem correctly. John ** John Hotaling http://www.AuctionAnything.com *** -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 19, 2003 12:52 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Domain Variables Win2K sp3 server, R:Tango 2000, R:Base 6.5 I'll try to explain this as best I can. I am having trouble with my domain variables. When I restart Witango services or it restarts itself, my domain variables are reset to old values, not the current ones. The current values are stored in a database table. Are domain variables stored in a cache that reloads if the service restarts? This is how my application works. FYI: I have patterned it after James Carroll's Storefront. Every time a visitor hits the home page, Default.taf, it checks to see if the Object Instance Variable <@VAR domain$Common> for catalog.tcf is empty. If it is, it calls catalog.tcf. The On_Create method calls the method within itself called InitializeSystemVariables. This method checks a domain variable <@VAR Domain$Initialized> to see if it is empty. If it is empty, it reads the database table and resets the variables. I can manually reset the variables with a method in catalog.tcf called ReloadSystemVariables which reads a database table of these variables and sets them up as domain variables. When I run that method, the domain variables are reset to the current variables in the table. I assume when the service restarts, that is clears all domain variables. In particular Domain$Initialized, so when the first visitor hits Default.taf, the application would reset the variables from the current values in the table. Any help would be appreciated. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Domain Variables
Interesting. That might be a better approach. A user could be viewing pages other than default.taf. I haven't used or heard of StartupURL. Can you point me to documentation about this. Can this be domain specific? This still may have the problems that John Hotaling talks about. Maybe I should automatically read the database and not check a SystemInitialized variable and use your method? Steve -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 12:06 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Domain Variables I haven't used domain variables yet, but this looks like it could be an interesting thread. You mention that on running default.taf for the first time, it checks whether domain$common is empty. What if the service restarts while a user session is in process. Would a user request still trigger this check? What about setting StartupURL to InitializeSystemVariables, and not depending on user state? >Win2K sp3 server, R:Tango 2000, R:Base 6.5 > >I'll try to explain this as best I can. I am having trouble with my domain >variables. When I restart Witango services or it restarts itself, my domain >variables are reset to old values, not the current ones. The current values >are stored in a database table. Are domain variables stored in a cache that >reloads if the service restarts? > >This is how my application works. FYI: I have patterned it after James >Carroll's Storefront. > >Every time a visitor hits the home page, Default.taf, it checks to see if >the Object Instance Variable <@VAR domain$Common> for catalog.tcf is empty. >If it is, it calls catalog.tcf. The On_Create method calls the method within >itself called InitializeSystemVariables. This method checks a domain >variable <@VAR Domain$Initialized> to see if it is empty. If it is empty, it >reads the database table and resets the variables. > >I can manually reset the variables with a method in catalog.tcf called >ReloadSystemVariables which reads a database table of these variables and >sets them up as domain variables. When I run that method, the domain >variables are reset to the current variables in the table. > >I assume when the service restarts, that is clears all domain variables. In >particular Domain$Initialized, so when the first visitor hits Default.taf, >the application would reset the variables from the current values in the >table. > >Any help would be appreciated. > >Steve Fogelson >Internet Commerce Solutions > >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 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/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: In-place Update
R:Tango 2000 R:Base 6.5 Win2K pro server Never did this before. I have a column called I_Quantity in an Inventory table. It contains quantity on hand for a product. Is it possible to use an Update action to update this column by subtracting quantity_purchased from I_Quantity with a <@calc> statement? IE: Column to update: I_Quantity Value: <@calc "Inventory.I_Quantity - quantity_purchased"> Or do I need to read the column first with a Search action. Set a variable equal to the "current quantity". Then use an Update action to the new quantity. If the first method is ok, is my reference to Inventory.I_Quantity ok or do I use a <@column Inventory.I_Quantity)? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: In-place Update
Bill, Unfortunately I cannot make it to the Corroboree this year. Hopefully With Ent will consider a Midwest location like Minneapolis/St Paul next year. Your (I_Quantity - <@VAR quantity_purchased>) suggestion did work. Thanks for the help. Steve -Original Message- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: In-place Update Steve, Are you coming to the Corroboree? I'll show an example like this in my presentation. You can do it within an <@CALC> inside the new value field, or you can do it without <@CALC>, using an expression understood by your database system. In this case, in the "Update them with these values" dialog, under Value, put something like: (I_Quantity - <@VAR quantity_purchased>) And under "Column" put I_Quantity Be sure you don't "quote value". Bill On Tue, 9 Sep 2003 15:00:29 -0500, Fogelson, Steve wrote: >Never did this before. I have a column called I_Quantity in an Inventory >table. It contains quantity on hand for a product. Is it possible to use an >Update action to update this column by subtracting quantity_purchased from >I_Quantity with a <@calc> statement? TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Purge user variable on window closing
I use a popup window in an application. The popup window is a taf that creates user variables. I need to use user variables in the popup as it creates a few large arrays and the taf branches back to itself, so I only want to create the arrays once. Is there a way to purge specific user variables when a popup window is closed? FYI: the parent window would still be open, but may be a different taf than the original one that opened the popup. So I believe the popup would need to purge the user variables when it is closed. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Purge user variable on window closing
Ben, I use MS IE 6. On my machine it doesn't work. The variable @@user$TheUserVar still show Hello World pm the second "Call View". It seems like your logic should work though. Is it possible that the javascript window.close(); executes before can do it's work? Thanks Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:48 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Purge user variable on window closing Ok Place these files in the root 1. Run the TestPurge.taf 2. click on the "Call View" (will show the user var value) 3. click on the "Call popup" (will show the user var value in popup) 4. click close or press window X in popup window 5. click on the "Call View" (will show the user var empty this time) Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:01 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Purge user variable on window closing I use a popup window in an application. The popup window is a taf that creates user variables. I need to use user variables in the popup as it creates a few large arrays and the taf branches back to itself, so I only want to create the arrays once. Is there a way to purge specific user variables when a popup window is closed? FYI: the parent window would still be open, but may be a different taf than the original one that opened the popup. So I believe the popup would need to purge the user variables when it is closed. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Security idea
Win2K server, R:Tango 2000, R:Base 6.5 I came up with an idea to hopefully secure personal information better than I have now and I am looking for comments about it. I know a lot of you refuse to store credit card info, but I need to for some applications. This could also apply to storing other personal info like social security number, drivers license, medical records, etc. Presently I have an order table in my database that stores credit card numbers. In this table I have a field called order number that is based on the following code: <@ASSIGN user$OrderNumber "<@currentdate format=datetime:%Y%m%d><@tstosecs <@currenttimestamp>>"> What I am thinking about doing is pulling the credit card number, month, and year out of the order table and creating a totally separate database with one table with five fields, ID, CC number, CC month, CC year. The fifth field would be based on the following: <@CIPHER ACTION=hash STR=<@var user$OrderNumber> ENCODING=none> When retrieving orders the appropriate credit card info would be found by this fifth field. I have never done it, but I believe that you can access 2 databases at the same time with one .taf or .tml My strategy is that if someone hacked into my server and found the catalog DB with the order table, they may assume I don't store CC info. If they happened to find the CC database, it would be very difficult for them to correlate the proper name and address to the correct credit card info. Could a credit card number be used without the proper name and address? The final level of security would be to encrypt each field of the CC database with Witango 5 or have Windows 2000 or 2003 encrypt the entire CC DB files. Would this work? Thanks for your comments Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Windows 2003 Server
It appears Witango 5 will work on the Windows 2003 server. Anyone know if it will work on Windows 2003 Web Edition server? If it does, would there be any draw backs? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: 404.taf
Windows 2K server. R:Tango 2000, R:Base 6.5 I am trying to set up a taf to be referenced when IIS 5.0 cannot find a page. I first tested by revising "HTTP Error" 404 under "Custom Errors" of the Internet Information Services manager with 404.html. Worked fine. I located the taf under the root of the site and executed it at http://www.reedssports.askics.net/404.taf Works fine. I then changed "HTTP Error" 404 to point at the taf. I tried http://www.reedssports.askics.net/4.html (file doesn't exist) and I get the following: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. The system cannot locate the object specified. Error processing resource 'http://www.reedssports.askics.net/tango.dtd'. I have attached the very simple taf. Any ideas? Thanks in advance Steve Fogelson Internet Commerce Solutions <<404.taf>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf 404.taf Description: Binary data
RE: Witango-Talk: 404.taf
Scott, That did it. I was using the File option instead of URL. Thanks Steve -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: 404.taf Hi Steve, It sounds like IIS output the TAF file without passing it through the Witango Plugin, so the raw XML of the TAF was sent and not parsed. What you're trying to do does work. Attached is a screen shot of how I configured IIS to do this. "Message-Type" should be "URL" and then provide a relative address to the TAF. In my case I have a "/" preceeding the TAF file name because the custom 404 is on a sub- directory and the TAF is on the root. You may need to play with your settings to include or exclude the slash depending on where you're doing yours. Hope this helps. Cheers.. Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) ----- -----Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "Witango User Group (E-mail)" <[EMAIL PROTECTED]> Date: Wed, 15 Oct 2003 11:31:59 -0500 Subject: Witango-Talk: 404.taf > Windows 2K server. R:Tango 2000, R:Base 6.5 > > I am trying to set up a taf to be referenced when IIS 5.0 cannot find a > page. I first tested by revising "HTTP Error" 404 under "Custom Errors" > of > the Internet Information Services manager with 404.html. Worked fine. > > I located the taf under the root of the site and executed it at > http://www.reedssports.askics.net/404.taf Works fine. > > I then changed "HTTP Error" 404 to point at the taf. I tried > http://www.reedssports.askics.net/4.html (file doesn't exist) and I get > the > following: > > The XML page cannot be displayed > Cannot view XML input using style sheet. Please correct the error and > then > click the Refresh button, or try again > later. > > The system cannot locate the object specified. Error processing > resource > 'http://www.reedssports.askics.net/tango.dtd'. > I have attached the very simple taf. > > Any ideas? > > Thanks in advance > > Steve Fogelson > Internet Commerce Solutions <<404.taf>> > > ___ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: database on another server
Hi, Does splitting the db to another server save resources on the Witango server? I would assume it saves disk reads, but would it save cpu usage? For example , if the search action has "ordered by" columns or a join? I don't know anything about ODBC. Not sure if the DB engine is part of OBDC. Is there a way to locate the DB Engine on the second server to move that processing to the 2nd server? What is the tradeoff of having to transmit the results back to the web and Witango server assuming over the network? Sorry for the questions, but I have always wondered what are the benefits and drawbacks of moving the db to another server and is there a better way to do it. Thanks Steve Fogelson Internet Commerce Solutions -Original Message-From: Jan Magnusson [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 29, 2003 5:07 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: database on another server Hi Alan, Maybe I misunderstood the question, but if you are going to have WiTango on one server and the db on another then just (re)configure the ODBC System DSN drivers on the WiTango server to point to the distant db server. The Witango service doesn't know where the database physically resides, just which ODBC connection to use. And if you use the exact same name, uid and pwd for the new odbc connection you should not even have to touch the Witango server, service or taf files. Things get a lot more complicated if you don't use the same name, then all the tafs need to be edited/updated. I don't know if there are some r:tango specific additional complicating matters, but this should work if it's now configured on an ODBC connection. Jan -Original Message-From: Alan Wolfe [mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003 00:32To: [EMAIL PROTECTED]Subject: Witango-Talk: database on another server how would you go about setting up a datasource that was on another server from where the datasource was being used by a .taf? i have no idea where to even begin looking for information on this one! (: we're using r:tango 5 on windows 2003 and the database is going to be on an NT 4 machine which has r:tango 2000 on it (so both sides have oterro if that matters). We're trying to set up an experiment to see how realistic it would be to have a database on another computer across the internet (im guessing not very realistic but maybe for limited usage it would work?) Thanks! Alan TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Mod Rewrite - (Maybe OT)
I was just talking to a Search Engine Key Phrase Placement Company I contract with. He threw a term at me that I am unfamiliar with "Mod Rewrite". He further explained that this shortened the URL (removed the ?), maybe the session id. This strategy is supposed to gain better search engine placement. Any thoughts or information on how you do this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Multiple DB vs. Site ID
I have a question about either method. Would it be possible to login under on site. Manually change the siteid in the url and then be surfing another site (logged in)? If so, are there any security issues with this? What would happen to the session id? Thanks Steve Fogelson Internet Commerce Solutions -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 3:19 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Multiple DB vs. Site ID One database with a site_id is best for a hosting environment, each db connection requires overhead. However, I would suggest that you do both, as this would gain your portability as well. Robert -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 3:45 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Multiple DB vs. Site ID I am in the process of rebuilding an application so it can be resold to customers. In some cases customers will elect to have me manage the hosting which I will be contracting out. I could build one database and manage the data with one set of taf files and then pull data based on the site ID ( I expect this all to be relatively low volume sites with periodic burst of users but averaging 1000 to 5,000 members per customer. Or would it make more sense to create a new database for each customer and build the taf files so they were dynamic in terms of what database they hit and what look and feel they loaded. Seems like the later is best to me. I'm wondering what the list thinks. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Application Log Error
R:Tango 2000, Win2K Server I am getting this error in my Windows application log once in a while. Any ideas what it is? Source: Tango_2000_Server Category: Runtime Event ID: 10 [1492] Fatal error at 02f831e2: Write EXCEPTION_ACCESS_VIOLATION at 047b4874 or [2272] Fatal error at 77fc918e: Write EXCEPTION_ACCESS_VIOLATION at 038e3ff8 Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Source Code Presentation
This might seem a little trivial, but I wanted to see if there was something I could do to make generated source code more presentable. In the Dev Studio, there is an "preference" option. Under the "Text" tab, there is a "Tab Size". I have this set to 2. This places 2 spaces per tab when displaying code for "results" actions in the dev studio. When html code is actually generated and sent to the browser, it places tabs instead of spaces. IE: 2 tabs instead of 2 spaces. Any way to change this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Source Code Presentation
Title: Witango-Talk: Source Code Presentation Buddy, Thanks for the response. I'm sorry. I didn't explain very well. In the dev studio, if you go to Edit, Preferences and then select the Text tab. You will see a "Tab Size" option. I have this set to 2. When you are editing a Results action and use the tab key to indent code for easier read ability, the number of spaces you specified in the "Tab Size" option are the number of spaces the tab key will indent. But when someone executes this taf with a browser, the generated html (viewable as source) uses tabs instead of spaces when displaying the code. Hope I explained it better. Thanks Steve -Original Message-From: Walker, Buddy [mailto:[EMAIL PROTECTED]Sent: Sunday, November 23, 2003 5:49 PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Source Code Presentation Steve Forgot to put the & in front of the nbsp. = 2 spaces Buddy -Original Message- From: Walker, Buddy Sent: Sun 11/23/2003 6:45 PM To: [EMAIL PROTECTED] Cc: Subject: RE: Witango-Talk: Source Code Presentation Steve Have you tried using nbsp instead of using the space bar or tab keys. If you want 2 spaces the use nbsp;nbsp Buddy -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Sun 11/23/2003 5:00 PM To: Witango User Group (E-mail) Cc: Subject: Witango-Talk: Source Code Presentation This might seem a little trivial, but I wanted to see if there was somethingI could do to make generated source code more presentable.In the Dev Studio, there is an "preference" option. Under the "Text" tab,there is a "Tab Size". I have this set to 2. This places 2 spaces per tabwhen displaying code for "results" actions in the dev studio.When html code is actually generated and sent to the browser, it places tabsinstead of spaces. IE: 2 tabs instead of 2 spaces.Any way to change this?ThanksSteve FogelsonInternet Commerce SolutionsTO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Client Error
R:Tango 2000 - R:Base 6.5 Win2K Server IIS 5.0 Is Client Error. The server refused connection. a Witango error or IIS? I started getting this quite often over the weekend. If I select refresh from the browser, it displays as normal. What are some of the most common causes of this error? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Source Code Presentation
HTML -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:20 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation What source are you trying to display; Witango or HTML? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Sunday, November 23, 2003 2:00 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Source Code Presentation This might seem a little trivial, but I wanted to see if there was something I could do to make generated source code more presentable. In the Dev Studio, there is an "preference" option. Under the "Text" tab, there is a "Tab Size". I have this set to 2. This places 2 spaces per tab when displaying code for "results" actions in the dev studio. When html code is actually generated and sent to the browser, it places tabs instead of spaces. IE: 2 tabs instead of 2 spaces. Any way to change this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Source Code Presentation
Ben, Here is code from an include in a taf as displayed in the browser generate source code: Notice 2 space indentation for each level Here is code from later on in the same browser generate source code only this is from a results action in the same taf: Notice leading tabs versus leading spaces. Maybe I am misunderstanding the way the preferences work in the dev studio. Maybe when you hit tab that is what you get, but it only display the number of spaces that you indicate in the preferences. Maybe I should quit using the tab when aligning code in the dev studio and use spaces instead. Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:52 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation Do you have an example snippet of the output where is shows 2 tabs? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:45 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Source Code Presentation HTML -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:20 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation What source are you trying to display; Witango or HTML? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Sunday, November 23, 2003 2:00 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Source Code Presentation This might seem a little trivial, but I wanted to see if there was something I could do to make generated source code more presentable. In the Dev Studio, there is an "preference" option. Under the "Text" tab, there is a "Tab Size". I have this set to 2. This places 2 spaces per tab when displaying code for "results" actions in the dev studio. When html code is actually generated and sent to the browser, it places tabs instead of spaces. IE: 2 tabs instead of 2 spaces. Any way to change this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Source Code Presentation
Thanks for the response Ben. Sounds like I should quit using the tab and just uses spaces. The generated source gets pretty wild with all the tabs. Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:43 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation Hi, According to the doc Tab Size. Type the number of characters you want to equal one tab character. The default is "3" So apparently the tab character is stored in the html and that this setting tell dev. Studio how many spaces to use per tab. The tab set is going to be different based on client. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:13 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Source Code Presentation Ben, Here is code from an include in a taf as displayed in the browser generate source code: Notice 2 space indentation for each level Here is code from later on in the same browser generate source code only this is from a results action in the same taf: Notice leading tabs versus leading spaces. Maybe I am misunderstanding the way the preferences work in the dev studio. Maybe when you hit tab that is what you get, but it only display the number of spaces that you indicate in the preferences. Maybe I should quit using the tab when aligning code in the dev studio and use spaces instead. Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:52 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation Do you have an example snippet of the output where is shows 2 tabs? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:45 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Source Code Presentation HTML -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:20 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Source Code Presentation What source are you trying to display; Witango or HTML? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- I am going behind bars for the MDA; come to my site for details on how to bail me out http://www.pcforge.com/MDALockup.htm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Sunday, November 23, 2003 2:00 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Source Code Presentation This might seem a little trivial, but I wanted to see if there was something I could do to make generated source code more presentable. In the Dev Studio, there is an "preference" option. Under the "Text" tab, there is a "Tab Size". I have this set to 2. This places 2 spaces per tab when displaying code for "results" actions in the dev studio. When html code is actually generated and sent to the browser, it places tabs instead of spaces. IE: 2 tabs instead of 2 spaces. Any way to change this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk:
I had help this last week with page optimization. One of the concepts was to
move all javascript to a separate file and link the script with the
following statement:
Abbreviated contents of JavaScript.js are as follows:
function newApp(MasterID) {
popupWindow = window.open("<@var domain$CGI><@var
domain$RootPath>searchapc.taf?Master_ID=" + MasterID +
"&<@userreferenceargument>", "newWin", "toolbar=yes, scrollbars=yes,
resizable=yes, menubar=yes, status=yes, directories=yes, location=yes,
width=700, height=500, screenX=0, screenY=0")
}
The script is called via a field (Cat_Description) in a table with the
following contents:
For help in choosing the proper Drive Belt, select
The field is displayed in a taf with the following tag:
<@var method$CurrentCategory[1,Cat_Description] encoding=metahtml>
Now the resulting url is
http://www.upnorthsports.com/<@var%20domain$CGI><@var%20domain$RootPath>sear
chapc.taf?Master_ID=3&<@userreferenceargument>
This worked fine prior to removing the script to a separate file and the
script was:
http://www.upnorthsports.com/searchapc.taf?Master_ID=1&_UserReference=2299BE
383C675C823FC2A483
I tried add encoding to the var tags in the script file and the url came out
as follows:
http://www.upnorthsports.com/<@var%20domain$CGI%20encoding=metahtml><@var%20
domain$RootPath%20encoding=metahtml>searchapc.taf?Master_ID=3&<@userreferenc
eargument>
Didn't help. Any ideas or do I need to move the script back to the original
file?
Thanks
Steve Fogelson
Internet Commerce Solutions
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Custom Variables
W2K Server, R:Tango 2000, R:Base 6.5 Is there anyway to reference or assign custom scoped variables in "actions" within the dev studio. IE: If or Assign actions. If not, must have to be done in Results action. Also if not, is this different in Dev Studio 5.0? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Computer Name
W2K, R:Tango 2000, R:Base 6.5 Is there any way in Witango to reference the "Computer Name" of the server you are accessing? I am trying to plan ahead for a startup.taf for startupUrl in a load splitting situation. Or maybe I am barking up a tree. If you have 2 or more servers and you want to do load splitting, do you always setup all you Witango application on all the servers? Or can you setup up some applications to run on all servers and some on just one of the servers? If the answer is yes to the last question, I was thinking the startup.taf could be the same on all servers, but it would reference the computer name from each server when setting up custom scoped variables for all the sites. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Many Domains - One set of taf's
W2K Server, R:Tango 2000, R:Base 6.5 Working on rewriting one of my app's to this concept. Is there any way to access taf's located outside the root directory of a site? It seems all the applicable tags are relative to the root. I realize I need to assign a user site id based on <@CGIPARAM NAME=SERVER_NAME> for selecting site variables, db, etc. I assumed I would still have a separate root folder for each site, but I can't figure out how to access taf's outside the root. Or is the way to do this is have all the sites (domains) point to the same root folder and not have unique roots folders for each site. Thanks for the advise. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
RE: Witango-Talk: Many Domains - One set of taf's
Bill, thanks for the response. I use Windows 2000 Server with IIS 5.0. I am not aware of anything similar to or directives. Still don't know if I should have all sites point to the same root directory or if there is a way to execute tafs outside the root directory. If they all point to the same root, as you stated I can have another site variable that points to HTML, txt, scripts, CSS, images. I guess we are leaning that direction. Thanks Steve -Original Message- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 3:20 PM To: Witango-Talk Subject: Re: Witango-Talk: Many Domains - One set of taf's Yes, I use one set of tafs for multiple sites. You need to just make sure the site key is available. I set a user variable to identify the site. Regarding include files (HTML, txt, scripts, CSS, images) you can store them in the file system if you don't want to use the db, and then have another user variable that points to the absolute path of these files. For tafs that are invoked external (by the browser) you can also use apache or directives in httpd.conf. >W2K Server, R:Tango 2000, R:Base 6.5 > >Working on rewriting one of my app's to this concept. > >Is there any way to access taf's located outside the root directory of a >site? It seems all the applicable tags are relative to the root. > >I realize I need to assign a user site id based on <@CGIPARAM >NAME=SERVER_NAME> for selecting site variables, db, etc. I assumed I would >still have a separate root folder for each site, but I can't figure out how >to access taf's outside the root. > >Or is the way to do this is have all the sites (domains) point to the same >root folder and not have unique roots folders for each site. > >Thanks for the advise. > >Steve Fogelson >Internet Commerce Solutions > >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 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/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
Witango-Talk: Version 5 Install
MS 2003 Web Edition, R:Tango 5 I read through the archives and found some info stating that you need to "Add a new Web service extension" in order to get Witango 5 to work on this server. I did this. Called the service "Witango" and set the "Required Files" to point to wiis.dll. I still get "Page not Found" error. Do you need to somehow indicate taf, tcf, and tml files? Or is there something else I am missing? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Version 5 Install
The Witango site is up now and I was able to download the instructions for Windows installation. It appears that the application extensions (tml, taf, tcf, thtml) were not setup in the Application Configuration of IIS Admin. I did that and it seems to be working now. Thanks Steve Fogelson -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, December 29, 2003 5:08 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Version 5 Install MS 2003 Web Edition, R:Tango 5 I read through the archives and found some info stating that you need to "Add a new Web service extension" in order to get Witango 5 to work on this server. I did this. Called the service "Witango" and set the "Required Files" to point to wiis.dll. I still get "Page not Found" error. Do you need to somehow indicate taf, tcf, and tml files? Or is there something else I am missing? 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
Witango-Talk: Server Question
I am in the process of separating my databases from the web and Witango box. Is it more important to have more processor speed for the web/Witango box or the DB box? How about RAM? And how about disk access? I am guessing more CPU power and RAM in the web/Witango box. Thanks for your advise. Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Witango 5 Conversion ?
I am converting an app from Tango 2000 to Witango 5. This app is shopping cart for many domains that uses one set of tafs. <@var user$U_Site> is set when the shopper first enters the domain and is the variable that is used for selecting the custom variables for a particular domain. I have custom variables set up for each domain as follows: ThemePath /Sites/<@var user$U_Site>/Theme/ ThemeHeader <@var <@var user$U_Site>$ThemePath>header.html ThemeFooter <@var <@var user$U_Site>$ThemePath>footer.html I use the following tags to include the site header template: <@include "<@var <@var user$U_Site>$ThemeHeader encoding=metahtml>"> Prior to Version 5 <@var <@var user$U_Site>$ThemePath> evaluated to /Sites/upnorth/Theme/ and <@var <@var user$U_Site>$ThemeHeader encoding=metahtml> evaluated to /Sites/upnorth/Theme/header.html In Version 5 <@var <@var user$U_Site>$ThemePath> evaluates to /Sites//Theme/ and <@var <@var user$U_Site>$ThemeHeader encoding=metahtml> evaluates to header.html It appears that the nested variable <@var user$U_Site> is getting lost now with version 5. Any ideas or comments why this is doing this? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Witango 5 Conversion ?
Wish I could report back what it took to fix this. I made many changes. Including your and Scott's suggestions. Probably too many at one time. Got it to work. Then changed this back to what it initially was (hopefully to find the problem) and it still works. Probably a syntax problem. Thanks for the help. Steve -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 12:14 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Witango 5 Conversion ? Have you checked that <@VAR user$u_site> is being set properly? -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 12:33 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Witango 5 Conversion ? I am converting an app from Tango 2000 to Witango 5. This app is shopping cart for many domains that uses one set of tafs. <@var user$U_Site> is set when the shopper first enters the domain and is the variable that is used for selecting the custom variables for a particular domain. I have custom variables set up for each domain as follows: ThemePath /Sites/<@var user$U_Site>/Theme/ ThemeHeader <@var <@var user$U_Site>$ThemePath>header.html ThemeFooter <@var <@var user$U_Site>$ThemePath>footer.html I use the following tags to include the site header template: <@include "<@var <@var user$U_Site>$ThemeHeader encoding=metahtml>"> Prior to Version 5 <@var <@var user$U_Site>$ThemePath> evaluated to /Sites/upnorth/Theme/ and <@var <@var user$U_Site>$ThemeHeader encoding=metahtml> evaluated to /Sites/upnorth/Theme/header.html In Version 5 <@var <@var user$U_Site>$ThemePath> evaluates to /Sites//Theme/ and <@var <@var user$U_Site>$ThemeHeader encoding=metahtml> evaluates to header.html It appears that the nested variable <@var user$U_Site> is getting lost now with version 5. Any ideas or comments why this is doing this? 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Another Ver 5 conversion question
I am using the following for redirects: <@assign request$httpHeader value="HTTP/1.1 <@httpstatuscode> <@httpreasonphrase><@crlf>Date: <@currenttimestamp format='datetime:http'><@crlf>Server: Witango 5.0.1.062<@crlf>MIME-Version: 1.0<@crlf>Content-Type: text/html<@crlf>Location: <@var method$URL encoding=metahtml><@crlf><@setcookies><@userreferencecookie><@crlf><@crlf>"> With debug on it yields: request$httpHeader=HTTP/1.1 200 OK Date: Friday, 02-Jan-2004 09:57:11 GMT Server: Witango 5.0.1.062 MIME-Version: 1.0 Content-Type: text/html Location: /Admin/modifycategory.taf?_function=detail&Categories_uid1=2 ; I don't get the 500 error but it doesn't redirect. Any ideas? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Version 5 Conversion - Windows 2003 Web Edition Server, R:Tango v ersion 5 ersion 5
I have a write file action that is acting odd. If the file exists, I have the "Generate an Error" option checked. So if I have the "Debug File" attribute activated and the file exists at the execution of the taf, the "Error" results works fine. If I deactivate the "Debug File" attribute and the file exists at the execution of the taf, it generates an "HTTP 500 - Internal Server Error" Any ideas? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Search Action - Limit To 1
I am converting an app to Version 5 - Win2003 Web Edition, R:Tango Version 5, IIS 6.0 I noticed an app with a search action that is supposed to be limited to number of rows retrieved, but it is retrieving all rows that meet the criteria. So I made a test taf with a very limited search action (2 selected fields, 1 criteria, limited to 1 row). I also included a DBMS action with the same info. Both retrieved 155 rows. Has any one else noticed this? Am I missing something? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Dreamweaver MX & WiTango
http://witango.webenergy-sw.com/witangotags.html -Original Message- From: Witty Tango [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 7:16 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Dreamweaver MX & WiTango Guys.. can someone tell me this? I need to get these add-ins for Dreamweaver MX... can someone send me a link? - Original Message - From: "Witty Tango" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 2:11 PM Subject: Re: Witango-Talk: Dreamweaver MX & WiTango -Followup > I need to get these add-ins... can someone send me a link? > > > - Original Message - > From: "Steve Campbell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 28, 2004 1:42 PM > Subject: RE: Witango-Talk: Dreamweaver MX & WiTango -Followup > > > > Just a follow up to this. > > > > Someone on this list offered Dreamweaver tags for the WiTango tags, if I > > am saying that right. I purchased them, and put them in my snipplets > > folder. I then experienced a crash and lost them, could someone please > > point me in the right direction here of who had those? > > > > Thanks > > Steve > > > > > > > > -Original Message- > > From: Matay, Diane [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 27, 2004 2:45 PM > > To: '[EMAIL PROTECTED]' > > Subject: Witango-Talk: Dreamweaver MX & WiTango > > > > Is anybody using the Dreamweaver add-in for WiTango tags provided by Web > > Energy? We've been trying to get the add-in to work for several weeks to > > no > > avail. > > > > If anyone knows of another add-in for WiTango tags, we would be very > > interested. > > > > Thanks! > > Diane Matay > > Business System Support Specialist > > DRS Optronics > > (321) 309-0486 > > > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004 > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004 > > > > > > > > > > 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:
Witango version 5, Win 2003 Web Edition Hi, I been working on this problem for 2 days and can't find the solution. I changed the "Log On As" account for Witango from "Local System Account" to a new account, so that I could locate my databases on a different server. I gave Full Control permissions to root directory of the site, wiis.dll in the scripts directory, Witango folder under the Program Files folder. I located the DB's on another server, set permissions for the new account, and changed the ODBC connections. Everything works great except for one thing: When I use External actions, it is having trouble. The External actions are not referencing anything on the DB server. I have even reduced the .bat file the External action references to just a dir *.* I am getting the following error: [Application File] [47] /listingimages.tcf [External Action] [47] call_identify [Query] [48] C:\Inetpub\wwwroot\CatSite\dir.bat; Parameters: PATH1=C:\Inetpub\wwwroot\CatSite\Sites\upnorth\Image\catimages\BuckKit.jpg; [External Action] [48] Forking process [Error] [48] -101 General error during data source operation. [Error] [48] -101 General error during data source operation. [External Action] [48] Complete Any ideas?? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: RE: Witango-Talk:
I logged in at the Witango server with the new service account. I went to the root folder of the site and was able to execute the bat file with no problems. So I would think that my permissions are set ok. The bat file is located in the root directory. The External action is as follows: Type: Command Line Command: <@webroot>dir.bat Environment Variables: Name - PATH1, Value - <@var method$file_name> This worked fine before I changed the "Log On As" account for Witango. I could change it back, but I would not be able to use a separate DB server, so I would like to work through this if possible. Thanks Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 10:46 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: RE: Witango-Talk: I think it has to be called using something like Cmd dir.bat Or Command dir.bat Trying to remember exact :-b Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 11:18 AM To: Witango User Group (E-mail) Subject: Witango-Talk: Witango version 5, Win 2003 Web Edition Hi, I been working on this problem for 2 days and can't find the solution. I changed the "Log On As" account for Witango from "Local System Account" to a new account, so that I could locate my databases on a different server. I gave Full Control permissions to root directory of the site, wiis.dll in the scripts directory, Witango folder under the Program Files folder. I located the DB's on another server, set permissions for the new account, and changed the ODBC connections. Everything works great except for one thing: When I use External actions, it is having trouble. The External actions are not referencing anything on the DB server. I have even reduced the .bat file the External action references to just a dir *.* I am getting the following error: [Application File] [47] /listingimages.tcf [External Action] [47] call_identify [Query] [48] C:\Inetpub\wwwroot\CatSite\dir.bat; Parameters: PATH1=C:\Inetpub\wwwroot\CatSite\Sites\upnorth\Image\catimages\BuckKit.j pg; [External Action] [48] Forking process [Error] [48] -101 General error during data source operation. [Error] [48] -101 General error during data source operation. [External Action] [48] Complete Any ideas?? 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: RE: Witango-Talk:
Scott, Robert, and Ben. Thanks for the responses. I don't specify an account and password when I set the datasource within Witango. I just select ODBC and specify the ODBC name with <@var <@var user$U_Site>$CatDSN>. It works fine when I have the DBs located on the Witango server OR if they are located on a separate server and I use a different account. I would prefer to use the Local System Account for Witango, but I get the following error with the ODBC connection pointing to a separate DB server: Thanks in advance for any advice. Steve Error An error occurred while processing your request: File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 7 [RBTI][Oterro ODBC Driver]-ERROR- Unable to connect database ( 7) 08001 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 0 [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). 01000 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 2638 [RBTI][Oterro ODBC Driver]The database is currently unavailable -- it is probably open with MULTI set OFF. 08004 File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 12:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: RE: Witango-Talk: Hi Steve, Unless I'm missing something, I don't see why you needed to change the permissions of the Witango Service if it was working fine before. The "System" Account on Windows is preferred for process like Witango. Moving your Database to another Server shouldn't force you to change the Account Witango runs under, even on Windows 2003. Most ODBC Drivers on Windows, that support remote ODBC Client connections (like SQL Server), allow you to specify a Username/Password that can be unique from the Service Account. It's the Username/Password configured for your Database Actions that talk to the ODBC Client you need to change if anything. But like I said, maybe I'm missing a piece of the scenario. Sorry if I don't have it right. Cheers... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) ----- -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Thu, 29 Jan 2004 12:10:44 -0600 Subject: RE: Witango-Talk: RE: Witango-Talk: > I logged in at the Witango server with the new service account. I went > to > the root folder of the site and was able to execute the bat file with > no > problems. So I would think that my permissions are set ok. > > The bat file is located in the root directory. > > The External action is as follows: > > Type: Command Line > Command: <@webroot>dir.bat > Environment Variables: Name - PATH1, Value - <@var method$file_name> > > This worked fine before I changed the "Log On As" account for Witango. > I > could change it back, but I would not be able to use a separate DB > server, > so I would like to work through this if possible. > > Thanks > > Steve > > -Original Message- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 10:46 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: RE: Witango-Talk: > > > I think it has to be called using something like > > Cmd dir.bat > Or > Command dir.bat > > Trying to remember exact :-b > > > > > Ben Johansen - http://www.pcforge.com > Authorized Witango & MDaemon Reseller > Available for Witango Developement > > > -Original Message- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 11:18 AM > To: Witango User Group (E-mail) > Subject: Witango-Talk: > > Witango version 5, Win 2003 Web Edition > Hi, > > I been working on this problem for 2 days and can't find the solution. > I > changed the "Log On As" account for Witango from "Local System Account" > to a > new account, so that I could locate my databases on a different server. > I > gave Full Control permissions to root directory of the site, wiis.d
RE: Witango-Talk: RE: Witango-Talk:
I just used a program called FileMon to track file access when I do this External action and I found the following: 1:26:38 PM witango.exe:3456OPENC:\s3c0 FILE NOT FOUND Options: Open Access: All 1:26:38 PM witango.exe:3456CREATE C:\s3c0 ACCESS DENIED ICS7\WitangoAdmin 1:26:38 PM witango.exe:3456OPENC:\s3c0 FILE NOT FOUND Options: Open Access: All Does this mean that I need to give my service account WitangoAdmin full control permission to the entire C: drive? I tried it and it worked. Windows gave me a warning about access and security when I did it. Not sure if it the best thing to do. I am still interested in pursuing the method utilizing Log As System Account. BTW: I did try rebooting the server. Didn't help. Thanks Steve -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: RE: Witango-Talk: Scott, Robert, and Ben. Thanks for the responses. I don't specify an account and password when I set the datasource within Witango. I just select ODBC and specify the ODBC name with <@var <@var user$U_Site>$CatDSN>. It works fine when I have the DBs located on the Witango server OR if they are located on a separate server and I use a different account. I would prefer to use the Local System Account for Witango, but I get the following error with the ODBC connection pointing to a separate DB server: Thanks in advance for any advice. Steve Error An error occurred while processing your request: File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 7 [RBTI][Oterro ODBC Driver]-ERROR- Unable to connect database ( 7) 08001 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 0 [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). 01000 File: Default.taf Position: FindCategoryForBanner Class: DBMS Main Error Number: 2638 [RBTI][Oterro ODBC Driver]The database is currently unavailable -- it is probably open with MULTI set OFF. 08004 File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. File: Default.taf Position: FindCategoryForBanner Class: Internal Main Error Number: -4 Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 12:32 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: RE: Witango-Talk: Hi Steve, Unless I'm missing something, I don't see why you needed to change the permissions of the Witango Service if it was working fine before. The "System" Account on Windows is preferred for process like Witango. Moving your Database to another Server shouldn't force you to change the Account Witango runs under, even on Windows 2003. Most ODBC Drivers on Windows, that support remote ODBC Client connections (like SQL Server), allow you to specify a Username/Password that can be unique from the Service Account. It's the Username/Password configured for your Database Actions that talk to the ODBC Client you need to change if anything. But like I said, maybe I'm missing a piece of the scenario. Sorry if I don't have it right. Cheers... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community - XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) ----- -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Thu, 29 Jan 2004 12:10:44 -0600 Subject: RE: Witango-Talk: RE: Witango-Talk: > I logged in at the Witango server with the new service account. I went > to > the root folder of the site and was able to execute the bat file with > no > problems. So I would think that my permissions are set ok. > > The bat file is located in the root directory. > > The External action is as follows: > > Type: Command Line > Command: <@webroot>dir.bat > Environment Variables: Name - PATH1, Value - <@var method$file_name> > > This worked fine before I changed the "Log On As" account for Witango. > I > could change it back, but I would not be able to use a separate DB > server, > so I would like to work through this if possible. > > Thanks > > Steve > > -Original Message- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 10:46 AM >
RE: Witango-Talk: Tango Memory Leaks
I tried the following on Tango 2000 Net stop "Tango 2000 Server" Net start "Tango 2000 Server" Worked fine except the watchdog restarted the Tango server before I could do my maintenance. Any way to prevent this? Thanks Steve Fogelson Internet Commerce Solutions -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: Tango Memory Leaks Hi ! I just created a bat file with two lines: Net stop "witango server 5" Net start "witango server 5" Then use the W2K Scheduler to set up a routine that calls the bat file. Seems to work fine. Bengt -Ursprungligt meddelande- Från: Steve Campbell [mailto:[EMAIL PROTECTED] Skickat: den 10 februari 2004 16:36 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: Tango Memory Leaks I am interested in this as well. Thanks Steve -Original Message- From: Peter Ternström [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 6:45 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango Memory Leaks Cool! could you tell me how to do this? I would like to restart tango server every night, due to memory leak problems. Kind regards Peter - Original Message - From: "RJ Hendrickson" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 9:10 PM Subject: Re: Witango-Talk: Tango Memory Leaks You can use the W2K Scheduler to set up a routine to reset Tango automatically on a daily basis, or as often as you like if you don't want to have to worry about doing it manually. RJ At 04:33 PM 4/1/2002, you wrote: >Unfortunately, I have found to have similar memory leaks in tango 4.05.047. >with apache. The leak occurs on windows 2000 and linux and mac. On my >win2000/apache or linux apache systems, I can slowly watch the memory usage >creap up, and my windows 2000 servers will crash occasionally due to it. I >am sure it is tango, because if I just restart the tango service, the memory >goes back to normal. As long as I restart the tango server every couple of >days, no problems. The linux machines will restart the tango daemon by >itself when the memory gets out of hand. > >I use a lot of binary library applications with tango, which means I am >pulling large amounts of binary data from PrimeBase SQL, and I think that is >why I see this problem more pronounced than others. > >-- > >Robert Garcia >BigHead Technology >21053 Devonshire Suite 206 >Chatsworth, Ca 91311 >Phone 818.773.8162 >Fax 818.773.8164 >http://www.bighead.net/ >[EMAIL PROTECTED] > > > > From: Jose Kuhn <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Wed, 20 Mar 2002 14:03:57 -0500 > > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > > Subject: Re: Witango-Talk: Trying to make plans - Mac, Web*, Tango > > projections > > > > Hello! > > > > Both, Robert Garcia and myself are huge Mac heads but we have both > > temporarily moved to WiTango 2k Windows 2K running with Apache(Due to the > > memory leak in the Tango Webstar Plug in). We also use PrimeBase as our SQL > > Database. There is a memory leak in the Webstar Plug in Witango 2k. I > would > > wait until this summer when Witango 5 comes out. Witango 5 will not run on > > Mac OS 9. According to Phil, there will be a Webstar 5 plug-in as well as > > the usual Apache Plug-in for Mac OS X. It runs fabulously with Apache. > > > > Primebase flies on Mac OS X (IT's slow on Mac OS 9.) You can download a > free > > developer's version from http://www.Primebase.com. > > > > BTW Robert's http://www.bighead.net company is a Primebase Distributor. You > > can Run Primebase from everything from Mac OS 9/X to Solaris/AIX > > > > Jose > > > > on 3/20/02 11:51 AM, Joe Terrasi at [EMAIL PROTECTED] wrote: > > > >> I currently use WebSTAR/Tango2k/Filemaker on a classic Mac (actually, > >> the FileMaker is on a different box). > >> > >> What are anybody's thoughts on how I should upgrade? > >> > >> > >> I wouldn't mind moving to an OSX box if necessary. > >> > >> I would love to scrap FileMaker all together (unless performance can > >> be improved). > >> > >> I REALLY want to stay with Tango. > >> > >> I would like to stay with WebSTAR if possible, but I could possibly > switch. > >> > >> > >> What will be my best solution in the next 6 months-1 year? What > >> database will serve me well? I also have a lot of forms/labels to > >> print from the data - do I need a separate reports package? > >> > >> Sorry if these are basic questions, but I'd love your collective input. > >> > >> Thanks!! > >> > >> Joe > > > > > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > >___ _ >TO UNSUBSCRIBE: send a plain text/US ASCII
RE: Witango-Talk: Tango Memory Leaks
Thanks Alan Do you have to restart the watchdog or does restarting Tango do it for you? Thanks Steve -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 4:20 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango Memory Leaks Hey Steve, stop the watchdog before you stop the tango service (: dont remember the exact command but we did that when we were using tango 2000 on NT 4.0 - Original Message - From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 10, 2004 2:11 PM Subject: RE: Witango-Talk: Tango Memory Leaks I tried the following on Tango 2000 Net stop "Tango 2000 Server" Net start "Tango 2000 Server" Worked fine except the watchdog restarted the Tango server before I could do my maintenance. Any way to prevent this? Thanks Steve Fogelson Internet Commerce Solutions -Original Message- From: Bengt Bredin [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: SV: Witango-Talk: Tango Memory Leaks Hi ! I just created a bat file with two lines: Net stop "witango server 5" Net start "witango server 5" Then use the W2K Scheduler to set up a routine that calls the bat file. Seems to work fine. Bengt -Ursprungligt meddelande- Från: Steve Campbell [mailto:[EMAIL PROTECTED] Skickat: den 10 februari 2004 16:36 Till: [EMAIL PROTECTED] Ämne: RE: Witango-Talk: Tango Memory Leaks I am interested in this as well. Thanks Steve -Original Message- From: Peter Ternström [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 6:45 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango Memory Leaks Cool! could you tell me how to do this? I would like to restart tango server every night, due to memory leak problems. Kind regards Peter - Original Message - From: "RJ Hendrickson" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 9:10 PM Subject: Re: Witango-Talk: Tango Memory Leaks You can use the W2K Scheduler to set up a routine to reset Tango automatically on a daily basis, or as often as you like if you don't want to have to worry about doing it manually. RJ At 04:33 PM 4/1/2002, you wrote: >Unfortunately, I have found to have similar memory leaks in tango 4.05.047. >with apache. The leak occurs on windows 2000 and linux and mac. On my >win2000/apache or linux apache systems, I can slowly watch the memory usage >creap up, and my windows 2000 servers will crash occasionally due to it. I >am sure it is tango, because if I just restart the tango service, the memory >goes back to normal. As long as I restart the tango server every couple of >days, no problems. The linux machines will restart the tango daemon by >itself when the memory gets out of hand. > >I use a lot of binary library applications with tango, which means I am >pulling large amounts of binary data from PrimeBase SQL, and I think that is >why I see this problem more pronounced than others. > >-- > >Robert Garcia >BigHead Technology >21053 Devonshire Suite 206 >Chatsworth, Ca 91311 >Phone 818.773.8162 >Fax 818.773.8164 >http://www.bighead.net/ >[EMAIL PROTECTED] > > > > From: Jose Kuhn <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Wed, 20 Mar 2002 14:03:57 -0500 > > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > > Subject: Re: Witango-Talk: Trying to make plans - Mac, Web*, Tango > > projections > > > > Hello! > > > > Both, Robert Garcia and myself are huge Mac heads but we have both > > temporarily moved to WiTango 2k Windows 2K running with Apache(Due to the > > memory leak in the Tango Webstar Plug in). We also use PrimeBase as our SQL > > Database. There is a memory leak in the Webstar Plug in Witango 2k. I > would > > wait until this summer when Witango 5 comes out. Witango 5 will not run on > > Mac OS 9. According to Phil, there will be a Webstar 5 plug-in as well as > > the usual Apache Plug-in for Mac OS X. It runs fabulously with Apache. > > > > Primebase flies on Mac OS X (IT's slow on Mac OS 9.) You can download a > free > > developer's version from http://www.Primebase.com. > > > > BTW Robert's http://www.bighead.net company is a Primebase Distributor. You > > can Run Primebase from everything from Mac OS 9/X to Solaris/AIX > > > > Jose > > > > on 3/20/02 11:51 AM, Joe Terrasi at [EMAIL PROTECTED] wrote: > > > >> I currently use WebSTAR/Tango2k/Filemaker on a classic Mac (actually, > >> the FileMaker is on a different box). > >> >
RE: Witango-Talk: Tango Memory Leaks
Maybe I should just start the watchdog. Steve -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 5:00 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Tango Memory Leaks yeah but if you stop the watchdog and restart tango, would the watchdog be running again? thats what he was asking i think. - Original Message - From: "Tom Ferguson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 10, 2004 2:54 PM Subject: RE: Witango-Talk: Tango Memory Leaks > if you start the WatchDog and Witango isn't running, won't the WatchDog > start it? > > > -Original Message- > > From: Alan Wolfe [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 10, 2004 5:38 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Witango-Talk: Tango Memory Leaks > > > > > > hmm, dont know > > > > You could try stopping the watchdog, stoping tango, starting tango and > > seeing what services are running to see if the watchdog is back on or not > > > > > > - Original Message - > > From: "Fogelson, Steve" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 10, 2004 2:19 PM > > Subject: RE: Witango-Talk: Tango Memory Leaks > > > > > > Thanks Alan > > > > Do you have to restart the watchdog or does restarting Tango do > > it for you? > > > > Thanks > > > > Steve > > > > -Original Message- > > From: Alan Wolfe [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 10, 2004 4:20 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Witango-Talk: Tango Memory Leaks > > > > > > Hey Steve, > > > > stop the watchdog before you stop the tango service (: > > > > dont remember the exact command but we did that when we were using tango > > 2000 on NT 4.0 > > > > - Original Message - > > From: "Fogelson, Steve" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 10, 2004 2:11 PM > > Subject: RE: Witango-Talk: Tango Memory Leaks > > > > > > I tried the following on Tango 2000 > > > > Net stop "Tango 2000 Server" > > Net start "Tango 2000 Server" > > > > Worked fine except the watchdog restarted the Tango server before > > I could do > > my maintenance. > > > > Any way to prevent this? > > > > Thanks > > > > Steve Fogelson > > Internet Commerce Solutions > > > > -Original Message- > > From: Bengt Bredin [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 10, 2004 10:08 AM > > To: [EMAIL PROTECTED] > > Subject: SV: Witango-Talk: Tango Memory Leaks > > > > > > > > Hi ! > > > > I just created a bat file with two lines: > > Net stop "witango server 5" > > Net start "witango server 5" > > Then use the W2K Scheduler to set up a routine that calls the bat file. > > Seems to work fine. > > > > Bengt > > > > > > > > -Ursprungligt meddelande- > > Från: Steve Campbell [mailto:[EMAIL PROTECTED] > > Skickat: den 10 februari 2004 16:36 > > Till: [EMAIL PROTECTED] > > Ämne: RE: Witango-Talk: Tango Memory Leaks > > > > I am interested in this as well. Thanks > > > > Steve > > > > > > > > -Original Message- > > From: Peter Ternström [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 10, 2004 6:45 AM > > To: [EMAIL PROTECTED] > > Subject: Re: Witango-Talk: Tango Memory Leaks > > > > Cool! > > > > could you tell me how to do this? I would like to restart tango server > > every > > night, due to memory leak problems. > > > > Kind regards > > Peter > > > > > > - Original Message - > > From: "RJ Hendrickson" <[EMAIL PROTECTED]> > > To: "Multiple recipients of list witango-talk" > > <[EMAIL PROTECTED]> > > Sent: Saturday, April 06, 2002 9:10 PM > > Subject: Re: Witango-Talk: Tango Memory Leaks > > > > > > You can use the W2K Scheduler to set up a routine to reset Tango > > automatically on a daily basis, or as often as you like if you don't > > want > > to have to worry about doing it manually. > > > > RJ > > > > At 04:33 PM 4/1/2002, you wrote: > > >Unfortunately, I have found to have similar memory leaks in tango > > 4.05.047. > > >with apache.
Witango-Talk: requests for ip address vs. domain names
I had something interesting happen to me the last few days. I have an app for many domains with one set of tafs with the usual table lookup to find the site and set a user variable that points to custom variable for that domain. Well if someone tried to hit the site with an ip address instead of the domain name, it would bypass dns and hit the web server. My TCF then tries the table lookup and doesn't find it. It then corrupts all my custom variables. Probably some coding logic. So what I want to do is redirect to a "page not found" or something if the site is not found in the table lookup. I already have a 404.taf that redirects if the domain is valid and the page is missing. I imagine it may be search engine spiders or hackers sequentially checking ip addresses, so I would like the response back to be a traditional server error if a page is not found. Any suggestions? Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: requests for ip address vs. domain names
Scott, Sorry about that. I am running Windows 2003 Web Edition, Witango 5. Thanks Steve -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 12:23 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: requests for ip address vs. domain names Hi Steve, The exact solution will depend highly on what kind of Webserver (and OS) you're running. Let us know, when you have a moment. Cheers -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "Witango User Group (E-mail)" <[EMAIL PROTECTED]> Date: Wed, 11 Feb 2004 12:05:46 -0600 Subject: Witango-Talk: requests for ip address vs. domain names > I had something interesting happen to me the last few days. I have an > app > for many domains with one set of tafs with the usual table lookup to > find > the site and set a user variable that points to custom variable for > that > domain. > > Well if someone tried to hit the site with an ip address instead of the > domain name, it would bypass dns and hit the web server. My TCF then > tries > the table lookup and doesn't find it. It then corrupts all my custom > variables. Probably some coding logic. So what I want to do is redirect > to a > "page not found" or something if the site is not found in the table > lookup. > I already have a 404.taf that redirects if the domain is valid and the > page > is missing. > > I imagine it may be search engine spiders or hackers sequentially > checking > ip addresses, so I would like the response back to be a traditional > server > error if a page is not found. > > Any suggestions? > > 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: requests for ip address vs. domain names
Scott, I assign an ip address to each web site and have not used host headers. Would I need a "dummy" web site for each real web site for each ip address? I set one up the way you described. With the host header value set to the ip address and the ip address to All Unassigned and it still goes to the real site with that address. Is it because I assign an ip address to the real site? I guess I was wondering if I could handle this in Witango. If the domain (ip address) was not found in the site table lookup, could I redirect with something like the following? <@assign request$httpHeader "HTTP/1.0 302 Moved<@CRLF>"> Except change the 302 code to something more appropriate, but I don't know what. Steve -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 1:33 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Hi Steve, There is more than one way to do this with IIS, but maybe the easiest is just to: ~ Create a new Website in IIS. ~ Go to "Properties" for the new Website. ~ Go to the "Website" tab. ~ Click the "Advanced" button. ~ And edit the "Host Header Name" with the IP address. Normally you would put a domain name in "Host Header Name", but you can also put an IP address there as well. Then all traffic using just the IP address will go to your new Website - then just put whatever code you need to handle the request in there. Like I said, there is more than one way to do this, but this way probably saves you entering all the "known" domains you might be using, then driving the "unknown" domains (and IP traffic) to an empty site. The logic (for me anyway) is clearer with my first suggestion. Hope this helps. Cheers Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Wed, 11 Feb 2004 13:14:33 -0600 Subject: RE: Witango-Talk: requests for ip address vs. domain names > Scott, > > Sorry about that. I am running Windows 2003 Web Edition, Witango 5. > > Thanks > > Steve > > -Original Message- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 11, 2004 12:23 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: requests for ip address vs. domain names > > > Hi Steve, > > The exact solution will depend highly on what kind of Webserver (and > OS) > you're running. Let us know, when you have a moment. > > Cheers > > > -Original Message- > From: "Fogelson, Steve" <[EMAIL PROTECTED]> > To: "Witango User Group (E-mail)" <[EMAIL PROTECTED]> > Date: Wed, 11 Feb 2004 12:05:46 -0600 > Subject: Witango-Talk: requests for ip address vs. domain names > > > I had something interesting happen to me the last few days. I have an > > app > > for many domains with one set of tafs with the usual table lookup to > > find > > the site and set a user variable that points to custom variable for > > that > > domain. > > > > Well if someone tried to hit the site with an ip address instead of > the > > domain name, it would bypass dns and hit the web server. My TCF then > > tries > > the table lookup and doesn't find it. It then corrupts all my custom > > variables. Probably some coding logic. So what I want to do is > redirect > > to a > > "page not found" or something if the site is not found in the table > > lookup. > > I already have a 404.taf that redirects if the domain is valid and > the > > page > > is missing. > > > > I imagine it may be search engine spiders or hackers sequentially > > checking > > ip addresses, so I would like the response back to be a traditional > > server > > error if a page is not found. > > > > Any suggestions? > > > > 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 > ___ > _ > 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: requests for ip address vs. domain names
I decided to translate the ip to the proper domain and redirect. I used the following code to translate, but it doesn't find a value. Does it have anything to do with the numbers and decimals in an ip address? It works fine if I filter on column 2 for test.com. <@assign request$domains "<@array rows=9 cols=2 value=' 110.170.44.180,test.com; 110.170.44.181,test1.com; 110.170.44.182,test2.com; 110.170.44.183,test3.com; 110.170.44.184,test4.com; 110.170.44.185,test5.com; 110.170.44.186,test6.com; 110.170.44.187,test7.com; 110.170.44.188,test8.com '>"> <@assign request$new "<@filter request$domains expr='#1="207.170.44.180"'>"> <@var request$new> Thanks Steve -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:07 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Actually, that should work, hostheaders override IPs... SITE 1 > 123.123.123.123 www.domain.com SITE 2 > 123.123.123.123 (blank) http://www.domain.com/ goes to site 1 http://123.123.123.123/ goes to site 2 (I should note that's in IIS5/Win2K) Don't forget though that in Witango you can use <@DOMAIN> to see the www.domain.com or "123.123.123.123" and react accordingly. Robert -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Hi Steve, I was afraid you'd might come back with a reply like that :-) I believe IP addresses override Host Header entries. I prefer going with all Host Header entries myself, because then I only need one IP address for an unlimited number of Websites (all can be in different directories too). If this is the way things are working for you, maybe working something into your code is the better solution. Besides, having some code to handle "was not found in the site table lookup" is a good idea anyway. Then you can redirect them to a special page that lists all your "known" domains that the user can choice from. Hope that helps. Cheers... Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Wed, 11 Feb 2004 13:56:52 -0600 Subject: RE: Witango-Talk: requests for ip address vs. domain names > Scott, > > I assign an ip address to each web site and have not used host headers. > Would I need a "dummy" web site for each real web site for each ip > address? > > I set one up the way you described. With the host header value set to > the ip > address and the ip address to All Unassigned and it still goes to the > real > site with that address. Is it because I assign an ip address to the > real > site? > > I guess I was wondering if I could handle this in Witango. If the > domain (ip > address) was not found in the site table lookup, could I redirect with > something like the following? > > <@assign request$httpHeader "HTTP/1.0 302 Moved<@CRLF>"> Except change > the > 302 code to something more appropriate, but I don't know what. > > Steve > > -Original Message- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 11, 2004 1:33 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: requests for ip address vs. domain names > > > Hi Steve, > > There is more than one way to do this with IIS, but maybe the easiest > is > just to: > > ~ Create a new Website in IIS. > ~ Go to "Properties" for the new Website. > ~ Go to the "Website" tab. > ~ Click the "Advanced" button. > ~ And edit the "Host Header Name" with the IP address. > > Normally you would put a domain name in "Host Header Name", but you can > also put an IP address there as well. > > Then all traffic using just the IP address will go to your new Website > - > then just put whatever code you need to handle the request in there. > > Like I said, there is more than one way to do this, but this way > probably > saves you entering all the "known" domains you might be using, then > driving the "unknown" domains (and IP traffic) to an empty site. The > logic (for me anyway) is clearer with my first suggestion. > > Hope this helps. Cheers.
RE: Witango-Talk: requests for ip address vs. domain names
Sorry the 207.170.44.180 should have been 110.170.44.180. Still no results. Steve -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 4:15 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names I decided to translate the ip to the proper domain and redirect. I used the following code to translate, but it doesn't find a value. Does it have anything to do with the numbers and decimals in an ip address? It works fine if I filter on column 2 for test.com. <@assign request$domains "<@array rows=9 cols=2 value=' 110.170.44.180,test.com; 110.170.44.181,test1.com; 110.170.44.182,test2.com; 110.170.44.183,test3.com; 110.170.44.184,test4.com; 110.170.44.185,test5.com; 110.170.44.186,test6.com; 110.170.44.187,test7.com; 110.170.44.188,test8.com '>"> <@assign request$new "<@filter request$domains expr='#1="207.170.44.180"'>"> <@var request$new> Thanks Steve -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:07 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Actually, that should work, hostheaders override IPs... SITE 1 > 123.123.123.123 www.domain.com SITE 2 > 123.123.123.123 (blank) http://www.domain.com/ goes to site 1 http://123.123.123.123/ goes to site 2 (I should note that's in IIS5/Win2K) Don't forget though that in Witango you can use <@DOMAIN> to see the www.domain.com or "123.123.123.123" and react accordingly. Robert -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Hi Steve, I was afraid you'd might come back with a reply like that :-) I believe IP addresses override Host Header entries. I prefer going with all Host Header entries myself, because then I only need one IP address for an unlimited number of Websites (all can be in different directories too). If this is the way things are working for you, maybe working something into your code is the better solution. Besides, having some code to handle "was not found in the site table lookup" is a good idea anyway. Then you can redirect them to a special page that lists all your "known" domains that the user can choice from. Hope that helps. Cheers... Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Wed, 11 Feb 2004 13:56:52 -0600 Subject: RE: Witango-Talk: requests for ip address vs. domain names > Scott, > > I assign an ip address to each web site and have not used host headers. > Would I need a "dummy" web site for each real web site for each ip > address? > > I set one up the way you described. With the host header value set to > the ip > address and the ip address to All Unassigned and it still goes to the > real > site with that address. Is it because I assign an ip address to the > real > site? > > I guess I was wondering if I could handle this in Witango. If the > domain (ip > address) was not found in the site table lookup, could I redirect with > something like the following? > > <@assign request$httpHeader "HTTP/1.0 302 Moved<@CRLF>"> Except change > the > 302 code to something more appropriate, but I don't know what. > > Steve > > -Original Message- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 11, 2004 1:33 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: requests for ip address vs. domain names > > > Hi Steve, > > There is more than one way to do this with IIS, but maybe the easiest > is > just to: > > ~ Create a new Website in IIS. > ~ Go to "Properties" for the new Website. > ~ Go to the "Website" tab. > ~ Click the "Advanced" button. > ~ And edit the "Host Header Name" with the IP address. > > Normally you would put a domain name in "Host Header Name", but you can > also put an IP address there as well. > > Then all traffic using just the IP address will go to your new Website > - > then just put whatever code you need to handle the request in there. > > Like I said, there is more than one way to do this
RE: Witango-Talk: requests for ip address vs. domain names
That did it. Thanks Dave Steve -Original Message- From: Dave Shelley [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 4:48 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Try taking out the leading before each IP address. It should work then. Dave Shelley -Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: February 11, 2004 5:32 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: requests for ip address vs. domain names Sorry the 207.170.44.180 should have been 110.170.44.180. Still no results. Steve -Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 4:15 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names I decided to translate the ip to the proper domain and redirect. I used the following code to translate, but it doesn't find a value. Does it have anything to do with the numbers and decimals in an ip address? It works fine if I filter on column 2 for test.com. <@assign request$domains "<@array rows=9 cols=2 value=' 110.170.44.180,test.com; 110.170.44.181,test1.com; 110.170.44.182,test2.com; 110.170.44.183,test3.com; 110.170.44.184,test4.com; 110.170.44.185,test5.com; 110.170.44.186,test6.com; 110.170.44.187,test7.com; 110.170.44.188,test8.com '>"> <@assign request$new "<@filter request$domains expr='#1="207.170.44.180"'>"> <@var request$new> Thanks Steve -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:07 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Actually, that should work, hostheaders override IPs... SITE 1 > 123.123.123.123 www.domain.com SITE 2 > 123.123.123.123 (blank) http://www.domain.com/ goes to site 1 http://123.123.123.123/ goes to site 2 (I should note that's in IIS5/Win2K) Don't forget though that in Witango you can use <@DOMAIN> to see the www.domain.com or "123.123.123.123" and react accordingly. Robert -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: requests for ip address vs. domain names Hi Steve, I was afraid you'd might come back with a reply like that :-) I believe IP addresses override Host Header entries. I prefer going with all Host Header entries myself, because then I only need one IP address for an unlimited number of Websites (all can be in different directories too). If this is the way things are working for you, maybe working something into your code is the better solution. Besides, having some code to handle "was not found in the site table lookup" is a good idea anyway. Then you can redirect them to a special page that lists all your "known" domains that the user can choice from. Hope that helps. Cheers... Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca -Original Message- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Wed, 11 Feb 2004 13:56:52 -0600 Subject: RE: Witango-Talk: requests for ip address vs. domain names > Scott, > > I assign an ip address to each web site and have not used host headers. > Would I need a "dummy" web site for each real web site for each ip > address? > > I set one up the way you described. With the host header value set to > the ip > address and the ip address to All Unassigned and it still goes to the > real > site with that address. Is it because I assign an ip address to the > real > site? > > I guess I was wondering if I could handle this in Witango. If the > domain (ip > address) was not found in the site table lookup, could I redirect with > something like the following? > > <@assign request$httpHeader "HTTP/1.0 302 Moved<@CRLF>"> Except change > the > 302 code to something more appropriate, but I don't know what. > > Steve > > -Original Message- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 11, 2004 1:33 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: requests for ip address vs. domain names > > > Hi Steve, > > There is more than one way to do this with IIS, but maybe the easiest > is > just to: > > ~ Create a new Website in IIS. > ~ Go to "Properties" for th
Witango-Talk: Apostrophe problem in DBMS statement
Window 2003 Web Edition, R:Tango 5.0 I am having trouble with the following DBMS action: update VariableValues SET Var_Value = <@sq><@var request$VarValue encoding=sql><@sq> from VariableValues v1, Variables v2 where ((v1.SiteID = <@var request$Site[1,SiteID]>) and (v2.Var_Name = <@sq><@var request$VarName><@sq>) and (v1.Var_ID = v2.Var_ID)) The DBMS action is preceded by <@assign noSQLEncoding true> and followed by <@assign noSQLEncoding false> I get the following info with debug: [Query] [517] update VariableValues SET Var_Value = 'Up North Sports carries a large selection of snowmobile products and accessories. Let Up North Sports earn your business and you won''t be disappointed.' from VariableValues v1, Variables v2 where ((v1.SiteID = 1) and (v2.Var_Name = 'DefPgDesc') and (v1.Var_ID = v2.Var_ID)) [Error] [518] 2059 [RBTI][Oterro ODBC Driver][CatSite]-WARNING- No rows exist or satisfy the specified clause. (2059) HY000 [Error] [519] 2038 [RBTI][Oterro ODBC Driver][CatSite]-ERROR- Var_Value is an undefined table. (2038) 42S02 [Error] [519] -101 General error during data source operation. [Error] [519] -101 General error during data source operation. It updates other variables just fine and will update this if I take the apostrophe out of won't Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Apostrophe problem in DBMS statement
Thanks for the feedback. I believe it is the apostrophe as if I update it with 1234 instead of the phrase with an apostrophe, it updates fine. There are many other variables as well that update fine that don't have an apostrophe. Var_Value is a column not a table as the error indicates. Somehow with the apostrophe in there it thinks it is a table. Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Apostrophe problem in DBMS statement Are you sure it is the apostrophe? The errors are NO ROW and Unknown TABLE Does a simple select statement using the where clause results with any rows? Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 2:37 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Apostrophe problem in DBMS statement Window 2003 Web Edition, R:Tango 5.0 I am having trouble with the following DBMS action: update VariableValues SET Var_Value = <@sq><@var request$VarValue encoding=sql><@sq> from VariableValues v1, Variables v2 where ((v1.SiteID = <@var request$Site[1,SiteID]>) and (v2.Var_Name = <@sq><@var request$VarName><@sq>) and (v1.Var_ID = v2.Var_ID)) The DBMS action is preceded by <@assign noSQLEncoding true> and followed by <@assign noSQLEncoding false> I get the following info with debug: [Query] [517] update VariableValues SET Var_Value = 'Up North Sports carries a large selection of snowmobile products and accessories. Let Up North Sports earn your business and you won''t be disappointed.' from VariableValues v1, Variables v2 where ((v1.SiteID = 1) and (v2.Var_Name = 'DefPgDesc') and (v1.Var_ID = v2.Var_ID)) [Error] [518] 2059 [RBTI][Oterro ODBC Driver][CatSite]-WARNING- No rows exist or satisfy the specified clause. (2059) HY000 [Error] [519] 2038 [RBTI][Oterro ODBC Driver][CatSite]-ERROR- Var_Value is an undefined table. (2038) 42S02 [Error] [519] -101 General error during data source operation. [Error] [519] -101 General error during data source operation. It updates other variables just fine and will update this if I take the apostrophe out of won't 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: ODBC Problems
Window 2003 Web Edition, R:Tango version 5 I have been getting the following error periodically in my Application Event Viewer: Unable to open to odbc.CatSites due to an error during connection. Followed by this Total Connection in Datasource Pool: 1 Max connections for the host: 0 Current connections in use for the host: 0. Once this starts, my app doesn't work until I restart Witango. The problem clears up immediately. Any ideas what is causing this. The DB is loaded on the same server. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: ODBC Problems
Robert, Thanks for the response. I think my problem is a little different. The DB is located on the same server. And when this problem starts, it doesn't let anyone access this DB until I restart Witango. So I don't think it is a long exec unless something somehow locks the DB. Steve -Original Message- From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 11:49 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: ODBC Problems The Witango error is a little misleading, but translates directly into "database isn't available". Is it possible that your db isn't responding for a moment (long exec) or is offline (auto-restart). I know I get this issue if I say, unplug the Ethernet cable to my SQL box. Witango has a fit, and does auto-close 'dead' db connections. Robert -----Original Message- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 12:08 PM To: Witango User Group (E-mail) Subject: Witango-Talk: ODBC Problems Window 2003 Web Edition, R:Tango version 5 I have been getting the following error periodically in my Application Event Viewer: Unable to open to odbc.CatSites due to an error during connection. Followed by this Total Connection in Datasource Pool: 1 Max connections for the host: 0 Current connections in use for the host: 0. Once this starts, my app doesn't work until I restart Witango. The problem clears up immediately. Any ideas what is causing this. The DB is loaded on the same server. 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Development Server
In the past I have set up sub domains for site development on my production server with no links leading to them. Well, some search engine have found them and are indexing them. So I need to set up a development server. As I understand, Witango will provide a free license for a development server. How are shops setting up their development server? Can it be setup on a internal server (intranet)? Also, how do you obtain the development license? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: configuration variable
This worked for me in Tango 2000 <@assign request$List[<@var request$ListRow>,IDName] "<@var request$resultSet[1,P_Name]>"> In Version 5, I get the following error: You may not set the configuration variable (List[1,IDName]) in the (request) scope. Consult the documentation for a list of valid scopes that can be used with this variable. I looked at the configuration variables in the documentation and didn't find List as a variable. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: (OT) favicon.ico
I get requests for favicon.ico in my Witango logs. Does anyone know what that is for? Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Event Log Error
Windows 2003 Web Edition, R:Tango Version 5 I periodically get the following error in my event log: Total Connections in Datasource Pool: 7 Max Connections for the host: 0 Current connections in use for the host: 6 Do I need to change one of my system variables for Max Connections or should I ignore this error. Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: (OT) favicon.ico
Bill & Tom, This shows up as a 404 - Item not found. I have a 404.taf for redirecting "page not found" requests. Any suggestions on how to handle this 404 issue? START /404.tafWitango_Server_5 404;http://www.upnorthsports.com:80/favicon.ico Thanks Steve -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Saturday, February 28, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: (OT) favicon.ico yep, and when someone bookmarks your page, the little icon should be what shows up in your "favorites". > -Original Message- > From: Bill Conlon [mailto:[EMAIL PROTECTED] > Sent: Saturday, February 28, 2004 12:53 PM > To: Witango-Talk > Subject: Re: Witango-Talk: (OT) favicon.ico > > > It's the little icon that appears in the browser address bar. > > >I get requests for favicon.ico in my Witango logs. > > > >Does anyone know what that is for? > > > >Steve Fogelson > >Internet Commerce Solutions > > > >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > > Bill Conlon > > To the Point > 345 California Avenue Suite 2 > Palo Alto, CA 94306 > > office: 650.327.2175 > 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
