RE: Witango-Talk: xls conversion
What database are you using? It may be easier to use Witango for just putting the file into a directory and then import the xls file into the database using a database procedure. This would be more efficient if the file is large. Ted -Original Message- From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Fri 12/31/2010 12:35 AM To: Witango-Talk@witango.com Subject: Witango-Talk: xls conversion Some of you may be familiar with auction sites that allow you to import excel xls files of auction items into the auction. I am trying to do something similar to this with Witango. Some of the columns may contain quotation marks to indicate a quote or maybe signify inches. One column contains a number with leading zeroes. Some columns contain html tags. I have tried opening the file with excel and saving as a csv file with a | as the delimiter and then reading into Witango. Two problems seem to occur with this method. Columns with number with leading zeroes lose the leading zeros and general columns are enclosed with quotes. Not necessarily a problem unless there are quotes in the field. I also need to be aware of potential SQL injection when importing these files. Anyone have any experience with this and a possible solution? I tried to search the list but I can't find it on the Witango website anymore. Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. winmail.dat
RE: Witango-Talk: xls conversion
You are right about mysql, I am most familiar with sql server. You will have to export to a flat file using Beverly advice. I would think that you could automate this step before importing. -Original Message- From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Fri 12/31/2010 1:54 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: xls conversion Hi Ted, I am using MySQL. I didn't know you could import an xls file directly into MySQL. Do you have a sample procedure you could share? I have used LOAD DATA INFILE but normally on comma delimited files. Thanks Steve -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Friday, December 31, 2010 7:32 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: xls conversion What database are you using? It may be easier to use Witango for just putting the file into a directory and then import the xls file into the database using a database procedure. This would be more efficient if the file is large. Ted -Original Message- From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Fri 12/31/2010 12:35 AM To: Witango-Talk@witango.com Subject: Witango-Talk: xls conversion Some of you may be familiar with auction sites that allow you to import excel xls files of auction items into the auction. I am trying to do something similar to this with Witango. Some of the columns may contain quotation marks to indicate a quote or maybe signify inches. One column contains a number with leading zeroes. Some columns contain html tags. I have tried opening the file with excel and saving as a csv file with a | as the delimiter and then reading into Witango. Two problems seem to occur with this method. Columns with number with leading zeroes lose the leading zeros and general columns are enclosed with quotes. Not necessarily a problem unless there are quotes in the field. I also need to be aware of potential SQL injection when importing these files. Anyone have any experience with this and a possible solution? I tried to search the list but I can't find it on the Witango website anymore. Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. winmail.dat
Witango-Talk: url tag
Hi, I am trying to use the url tag to put a rss feed into variable, then parse the variable with dom tag to extract the elements. @ASSIGN NAME=vxml VALUE='@URL LOCATION=http://feeds.feedburner.com/mnt/healthnews?format=xml;' scope=method @ASSIGN NAME=myDom SCOPE=application VALUE='@DOM VALUE=@VAR vxml SCOPE=Method' The error I get is: An error occurred while parsing the XML. The input ended before all started tags were ended. Last tag started was 'description' I have used the same code with other websites successfully. Seems like there a truncation occurring. Is there a size limit for the @assign, the @url or the @dom tag? Using witango 6 (free version) on windows xp with apache. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: url tag
What would be a safe number? Double it? [MAXRESULTSIZE=128000] Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Ben Johansen [mailto:b...@webspinr.com] Sent: Thursday, December 09, 2010 8:58 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: url tag you probably need to set [MAXRESULTSIZE=size] default value for this attribute is 64K, see docs for @URL On Dec 9, 2010, at 5:35 AM, Ted Wolfley wrote: Hi, I am trying to use the url tag to put a rss feed into variable, then parse the variable with dom tag to extract the elements. @ASSIGN NAME=vxml VALUE='@URL LOCATION=http://feeds.feedburner.com/mnt/healthnews?format=xml;' scope=method @ASSIGN NAME=myDom SCOPE=application VALUE='@DOM VALUE=@VAR vxml SCOPE=Method' The error I get is: An error occurred while parsing the XML. The input ended before all started tags were ended. Last tag started was 'description' I have used the same code with other websites successfully. Seems like there a truncation occurring. Is there a size limit for the @assign, the @url or the @dom tag? Using witango 6 (free version) on windows xp with apache. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. Ben Johansen http://www.webspinr.com b...@webspinr.com Phone: 360-597-3372 Mobile: 360-600-7775 To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: RE: odbc connection to rbase database
Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce422462484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database You should upgrade to Oterro 9.0 – it’s the latest version. I believe (not completely sure) that the database can be on a different machine, but the Oterro driver needs to be on the same machine as the Witango engine. Steve Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) Steve Sweeney Co-Founder (925) 876-3100 - Tel www.webkpi.com http://www.webkpi.com/ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:53 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Which version? We have oterro 2.6 that we use with RTango but would like to upgrade to Witango. Also, does the Rbase database need to be on the same machine as Witango? Thanks Ted From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:15 PM To: Witango-Talk@witango.com Subject: Witango-Talk: RE: odbc connection to rbase database All you need is the Oterro driver, available from R:BASE Technologies, Inc – 724-733-0053. It works great! Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:19 AM To: Witango-Talk@witango.com Subject: Witango-Talk: odbc connection to rbase database Hi, Does anyone know if it is possible to connect to a RBase 7.6 database with Witango? If so, how did you do it. Thanks Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body
RE: Witango-Talk: RE: odbc connection to rbase database
The Witango server is also using sql server odbc datasources with pooling on. The ajax queries work with rbase 7.6, oterro 2.6 and RTango all on the same machine. I also posted to the RBase list but still no response. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:28 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database According to the small bit of log below, the failure to connect occurred on the 4th concurrent request. It seems that Oterro is either not allowing multiple requests or there is a limit to the number of requests/connections that can be active/opened at once. Have you found that setting datasourcelife=0 is necessary with Oterro? It is not a recommended configuration. Robert From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 2:50 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce422462484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database You should upgrade to Oterro 9.0 – it’s the latest version. I believe (not completely sure) that the database can be on a different machine, but the Oterro driver needs to be on the same machine as the Witango engine. Steve Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) Steve Sweeney Co-Founder (925) 876-3100 - Tel www.webkpi.com http://www.webkpi.com/ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:53 AM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Which version? We have oterro 2.6 that we use with RTango but would like to upgrade to Witango. Also, does the Rbase database need to be on the same machine as Witango? Thanks Ted From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:15 PM To: Witango-Talk@witango.com Subject: Witango-Talk: RE: odbc connection to rbase database All you need is the Oterro driver, available from R:BASE Technologies, Inc – 724-733-0053. It works great! Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax
RE: Witango-Talk: RE: odbc connection to rbase database
Yes. The new Oterro 9 is suppose to be unlimited connections. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:38 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database So upgrading to Oterro 9 and splitting between two server seems to have introduced the problem? From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 3:49 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database The Witango server is also using sql server odbc datasources with pooling on. The ajax queries work with rbase 7.6, oterro 2.6 and RTango all on the same machine. I also posted to the RBase list but still no response. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:28 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database According to the small bit of log below, the failure to connect occurred on the 4th concurrent request. It seems that Oterro is either not allowing multiple requests or there is a limit to the number of requests/connections that can be active/opened at once. Have you found that setting datasourcelife=0 is necessary with Oterro? It is not a recommended configuration. Robert From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 2:50 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce422462484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database You should upgrade to Oterro 9.0 – it’s the latest version. I believe (not completely sure) that the database can be on a different machine, but the Oterro driver needs to be on the same machine as the Witango engine. Steve Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) Steve Sweeney Co-Founder (925) 876-3100 - Tel www.webkpi.com http://www.webkpi.com/ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:53 AM To: Witango
RE: Witango-Talk: RE: odbc connection to rbase database
Also, the problem also occurs between physical servers besides virtual servers. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:38 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database So upgrading to Oterro 9 and splitting between two server seems to have introduced the problem? From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 3:49 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database The Witango server is also using sql server odbc datasources with pooling on. The ajax queries work with rbase 7.6, oterro 2.6 and RTango all on the same machine. I also posted to the RBase list but still no response. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:28 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database According to the small bit of log below, the failure to connect occurred on the 4th concurrent request. It seems that Oterro is either not allowing multiple requests or there is a limit to the number of requests/connections that can be active/opened at once. Have you found that setting datasourcelife=0 is necessary with Oterro? It is not a recommended configuration. Robert From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 2:50 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce422462484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database You should upgrade to Oterro 9.0 – it’s the latest version. I believe (not completely sure) that the database can be on a different machine, but the Oterro driver needs to be on the same machine as the Witango engine. Steve Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) Steve Sweeney Co-Founder (925) 876-3100 - Tel www.webkpi.com http://www.webkpi.com/ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11
RE: Witango-Talk: RE: odbc connection to rbase database
Datasourselife =30 and oterro odbc pooling off with the same results. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:46 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Have you tested setting datasourcelife above 0? From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 3:59 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Yes. The new Oterro 9 is suppose to be unlimited connections. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:38 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database So upgrading to Oterro 9 and splitting between two server seems to have introduced the problem? From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 3:49 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database The Witango server is also using sql server odbc datasources with pooling on. The ajax queries work with rbase 7.6, oterro 2.6 and RTango all on the same machine. I also posted to the RBase list but still no response. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, November 17, 2010 3:28 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database According to the small bit of log below, the failure to connect occurred on the 4th concurrent request. It seems that Oterro is either not allowing multiple requests or there is a limit to the number of requests/connections that can be active/opened at once. Have you found that setting datasourcelife=0 is necessary with Oterro? It is not a recommended configuration. Robert From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, November 17, 2010 2:50 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database Hi, The setup: 2 window 2003 virtual servers, one has the rbase 7.6 database, the other server has Witango 5.5 and Oterro 9 unlimited. The only change to the Witango.ini file is datasoucelife=0 The Oterro odbc has pooling enabled. A simple taf with multiple database queries in a top-down structure works fine. The problem: Trying to render a taf with ajax database queries, the pages hang with none of the ajax queries connecting to the database. If I run the ajax queries separately, the page renders. Sometimes the first ajax query will connect but the others fail. Following error in Witango log: [Error] -4 Unable to connect to the specified data source. 17/11/2010 14:02:46 209.251.52.196 u...@3cfcd3bf795fd7ab4ce422462484 4 189 [Datasource] Unable to open a connection to odbc.demo due to an unknown error during connection Any suggestions? I have no problems using ajax queries when the odbc datasource is sql server. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 29, 2010 5:10 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: RE: odbc connection to rbase database A component of Oterro is the ODBC driver, which needs to be installed on the same machines that Witango is. You’ll need to use the ODBC control panel to setup data sources before Witango can access them. I suspect that the ODBC driver can access the Oterro engine across the network, this is how it normally works, but I don’t have it setup here to test. One note, you need to use the 32-bit version. Since Witango 5.5 (and 6.0) are 32-bit applications, they cannot access ODBC connections setup under a 64-bit driver. Going forward, Witango is going to support database connectivity through ODBC and JDBC only. Native drivers are messy to support and will only return to the product if there is enough demand. Robert From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:47 PM
RE: Witango-Talk: Witango service recovery
Hi, We are using windows 2003 and have the same service settings. We also run a batch file every night that use the pskill command to restart the Witango service. Here is the contents: pskill -t witango.exe /accepteula sleep 3 net start Witango Server 5.5 we found that Witango preformed better if it was restarted everyday. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com www.ogdengroup.com -Original Message- From: MC Tay [mailto:sm...@media88.com] Sent: Wednesday, November 10, 2010 11:40 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Witango service recovery Hi: We use Witango service on Windows 2003, Periodically our Witango service just stopped unexpectedly. I just noticed that under the Properties of the Witango Service, there's a Recover tab where you can set the options to recover the service. I have just set the option to Restart the Service on First Failure, Second Failure and Subsequent Failures. Has anyone done this on their Windows 2003 server? Does it restart the Witango service when it gone death suddenly? I couldn't tell yet not until the Witango service stops again. Thanks! MC To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Witango service recovery
Never noticed having that issue with Restart the service settig, only issue we have is that Witango will hang once in a great while but I think that is from a database query but that is very rare. Is the Witango service actually stopping? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com www.ogdengroup.com -Original Message- From: MC Tay [mailto:sm...@media88.com] Sent: Wednesday, November 10, 2010 12:25 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Witango service recovery Hi Ted: Yes, we also restart Witango every night. But, my problem is the Witango service will just gone death unexpectedly during work day from time to time. Will the Restart the service work in the Recover setting? Thanks! MC At 10:05 AM 11/10/2010, you wrote: Hi, We are using windows 2003 and have the same service settings. We also run a batch file every night that use the pskill command to restart the Witango service. Here is the contents: pskill -t witango.exe /accepteula sleep 3 net start Witango Server 5.5 we found that Witango preformed better if it was restarted everyday. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com www.ogdengroup.com -Original Message- From: MC Tay [mailto:sm...@media88.com] Sent: Wednesday, November 10, 2010 11:40 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Witango service recovery Hi: We use Witango service on Windows 2003, Periodically our Witango service just stopped unexpectedly. I just noticed that under the Properties of the Witango Service, there's a Recover tab where you can set the options to recover the service. I have just set the option to Restart the Service on First Failure, Second Failure and Subsequent Failures. Has anyone done this on their Windows 2003 server? Does it restart the Witango service when it gone death suddenly? I couldn't tell yet not until the Witango service stops again. Thanks! MC To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Server Free Edition
Hi, Will the free version have the functionality to use objects? Ted From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Sunday, October 17, 2010 5:07 AM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Server Free Edition I have to say, I love the whole new feel to the way this product is sold. Good on you Robert, your success is ours and vice-versa. Wayne Irvine On 17/10/2010, at 1:01 AM, Anthony Humphreys anth...@humphreys.org wrote: Excellent!!! Way Cool! On Fri, Oct 15, 2010 at 11:21 AM, Robert Shubert rshub...@tronics.com wrote: Explanation of the Free License: The Free server edition is limited in the number of user sessions (10) and threads (5) that it can process at any one given time. The Free server is officially a replacement for the Lite, Small Business, and Developers licenses. It is also intended to be used for pre-purchase trial and testing, to support validation, demoing, and burn-in on new systems and it can be used to support small hobbyist and personal sites. Robert From: Bill Downall [mailto:bdown...@downallconsulting.com] Sent: Friday, October 15, 2010 11:03 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Server Free Edition Robert, What is the Free edition of the Witango Application Server License, shown on the Licensing page at witango.com? Is that an option for a development machine? Thanks. Bill To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
Witango-Talk: odbc connection to rbase database
Hi, Does anyone know if it is possible to connect to a RBase 7.6 database with Witango? If so, how did you do it. Thanks Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: RE: odbc connection to rbase database
Which version? We have oterro 2.6 that we use with RTango but would like to upgrade to Witango. Also, does the Rbase database need to be on the same machine as Witango? Thanks Ted From: Steve Sweeney [mailto:steve_swee...@addesigns.com] Sent: Wednesday, September 29, 2010 2:15 PM To: Witango-Talk@witango.com Subject: Witango-Talk: RE: odbc connection to rbase database All you need is the Oterro driver, available from R:BASE Technologies, Inc – 724-733-0053. It works great! Steve Sweeney Advanced Database Designs LLC http://www.addesigns.com/ 2551 San Ramon Valley Blvd., Suite 217 San Ramon, CA 94583 925-838-8394 (Office) 925-838-8673 (Fax) 925-876-3100 (Cell) From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Wednesday, September 29, 2010 11:19 AM To: Witango-Talk@witango.com Subject: Witango-Talk: odbc connection to rbase database Hi, Does anyone know if it is possible to connect to a RBase 7.6 database with Witango? If so, how did you do it. Thanks Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field
If the date form field is blank don’t include the date insert section as part of the insert statement. Best way is to use the Direct DBMS action. Ted From: WebDude [mailto:webd...@cipromo.com] Sent: Monday, September 13, 2010 1:46 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Updating or Inserting NULL into MSSQL datetime field Hello, Can this be done? I have a table where they need to sort by date. The column is a datetime filed to sort dates correctly. we also need to be able to update the date, delete the date (make null) or keep the date null on an insert. Keeping the dat null on insert is fairly easy, but what if they want to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db. Can an insert of NULL be written in SQL? I tried he obvious... @IFEMPTY @ARG dateNULL@ELSE@ARG date/@IF, @IFEMPTY @ARG dateDbNull.value@ELSE@ARG date/@IF, etc... Has anyone done this before? Thanks! To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to lists...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Announcement - Witango under new ownership
Congratulations Robert Ted From: supp...@witango.com [mailto:supp...@witango.com] Sent: Monday, August 02, 2010 2:44 PM To: Witango-Talk@witango.com Subject: Witango-Talk: Announcement - Witango under new ownership To the Witango community: Tronics Software LLC has purchased the Witango product suite from Witango Technologies Pty Ltd. We at Tronics Software are extremely excited to launch this new chapter for Witango, and we are dedicated to the ongoing support and development of the Witango products. Over the next few days and weeks we will be releasing further information about our plans for Witango, the timing of the version 6.0 release, and pricing details. We are also committed to supporting and expanding the Witango community, and we will be launching community forums and a development blog shortly. We will post all announcements to the list and to the witango.com http://www.witango.com website - please check back often! Thank you all for your continued support of Witango, Tronics Software LLC Tronics Software LLC is a software development company in New Jersey, part of the Tronics group of companies founded by Robert Shubert. Robert has been a part of the Witango community since 1998 and owns Tronics, the leading Witango web hosting provider. To contact Tronics Software with questions, please email supp...@witango.com mailto:supp...@witango.com or call (570) 647-4370. To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body. To unsubscribe from this list, please send an email to mails...@witango.com with unsubscribe witango-talk in the body.
RE: Witango-Talk: Spammers
Hi, I tried a CAPTHA but didn't have any luck. Then I read it is better to have the person uncheck a checkbox before submitting. Ted From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Tuesday, April 20, 2010 3:20 PM To: witango-talk@witango.com Subject: Witango-Talk: Spammers I had a little misfortune this last weekend. I have a Recommend It program on our commerce sites where someone can recommend the site to their friends by entering up to 3 email address and a personal comment and then the program emails accordingly. You guessed it, I believe someone wrote a crone program to use this to send out spam. Started on Saturday afternoon and ended when I caught it Monday morning. Ironically the ip address originates down under in Australia. They must be familiar with the taf extension down there. LOL What are you guys doing to prevent this. CAPTCHA? Or some other strategy? If it is CAPTCHA, could you recommend where I could obtain a bunch CAPTCHA images so I can create this step to hopefully keep spammers from using the program.? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Multiple Sorts
Here is a quick example, all in a Results Action: order of columns returned: company, lname, state, customerid build the sort: @ASSIGN NAME=vsortorder VALUE= SCOPE=user @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF Sort the results set, checking if there is results first or it will error: @IFEMPTY VALUE=@@request$ResultSet @else @IFEMPTY VALUE=@@request$vsortorder @else @SORT ARRAY=ResultSet scope=request COLS=@VAR vsortorder SCOPE=User /@IF /@IF I did the example in ascending order, it can also be done in descending or both directions, just add additional @elseif to the sortorder statements. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 7:31 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Well... That's the way I do it. But it seems that you cannot have a blank variable or multiple sorts within 1 variable... Or am I missing something here. Do you have an example? -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Monday, March 01, 2010 10:13 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts I found it better and faster to do the sort after the results are returned in the Results Action. Use a user variable and keep appending to the beginning, then use the variable in the sort tag. Remember to have a way to clear the sort and the variable Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Mon 3/1/2010 7:29 PM To: witango-talk@witango.com Subject: Witango-Talk: Multiple Sorts Typically in the past, I load a sort into a variable and then add that variable as a sort in the search function... I then use an argument to change the sorts... @IFEQUAL @ARG sort 1@ASSIGN sort company_info.company/@IF @IFEQUAL @ARG sort 2@ASSIGN sort company_info.lname/@IF @IFEQUAL @ARG sort 3@ASSIGN sort company_info.state/@IF @IFEQUAL @ARG sort 4@ASSIGN sort company_info.customer_id/@IF I've been going around and around on this... is there anyway to hold onto the sorts so, let's say, they click on Company first, and then click on last name, they get a sort by lname, company. An thus, if they click next on State, they get a sort of state, lname, company... and so on. I'm sure this has comeup before... I just can't find the answer. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Multiple Sorts
One correction, delete the @ASSIGN NAME=vsortorder VALUE= SCOPE=user line before the first if statement or the sortorder will only sort on one column. -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 8:32 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Here is a quick example, all in a Results Action: order of columns returned: company, lname, state, customerid build the sort: ASSIGN NAME=vsortorder VALUE= SCOPE=user @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF Sort the results set, checking if there is results first or it will error: @IFEMPTY VALUE=@@request$ResultSet @else @IFEMPTY VALUE=@@request$vsortorder @else @SORT ARRAY=ResultSet scope=request COLS=@VAR vsortorder SCOPE=User /@IF /@IF I did the example in ascending order, it can also be done in descending or both directions, just add additional @elseif to the sortorder statements. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 7:31 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Well... That's the way I do it. But it seems that you cannot have a blank variable or multiple sorts within 1 variable... Or am I missing something here. Do you have an example? -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Monday, March 01, 2010 10:13 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts I found it better and faster to do the sort after the results are returned in the Results Action. Use a user variable and keep appending to the beginning, then use the variable in the sort tag. Remember to have a way to clear the sort and the variable Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Mon 3/1/2010 7:29 PM To: witango-talk@witango.com Subject: Witango-Talk: Multiple Sorts Typically in the past, I load a sort into a variable and then add that variable as a sort in the search function... I then use an argument to change the sorts... @IFEQUAL @ARG sort 1@ASSIGN sort company_info.company/@IF @IFEQUAL @ARG sort 2@ASSIGN sort company_info.lname/@IF @IFEQUAL @ARG sort 3@ASSIGN sort company_info.state/@IF @IFEQUAL @ARG sort 4@ASSIGN sort company_info.customer_id/@IF I've been going around and around on this... is there anyway to hold onto the sorts so, let's say, they click on Company first, and then click on last name, they get a sort by lname, company. An thus, if they click next on State, they get a sort of state, lname, company... and so on. I'm sure this has comeup before... I just can't find the answer. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Multiple Sorts
My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @VAR vsortorder@COMMENTJust so I can watch it/@COMMENT @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF P /P TABLE BORDER=0 TR VALIGN=TOP ALIGN=LEFT TD Ba href=@APPFILE?_function=listsort=1Company/a/B /TD TD Ba href=@APPFILE?_function=listsort=2Lname/a/B /TD TD Ba href=@APPFILE?_function=listsort=3State/a/B /TD TD Ba href=@APPFILE?_function=listsort=4ID/a/B /TD /TR @ROWS TR VALIGN=TOP TD A HREF=@APPFILE?_function=detaillogin_request_uid1=@COLUMN login_request.ID ENCODING=URL@UserReferenceArgument@COLUMN login_request.Company/A /TD TD @COLUMN login_request.Lname /TD TD @COLUMN login_request.State /TD TD @COLUMN login_request.ID /TD /TR /@ROWS /TABLE P /BODY /HTML -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 7:35 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts One correction, delete the @ASSIGN NAME=vsortorder VALUE= SCOPE=user line before the first if statement or the sortorder will only sort on one column. -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 8:32 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Here is a quick example, all in a Results Action: order of columns returned: company, lname, state, customerid build the sort: ASSIGN NAME=vsortorder VALUE= SCOPE=user @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@@request$vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user
RE: Witango-Talk: Multiple Sorts
Put the ResultSet from the initial search in an user variable and only replace it when a new search is preformed. Sort the user$ResultSet then display pages using the start and stop attributes of the @ROWS START=@@request$vstart STEP=1 STOP=@@request$vstop ARRAY= /@ROWS tag. Ted From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com http://cipromo.com/ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3
RE: Witango-Talk: Multiple Sorts
If you are using SQL SERVER you can actually use both. Set the number of results to be returned using the SET ROWCOUNT n option; Then use the ORDER BY SQL to retrieve the latest n records. Remember to use SET ROWCOUNT 0 to turn off the option. In DirectDBMS: SET ROWCOUNT 100; Select * from table order by date desc; SET ROWCOUNT 0; You now have the Resultset available for sorting. Ted From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 1:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and @ROWS start=/stop= only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This will usually work, but can be deadly if you are working with many thousands of rows or more. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com http://cipromo.com/ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY
RE: Witango-Talk: Multiple Sorts
Set Rowcount is an sql server option that limits the number of rows returned. I used date as an example. Ted From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 1:57 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts SET ROWCOUNT n? Where is this? date desc;? no date here John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com http://cipromo.com/ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 12:45 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL SERVER you can actually use both. Set the number of results to be returned using the SET ROWCOUNT n option; Then use the ORDER BY SQL to retrieve the latest n records. Remember to use SET ROWCOUNT 0 to turn off the option. In DirectDBMS: SET ROWCOUNT 100; Select * from table order by date desc; SET ROWCOUNT 0; You now have the Resultset available for sorting. Ted From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 1:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and @ROWS start=/stop= only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This will usually work, but can be deadly if you are working with many thousands of rows or more. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com http://cipromo.com/ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got
RE: Witango-Talk: Multiple Sorts
Now that I think about it, the WHERE limits the results, ORDER BY just sorts. In Witango, I found it is faster to retrieve the limited unsorted Resultset and do the sorting in Witango. Ted From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 1:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and @ROWS start=/stop= only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This will usually work, but can be deadly if you are working with many thousands of rows or more. Robert From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 12:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com http://cipromo.com/ From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 11:13 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Not very pretty, but this works great! Thanks! @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=1 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 1 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 2 @COMMENTlname/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=2 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=2 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 2 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 3 @COMMENTstate/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=3 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=3 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 3 NUM ASC REPLACESTR=' /@IF @ELSEIF EXPR=@ARG sort= 4 @COMMENTcustomerid/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=4 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder VALUE=4 NUM ASC, @VAR vsortorder SCOPE=User SCOPE=user @ASSIGN vsortorder '@REPLACE STR=@VAR vsortorder FINDSTR=, 4 NUM ASC REPLACESTR=' /@IF @ELSE @COMMENTdefault/@COMMENT @ASSIGN NAME=vsortorder VALUE= SCOPE=user /@IF @IFEMPTY VALUE=@VAR ResultSet @else @IFEMPTY VALUE=@VAR vsortorder @else @SORT ARRAY=ResultSet scope=local COLS=@VAR vsortorder SCOPE=User /@IF /@IF -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 9:48 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is 1,2,3,4 and the new sort to be added is 3 to make the sort 3,1,2,4 you have to remove the existing 3 first. Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 10:25 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to @VAR vsortorder it works fine. Now that being said... I get to around 5 clicks (in which the sorts all work exactly as planned) and then Witango crashes. I am muxing the result array somehow. I am not sure how to post the sort arguments... Do I need to do a search for every post of the sort? Here is what I have so far. By the way... Thank you for the help... I appreciate it. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD TITLEMatching Records/TITLE /HEAD BODY @IF EXPR=@ARG sort= 1 @COMMENTcompany/@COMMENT @IFEMPTY VALUE=@VAR vsortorder @ASSIGN NAME=vsortorder VALUE=1 NUM ASC SCOPE=user @else @ASSIGN NAME=vsortorder
RE: Witango-Talk: Multiple Sorts
I found it better and faster to do the sort after the results are returned in the Results Action. Use a user variable and keep appending to the beginning, then use the variable in the sort tag. Remember to have a way to clear the sort and the variable Ted -Original Message- From: WebDude [mailto:webd...@cipromo.com] Sent: Mon 3/1/2010 7:29 PM To: witango-talk@witango.com Subject: Witango-Talk: Multiple Sorts Typically in the past, I load a sort into a variable and then add that variable as a sort in the search function... I then use an argument to change the sorts... @IFEQUAL @ARG sort 1@ASSIGN sort company_info.company/@IF @IFEQUAL @ARG sort 2@ASSIGN sort company_info.lname/@IF @IFEQUAL @ARG sort 3@ASSIGN sort company_info.state/@IF @IFEQUAL @ARG sort 4@ASSIGN sort company_info.customer_id/@IF I've been going around and around on this... is there anyway to hold onto the sorts so, let's say, they click on Company first, and then click on last name, they get a sort by lname, company. An thus, if they click next on State, they get a sort of state, lname, company... and so on. I'm sure this has comeup before... I just can't find the answer. Thanks! TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafwinmail.dat
RE: Witango-Talk: @callmethod
Thanks for your help but I figured it out after reading the @callmethod syntax more carefully. My method action has an input and an output parameters so using the following code, the second parameter receives the output array: @CALLMETHOD OBJECT='vInfogatherobj' SCOPE='Domain' METHOD='sqlarray(@VAR vsqlstatement SCOPE=Request,@VARPARAM NAME=varrayout SCOPE=request)' METHODTYPE='invoke' The confusion came when I dragged over the Call Method and Assign Results to Variables tag from Objects under the Meta Tags . This tag does not work with parameters. @ASSIGN NAME= SCOPE= VALUE=@CALLMETHOD OBJECT= SCOPE= METHOD=() METHODTYPE=invoke Should of known the tag was the problem since it was also missing an ending . Ted From: Dale Graham [mailto:dale.gra...@gmail.com] Sent: Wednesday, February 24, 2010 4:31 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: @callmethod Just a thought, but if you refer to an array in other Witango calls, they are called this way array='request$vsqlstatement' NOT array='@@request$vsqlstatement' That is, Witango is looking for an array as a variable, and therefore the @var or @@ is presumed already and you will (typically) get the request$__t28 sort of response when you miscall an array. If you're still having issues using Bill's format, try changing it by calling the arrays that way and see if that fixes things. On Feb 24, 2010, at 1:22 PM, Bill Downall wrote: Ted, Try: @callmethod object='domain$vInfogatherobj' method='sqlarray(@@reqeust$vsqlstatement, @varparam name=vArrayOut scope=request)' methodtype='invoke' Bill On Wed, Feb 24, 2010 at 12:15 PM, Ted Wolfley t...@ogdengroup.com wrote: I am trying to convert some method actions to the @callmethod tag with parameters but I cannot get the results into a variable. The @callmethod tag without parameters works fine. Here is my object creation, query being used and the method call: @ASSIGN NAME=varrayout VALUE='@CALLMETHOD OBJECT=vInfogatherobj SCOPE=Domain METHOD=sqlarray(@@request$vsqlstatement,) METHODTYPE=get' SCOPE=request The method action takes 2 parameters (an input and an output), @@request$vsqlstatement and @@request$varrayout I've tried @ASSIGN NAME=varrayout VALUE='@CALLMETHOD OBJECT=vInfogatherobj SCOPE=Domain METHOD=sqlarray(@VARPARAM NAME=vsqlstatement scope=request) METHODTYPE=invoke' SCOPE=request 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: @callmethod
Hi, I am trying to convert some method actions to the @callmethod tag with parameters but I cannot get the results into a variable. The @callmethod tag without parameters works fine. Here is my object creation, query being used and the method call: @ASSIGN NAME=vInfogatherobj VALUE='@CREATEOBJECT OBJECTID=InfoGather.tcf TYPE=TCF' SCOPE=domain @ASSIGN NAME=vsqlstatement VALUE=select * from manager2.dbo.usrnames with (nolock) where clientid=@@user$vclientid SCOPE=request @ASSIGN NAME=varrayout VALUE='@CALLMETHOD OBJECT=vInfogatherobj SCOPE=Domain METHOD=sqlarray(@@request$vsqlstatement,) METHODTYPE=get' SCOPE=request I get an output variable that I did not create: request$__t28= The method action takes 2 parameters (an input and an output), @@request$vsqlstatement and @@request$varrayout The documentation is not to clear. I've tried @ASSIGN NAME=varrayout VALUE='@CALLMETHOD OBJECT=vInfogatherobj SCOPE=Domain METHOD=sqlarray(@VARPARAM NAME=vsqlstatement scope=request) METHODTYPE=invoke' SCOPE=request Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Re: Re: Re: Re: Re: Witango-Talk: Your email requires verification verify#NmDRXlNjIXRXailGSJpmjv4ohq5XNy9e
Ben, We get it, No action needed. Ted -Original Message- From: Ben Johansen [mailto:b...@webspinr.com] Sent: Thursday, November 19, 2009 10:18 AM To: witango-talk@witango.com Subject: Re: Re: Re: Re: Re: Re: Witango-Talk: Your email requires verification verify#NmDRXlNjIXRXailGSJpmjv4ohq5XNy9e This message is a reply to a boxtrapper verifcation message. No action is needed on your part. The headers of the message sent from your address are shown below: From owner-witango-t...@witango.com Thu Nov 19 09:17:54 2009 Received: from 177.137.55.203-static.velocitynet.com.au ([203.55.137.177]:4358 helo=mail.witango.com) by gator945.hostgator.com with esmtps (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from owner-witango-t...@witango.com) id 1NB8lY-Qt-W9 for b...@webspinr.com; Thu, 19 Nov 2009 09:17:54 -0600 Received: from gateway12.websitewelcome.com ([69.93.82.6]) by mail.witango.com (IceWarp 9.4.2) with SMTP id AAK10848 for witango-talk@witango.com; Fri, 20 Nov 2009 02:17:48 +1100 Received: (qmail 7741 invoked from network); 19 Nov 2009 15:31:01 - Received: from gator945.hostgator.com (174.120.83.98) by gateway12.websitewelcome.com with SMTP; 19 Nov 2009 15:31:01 - Received: from webspinr by gator945.hostgator.com with local (Exim 4.69) (envelope-from b...@pcforge.com) id 1NB8lL-OZ-4J for witango-talk@witango.com; Thu, 19 Nov 2009 09:17:35 -0600 X-Boxtrapper: 0gs99hjF8ycFQIcriJ6dp_Ew4FiQG4Og X-Autorespond: 0gs99hjF8ycFQIcriJ6dp_Ew4FiQG4Og Precedence: auto_reply X-Precedence: auto_reply From: Ben Johansen b...@pcforge.com To: witango-talk@witango.com Subject: Re: Re: Re: Re: Re: Witango-Talk: Your email requires verification verify#NmDRXlNjIXRXailGSJpmjv4ohq5XNy9e Message-Id: e1nb8ll-oz...@gator945.hostgator.com Date: Thu, 19 Nov 2009 09:17:35 -0600 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - gator945.hostgator.com X-AntiAbuse: Original Domain - witango.com X-AntiAbuse: Originator/Caller UID/GID - [849 849] / [47 12] X-AntiAbuse: Sender Address Domain - pcforge.com Reply-To: witango-talk@witango.com X-Spam-Status: No, score=1.5 X-Spam-Score: 15 X-Spam-Bar: + X-Spam-Flag: NO TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [off] JS pulldown/select-option question
Hi, You could use ajax and load the city field after they enter the zip code, if you have the zip code for each city. Ted From: Anthony Humphreys [mailto:anth...@humphreys.org] Sent: Tuesday, November 10, 2009 11:20 AM To: witango-talk@witango.com Subject: Witango-Talk: [off] JS pulldown/select-option question 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: sql server 2005 odbc pooling
Thanks, Already have the pooling off and the datasource life at 30, I'll give the other option a try. Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Friday, October 23, 2009 3:27 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: sql server 2005 odbc pooling Pooling is done within .net, and pooling is done similar to how witango uses persistent connections. I would try using Datasource life on witango to 30 or so, and then turn pooling off. Then I would test with pooling on and witango datasource life at 0, and see which performs better, but I wouldn't use with both on. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 22, 2009, at 4:55 PM, Ted Wolfley wrote: Hi, Came across an article that suggests boasting application connection speed for the sql server odbc by enabling pooling in the sql server odbc driver. The sql server odbc driver installs with pooling off. Has anyone tried enabling with Witango? witango 5.5 on window 2003 32-bit sql server 2005 x64 on windows 2003 x64 Thanks. Ted 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: sql server 2005 odbc pooling
Hi, Setting the Witango datasource life to 0 and enabling pooling is definitely quicker. The only problem I have come across is if there is a separate insert action and then try to retrieve the new id of the inserted row in a selection action immediately after, the select falls to return the id because the connection has been closed. Combining the insert and select statements in a DirectDBMS should be the solution. Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Friday, October 23, 2009 3:27 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: sql server 2005 odbc pooling Pooling is done within .net, and pooling is done similar to how witango uses persistent connections. I would try using Datasource life on witango to 30 or so, and then turn pooling off. Then I would test with pooling on and witango datasource life at 0, and see which performs better, but I wouldn't use with both on. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 22, 2009, at 4:55 PM, Ted Wolfley wrote: Hi, Came across an article that suggests boasting application connection speed for the sql server odbc by enabling pooling in the sql server odbc driver. The sql server odbc driver installs with pooling off. Has anyone tried enabling with Witango? witango 5.5 on window 2003 32-bit sql server 2005 x64 on windows 2003 x64 Thanks. Ted 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: sql server 2005 odbc pooling
Please post the blog link when finished. Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Friday, October 23, 2009 3:06 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: sql server 2005 odbc pooling You need to change that to a a directdbms, and make 2 queries in one call. I am actually doing a blog on this issue with of persistent connections and pooling. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 23, 2009, at 9:40 AM, Ted Wolfley wrote: Hi, Setting the Witango datasource life to 0 and enabling pooling is definitely quicker. The only problem I have come across is if there is a separate insert action and then try to retrieve the new id of the inserted row in a selection action immediately after, the select falls to return the id because the connection has been closed. Combining the insert and select statements in a DirectDBMS should be the solution. Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Friday, October 23, 2009 3:27 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: sql server 2005 odbc pooling Pooling is done within .net, and pooling is done similar to how witango uses persistent connections. I would try using Datasource life on witango to 30 or so, and then turn pooling off. Then I would test with pooling on and witango datasource life at 0, and see which performs better, but I wouldn't use with both on. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com http://eventpix.com/ 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 22, 2009, at 4:55 PM, Ted Wolfley wrote: Hi, Came across an article that suggests boasting application connection speed for the sql server odbc by enabling pooling in the sql server odbc driver. The sql server odbc driver installs with pooling off. Has anyone tried enabling with Witango? witango 5.5 on window 2003 32-bit sql server 2005 x64 on windows 2003 x64 Thanks. Ted TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: autocomplete speed comparison
Hi, We created a simple ajax autocomplete retrieving name and company from a sql server 2005 table on another server. We compared 2 different options. Both servers are Windows 2003 32-bit Using Witango 5.5, the query request took 528ms. Using ASP.Net, the query request took 34 ms The sql statement is the same for both queries Wondering if someone could give an explanation why there is so much difference in speed and is there a way to speed up the Witango query. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: autocomplete speed comparison
Witango speed stayed about the same on repeat queries and the datsourcelife is set at the default. The ajax taf is tiny and using the Direct_DBMS for the query via a tcf. The database connection is opened at login to the site. I guess we will go with the .NET version until we see what Witango 6 has to offer. Thanks Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Tuesday, October 06, 2009 10:12 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: autocomplete speed comparison ODBC and persistent connections would be my guess, as long as ALL OTHER variables are equal. Repeat the query a few times, and see if it is faster. Witango is most likely using ODBC connector and .NET is using a more native, optimized connection. Witango will always take longer on its FIRST query to a connection, due to the overhead of opening a connection from scratch. Witango will then hold that connection in memory and try to reuse it, saving time on subsequent queries. This seems efficient, but it actually ends up wasting memory on both the witango side and especially the db server side. Check the documentation on the datasourcelife configuration variable. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 6, 2009, at 6:44 AM, Ted Wolfley wrote: Hi, We created a simple ajax autocomplete retrieving name and company from a sql server 2005 table on another server. We compared 2 different options. Both servers are Windows 2003 32-bit Using Witango 5.5, the query request took 528ms. Using ASP.Net, the query request took 34 ms The sql statement is the same for both queries Wondering if someone could give an explanation why there is so much difference in speed and is there a way to speed up the Witango query. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: autocomplete speed comparison
Tested both odbc, with the same result. Thanks for all the help, not going to dwell on it any longer. The autocompleter needs to keep up with the typist and that means go with the faster code. Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Tuesday, October 06, 2009 11:10 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: autocomplete speed comparison Witango is probably always going to be slower, but 528ms seems excessive. TCF vs TAF should only add a couple of milliseconds. The other thing I would check is how you specify the datasource in the ODBC connection setup for witango. Try using an ip address if you are using a hostname. I have seen where dns is slow and can cause this. It could also be that you are using a version of the SQL 2005 ODBC driver that witango isn't too happy with, I have also seen where changing versions of ODBC can have a significant impact. It is difficult, because witango is so out of date that you have to setup a machine with older versions of software that witango is comfortable with. We have 2 small witango servers still serving a few old apps and we have to use OLD java version 1.4, older mysql ODBC drivers, etc etc. If you can't find a quick solution to the huge difference, I would stick with .net and save the headaches. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 6, 2009, at 7:54 AM, Ted Wolfley wrote: Witango speed stayed about the same on repeat queries and the datsourcelife is set at the default. The ajax taf is tiny and using the Direct_DBMS for the query via a tcf. The database connection is opened at login to the site. I guess we will go with the .NET version until we see what Witango 6 has to offer. Thanks Ted From: Robert Garcia [mailto:wita...@bighead.net] Sent: Tuesday, October 06, 2009 10:12 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: autocomplete speed comparison ODBC and persistent connections would be my guess, as long as ALL OTHER variables are equal. Repeat the query a few times, and see if it is faster. Witango is most likely using ODBC connector and .NET is using a more native, optimized connection. Witango will always take longer on its FIRST query to a connection, due to the overhead of opening a connection from scratch. Witango will then hold that connection in memory and try to reuse it, saving time on subsequent queries. This seems efficient, but it actually ends up wasting memory on both the witango side and especially the db server side. Check the documentation on the datasourcelife configuration variable. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com http://eventpix.com/ 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Oct 6, 2009, at 6:44 AM, Ted Wolfley wrote: Hi, We created a simple ajax autocomplete retrieving name and company from a sql server 2005 table on another server. We compared 2 different options. Both servers are Windows 2003 32-bit Using Witango 5.5, the query request took 528ms. Using ASP.Net http://ASP.Net/ , the query request took 34 ms The sql statement is the same for both queries Wondering if someone could give an explanation why there is so much difference in speed and is there a way to speed up the Witango query. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf 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: And We're Back To Silence
But the one question that has been weighing on everyone's mind: How's Sophie? Ted From: Anthony Humphreys [mailto:anth...@humphreys.org] Sent: Thursday, September 24, 2009 3:43 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: And We're Back To Silence 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: And We're Back To Silence
Thanks, didn't even think of that but I don't use fb that regularly. So which profile is the correct one? ted -Original Message- From: Dan Stein [mailto:d...@dss-db.com] Sent: Thu 9/24/2009 4:50 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: And We're Back To Silence and if you really care about the wade family and how they are doing in general he is of course like many of us on FB so friend him -- Dan Stein MSN FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 303 W. Chestnut St Souderton PA 18964 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango,MSSQL, MySQL,PHP d...@dss-db.com www.dss-db.com 'I wonder why we say that people are of different races. It seems to me, we're all running at the same speed and heading towards the same destination. The only winners are the ones who've made the world a better place for having been here.' From for Better or Worse 2/28/2006 On Sep 24, 2009, at 4:08 PM, Stefan Gonick wrote: I don't think that snide comments are helpful. I understand that they are coming from a place of frustration. Phil, I know that you are not a communicator, but it would really be helpful if you could respond one more time before being out of touch for another lengthy period. Just be honest with us instead of non-responsive. We want more news about version 6. If all you can say is that you're working on it but can't give us an estimate as to when it will be done, that would at least be respecting us by giving a response. Please. Stefan At 03:43 PM 9/24/2009, you wrote: Shhh! Genius at work... On Thu, Sep 24, 2009 at 3:40 PM, Steve Smith ssm...@oakbridge.ca wrote: Interesting... Steve Smith Oakbridge Information Solutions Oakville Office: (416) 628-0793 Cambridge Office: (519) 489-0142 Email: ssm...@oakbridge.ca Web: www.oakbridge.ca Certified DayLite Master Partner FileMaker Solutions Alliance Member MoneyWorks Consultant LightSpeed Authorized Reseller TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafwinmail.dat
RE: Witango-Talk: License Keys
But the list got active if only for a short while. Getting bored watching it. Ted From: Dan Stein [mailto:d...@dss-db.com] Sent: Tuesday, September 22, 2009 2:33 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: License Keys Robert, And not to beat a dead horse but I am confused as to why this whole discussion ended up on the list. What is done off the list of course stays off the list. But putting it out there that you are going to do something you have to know is illegal just does not make sense. Why the need to make a statement to the list. This should have all stayed back channel. The thread should just end now and everyone should follow their own conscience. It would be nice to hear from Phil but thats a real long shot. Meanwhile 5.x still works and serves us well while we all obviously have been moving to PHP or something else. -- Dan Stein MSN FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 303 W. Chestnut St Souderton PA 18964 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango,MSSQL, MySQL,PHP d...@dss-db.com www.dss-db.com EDI,SQL 2000, MySQL, CWP d...@dss-db.com www.dss-db.com It is perfectly safe to stand nowhere. On Sep 22, 2009, at 1:54 PM, Scott Cadillac wrote: Robert, It may not appear so to some, but your statements to Phil are nothing but a thinly veiled threat. Phil owns the rights to these licenses and has sole control over them, and your assumption and ultimatum adds up to nothing less than extortion. Give your head a shake. Scott, On Sep-22-2009, at 1:16 PM, Robert Garcia wrote: No offense to me. I just keep getting requests from people asking for help, which would include a key. I understand their issue. They are mostly moving off of witango, but have a need due to demands on their own systems that requires a bridge. So one person that I know well enough from the board asks for a key, ok. Then 10 more come. At this point, I don't feel as comfortable, but feel horrible not helping, when I feel they have been left in a really bad spot. I would drop a few more thousand dollars on a key, would you? So I felt I couldn't just leave them hanging high and dry, and I shouldn't just pass out keys. So I have sent a message to phil and posted, if they don't respond, then I will post them. I guess I didn't need to add the dungeon food comment at the end, but that is the rough edge this situation has bought out in me. So, for the record, again: Phil, Many people feel stranded, and I have received more than a few requests for license keys to help them bridge to another platform. It is my assumption due to unreturned emails, and lack of any updates that this product (witango application server and studio) is dead. If the product is dead, these keys are of no use to me, and only of temporary use to others and may be released to those requesting. If the product is NOT dead, or there IS some update, please inform me in public here on the list, or in private if you wish so that I will no longer consider the product dead (EOL). -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 rgar...@bighead.net - rgar...@eventpix.com http://bighead.net/ - http://eventpix.com/ On Sep 22, 2009, at 8:48 AM, Mark Weiss wrote: Scott, As much respect as I have for Robert, and I do, he isn't perfect as we all know. We aren't either. Reminds me of a story.. Mother having a baby. In distress. Country doctor can't be found. He finally shows up, sees the situation acts quickly and it seems everything was resolved. A few days later, the mother died of the disease the doctor was treating at the home prior to arriving to deliver the baby. The father became angry and more angry. This doctor should have been more careful. He should not be allowed to practice. A terrible wrong had been committed and he needed to pay for it. One day, this man's spiritual leader offered this council. John, leave it alone. Nothing you can do will bring her back. Everything you do will only make it worse. John, leave it alone. Many years later, the bereaved father said, I was an old man before I could see. I was an old man before I saw a country doctor, over worked underpaid, saving lives for the most part, with few tools and implements. I would have ruined his life and my own, except for the wise counsel of my spiritual leader, John, leave it alone. As angry as I have been over how poorly I have been
RE: Witango-Talk: Test for talk list..
Still here, working hard and saving money for the upcoming Witango conference to promote the latest Witango software. Ted From: Kaustav Acharya [mailto:kacha...@colleges.com] Sent: Friday, July 10, 2009 2:03 PM To: witango-talk@witango.com Subject: Witango-Talk: Test for talk list.. We seem to have stopped getting the witango talk for several months. Is anyone still around? Kaustav Acharya Web Developer U. Inc. 12264 El Camino Real, Suite #401 San Diego, CA. 92130 Office: (858) 847-3350 x1004 Fax: (858) 847-3340 email: kacha...@colleges.com http://www.colleges.com Power to the People - http://www.campaign.com Important Note: This e-mail may contain privileged, undisclosed or confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform kacha...@colleges.com Immediately and permanently destroy the original transmittal. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: db connection string in Tango
Hi, Using direct dbms action, here is sample of a call I use that passes a parameter and returns a value. DECLARE @return_value int, @vmatrixido int SELECT @vmatrixido = 0 EXEC @return_value = [dbo].[ps_matrix] @vordernumberlist = N'@@user$vordernumberlist', @vmatrixido = @vmatrixido OUTPUT SELECT @vmatrixido as N'@vmatrixido' SELECT 'Return Value' = @return_value Ted -Original Message- From: George [mailto:gkass...@rogers.com] Sent: Thursday, May 21, 2009 12:03 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: db connection string in Tango Rick, I'm curious to know how you would call store proc's in witango. Do you also pass parameters? Thx George On May 21, 2009, at 9:47 AM, Rick Sanders r...@webenergy-sw.com wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: @totalrows
The Direct DBMS returns an array so put the number of row of the array into a variable. @ASSIGN NAME=totalrows VALUE='@NUMROWS ARRAY=@VAR resultSet SCOPE=Request' SCOPE=request Ted From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Wednesday, April 22, 2009 12:24 PM To: witango-talk@witango.com Subject: Witango-Talk: @totalrows Probably should know this! The Search Action provides a check box to return a number that will be provided by the tag @totalrows indicating the total number of rows matching the criteria specified in the Search action. The Direct DBMS action does not provide this check box. I am specifying the number of rows to retrieve and @totalrows will be different from @numrows. Is there a way to get the totalrows without retrieving all of them, same as in the Search Action? FYI: I am using MySQL. Thanks Steve Fogelson TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: iis connection timeout setting
Hi, We are trying to troubleshoot a hanging Witango server (windows 2003 web edition, Witango 5.0 server, IIS 6.0) and we noticed that the IIS connection timeout had been increased to 600 seconds (default 120 seconds). Is 10 minutes to long for a connection timeout? We are considering lowering it the default value. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: witango 5.5 restart
Hi, I have a crontab on a Windows 2003 server that restarts the Witango service every morning at 12 am. Occasionally the Witango service hangs while shutting down and I have to restart the server. I'm thinking the cause is the open connections to Witango and Witango is trying to close them. Is there a way to drop all the connections before restarting the Witango service? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: flushing log buffer
Hi, We have a website that is very reliable but does hang sometimes. Logging level is set to 1 but when the server does hang, the last thing that Witango is processing is not written to the log file before we have to restart the server. Is there a way to flush the log buffer to the log file before restarting? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 t...@ogdengroup.com mailto:t...@ogdengroup.com www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: User defined SQL function
Are you using the @datetosecs on an insert or update to the database? Transact-sql has DATEDIFF that allows results in seconds. If you want to use the ms sql statement only, in a direct-dbms: select DATEDIFF(s,Begin_date,End_date) Ted -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2008 1:18 PM To: witango-talk@witango.com Subject: Witango-Talk: User defined SQL function Does anyone have/use a UDF for MS SQL that works similarly to the @datetosecs Witango metatag? I'm not smart enough to write one. LOL! TIA Tom Ferguson TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Re: Re: Re: Re: Re: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#cofchR30w40KTQzaHheF4
How do I stop Ben from filling up my in box? Ted -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Sunday, September 14, 2008 2:30 PM To: witango-talk@witango.com Subject: Re: Re: Re: Re: Re: Re: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#cofchR30w40KTQzaHheF4tPSosC3Trxz) This message is a reply to a boxtrapper verifcation message. No action is needed on your part. The headers of the message sent from your address are shown below: From [EMAIL PROTECTED] Sun Sep 14 12:29:55 2008 Received: from webspinr by box443.bluehost.com with local-bsmtp (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KewM1-0008R3-Po for [EMAIL PROTECTED]; Sun, 14 Sep 2008 12:29:55 -0600 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on box443.bluehost.com X-Spam-Level: X-Spam-Status: No, score=-0.4 required=5.0 tests=ANY_BOUNCE_MESSAGE,AWL, BAYES_00,CRBOUNCE_MESSAGE,MISSING_MID,NORMAL_HTTP_TO_IP,SPF_NEUTRAL, URIBL_RHS_DOB shortcircuit=no autolearn=no version=3.2.4 Received: from 177.137.55.203-static.velocitynet.com.au ([203.55.137.177] helo=mail.witango.com) by box443.bluehost.com with esmtps (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KewM1-0008OT-Ax for [EMAIL PROTECTED]; Sun, 14 Sep 2008 12:29:49 -0600 Received: from outbound-mail-x1.bluehost.com ([74.220.195.79]) by mail.witango.com (Merak 8.9.1) with SMTP id UBR59353 for witango-talk@witango.com; Mon, 15 Sep 2008 04:29:53 +1000 Received: (qmail 13449 invoked by uid 0); 14 Sep 2008 18:29:43 - Received: from unknown (HELO box443.bluehost.com) (69.89.31.243) by xmail.bluehost.com with SMTP; 14 Sep 2008 18:29:43 - DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=webspinr.com; h=Received:Date:X-Boxtrapper:X-Autorespond:Precedence:X-Precedence:From: To:Subject:X-Identified-User; b=Jhgmlmm4xvPqTVNvvQttMdFmv8pQCchQcKGnp3Tq+73ZCeuRIHQGqNOERyH6A/Z/r05vly NWVWcMrjrjLyCIkDkX0meKDxr6xRc0K2BEiaXb8WE1F1S2IWHE3h9pQIl4; Received: from localhost ([127.0.0.1] helo=box443.bluehost.com) by box443.bluehost.com with esmtp (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KewLv-0008MB-Lt for witango-talk@witango.com; Sun, 14 Sep 2008 12:29:43 -0600 Date: Sun, 14 Sep 2008 12:29:43 -0600 X-Boxtrapper: hozmskVjSu28juBkgdbJcPqbzUrKryOx X-Autorespond: hozmskVjSu28juBkgdbJcPqbzUrKryOx Precedence: auto_reply X-Precedence: auto_reply From: [EMAIL PROTECTED] To: witango-talk@witango.com Subject: Re: Re: Re: Re: Re: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#cofchR30w40KTQzaHheF4tPSosC3Trxz) X-Identified-User: {3228:box443.bluehost.com:webspinr:webspinr.com} {sentby:program running on server} Reply-To: witango-talk@witango.com X-user: 203.55.137.177:box443.bluehost.com:: Message-Id: [EMAIL PROTECTED] X-user-local: {3228:box443.bluehost.com:webspinr:webspinr.com} {sentby:program running on server} TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#HVA_0k5MSnLKXzodmohJaH3AdTSSUUxO)
How many of these to I need to get a prize? Ted -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 11:32 AM To: witango-talk@witango.com Subject: Re: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#HVA_0k5MSnLKXzodmohJaH3AdTSSUUxO) This message is a reply to a boxtrapper verifcation message. No action is needed on your part. The headers of the message sent from your address are shown below: From [EMAIL PROTECTED] Mon Sep 15 09:31:48 2008 Received: from webspinr by box443.bluehost.com with local-bsmtp (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KfG3D-00017W-Mx for [EMAIL PROTECTED]; Mon, 15 Sep 2008 09:31:48 -0600 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on box443.bluehost.com X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=ANY_BOUNCE_MESSAGE,AWL, BAYES_00,CRBOUNCE_MESSAGE,MISSING_MID,NORMAL_HTTP_TO_IP,SPF_NEUTRAL, URIBL_RHS_DOB shortcircuit=no autolearn=no version=3.2.4 Received: from 177.137.55.203-static.velocitynet.com.au ([203.55.137.177] helo=mail.witango.com) by box443.bluehost.com with esmtps (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KfG3D-00011m-9J for [EMAIL PROTECTED]; Mon, 15 Sep 2008 09:31:43 -0600 Received: from outbound-mail-x1.bluehost.com ([74.220.195.79]) by mail.witango.com (Merak 8.9.1) with SMTP id VYU73435 for witango-talk@witango.com; Tue, 16 Sep 2008 01:31:35 +1000 Received: (qmail 6764 invoked by uid 0); 15 Sep 2008 15:31:31 - Received: from unknown (HELO box443.bluehost.com) (69.89.31.243) by xmail.bluehost.com with SMTP; 15 Sep 2008 15:31:31 - DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=pcforge.com; h=Received:Date:X-Boxtrapper:X-Autorespond:Precedence:X-Precedence:From: To:Subject:X-Identified-User; b=lHQ5H40ufLYZSh0XOlzNzXCU2pJt1VQAPvRJOXBx1Zq5f4gYHPJw85MCZTwOllaEtxvBsI SqwOEBhaToKqxjLL8c85jMbD3aDxMHqZDIFlUKptmoTYWBwKJDdBvmSZeh; Received: from localhost ([127.0.0.1] helo=box443.bluehost.com) by box443.bluehost.com with esmtp (Exim 4.69) (envelope-from [EMAIL PROTECTED]) id 1KfG31-wo-1H for witango-talk@witango.com; Mon, 15 Sep 2008 09:31:31 -0600 Date: Mon, 15 Sep 2008 09:31:30 -0600 X-Boxtrapper: 0gs99hjF8ycFQIcriJ6dp_Ew4FiQG4Og X-Autorespond: 0gs99hjF8ycFQIcriJ6dp_Ew4FiQG4Og Precedence: auto_reply X-Precedence: auto_reply From: Ben Johansen [EMAIL PROTECTED] To: witango-talk@witango.com Subject: Re: You have been added to [EMAIL PROTECTED]'s whitelist and your mail has been delivered. (was: Re: Witango-Talk: Your email requires verification verify#HVA_0k5MSnLKXzodmohJaH3AdTSSUUxO) X-Identified-User: {3228:box443.bluehost.com:webspinr:webspinr.com} {sentby:program running on server} Reply-To: witango-talk@witango.com X-user: 203.55.137.177:box443.bluehost.com:: Message-Id: [EMAIL PROTECTED] X-user-local: {3228:box443.bluehost.com:webspinr:webspinr.com} {sentby:program running on server} TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: datasource timeout
How did you get 200 connections? The most we get on one Witango server at one time is 9. Ted From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 12:43 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: datasource timeout A datasourcetimeout of 15-60 minutes is acceptable. All this means is that during times of no/lower activity unused connections will be closed to free up resources. Each ODBC connection consumes memory (about ½ MB I think), today's servers have no problems juggling 10s or even 100s of them. As I write this there are over 200 connections between my Witango services and my SQL server. The nice thing is that if Witango needs to ramp-up to 20-30 connections to service some peak traffic, most of them will timeout during low traffic. Refreshing ODBC connections can be healthy as well. Especially if you have a problem with your SQL server or network, Witango will need to kill off all active connections and make new ones. For you second question, use @HTTPATTRIBUTE to look for these bots at the top of your TAFs and send back a handmade 404 error. Robert From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 11:05 AM To: witango-talk@witango.com Subject: Witango-Talk: datasource timeout Hi, 2 questions: Question 1: On our win2003 box running Witango 5.5, we noticed we have DATASOURCELIFE=1440, a carry over from when we used to run RTango2000 and Oterro ODBC. Has any one run into any problems running the datasourcelife at its default of 30? Our website is getting hit constantly by bots and wondering if lowering the datasourcelife would increase proformance. Queston 2: Related to question 1, in the iis logs, there are a lot of entries that have lwp-trivial/1.41 or LWP::Simple/5.805. Does anyone have a recommendation on how to handle them. They are hitting the site about every 3 seconds. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Please Ignore, trying to fix the bounces
But you didn't answer the question of how many needed for a prize. Ted -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 3:22 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Please Ignore, trying to fix the bounces Ok, sorry for the bouncing of the white-listing messages, as with any setup trying to get it. I think i might have it, I was going off the from: but need the white list the to: This should resolve it On Sep 14, 2008, at 11:24 AM, Ben Johansen wrote: Ben Johansen http://www.webspinr.com [EMAIL PROTECTED] Phone: 360-597-3372 Mobile: 360-600-7775 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: production loglevel at 1
Hi, Does anyone know much of a performance hit there is when logging level is set at 1 on a production server? We have a site that gets crawled by various search bots and it is not unusual to have the daily Witango log around 20-30 mb. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: witango error
Hi, Does anyone know what causes Witango to generate this error: [Error] -3 The application file was either missing or invalid. ? Witango 5.5 running on Windows 2003 Standard Editon SP2. Witango was working correctly and finding the tafs without a problem before generating the error. No changes had been made to the tafs prior to the error. After restarting the server, Witango works correctly. Can a timeout error on a database query cause the problem? The following 2 errors were in the Event viewer under applications. The following information is part of the event: [1676] The application file /artinfo.tcf has timed out in the Results action and has been terminated (719 seconds). The following information is part of the event: [1676] The application file has timed out in the NULL action and has been terminated (630 seconds). Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: cancel a query
A view is being used to link data between 6 tables where the user can search at least 10 fields bringing back about 40 columns. From: MC Tay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 4:12 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: cancel a query If the index is setup properly, querying 1000 records out of 3.5 million records should be pretty fast. We have a query retrieving 500-1000 records from 1.75 million records in a three table joint, and it takes about 3 to 6 seconds. MC At 08:29 AM 3/28/2008, you wrote: Hi, I have a site where a user can submit a complex query to search a 3.5+ million record table. Once submitted, the query is set-up to bring back only the first 1000 records. While waiting for the results, the user hits the back button or closes the browser window, how does Witango handle the cancelling of the query? Does the query still continue until the results are ready to be transferred to Witango? Is there a correct way to cancel the query and restore resources to the server? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf 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: cancel a query
Hi, I have a site where a user can submit a complex query to search a 3.5+ million record table. Once submitted, the query is set-up to bring back only the first 1000 records. While waiting for the results, the user hits the back button or closes the browser window, how does Witango handle the cancelling of the query? Does the query still continue until the results are ready to be transferred to Witango? Is there a correct way to cancel the query and restore resources to the server? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Using an array for In Search
Hi, Here is what I do, I put the array into an variable using the csuffix and add a ) after the array variable tag. Then I use the replace function looking for the ,) that is a the end of the comma delimited list. Example: @ASSIGN NAME='vcommalist' VALUE='@VAR varray[*,1] SCOPE=Request type=text aprefix= asuffix= rprefix= rsuffix= cprefix= csuffix=,)' SCOPE='request' @ASSIGN NAME=vcommalist VALUE=@REPLACE STR='@@request$vcommalist' FINDSTR=',)' REPLACESTR=')' SCOPE=request Ted -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 8:16 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Using an array for In Search Thanks guess I was over thinking it I had that but didn't try it. As usually witango does the hard work. -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com I destroy my enemies when I make them my friends. Abraham Lincoln From: Alan Wolfe [EMAIL PROTECTED] Reply-To: witango-talk@witango.com witango-talk@witango.com Date: Tue, 18 Mar 2008 16:41:07 -0700 To: witango-talk@witango.com witango-talk@witango.com Subject: Re: Witango-Talk: Using an array for In Search Ive tried this before by building an sql query as a string then putting it in a direct DBMS. We hit problems though when the string got too long, our DB didn't accept the query anymore. So, if you go this way you might want to check the maximum length query your DB supports and make sure that's enough space for your worst case scenario, but yeah you can deffinately do this (: On 3/18/08, Walker, Buddy [EMAIL PROTECTED] wrote: Dan Not sure if this what you are talking about but this is what I've done in a search action Column Oper.Value MasterVisitID.CourseID Is in @VAR uDeptCourses SCOPE=USER [*,1] UDeptCourses is a one column array. Buddy From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 7:28 PM To: witango-talk@witango.com Subject: Witango-Talk: Using an array for In Search I want to use an array of ID's to do an in search. I am trying to figure out how to take the array and return it as a comma delimited string without the trailing comma that shows up with csuffix=, Is there a simple way way assign this to a variable and lose that comma? Seems there should be -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals 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: SQL Generated Query
You could always put the sql statement into a variable and use the variable in a Direct DBMS action. Not only do you have the results in a variable but also the sql statement that was run. Ted -Original Message- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 2:56 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: SQL Generated Query Your memory is not that fuzzy. *laughs* What you pointed out is the same code you get if you open a SQL window and drag a query action into it. However, I want to write the actual query string to a database and that little trick does not help. For example, if a query action have three vars in the criteria section and two of them are null the string generated completely omits those conditions. Rightly so. So I would like to be able to see what the SQL generated code is on every execution of a given query action and I'll be damned if I can find a way of doing it in Witango. If Robert has requested this feature I suspect there is no way to currently do this in Witango. -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 2:47 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: SQL Generated Query Hi Gene, If my fuzzy memory serves me correctly, if you right-click on a database Action, you should have an option for SQL Query, which opens a little query utility that contains your generated SQL statement. I think it may also contain your metatags (for your WHERE clause arguments and such) but not the actual values. Hope that helps. Scott, On Monday, March 17, 2008 3:24pm, Robert Shubert [EMAIL PROTECTED] said: @SQL is populated with the last run SQL statement - except for the fact that bound values are not shown, which means that you may need to do additional work in certain places to know what was in the bindings. This is my #1 request for v6. Robert _ From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 2:17 PM To: witango-talk@witango.com Subject: Witango-Talk: SQL Generated Query Easy question. Is there any way of obtaining, from Witango, the actual SQL code generated by searches? I know the code is available in the debug dump but It would be really handy to be able to pull a variable that contains that code and be able to write it to a database file for testing and checking. I'd really like to be able to write this code to a database table where I could record employee ID, date and time requested, etc. Thoughts on how to accomplish this? Gene Wolf Supervisor, Business Systems DRS Sensors Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State. __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Graphical charting for Witango 5.5
Hi, We use OWTChart. Open source. http://www.maptools.org/owtchart/ Ted -Original Message- From: Stefan Gonick [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 1:16 PM To: witango-talk@witango.com Subject: Witango-Talk: Graphical charting for Witango 5.5 Hi All, Does anyone know of a simple graphical charting application available for Witango 5.5? Thanks, Stefan = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: performance question
Hi, I have a website running on Windows 2003 using Witango server 5.5.003 pulling data from Sql Server 2000 on a Windows Storage Server 2003. In the taf, there is a group of about 8 database I/O that are used to fill small arrays (scope: request) for use in choice lists each time a page is called, The data will rarely change and never in the same session. The main function of the taf is to search the database and return the most recent 1000 results, if there are that many and putting the results into an user array, which works fine. The taf then display the array in results of 20 using the start and stop of the array loop. When going from one page to another, it takes about 6 seconds. Since the main data is already in an array, the only thing accessing the database is the 8 database I/Os. How much pagination speed would I pick up if I change the small database I/Os to run just once and use user arrays? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: performance question
Hi, All queries are indexed and I agree it would be a good idea to put the small data results into domain arrays. What is the best way to set the domain array, at witango server startup or schedule a taf to run? I forgot one important fact; the site has a page that is also being heavily hit by search bots, Last week, the site was hit by a google bot over 48,000 times in half a day. The Witango log is averaging 25 mg a day at logging level 1. We are also thinking of blocking the bots because the page they are hitting is only returning counts to a calling page. Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 10:17 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: performance question I agree on indexing, but also, a good idea here, is to use the application scope, or the domain scope to cache this data. Unless this data is unique to each user. You just build controls to build your domain arrays, so that your apps have constant access to them, across users. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 25, 2008, at 7:07 AM, Stefan Gonick wrote: Hi Ted, From your description it seems like you have an indexing issue. It shouldn't take so long to do those queries. You might want to look into coming up with good indexes to speed things up. Stefan At 10:05 AM 2/25/2008, you wrote: Hi, I have a website running on Windows 2003 using Witango server 5.5.003 pulling data from Sql Server 2000 on a Windows Storage Server 2003. In the taf, there is a group of about 8 database I/O that are used to fill small arrays (scope: request) for use in choice lists each time a page is called, The data will rarely change and never in the same session. The main function of the taf is to search the database and return the most recent 1000 results, if there are that many and putting the results into an user array, which works fine. The taf then display the array in results of 20 using the start and stop of the array loop. When going from one page to another, it takes about 6 seconds. Since the main data is already in an array, the only thing accessing the database is the 8 database I/Os. How much pagination speed would I pick up if I change the small database I/Os to run just once and use user arrays? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com / http://www.ogdengroup.com / TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf http://www.witango.com/developer/maillist.taf = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com http://www.databasewebworks.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: performance question
Thanks, I'll give it a try. Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 10:51 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: performance question I can tell you how I do it. Create a TCF that loads the domain vars in the oncreate event. I do this in a general widgets tcf. Then put this code at the top of any page that will access the domain vars. !-- Check Peach Widgets Start Timer: @timer -- @if @var domain$widgets type=text contains 'Object' !-- Just Checking the Peach Object Status Listener Address: @var system$listenerAddress:@var system$listenerPort Current Object: @var domain$Widgets -- @else @assign domain$widgets @CREATEOBJECT OBJECTID=widgets.tcf TYPE=TCF !-- Just Creating the Peach Object Status Listener Address: @var system$listenerAddress Created Object: @var domain$widgets -- /@if!-- Check Peach Widgets End Timer: @timer -- You don't need all the timers and comments, but this is what I do, to see in source of page what is going on. so this code will make sure the object exists, if not create. To purge your domain vars, just create and don't check first. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 25, 2008, at 7:48 AM, Ted Wolfley wrote: Hi, All queries are indexed and I agree it would be a good idea to put the small data results into domain arrays. What is the best way to set the domain array, at witango server startup or schedule a taf to run? I forgot one important fact; the site has a page that is also being heavily hit by search bots, Last week, the site was hit by a google bot over 48,000 times in half a day. The Witango log is averaging 25 mg a day at logging level 1. We are also thinking of blocking the bots because the page they are hitting is only returning counts to a calling page. Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, February 25, 2008 10:17 AM To: witango-talk@witango.com mailto:witango-talk@witango.com Subject: Re: Witango-Talk: performance question I agree on indexing, but also, a good idea here, is to use the application scope, or the domain scope to cache this data. Unless this data is unique to each user. You just build controls to build your domain arrays, so that your apps have constant access to them, across users. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://bighead.net/ http://bighead.net/ - http://eventpix.com/ http://eventpix.com/ On Feb 25, 2008, at 7:07 AM, Stefan Gonick wrote: Hi Ted, From your description it seems like you have an indexing issue. It shouldn't take so long to do those queries. You might want to look into coming up with good indexes to speed things up. Stefan At 10:05 AM 2/25/2008, you wrote: Hi, I have a website running on Windows 2003 using Witango server 5.5.003 pulling data from Sql Server 2000 on a Windows Storage Server 2003. In the taf, there is a group of about 8 database I/O that are used to fill small arrays (scope: request) for use in choice lists each time a page is called, The data will rarely change and never in the same session. The main function of the taf is to search the database and return the most recent 1000 results, if there are that many and putting the results into an user array, which works fine. The taf then display the array in results of 20 using the start and stop of the array loop. When going from one page to another, it takes about 6 seconds. Since the main data is already in an array, the only thing accessing the database is the 8 database I/Os. How much pagination speed would I pick up if I change the small database I/Os to run just once and use user arrays? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com / http://www.ogdengroup.com / TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf http://www.witango.com/developer/maillist.taf = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com http://www.databasewebworks.com
Witango-Talk: witango ftp upload form
Hi, Has anyone created or found a way to use witango to ftp a file from the local machine and not the server that witango is setting on? I can successfully ftp from the witango server to the ftp site with the external action but witango can't find the file on my workstation. I have found php pages on the web that I may have to use. Of course, I could wait for Witango 6 with its built-in ftp upload. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: witango ftp upload form
We are also uploading the files now but the files are getting too big and the upload ties up the witango server.. Ted From: Driscoll, Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 12:24 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form We do this But we actually upload the file to the server then use the external command using ftp text file to upload the file to the site Kevin -- Sent from my BlackBerry Wireless Handheld -Original Message- From: Ted Wolfley To: witango-talk@witango.com Sent: Wed Feb 13 12:32:18 2008 Subject: Witango-Talk: witango ftp upload form Hi, Has anyone created or found a way to use witango to ftp a file from the local machine and not the server that witango is setting on? I can successfully ftp from the witango server to the ftp site with the external action but witango can't find the file on my workstation. I have found php pages on the web that I may have to use. Of course, I could wait for Witango 6 with its built-in ftp upload. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: witango ftp upload form
Using the witango file action to upload a 10 mg file seems to take a lot of witango resources and slows down displaying of other witango pages on the server. Looking for a one-step work around. Considering having a webpage to collect file info and have the user use an ftp client to upload the file, a two step process. Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 1:39 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form do you mean, witango sends it to ftp server, before saving it on YOUR server first? If that is what you mean, its not possible, because of the way witango works with your webserver. The file is completely transferred to the webserver before being handed over to witango. We have written special upload handlers, to allow progress bar uploading, and throttling, and other cool features. We do this by handling the upload byte by byte, this is NOT possible in witango. It is also not possible in PHP. It is possible with some very low level .net coding, and it is also possible by creating a CGI script, like in perl or something. If you submit your upload to a perl cgi, for example, you could write it to accept data in memory and at the same time connect and send to an FTP server. This would be very troublesome, and I wouldn't recommend it, unless you were sure of 100% uptime and great bandwidth up to the ftp server from the witango server. You would basically be holding/caching the http upload to cgi in memory as you pull from the memory to the ftp server. I would think you are better off, investing in larger more reliable network storage on your server side, accept the entire upload, and then ftp up to wherever and delete. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 10:44 AM, Ted Wolfley wrote: User submits file thru the witango webpage and witango ftp the file to another server without writing to the ftp server first. From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 1:24 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form Do you mean, the local machine, as in the user hitting the web page, or the local machine, as in the web server machine, which may be different from the witango server? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 9:32 AM, Ted Wolfley wrote: Hi, Has anyone created or found a way to use witango to ftp a file from the local machine and not the server that witango is setting on? I can successfully ftp from the witango server to the ftp site with the external action but witango can't find the file on my workstation. I have found php pages on the web that I may have to use. Of course, I could wait for Witango 6 with its built-in ftp upload. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: witango ftp upload form
User submits file thru the witango webpage and witango ftp the file to another server without writing to the ftp server first. From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 1:24 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form Do you mean, the local machine, as in the user hitting the web page, or the local machine, as in the web server machine, which may be different from the witango server? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 9:32 AM, Ted Wolfley wrote: Hi, Has anyone created or found a way to use witango to ftp a file from the local machine and not the server that witango is setting on? I can successfully ftp from the witango server to the ftp site with the external action but witango can't find the file on my workstation. I have found php pages on the web that I may have to use. Of course, I could wait for Witango 6 with its built-in ftp upload. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: witango ftp upload form
Window Server 2003 Web Edition Service Pack 2 Pentium 4 2.79 GHz, 1.98GB of RAM IIS V6.0 Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 2:08 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form Due to my work at eventpix, I have spent 100s of hours on upload work, and research and coding. Witango doesn't handle the upload. The webserver handles the upload from the form, and when the upload is complete, the webserver hands the file/data in a wrapper over to witango. So the witango server doesn't even see the uploaded file, until the upload is complete. So if you are seeing a slow down, it is your webserver that is slowing things down. What web server are you using, IIS? And which version? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 11:09 AM, Ted Wolfley wrote: Using the witango file action to upload a 10 mg file seems to take a lot of witango resources and slows down displaying of other witango pages on the server. Looking for a one-step work around. Considering having a webpage to collect file info and have the user use an ftp client to upload the file, a two step process. Ted From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 1:39 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form do you mean, witango sends it to ftp server, before saving it on YOUR server first? If that is what you mean, its not possible, because of the way witango works with your webserver. The file is completely transferred to the webserver before being handed over to witango. We have written special upload handlers, to allow progress bar uploading, and throttling, and other cool features. We do this by handling the upload byte by byte, this is NOT possible in witango. It is also not possible in PHP. It is possible with some very low level .net coding, and it is also possible by creating a CGI script, like in perl or something. If you submit your upload to a perl cgi, for example, you could write it to accept data in memory and at the same time connect and send to an FTP server. This would be very troublesome, and I wouldn't recommend it, unless you were sure of 100% uptime and great bandwidth up to the ftp server from the witango server. You would basically be holding/caching the http upload to cgi in memory as you pull from the memory to the ftp server. I would think you are better off, investing in larger more reliable network storage on your server side, accept the entire upload, and then ftp up to wherever and delete. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 10:44 AM, Ted Wolfley wrote: User submits file thru the witango webpage and witango ftp the file to another server without writing to the ftp server first. From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 1:24 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: witango ftp upload form Do you mean, the local machine, as in the user hitting the web page, or the local machine, as in the web server machine, which may be different from the witango server? -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 13, 2008, at 9:32 AM, Ted Wolfley wrote: Hi, Has anyone created or found a way to use witango to ftp a file from the local machine and not the server that witango is setting on? I can successfully ftp from the witango server to the ftp site with the external action but witango can't find the file on my workstation. I have found php pages on the web that I may have to use. Of course, I could wait for Witango 6 with its built-in ftp upload. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http
RE: Witango-Talk: is witango alive?
Here and coding away with Witango Ted -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Friday, January 25, 2008 3:03 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: is witango alive? Maybe no news is good news as far as the list being quiet. Nobody is reporting problems, maybe things are just working smoothly for everyone (: Either that or everybody else has left... Maybe we should have a roll-call? PRESENT, and I brought my pencil ;-) Scott, TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: witango log file analysis
Hi, Has anyone created or come across a program to analyze witango log files? We want to look for bottlenecks in our websites. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.ogdengroup.com http://www.ogdengroup.com/ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: https
Hi, We have Witango 5.5 running on Windows 2003 with https for the site. Witango is pulling in images for display from a Window Storage Server 2003. In IE, the non-secure items dialog box is appearing even though the images' directory is set up as a virtual directory on the Witango server. Witango is translating the virtual directory address to the nonsecure http address. What is the best way to set up the servers so you can pull the images and not get the warning? Putting a https certificate on the Storage Server is not an option. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: https
Never mind, figured it out. Simple typing error. I guess I should have walked away from it earlier. Thanks. Ted From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 11:55 AM To: witango-talk@witango.com Subject: Witango-Talk: https Hi, We have Witango 5.5 running on Windows 2003 with https for the site. Witango is pulling in images for display from a Window Storage Server 2003. In IE, the non-secure items dialog box is appearing even though the images' directory is set up as a virtual directory on the Witango server. Witango is translating the virtual directory address to the nonsecure http address. What is the best way to set up the servers so you can pull the images and not get the warning? Putting a https certificate on the Storage Server is not an option. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: upgrade question
Hi, We running version 5.5.003 Liquorice (Win32) on window 2003 server. I noticed that latest version on the Witango website is 5.5.020. Is there a cost to upgrade or this just a replacement for the previous version? Does the original license key work for the upgrade? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: beta list
Hi, I just joined the beta list and got the confirmation email but I keep getting refused by the beta list because I do not have permission. Is anyone else having this problem? My question for the studio 6 is where are the editor preferences so I can set the tab size, font size and font type? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: beta list
That was a big DUH Thanks Ben From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 2:15 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: beta list Did you reply to the first beta confirm email, and get the second one saying successful? On Aug 15, 2007, at 6:01 AM, Ted Wolfley wrote: Hi, I just joined the beta list and got the confirmation email but I keep getting refused by the beta list because I do not have permission. Is anyone else having this problem? My question for the studio 6 is where are the editor preferences so I can set the tab size, font size and font type? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: No Messages?
None for me either and I am in the office. Ted -Original Message- From: Mcgriff, Gary S. (MSFC-IS50) [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 3:38 PM To: witango-talk@witango.com Subject: Witango-Talk: No Messages? No messages for me in a week? 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: branching to html?
Hi, Hi, You could record the selection before opening the swf in a separate window. When the user is done with the swf, the window is closed and they are back to the menu. Ted -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 5:27 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: branching to html? Hi, I don't have the source for the Flash files (neither do I have MAcromedia). So, at present, I can do the following: a) the user logs in (ie to a .taf) b) user can choose one of the .swf files to run (or exit) c) the .swf file runs fine and then it calls a .taf file to update the database (I think this will work ok) Now want to exit this .taf and go back to the start (part (b)) ... that's the problem thanks Norm Original Message Subject: RE: Witango-Talk: branching to html? From: John Arnold [EMAIL PROTECTED] Date: Thu, June 21, 2007 1:37 pm To: witango-talk@witango.com So is the problem directing them to the correct flash file? or recording the completion? Because including the html should work just fine. You can even include variables and other tags in your included html if you like. Heck, dynamically building the embed in a result would be fine too. If you're trying to record a successful completion, you need to add a call to your movie to call a page when its done. The page call could be XML and load variables in the movie, or refresh the page to a menu for the next selection. --- [EMAIL PROTECTED] wrote: ok, here's exactly what I'd like to do. a) I have 5 flash files (.swf) b) the user logs in (ie to a .taf) c) user can choose one of the .swf files to run (or exit) d) when .swf file complete, the database is updated (recording user's progress) e) user can choose one of the .swf files to run (or exit) so @include won't work rmand I think the redirect will lose context so I don't have the logini info any more. any ideas? thanks No Original Message Subject: Re: Witango-Talk: branching to html? From: Jason Pamental [EMAIL PROTECTED] Date: Thu, June 21, 2007 10:35 am To: witango-talk@witango.com Norman, I don't think you can use the 'branch' action to do anything other than branch to another part of a taf or a different taf file. You could however use 'include' to bring the html file in. Depends on what you're trying to accomplish really in order to figure out the best possible approach. Feel free to outline more completely what you're trying to do. Jason - Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] On Jun 21, 2007, at 1:25 PM, [EMAIL PROTECTED] wrote: Hi, I'd like to branch out of my .taf file to a .html file (and perhaps some other types of files to) and then return to the .taf is there any way to do this? thanks Norman __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Visit us at http://www.northsails.com [This E-mail scanned for viruses by Declude Virus] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Array Rows to columns Help
Hi, This should work table tr @ROWS START=1 STEP=1 ARRAY=@@array td a href=link.taf?letter_from=@@array[@currow,2] letter_to=@@array[@currow,3]@@array[@currow,1]/a /td /@ROWS /tr /table -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, May 31, 2007 3:10 PM To: witango-talk@witango.com Subject: Witango-Talk: Array Rows to columns Help I have an array that looks like this AA-AC AA AC AD-AF AD AF Etc. I want to display it like this AA-AC AD-AF AG-AR ... And I want each one to be a link that contains the the letter_from=AA letter_to=AC I am not sure how to manipulate the array so I show only the letter spans but have the to and from in the Href. It has to display on the horizontal -- -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com It is perfectly safe to stand nowhere. 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: Stumped
Hi, If D is null in the database, the value of the input box is null. Set the value of the input box to what the value should be if checked. Ted -Original Message- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 2:13 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Stumped um... ok. I intended to set the value of D on the form to the current value in the database. If the database is null, it will be unchecked, if the database is 1 it will be checked. I must be having a space cadet moment, but doesn't checking the box make the value 1?? -Original Message- From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 01:21 To: witango-talk@witango.com Subject: Re: Witango-Talk: Stumped You've defined the checked value of D to be NULL. when you check it, you get NULL submitted Bill William M. Conlon, P.E., Ph.D. To the Point 2330 Bryant Street Palo Alto, CA 94301 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com On Apr 11, 2007, at 10:06 AM, Tom Ferguson wrote: I've got a form that has a series of checkboxes. They are defined as follows: INPUT NAME=D TYPE=CHECKBOX VALUE=@COLUMN 'BlastMailList.D' @IFEQUAL @COLUMN BlastMailList.D ENCODING=MULTILINE 1CHECKED/@IFD If I check one of the checkboxes, it does not update the field in the database. When I put it in debug mode, the args are there but the newly checked arg shows a null value. However, if I uncheck one of the checked values, it works. What am I missing here?? Here is the debug: A, B, and C have a value of 1 in the database. I checked D, but it comes across as null. [Application File] [50] START /intranet/editBlastList.taf Tango_2000_Server _function=updateBlastMailList_uid1=21_UserReference=B188C6555103D10A 461CF0 DC A=1 B=1 C=1 D= [EMAIL PROTECTED] FirstName=Mike J=1 LastName=Beatty Salutation= Total Length of Postargs: 83 [user$ Vars] [50] numAffected=1 variableTimeout=30 [If Action] [50] IfForm [ElseIf Action] [50] ElseIfList [ElseIf Action] [50] ElseIfDetail [ElseIf Action] [50] ElseIfUpdate [Update Action] [50] Update1 [Warning] [50] Missing argument: E [Warning] [50] Missing argument: F [Warning] [50] Missing argument: G [Warning] [50] Missing argument: H [Warning] [50] Missing argument: I [Query] [50] UPDATE dbo.BlastMailList SET FirstName=?,LastName=?,eMail=?,Salutation='',A='1',B='1',C='1',D=NULL, E=NULL ,F=NULL,G=NULL,H=NULL,I=NULL,J='1' WHERE (ID=21) [BoundVals] [50] [v1='Mike'; v2='Beatty'; v3='[EMAIL PROTECTED]'] [Results Action] [66] UpdateResponse [Changed Vars] [66] user$numAffected=1 [Return Action] [66] Return [user$ Vars] [66] numAffected=1 variableTimeout=30 __ __ 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: AJAX Pop-up list
Hi, We just started using AJAX this year and I did a google search on AJAX autocomplete. The code to interact with the database was in php but I just created a taf to handle the requests. It is easier than you think to set up. Ted From: Stefan Gonick [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 2:15 PM To: witango-talk@witango.com Subject: Witango-Talk: AJAX Pop-up list Hi Everyone, I want to do the simplest possible AJAX function for one of my clients. I have never done any AJAX before, so I don't even know where to start and am hesitant to plunge into the whole topic for this simple application. What I am trying to do is as follows: I have a table with 2500 entries that I would like to put in a pop-up list, but it's too many items to be practical. Instead, I would like to use a small text field where I would start typing in a few characters, which would dynamically (AJAX-style) update a separate pop-up list (select field). I probably wouldn't start populating the list until at least 2 characters had been typed to keep the list size reasonable. Has anyone created any simple AJAX already that could give me some pointers for my application? Thanks in advance, Stefan = Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com http://www.databasewebworks.com/ CoachVille: For coaches and people taking teleclasses http http://www.cvcommunity.com/?af=69474 :// www.cvcommunity.com?af=69474 http://www.cvcommunity.com/?af=69474 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Cybersource payment services
Hi, We have a client that is currently using Cybersource for online payments. For the new site that is being created in Witango, what is the best way to implement Cybersouce with Witango. Cybersouce has api for asp/com, c, java, .net, php, and perl. I would like to write the submission form in Witango but don't know the correct way to incorporate any of the above api in Witango so I can submit the data and retrieve the results. Any info would be greatly appreciated. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.ogdengroup.com http://www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Studio Beta?
Phil, Thanks for the update Ted From: Phil Wade [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 13, 2006 7:16 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Studio Beta? On 13/12/2006, at 9:16 AM, Dan Stein wrote: I have heard from reliable source it is not EOL of the release of 5.5 beta and 6 are forthcoming. That said it would seem that the community is way way overdue for an update. Yes there is another release of the 5.5 server coming before Christmas. It is a maintenance release and will include a version for OS X on Intel Macs. We had a few internal issues with the build that we had to rectify before we released it. The rewritten Dev Studio v6 is currently in private testing and we are making good progress on the v6 server which will be released in Q2 2007. Regards Phil TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: choicelist tag problem
Hi, I am trying to use the onChange attribute of the @CHOICELIST to capture the selected value and open a webpage in an iframe with the selected value as an argument. The webpage opens but the value is not captured and not passed. Has anyone know of a way to make this work. I have tried various coding for the onChange, below is the latest with select statements it creates. Ted @CHOICELIST NAME=a_arthouseidc TYPE=SELECT OPTIONS=@@request$varthouses[*,2] VALUES=@@request$varthouses[*,1] SIZE=1 SELECTED=selectedValue SELECTEXTRAS=ID='a_arthouseidc' >window.arthouselocations.location='@appfile?_function=locationsa_arthouseid=window.form1.a_arthouseidc.options[window.form1.a_arthouseidc.selectedIndex].value'/td SELECT NAME=a_arthouseidc return true; SIZE=1 ID='a_arthouseidc' OPTION VALUE=/OPTION OPTION VALUE=1Abell/OPTION OPTION VALUE=491ADER/OPTION OPTION VALUE=1369Adjug'art/OPTION /select Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: choicelist tag problem
Thanks, That worked. I had to change your single quote so it looked like this: FYI, OnChange does work inside and outside the SELECTEXTRAS attribute. I tried both Ben. Ted From: Christian Carrier [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 2:42 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: choicelist tag problem Your on change looks wrong. OnChange should be something more like >window.arthouselocations.location='@appfile?_function=locationsa_arthouseid= + window.form1.a_arthouseidc.options[window.form1.a_arthouseidc.selectedIndex].value Regards, Christian From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 2:47 PM To: witango-talk@witango.com Subject: Witango-Talk: choicelist tag problem Hi, I am trying to use the onChange attribute of the @CHOICELIST to capture the selected value and open a webpage in an iframe with the selected value as an argument. The webpage opens but the value is not captured and not passed. Has anyone know of a way to make this work. I have tried various coding for the onChange, below is the latest with select statements it creates. Ted @CHOICELIST NAME=a_arthouseidc TYPE=SELECT OPTIONS=@@request$varthouses[*,2] VALUES=@@request$varthouses[*,1] SIZE=1 SELECTED=selectedValue SELECTEXTRAS=ID='a_arthouseidc' >window.arthouselocations.location='@appfile?_function=locationsa_arthouseid=window.form1.a_arthouseidc.options[window.form1.a_arthouseidc.selectedIndex].value'/td SELECT NAME=a_arthouseidc return true; SIZE=1 ID='a_arthouseidc' OPTION VALUE=/OPTION OPTION VALUE=1Abell/OPTION OPTION VALUE=491ADER/OPTION OPTION VALUE=1369Adjug'art/OPTION /select Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: client/plugin error
Hi, When I use the search action that brings back over 20,000 records with the Limit to button checked on the Results tab I get the following error at the bottom of the webpage. The error does not appear on results of 15,000 or less. There is no errors appearing in the witangoevents.log. The only reason I am using the search action because it created next and previous buttons at the bottom of the page faster than could code them. Should I create my own code for the next and previous buttons? HTTP/1.1 500 Application Server Error Connection: close Date: Fri, 07 Jul 2006 12:46:46 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Client/Plug-in Error The client encountered problems in communicating with the application server. Please check witangoevents.log for further information. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Upload action
Hi, Does anyone know why the file upload action works on one workstation using IE and not on another workstation using IE. The upload action throws a -303 can not open the specified file error. I works in IE 7 beta but not in IE 6 Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Upload action
Not a permissions problem, me coding problem, I didn't remove the directory structure from the uploaded filename and the file action was trying to write to a non-existent directory. Ted -Original Message- From: Isabelle [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 12:27 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Upload action not a problem on permission directory ? Le 06-06-02, à 12:15, Ted Wolfley a écrit : Hi, Does anyone know why the file upload action works on one workstation using IE and not on another workstation using IE. The upload action throws a -303 can not open the specified file error. I works in IE 7 beta but not in IE 6 Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: [OT] Interesting picture
I added another monitor to my workstation and I couldnt believe how productive it was. Ted From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 2:34 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: [OT] Interesting picture 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: Displaying text with links
Title: Re: Witango-Talk: Displaying text with links Hi, Have you tried encoding=none or encoding=METAHTML? I store html including links in databases and display it without any problems. Ted From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 3:10 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Displaying text with links I think this is a job for regex but I am not sure how to do it. on 5/31/06 14:37, Dan Stein at [EMAIL PROTECTED] wrote: I am using FMP to store text with CSS imbedded so I can let my client format descriptions with bold italic colors etc. So they type this Recommended for ages 7-13 Visit a href="" href="http://www.comev.org.br%3eCOMEV%3c/a%3e.">http://www.comev.org.brCOMEV/a. Abraham -- An epic journey to the Promised Land, a miraculous birth to aged parents, and the story of God's greatest test: Abraham must kill his beloved son upon a sacrificial altar. It loads into the Database this BRRecommended for ages 7-13BRVisit lt;a href="" href="http://www.comev.org.br%3eCOMEV%3c/a%3e.%3cBR%3e%3cBR%3e%3c/SPAN%3e">http://www.comev.org.brgt;COMEVlt;/agt;.BRBR/SPAN SPAN STYLE= font-weight: bold; Abraham/SPAN SPAN STYLE= -- An epic journey to the Promised Land, a miraculous birth to aged parents, and the story of God's greatest test: Abraham must kill his beloved son upon a sacrificial altar.BRBR/SPAN But the Hrref needs to be a link. Do I need to encode the column when I display it? The style works fine but not the link TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com It is perfectly safe to stand nowhere. 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: Basic Method scope question
Dan, This is assuming that you have a parameter called thatarray and this line in the tcf: @SETPARAM NAME=thatarray VALUE=@@method$thatarray In the taf, open the method that is being used to call the array, under parameters, assign the value column for the thatarray parameter to Request and enter your variable name. Ted -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 4:42 PM To: witango-talk@witango.com Subject: Witango-Talk: Basic Method scope question Fro some reason this stuff never ever sticks in my head. Must be because I hardly ever use it. I have a tcf that returns an array in the method scope so method$thatarray ahs a value. I need to get that into a request scope array so I can use it to loop through a set of records and find the 4 ID's that came back. I can't seem to get that into a request scope array. I thought that in the method action if I assign a value of request and a name it would then assign the method scope array that comes back to that request scope The request scope keeps being empty. I did assign it the same name does that matter? -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com There is a larger frame to the painting than the one that bounds our life's events. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: accessing a dll
Hi, We just purchased a text summarization source code (ansi C) with compiled .dlls. The web demo that came with it uses Apache Web Server and ActiveState Perl. I would like to use the dll with Witango. Does anyone have any suggestions on how to access the dll in Witango. The dll does not appear in the Witango add object window. If not, I am going to have to take a crash course in perl. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: @SECSTOTIME tag
the @secstots tag references a timestamp from January 1, 1970. I want the days, hours,minutes and seconds that have elasped froma total number of seconds. Ted From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:38 PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: @SECSTOTIME tag Wrong metatag @secstots not @secstotime On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use @SECSTOTIME SECS="105241". Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Am I totally brain dead?
Hi, have you tried the following or variant: @VAR request$dynamicStuff @IF EXPR='@VERSION beginswith 5.5'ENCODING=META@elseENCODING=METAHTML/@if Ted -Original Message- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 1:06 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Am I totally brain dead? Thank you Bill, I tried your suggestion, but that doesn't help. Placing @@request$fixEnc by itself in the sample returns the value META just fine. The ENCODING attribute is just not accepting it. Am I crazy, or shouldn't any Metatag attribute accept a dynamic value? -Original Message- From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 10:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Am I totally brain dead? How about quoting attributes? @IF EXPR=@VERSION beginswith 5.5 @ASSIGN SCOPE=request NAME=fixEnc VALUE=META @ELSE @ASSIGN SCOPE=request NAME=fixEnc VALUE=METAHTML /@IF On Jan 13, 2006, at 9:48 AM, Scott Cadillac wrote: Thank you Bill, But that part works okay. It's the dynamic setting of the ENCODING attribute that is the problem. The ENCODING attribute does not want to accept a dynamic variable value, and in the case of my example the @VERSION metatag is not evaluating - it's returning the raw text of @VERSION, not executing the metatags. The ENCODING is defaulting to NONE on 5.5, not the META value I'm trying to set. By the way, I've already tried searching the List archive on this, but no luck. Thanks. -Original Message- From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 10:43 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Am I totally brain dead? Try quoting '5.5' I'm betting 5.5 is getting cast as a number. On Jan 13, 2006, at 9:34 AM, Scott Cadillac wrote: Hi All, I know I said I wouldn't do it again, but I couldn't help myself - it felt sooo gd! I'm writing Witango code again, but I'll leave you guessing who I'm working for :-) Why doesn't the following work? Witango 5.0 or 5.5 on Windows. @IF EXPR=@VERSION beginswith 5.5 @ASSIGN request$fixEnc VALUE=META @ELSE @ASSIGN request$fixEnc VALUE=METAHTML /@IF @ASSIGN request$dynamicStuff VALUE=@LITERAL VALUE='@VERSION' @VAR request$dynamicStuff ENCODING=@@request$fixEnc Has it just been so long since writing Witango code for me, that I can't remember some basic principle here? Shouldn't I be able to dynamically set any attribute value for a Metatag? Thank you for any feedback. From ~ Scott Cadillac, Software Programmer For Hire Email ~ [EMAIL PROTECTED] Phone ~ 403-254-5002 Web ~ http://www.xmlx.ca Mail ~ XML-Extranet P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 _ _ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Bill William M. Conlon, P.E., Ph.D. To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[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 Bill William M. Conlon, P.E., Ph.D. To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[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
RE: Witango-Talk: Recording clickthroughs
Thanks, the @CGIPARAM http_search_args is what I was looking for. Ted From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 5:00 PMTo: witango-talk@witango.comSubject: RE: Witango-Talk: Recording clickthroughs The string of text after the question mark should be available with: @CGIPARAM http_search_args If that doesnt work for you, then youll need to reconstruct the argument list using a FOR loop and the array @SEARCHARGNAMES Robert From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 4:04 PMTo: witango-talk@witango.comSubject: Witango-Talk: Recording clickthroughs Hi, I am trying to create a taf to record when some one clicks on a link on my site that takes them to another site. The problem that I am having is in retrieving the arguments after the in the url string. When there is no in the url string, I can redirect to the correct url with out any problems because I know what url argument is. Since the links are coming from a table, I don't know what the additional arguments names are in advance.Is there a way to retrieve the arguments after the so I can recreate the original link and redirect to it? Or is there a better way? Here is an example of a typical url with 2 arguments: http://mywebsite/redirect.taf?url=""> Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Recording clickthroughs
Hi, I am trying to create a taf to record when some one clicks on a link on my site that takes them to another site. The problem that I am having is in retrieving the arguments after the in the url string. When there is no in the url string, I can redirect to the correct url with out any problems because I know what url argument is. Since the links are coming from a table, I don't know what the additional arguments names are in advance.Is there a way to retrieve the arguments after the so I can recreate the original link and redirect to it? Or is there a better way? Here is an example of a typical url with 2 arguments: http://mywebsite/redirect.taf?url=""> Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: calendar display
Hi, Before I start designing it, has anyone created in Witango, a month events calendar where the month display is built on the flyand the dates are hyperlinks to that day's events. Here is an example of what I am looking for built using coldfusion: http://www.cityofrochester.com/index.cfm?app=calendar Thanks in advance Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: calendar display
Thanks, just what I was looking for. Ted From: Robert Shubert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 20, 2005 11:26 AMTo: witango-talk@witango.comSubject: RE: Witango-Talk: calendar display This is some code I threw together for one project. There are some notes at the top about what variables to have available. The calendar it makes is kind of small, but it should be a good starting point for you. Robert From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 20, 2005 11:03 AMTo: witango-talk@witango.comSubject: Witango-Talk: calendar display Hi, Before I start designing it, has anyone created in Witango, a month events calendar where the month display is built on the flyand the dates are hyperlinks to that day's events. Here is an example of what I am looking for built using coldfusion: http://www.cityofrochester.com/index.cfm?app=calendar Thanks in advance Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Variable Datasource info in DBMS
Hi, We use it and haven't had any speed problems. Saves a lot time if you have a lot of actions that require a data source. I even went a step further and created a tcf file that has the DBMS actions in it. One action is for returning result arrays, the other is for no results like insert or update. All I have to pass is the sql statement and data source parameters instead of editing each action in the taf. Ted From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, December 01, 2005 1:39 PMTo: witango-talk@witango.comSubject: Witango-Talk: Variable Datasource info in DBMS Hey guys,I was wondering, is there any kind of penalty or downsite for using variable datasource info (datasource name, login, password) for DBMS actions?Is it slower than just using a staticly named datasource? 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: Choice List Help
Hi, The choice list uses an array for its options and values so your @@request$ptype should be @@request$ptype[*,1] with the column value depending on what column you are using for the values and options. @CHOICELIST NAME=ProgramType TYPE=Radio OPTIONS=@@request$ptype[*,1] VALUES=@@request$ptype[*,1] SELECTED=@COLUMN 'StatePrograms.ProgramType' Ted -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 9:24 AM To: witango-talk@witango.com Subject: Witango-Talk: Choice List Help This does not seem to return HTML with the radio button selected where the values match @CHOICELIST NAME=ProgramType TYPE=Radio OPTIONS=@@request$ptype VALUES=@@request$ptype SELECTED=@COLUMN 'StatePrograms.ProgramType' -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Choice List Help
I do it that way to keep my coding from being confusing. What does the webpage source code display for the radio button values? Does the select value match the value for the radio button? -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 10:38 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Choice List Help Ted. In this case it is a one column array so it works fine as I had it. It is not the radio button that does not show up but the selected is not working nothing is selected. Are you saying I have to do it the way you indicated to get the selected too work? It does not seem that way from the docs. Dan on 11/16/05 9:35, Ted Wolfley at [EMAIL PROTECTED] wrote: Hi, The choice list uses an array for its options and values so your @@request$ptype should be @@request$ptype[*,1] with the column value depending on what column you are using for the values and options. @CHOICELIST NAME=ProgramType TYPE=Radio OPTIONS=@@request$ptype[*,1] VALUES=@@request$ptype[*,1] SELECTED=@COLUMN 'StatePrograms.ProgramType' Ted -Original Message- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 9:24 AM To: witango-talk@witango.com Subject: Witango-Talk: Choice List Help This does not seem to return HTML with the radio button selected where the values match @CHOICELIST NAME=ProgramType TYPE=Radio OPTIONS=@@request$ptype VALUES=@@request$ptype SELECTED=@COLUMN 'StatePrograms.ProgramType' -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com The love of one's country is a splendid thing. But why should love stop at the border? Pablo Casals __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com It is perfectly safe to stand nowhere. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Tracking user time on the site
Hi, I have a client who would like to track the amount of time their personnel spends on each page of the web site. I know I can use the @timer tag to get the elapsed time. I can record the date and time for page entry or when a hyperlink is used to leave a page to get the end time.What wouldbe the best way retrieve the end time when the page is closed? Any info on page time tracking is appreciated. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Dev Studio 5.0
Check your username and password for the connection in the dev studio. Right click on the action and select properties. I have found that sometimes the username and password in this property window is different than the one that comes up when you select a datasource on the right. Ted From: Michael Dittbrenner [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:52 AMTo: witango-talk@witango.comSubject: RE: Witango-Talk: Dev Studio 5.0 Thats the funny thing. I can connect using ODBC from the ODBC administrator with no problem. I can from sql query in the dev studio for windows under the window tab connect. I just cant connect using the database panel so it seems I can connect from everywhere except from the dev studio. Also the server can still connect and pull data just not the dev studio. Mike D Educational Directories Unlimited, Inc. Michael DittbrennerSystems Administratorhttp://www.StudyAbroad.comhttp://www.GradSchools.comA service of EDU, Inc... http://www.EDUdirectories.comA partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/ [Phone] 610-499-9200[Fax] 610-499-9205[E-mail] [EMAIL PROTECTED] or [EMAIL PROTECTED] From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:40 AMTo: witango-talk@witango.comSubject: Re: Witango-Talk: Dev Studio 5.0 It would be using odbc. Whatever port ODBC tells it to. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Nov 9, 2005, at 5:39 AM, Michael Dittbrenner wrote: I wanted to thank you all for your ideas with my database issue. I have found out the cause but dont have a solution yet. I have recently upgraded our db2 databases from v8.1 to v8.2 In doing so it somehow locks the dev studio only out. I have tested it as I was going to deploy a new database but instead decided to run a test. I put 8.1 on it and opened dev studio could get to the database. Upgraded to v8.2 of db2 and closed dev studio and restarted it. I was no longer able to access it. So does the dev studio use some sort of certain port or authentication or anything I need to make sure my database accepts? Any ideas would be greatly appreciated. Mike D Educational Directories Unlimited, Inc. Michael DittbrennerSystems Administratorhttp://www.StudyAbroad.comhttp://www.GradSchools.comA service of EDU, Inc... http://www.EDUdirectories.comA partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/ [Phone] 610-499-9200[Fax] 610-499-9205[E-mail] [EMAIL PROTECTED] or [EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: O.T Auto Fill Form from a DB Call
How about using a frame with the id number at the top and the rest of the form at the bottom. You can hide the dividing line between the two sections to make it look like on page. Use a hidden field for the id number on the bottom. Ted -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 3:57 PM To: witango-talk@witango.com Subject: Witango-Talk: O.T Auto Fill Form from a DB Call Sorry if this is off topic but I have a perplexing problem I am trying to figure out. I was wondering if it is possible to auto fill values into a from by typing in something like a client ID. I don't mean a two page form, that would be easy. But is it possible to have someone fill in the client ID and have the form that is already visable auto fill the rest of the values. I think it would need to do a DB call on a mousedown to do this. Has anyone tried anything like this before? Thanks 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: Selects
Hi, This is the sequence of code that I use. @ASSIGN NAME=vbiglist VALUE=@POSTARG NAME='biglist' TYPE=ARRAY SCOPE=request @ASSIGN NAME='vnewbiglist' VALUE='@VAR vbiglist[*,1] SCOPE=Request type=text aprefix= asuffix= rprefix= rsuffix= cprefix= csuffix=,' SCOPE='request' Ted -Original Message- From: Mark Weiss [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 3:31 AM To: witango-talk@witango.com Subject: Witango-Talk: Selects I asked this before, but I lost the email I guess. When you have a multiple select Statement select size=4 name=biglist multiple /select How do you retrieve the multiple selections into an array that is comma delimited. I had it working by defining the table separators into local variables, but again, I have lost it. Thanks for your help. Mark TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf