Re: TeraScript-Talk: RE: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.15

[Wayne Irvine]

Hey Steve, can't help but just thought you'd like to know someone is following your emails. WayneOn 2 May 2023, at 2:02 pm, Steve Fogelson  wrote:









Loaded another VM with Windows Server 2016 Standard and I am having the same problem.
 

Loaded IISLoaded TeraScript 7.15Loaded Java
jre-8u191-windows-x64Loaded
Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security UpdateLoaded MySQL J Connector 8.0.33.0Setup the CLASSPATH
 
Gotta be missing something.
 
Any suggestions would be appreciated.
 
Thanks
 
Steve
 
 
From: Steve Fogelson 

Sent: Monday, May 1, 2023 11:51 AM
To: TeraScript-Talk@terascript.com
Subject: TeraScript-Talk: RE: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.15


 
Ran into another challenge. Anyone have insight into this?
 
I did put in the CLASSPATH
 
Thanks
 
Steve
 
[ 6876] 2023-05-01 11:13:40 START  INFO Java Virtual Machine: Attempting to load C:\Program Files\Java\jre1.8.0_201\bin\server\jvm.dll
[ 6876] 2023-05-01 11:13:41 START  INFO Java Virtual Machine: Enabled
[ 6876] 2023-05-01 11:13:41 START  INFO COM Interface: Enabled
[ 6876] 2023-05-01 11:13:41 START  INFO JAVABEAN Interface: Enabled
[ 6876] 2023-05-01 11:13:41 START  INFO Web Service: Disabled
[ 6876] 2023-05-01 11:13:41 START  INFO ODBC Interface: Enabled
[ 6876] 2023-05-01 11:13:41 START  WARNING  JDBC Interface: Disabled
[ 6876] 2023-05-01 11:13:41 START  ERROR    Please check jdbc java library is in the server running directory
 

 


From: Steve Fogelson 

Sent: Monday, May 1, 2023 9:05 AM
To: TeraScript-Talk@terascript.com
Subject: TeraScript-Talk: RE: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.15


 
 
I am getting closer. The link was for Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security Update
 
Download Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security Update from Official Microsoft Download Center
 
JVM now loads. 
 
I will do some further testing and if successful post to the forum exactly what needs to be done to run TeraScript with JDBC on Windows 2019
 
Steve
 


From: Steve Fogelson 

Sent: Sunday, April 30, 2023 10:22 PM
To: TeraScript-Talk@terascript.com
Subject: TeraScript-Talk: RE: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.15


 
I just came across something that might help.
 
I was looking at the TeraScript web site and saw this. The problem is the link doesn’t work for Microsoft. Does anyone know what this link is supposed to point to?
 
TeraScript by Tronics Software LLC


Version 7


Known Issues

JVM does not load on certain versions of Windows
The Java installation on some versions of Windows can not find a specific file. Installing this redistributable package from MS should
 correct the issue:
http://www.microsoft.com/en-us/download/details.aspx?id=13523
 
 
Thanks
 
Steve
 


From: Steve Fogelson 

Sent: Sunday, April 30, 2023 7:16 PM
To: TeraScript-Talk@terascript.com
Subject: TeraScript-Talk: RE: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.15


 
I meant to say TeraScript 7.15, not 7.50. I did some research on Java’s site and found that version 8.0_201 was the correct version for Windows 2019.
 
Oracle JDK 8 and JRE 8 Certified System Configurations
 




Windows Server 2019


x64


1.8.0_201


Includes Windows Server 2019 Core. Only 64-bit supported




 
Here is part of the events log and part of server.ini
 
Any ideas or am I chasing something that won’t work.
 
Thanks
 
Steve
 
[ 2856] 2023-04-30 17:42:30 START  INFO Configuration: Loading configuration stanza 'TeraScript Server 7'
[ 2856] 2023-04-30 17:42:30 LICENSE    INFO HyperThreading not enabled. Logical Processors 2; Cores 2; Physical processor packages 1.
[ 2856] 2023-04-30 17:42:30 START  INFO Java Virtual Machine: Attempting to load C:\Program Files\Java\jre1.8.0_201\bin\server\jvm.dll
[ 2856] 2023-04-30 17:42:30 START  ERROR    Java Virtual Machine: JVM specified by JAVAVIRTUALMACHINE in server.ini file did not load: Unable To Load any JVM shared library. 

[ 2856] 2023-04-30 17:42:30 START  INFO     Java Virtual Machine: Disabled
[ 2856] 2023-04-30 17:42:30 START  INFO COM Interface: Enabled
 
_javascript_SWITCH=on
JAVASWITCH=on
JAVAVIRTUALMACHINE=C:\\Program Files\\Java\\jre1.8.0_201\\bin\\server\\jvm.dll
 
 


From: Steve Fogelson 

Sent: Saturday, April 29, 2023 3:45 PM
To: TeraScript-Talk@terascript.com
Subject: TeraScript-Talk: Windows 2019 - IIS 10 - MySQL 8 - TeraScript 7.5


 
Has anyone successfully installed TeraScript 7.5 on Windows 2019 with IIS 10.
 
Seems to be going ok until the server.ini tries to load Java for JDBC connections to MySQL.

 
The events log indicates that JAVA did not load. The version of JAVA is 8.0_191. I know this is not a current version of JAVA but I use it successfully on Windows 2012 – IIS 8.5
 
Does 

Re: TeraScript-Talk: Automatic tag execution

[Wayne Irvine]

I used to use this all the time but it wasn’t working on 7 on OSX. I used 
LaunchDaemons instead.

Wayne

> On 4 Jul 2021, at 7:12 am, Robert Shubert  wrote:
>
> TeraScript has built in CRONTAB functionality that can do this.
>
> In the Programmer's Reference, review the configuration variable named 
> crontabFile.
>
> Robert
>
> -Original Message-
> From: Rich [mailto:r...@ogdengroup.com]
> Sent: Saturday, July 03, 2021 1:18 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Automatic tag execution
>
> I want to build a taf that will run two times a month on specific dates. Is 
> that possible?
>
> Rich
>
> Sent from my iPhone
>
>
> 
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
> 
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>




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

Re: TeraScript-Talk: Terascript

[Wayne Irvine]

I’m still running it on one of my servers. Not sure how supported it is though.

Wayne

> On 24 Jun 2021, at 11:04 am, Rich  wrote:
>
> Is terascript still alive
>
> Rich Jasinski
>
> Sent from my iPhone
>
>
> 
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>




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

Re: TeraScript-Talk: Echo

[Wayne Irvine]

Cheers Robert.

Wayne

> On 2 May 2020, at 12:11 am, Robert Shubert  wrote:
>
> Thanks Wayne,
>
> I'll see if I can get this addressed.
>
> Robert
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Friday, May 01, 2020 6:58 AM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Echo
>
> I have to use the external script as Web Call is giving an SSL Handshake 
> error:
> Error
>
> An error occurred while processing your request:
> File: tdtest.taf
> Position: WebCall2
> Class: Internal
> Main Error Number: -1001
>
> Unable to send data when processing URL request.
> wrong when connecting with SSL SSL peer handshake failed, the server most 
> likely requires a client certificate to connect
>
> File: tdtest.taf
> Position: WebCall2
> Class: Internal
> Main Error Number: -1001
>
> Unable to send data when processing URL request.
> This just started happening on previously working code in November last year. 
> I guess some certificate has expired or something.
>
> Wayne
>
>
>
>> On 1 May 2020, at 11:52 pm, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> As of 6.2, the @URL tag and the Web Call action both utilize cURL under the 
>> hood. It's better to use the native implementation than an external bash 
>> script. Is there some reason you need to do the external script?
>>
>> Robert
>>
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Friday, May 01, 2020 12:34 AM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: Re: TeraScript-Talk: Echo
>>
>> Cheers!
>>
>> Makes for a much simpler workflow.
>>
>> Wayne
>>
>>> On 1 May 2020, at 5:18 pm, ubs...@uw.edu <mailto:ubs...@uw.edu> wrote:
>>>
>>> If using MacOS bash, the Command Line external call action in TS outputs 
>>> results into @@resultset as an array.
>>> A bash script file ( /usr/local/var/www/website/scripts/get_google.sh ) can 
>>> be called in the external action's "command" field:
>>> #!/bin/bash
>>> curl "https://www.google.com/; <https://www.google.com/>
>>>
>>> echo is not required for output
>>> The curl output in this case can then be viewed in html with <@var 
>>> resultset encoding="html">.
>>> The external action outputs (from old user guide):
>>> "A single item result is treated as a one-column row, a list of items is 
>>> treated as a row of columns, and a list of lists is treated as a rowset."
>>>
>>> Check (full) path to file and permissions.
>>>
>>> On 4/30/20 11:01 PM, Wayne Irvine wrote:
>>>> I’m calling a bash script which contains a curl command. How do I get the 
>>>> results of the curl command back to Terascript?
>>>>
>>>> Do I have to prefix the Bash script with echo? And do I use @@resultset in 
>>>> the taf?
>>>>
>>>> Wayne
>>>>
>>>>
>>>>
>>>>
>>>> 
>>>>  To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body.
>>>>
>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.





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

Re: TeraScript-Talk: Echo

[Wayne Irvine]

I have to use the external script as Web Call is giving an SSL Handshake error:
Error

An error occurred while processing your request:

File: tdtest.taf
Position: WebCall2
Class: Internal
Main Error Number: -1001

Unable to send data when processing URL request.
wrong when connecting with SSL SSL peer handshake failed, the server most 
likely requires a client certificate to connect

File: tdtest.taf
Position: WebCall2
Class: Internal
Main Error Number: -1001

Unable to send data when processing URL request.

This just started happening on previously working code in November last year. I 
guess some certificate has expired or something.

Wayne


> On 1 May 2020, at 11:52 pm, Robert Shubert  wrote:
>
> As of 6.2, the @URL tag and the Web Call action both utilize cURL under the 
> hood. It's better to use the native implementation than an external bash 
> script. Is there some reason you need to do the external script?
>
> Robert
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
> <mailto:wa...@byteserve.com.au>]
> Sent: Friday, May 01, 2020 12:34 AM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: Re: TeraScript-Talk: Echo
>
> Cheers!
>
> Makes for a much simpler workflow.
>
> Wayne
>
>> On 1 May 2020, at 5:18 pm, ubs...@uw.edu <mailto:ubs...@uw.edu> wrote:
>>
>> If using MacOS bash, the Command Line external call action in TS outputs 
>> results into @@resultset as an array.
>> A bash script file ( /usr/local/var/www/website/scripts/get_google.sh ) can 
>> be called in the external action's "command" field:
>> #!/bin/bash
>> curl "https://www.google.com/; <https://www.google.com/>
>>
>> echo is not required for output
>> The curl output in this case can then be viewed in html with <@var resultset 
>> encoding="html">.
>> The external action outputs (from old user guide):
>> "A single item result is treated as a one-column row, a list of items is 
>> treated as a row of columns, and a list of lists is treated as a rowset."
>>
>> Check (full) path to file and permissions.
>>
>> On 4/30/20 11:01 PM, Wayne Irvine wrote:
>>> I’m calling a bash script which contains a curl command. How do I get the 
>>> results of the curl command back to Terascript?
>>>
>>> Do I have to prefix the Bash script with echo? And do I use @@resultset in 
>>> the taf?
>>>
>>> Wayne
>>>
>>>
>>>
>>>
>>> 
>>>  To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>>
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.





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

Re: TeraScript-Talk: Echo

[Wayne Irvine]

Cheers!

Makes for a much simpler workflow.

Wayne

> On 1 May 2020, at 5:18 pm, ubs...@uw.edu wrote:
>
> If using MacOS bash, the Command Line external call action in TS outputs 
> results into @@resultset as an array.
>
> A bash script file ( /usr/local/var/www/website/scripts/get_google.sh ) can 
> be called in the external action's "command" field:
> #!/bin/bash
> curl "https://www.google.com/; <https://www.google.com/>
>
> echo is not required for output
> The curl output in this case can then be viewed in html with <@var resultset 
> encoding="html">.
>
> The external action outputs (from old user guide):
>
> "A single item result is treated as a one-column row, a list of items is 
> treated as a row of columns, and a list of lists is treated as a rowset."
>
>
>
> Check (full) path to file and permissions.
>
>
> On 4/30/20 11:01 PM, Wayne Irvine wrote:
>> I’m calling a bash script which contains a curl command. How do I get the 
>> results of the curl command back to Terascript?
>>
>> Do I have to prefix the Bash script with echo? And do I use @@resultset in 
>> the taf?
>>
>> Wayne
>>
>>
>>
>>
>> 
>>  To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.





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

TeraScript-Talk: Echo

[Wayne Irvine]

I’m calling a bash script which contains a curl command. How do I get the 
results of the curl command back to Terascript?

Do I have to prefix the Bash script with echo? And do I use @@resultset in the 
taf?

Wayne





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

Re: TeraScript-Talk: API no longer working. SSL error

[Wayne Irvine]

I got it working in a really backhanded mongolian clusterfluke way.

I am calling an External action, which calls a Bash script which calls CURL and 
writes the results to a file. Then reading that file.

It works, but it shouldn’t be that hard. Or take that long.

Now that I’ve got it out of the way I will follow Steve and Robert's advice and 
purchase a new server (I can’t mess with the existing one), installing a newer 
OS, Terascript 7.1.5 and doing this the proper way. However I won’t be at all 
surprised if I meet another showstopper along the way.

W

> On 12 Dec 2019, at 7:39 am, Robert Shubert  wrote:
>
> Wayne,
>
> You may have luck with TS 7.1.5 which updates cURL and OpenSSL support, 
> although on OSX its still dependent on what's on your machine.
>
> You may also want to test TS 8 (even if just as a proxy) as it uses a 
> completely different http client (100% Java)
>
> Robert
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
> <mailto:wa...@byteserve.com.au>]
> Sent: Wednesday, December 11, 2019 12:08 AM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: Re: TeraScript-Talk: API no longer working. SSL error
>
>
>> On 11 Dec 2019, at 5:00 pm, ubslab mailto:ubs...@uw.edu>> 
>> wrote:
>>
>> Wayne,
>> Sorry if I missed earlier, but what version MacOS and TS are you using?
>
> Mac OS X Sierra 10.12.6 with Terascript 7.1.3.
>
>
>> Some thoughts, starting with setting curl -m, --max-time  for 
>> extending call completion time if a connection is successful.
>
> I’m not sure the issue is CURL waiting so much as Terascript waiting for CURL 
> to produce results.
>
>
>> I'm not sure what MacOS sets curl -m for default, but it appears to be at 
>> least 2 minutes.
>> If extended delay on External calls ("wait for") are required you'll likely 
>> need to make a bash loop.
>> Maybe something like this written into a called script:
>> until $(curl --output /dev/null --silent --head --fail http://myhost:myport 
>> <http://myhost:myport>); do
>> printf '.'
>> sleep 5
>> done
>> from stackoverflow.com/questions/11904772/ 
>> <http://stackoverflow.com/questions/11904772/>
>>
> I’ll check these out. Cheers.
>
>> Had very similar issues with SSL/TLS connections to external servers and 
>> clients.
>> I resisted changing MacOS versions but found I could not overcome the built 
>> in security limitations of MacOS if I wanted to continue to use TS.
>> After some tests I started building my Mac servers using Homebrew with TS7 
>> for MacOS 10.10-10.14.
>> Currently on 10.12 - 10.14 I do not have any issues with SSL/TLS External 
>> and Webcall actions in TS.
>
> Ok, so are you saying you’re using later Mac OS (and CURL) with Terascript 
> and not having the SSL issues? Or you install CURL separately with OpenSSL?
>
> Wayne
>
>
>
>
>
>
>> Best,
>> Steve
>> On 12/10/19 9:01 PM, Wayne Irvine wrote:
>>> As the PHP app worked I know it is not the CURL installed at /user/bin/.
>>>
>>> So I am trying to use an External action, passing the arguments and header 
>>> to a script. During debug I was seeing good results: missing header, 
>>> missing token etc. But now that I have all those in place the the action 
>>> almost immediately returns blank results. I know this API call takes a few 
>>> seconds to respond. How do I get and External action to wait?
>>>
>>> Wayne
>>>
>>>> On 11 Dec 2019, at 2:17 pm, Wayne Irvine >>> <mailto:wa...@byteserve.com.au>> wrote:
>>>>
>>>> Sorry about the formatting. Seems attachments cause the signature to be 
>>>> added.
>>>>
>>>> The attached files are a better comparison.
>>>>
>>>> The PHP results in good returned data. The TAF gives an SSL handshake 
>>>> error.
>>>>
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body. 
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body. 
>>>>
>>>>
>>>>> On 11 Dec 2019, at 2:02 pm, Wayne Irvine >>>> <mailto:wa...@byteserve.com.au>> wrote:
>>>>>
>>>>> I’m still fighting with this. I enable

Re: TeraScript-Talk: API no longer working. SSL error

[Wayne Irvine]

> On 11 Dec 2019, at 5:00 pm, ubslab  wrote:
>
> Wayne,
> Sorry if I missed earlier, but what version MacOS and TS are you using?

Mac OS X Sierra 10.12.6 with Terascript 7.1.3.

> Some thoughts, starting with setting curl -m, --max-time  for 
> extending call completion time if a connection is successful.

I’m not sure the issue is CURL waiting so much as Terascript waiting for CURL 
to produce results.

> I'm not sure what MacOS sets curl -m for default, but it appears to be at 
> least 2 minutes.
> If extended delay on External calls ("wait for") are required you'll likely 
> need to make a bash loop.
> Maybe something like this written into a called script:
> until $(curl --output /dev/null --silent --head --fail http://myhost:myport); 
> do
> printf '.'
> sleep 5
> done
>
> from stackoverflow.com/questions/11904772/
>
>
I’ll check these out. Cheers.
> Had very similar issues with SSL/TLS connections to external servers and 
> clients.
>
> I resisted changing MacOS versions but found I could not overcome the built 
> in security limitations of MacOS if I wanted to continue to use TS.
> After some tests I started building my Mac servers using Homebrew with TS7 
> for MacOS 10.10-10.14.
> Currently on 10.12 - 10.14 I do not have any issues with SSL/TLS External and 
> Webcall actions in TS.

Ok, so are you saying you’re using later Mac OS (and CURL) with Terascript and 
not having the SSL issues? Or you install CURL separately with OpenSSL?

Wayne





> Best,
>
> Steve
> On 12/10/19 9:01 PM, Wayne Irvine wrote:
>> As the PHP app worked I know it is not the CURL installed at /user/bin/.
>>
>> So I am trying to use an External action, passing the arguments and header 
>> to a script. During debug I was seeing good results: missing header, missing 
>> token etc. But now that I have all those in place the the action almost 
>> immediately returns blank results. I know this API call takes a few seconds 
>> to respond. How do I get and External action to wait?
>>
>> Wayne
>>
>>> On 11 Dec 2019, at 2:17 pm, Wayne Irvine >> <mailto:wa...@byteserve.com.au>> wrote:
>>>
>>> Sorry about the formatting. Seems attachments cause the signature to be 
>>> added.
>>>
>>> The attached files are a better comparison.
>>>
>>> The PHP results in good returned data. The TAF gives an SSL handshake error.
>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body. 
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body. 
>>>
>>>
>>>> On 11 Dec 2019, at 2:02 pm, Wayne Irvine >>> <mailto:wa...@byteserve.com.au>> wrote:
>>>>
>>>> I’m still fighting with this. I enabled PHP and ran this sample code:
>>>>
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body. 
>>>>
>>>> It returns good results.
>>>>
>>>> I used exactly the same values in this TAF:
>>>>
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body. 
>>>>
>>>> Both are calling CURL with various options and headers and data. But 
>>>> different results.
>>>>
>>>> Can anyone see what I am overlooking?
>>>>
>>>> Wayne
>>>>
>>>>> On 6 Dec 2019, at 2:39 am, Robert Shubert >>>> <mailto:rshub...@tronics.com>> wrote:
>>>>>
>>>>> It's hard to say if updating cURL on the OS will break TS. When we build 
>>>>> TS we do so against the prevailing cURL on our build system. Newer 
>>>>> versions may or may not be compatible.
>>>>>
>>>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>>>>> <mailto:wa...@byteserve.com.au>]
>>>>> Sent: Wednesday, December 04, 2019 9:00 PM
>>>>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>>>>> Subject: Re: TeraScript-Talk

Re: TeraScript-Talk: API no longer working. SSL error

[Wayne Irvine]

As the PHP app worked I know it is not the CURL installed at /user/bin/.

So I am trying to use an External action, passing the arguments and header to a 
script. During debug I was seeing good results: missing header, missing token 
etc. But now that I have all those in place the the action almost immediately 
returns blank results. I know this API call takes a few seconds to respond. How 
do I get and External action to wait?

Wayne

> On 11 Dec 2019, at 2:17 pm, Wayne Irvine  wrote:
>
> Sorry about the formatting. Seems attachments cause the signature to be added.
>
> The attached files are a better comparison.
>
> The PHP results in good returned data. The TAF gives an SSL handshake error.
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body. 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body. 
>
>
>> On 11 Dec 2019, at 2:02 pm, Wayne Irvine > <mailto:wa...@byteserve.com.au>> wrote:
>>
>> I’m still fighting with this. I enabled PHP and ran this sample code:
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body. 
>>
>> It returns good results.
>>
>> I used exactly the same values in this TAF:
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body. 
>>
>> Both are calling CURL with various options and headers and data. But 
>> different results.
>>
>> Can anyone see what I am overlooking?
>>
>> Wayne
>>
>>> On 6 Dec 2019, at 2:39 am, Robert Shubert >> <mailto:rshub...@tronics.com>> wrote:
>>>
>>> It's hard to say if updating cURL on the OS will break TS. When we build TS 
>>> we do so against the prevailing cURL on our build system. Newer versions 
>>> may or may not be compatible.
>>>
>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>>> <mailto:wa...@byteserve.com.au>]
>>> Sent: Wednesday, December 04, 2019 9:00 PM
>>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>>> Subject: Re: TeraScript-Talk: API no longer working. SSL error
>>>
>>> Looking into this it appears the issue is with CURL on OSX not using 
>>> OpenSSL but some proprietary code.
>>>
>>> Solution seems to be to remove the native CURL and rebuild with a generic 
>>> version. Just wondering if I have to tell Terascript anything about the new 
>>> version. And will it break everytime I update the system?
>>>
>>> Also puzzled as to why it worked for a few weeks then just stopped. I 
>>> assume something changed, I just don’t know what.
>>>
>>> Wayne
>>>
>>>> On 5 Dec 2019, at 12:28 pm, Wayne Irvine >>> <mailto:wa...@byteserve.com.au>> wrote:
>>>>
>>>> I’m submitting some details to a courier’s API in an effort to get back a 
>>>> range of quotes. All was working correctly until just before I left for 
>>>> holidays.
>>>>
>>>> The error is:
>>>> File: tdtest2.taf
>>>> Position: WebCall2
>>>> Class: Internal
>>>> Main Error Number: -1001
>>>>
>>>> Unable to send data when processing URL request.
>>>> wrong when connecting with SSL SSL peer handshake failed, the server most 
>>>> likely requires a client certificate to connect
>>>>
>>>> I assume there is some client certificate on the server that is out of 
>>>> date. I’m using OSX but assume the problem happens on all platforms. Any 
>>>> pointers?
>>>>
>>>> Wayne Irvine
>>>>
>>>> Byteserve Pty Ltd
>>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>>>> p: +61 02 9960 6099
>>>> m: 0409 960 609
>>>> f: +61 02 9960 6088
>>>>
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>&

Re: TeraScript-Talk: API no longer working. SSL error

[Wayne Irvine]

Looking into this it appears the issue is with CURL on OSX not using OpenSSL 
but some proprietary code.

Solution seems to be to remove the native CURL and rebuild with a generic 
version. Just wondering if I have to tell Terascript anything about the new 
version. And will it break everytime I update the system?

Also puzzled as to why it worked for a few weeks then just stopped. I assume 
something changed, I just don’t know what.

Wayne

> On 5 Dec 2019, at 12:28 pm, Wayne Irvine  wrote:
>
> I’m submitting some details to a courier’s API in an effort to get back a 
> range of quotes. All was working correctly until just before I left for 
> holidays.
>
> The error is:
> File: tdtest2.taf
> Position: WebCall2
> Class: Internal
> Main Error Number: -1001
>
> Unable to send data when processing URL request.
> wrong when connecting with SSL SSL peer handshake failed, the server most 
> likely requires a client certificate to connect
>
> I assume there is some client certificate on the server that is out of date. 
> I’m using OSX but assume the problem happens on all platforms. Any pointers?
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088





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

TeraScript-Talk: API no longer working. SSL error

[Wayne Irvine]

I’m submitting some details to a courier’s API in an effort to get back a range 
of quotes. All was working correctly until just before I left for holidays.

The error is:
File: tdtest2.taf
Position: WebCall2
Class: Internal
Main Error Number: -1001

Unable to send data when processing URL request.
wrong when connecting with SSL SSL peer handshake failed, the server most 
likely requires a client certificate to connect

I assume there is some client certificate on the server that is out of date. 
I’m using OSX but assume the problem happens on all platforms. Any pointers?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088





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

Re: TeraScript-Talk: WebCall and JSON

[Wayne Irvine]

Ahhh!



Cheers

W

> On 3 Oct 2019, at 3:29 pm, Wayne Irvine  wrote:
>
> I am working with an API that expects JSON. They have provided sample JSON:
>
> {
> "declared_value": "1000.00",
> "items": [
> {
> "weight": "38.63",
> "height": "0.25",
> "width": "1.65",
> "length": "3.32",
> "quantity": 1,
> "description": "carton"
> },
> {
> "weight": "39.63",
> "height": "1.25",
> "width": "2.65",
> "length": "4.32",
> "quantity": 2,
> "description": "carton"
> }
> ],
> "sender": {
> "postcode": "2000",
> "suburb": "SYDNEY",
> "type": "business",
> "country": "AU"
> },
> "receiver": {
> "postcode": "3000",
> "suburb": "MELBOURNE",
> "type": "business",
> "country": "AU"
> }
> }
>
> I have tried pasting this in the Data section of the WebCall action but am 
> getting an error:
> 415 Unsupported Media Type
>
> Do I have to escape this data or something?
>
> Wayne
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: WebCall and JSON

[Wayne Irvine]

Where do I set the content type? There doesn’t appear to be an option for it in 
the action.

W

> On 3 Oct 2019, at 9:50 pm, Peter Dobbs  wrote:
>
> What are you setting your content type to?
>
>
> A 415 unsupported media type error occurs when the origin server refuses a 
> particular request since the resource is in a format that is not supported by 
> the server for the HTTP method used. This unsupported format typeissue can be 
> caused by what is defined in the resource's Content-Type or Content-Encoding 
> headers
>
>
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151  | F: 
> 416.901.6150  | enginess.io 
>
> This message may have been dictated and poorly interpreted by Siri. If this 
> message contains any content that is offensive or unusual/confusing in 
> anyway, please disregard as Siri is useful despite being incompetent.
>
> This email and any attachments are confidential and are intended only for the 
> person(s) to whom it is addressed. It you are not the addressee named above, 
> any use, copying, distribution or disclosure is strictly unauthorized. If you 
> have received this information in error, please delete it and any attachments 
> and notify me immediately.
>
>
>> On Oct 3, 2019, at 1:30 AM, Wayne Irvine  wrote:
>>
>>  I am working with an API that expects JSON. They have provided sample JSON:
>>
>> {
>> "declared_value": "1000.00",
>> "items": [
>> {
>> "weight": "38.63",
>> "height": "0.25",
>> "width": "1.65",
>> "length": "3.32",
>> "quantity": 1,
>> "description": "carton"
>> },
>> {
>> "weight": "39.63",
>> "height": "1.25",
>> "width": "2.65",
>> "length": "4.32",
>> "quantity": 2,
>> "description": "carton"
>> }
>> ],
>> "sender": {
>> "postcode": "2000",
>> "suburb": "SYDNEY",
>> "type": "business",
>> "country": "AU"
>> },
>> "receiver": {
>> "postcode": "3000",
>> "suburb": "MELBOURNE",
>> "type": "business",
>> "country": "AU"
>> }
>> }
>>
>> I have tried pasting this in the Data section of the WebCall action but am 
>> getting an error:
>> 415 Unsupported Media Type
>>
>> Do I have to escape this data or something?
>>
>> Wayne
>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

Ok, so in theory should this work?


What am I missing?

Wayne

> On 26 Jul 2019, at 1:40 am, Robert Shubert  wrote:
>
> The alias t1 is set in the query by having it follow the table name, so yes, 
> "FROM test t1" is creating the alias t1
>
> @BOUNDVALS should work normally, in the query below there are none, so 
> nothing should've been reported.
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Wednesday, July 24, 2019 6:43 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: First time doing Direct_DBMS
>
> <@SQL> just gives the same string as the DEBUG information.
> 
>
> It gives no information on how the t1 alias is set up (unless ‘FROM testtable 
> t1’ is how it is done). Either way, this statement used in the Direct_DBMS 
> action results in an error still.
>
> <@BOUNDVALS> is pink in Terascribe and ignored by Terascript.
>
> Wayne
>
>> On 24 Jul 2019, at 12:01 am, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> You can see generated SQL with @SQL and @BOUNDVALS, just output those tags 
>> immediately after the query.
>>
>> -Original Message-
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Monday, July 22, 2019 7:03 PM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: Re: TeraScript-Talk: First time doing Direct_DBMS
>>
>> Well no luck so far on the Direct_DBMS action.
>>
>> Tried with a fresh new table and very simple SQL statement and got the same 
>> error.
>>
>> I would really love a way to actually log the SQL statement generated and 
>> sent by the Search Action. The one in the Debug uses aliases and you can’t 
>> see the steps beforehand to test it out.
>>
>> Wayne
>>
>>
>>> On 12 Jul 2019, at 10:23 am, Wayne Irvine >> <mailto:wa...@byteserve.com.au>> wrote:
>>>
>>> This is Mac OSX Sierra Server 10.12.6 and Filemaker Server Advanced 12.
>>>
>>> What i would like to be able to log is the call the Search action makes to 
>>> the JDBC plugin. Then I could emulate tis is a Direct_DBMS action and 
>>> modify from there.
>>>
>>> One thing that has got me thinking is the actions next to Direct_DBMS. 
>>> Begin_Transaction and End_Transaction. Do these need to be before and after 
>>> the Direct_DBMS action? I’ve never seen documentation for how these work.
>>>
>>> Wayne
>>>
>>>
>>>> On 12 Jul 2019, at 9:12 am, ubslab mailto:ubs...@uw.edu>> 
>>>> wrote:
>>>>
>>>> Wayne,
>>>>
>>>> Am I correct assume this is all on a MacOS server?
>>>>
>>>> If so, which version of OS and FileMaker are you using?
>>>>
>>>> - Steve K
>>>>
>>>> On 7/10/2019 7:18 PM, ubs...@uw.edu <mailto:ubs...@uw.edu> wrote:
>>>>
>>>>> Wayne,
>>>>>
>>>>> I recall needing to adjust datatype(s) in FM databases to work
>>>>> correctly with Wtango and JDBC/ODBC.
>>>>>
>>>>> Perhaps a test FM db with only integer columns.
>>>>>
>>>>> - Steve K
>>>>>
>>>>>
>>>>> On 7/10/19 7:06 PM, ubslab wrote:
>>>>>
>>>>>> Wayne,
>>>>>>
>>>>>> Are you able to connect to FM table.columns in the Terascribe
>>>>>> editor JDBC/ODBC panel?
>>>>>>
>>>>>> - Steve K
>>>>>>
>>>>>> On 7/10/19 6:45 PM, Wayne Irvine wrote:
>>>>>>
>>>>>>>> On 11 Jul 2019, at 12:38 am, Robert Shubert
>>>>>>>> mailto:rshub...@tronics.com>>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>> Wayne,
>>>>>>>>
>>>>>>>> First do a simple query like "SELECT 1" just to double check the DBMS.
>>>>>>> I tried:
>>>>>>> SELECT 1
>>>>>>> SELECT 1 FROM Packages
>>>>>>>
>>>>>>> both gave an error.
>>>>>>>
>>>>>>>> Then try grabbing just one row "SELECT packagename FROM Packages
>>>>>>>> WHERE packagename = '{known name}’"
>>>>>>> SELECT packagename

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

<@SQL> just gives the same string as the DEBUG information.


It gives no information on how the t1 alias is set up (unless ‘FROM testtable 
t1’ is how it is done). Either way, this statement used in the Direct_DBMS 
action results in an error still.

<@BOUNDVALS> is pink in Terascribe and ignored by Terascript.

Wayne

> On 24 Jul 2019, at 12:01 am, Robert Shubert  wrote:
>
> You can see generated SQL with @SQL and @BOUNDVALS, just output those tags 
> immediately after the query.
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Monday, July 22, 2019 7:03 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: First time doing Direct_DBMS
>
> Well no luck so far on the Direct_DBMS action.
>
> Tried with a fresh new table and very simple SQL statement and got the same 
> error.
>
> I would really love a way to actually log the SQL statement generated and 
> sent by the Search Action. The one in the Debug uses aliases and you can’t 
> see the steps beforehand to test it out.
>
> Wayne
>
>> On 12 Jul 2019, at 10:23 am, Wayne Irvine  wrote:
>>
>> This is Mac OSX Sierra Server 10.12.6 and Filemaker Server Advanced 12.
>>
>> What i would like to be able to log is the call the Search action makes to 
>> the JDBC plugin. Then I could emulate tis is a Direct_DBMS action and modify 
>> from there.
>>
>> One thing that has got me thinking is the actions next to Direct_DBMS. 
>> Begin_Transaction and End_Transaction. Do these need to be before and after 
>> the Direct_DBMS action? I’ve never seen documentation for how these work.
>>
>> Wayne
>>
>>> On 12 Jul 2019, at 9:12 am, ubslab  wrote:
>>>
>>> Wayne,
>>>
>>> Am I correct assume this is all on a MacOS server?
>>>
>>> If so, which version of OS and FileMaker are you using?
>>>
>>> - Steve K
>>>
>>> On 7/10/2019 7:18 PM, ubs...@uw.edu wrote:
>>>> Wayne,
>>>>
>>>> I recall needing to adjust datatype(s) in FM databases to work
>>>> correctly with Wtango and JDBC/ODBC.
>>>>
>>>> Perhaps a test FM db with only integer columns.
>>>>
>>>> - Steve K
>>>>
>>>>
>>>> On 7/10/19 7:06 PM, ubslab wrote:
>>>>> Wayne,
>>>>>
>>>>> Are you able to connect to FM table.columns in the Terascribe
>>>>> editor JDBC/ODBC panel?
>>>>>
>>>>> - Steve K
>>>>>
>>>>> On 7/10/19 6:45 PM, Wayne Irvine wrote:
>>>>>>> On 11 Jul 2019, at 12:38 am, Robert Shubert
>>>>>>> 
>>>>>>> wrote:
>>>>>>>
>>>>>>> Wayne,
>>>>>>>
>>>>>>> First do a simple query like "SELECT 1" just to double check the DBMS.
>>>>>> I tried:
>>>>>> SELECT 1
>>>>>> SELECT 1 FROM Packages
>>>>>>
>>>>>> both gave an error.
>>>>>>> Then try grabbing just one row "SELECT packagename FROM Packages
>>>>>>> WHERE packagename = '{known name}’"
>>>>>> SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’
>>>>>>
>>>>>> Error
>>>>>>> If that works, then we may be looking for a bug dealing with
>>>>>>> non-value. Try "SELECT packagename FROM Packages WHERE
>>>>>>> packagename IS NOT NULL”
>>>>>> SELECT packagename FROM Packages WHERE packagename IS NOT NULL
>>>>>>
>>>>>> Error
>>>>>>> What version of TS are you running? There was a JDBC fix in 7.1.1
>>>>>>> and I have another fix (which may be your problem) coming in 7.1.5.
>>>>>> 7.1.3.1
>>>>>>
>>>>>> Wayne
>>>>>>
>>>>>> Byteserve Pty Ltd
>>>>>> w: http://www.byteserve.com.au/
>>>>>> e: i...@byteserve.com.au
>>>>>> p: +61 02 9960 6099
>>>>>> m: 0409 960 609
>>>>>> f: +61 02 9960 6088
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> 
>>>>>>
>>>>>> To unsubscribe from this list, please send an email to
>>>>>> lists...@terascript.com with "unsubscribe

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

Well no luck so far on the Direct_DBMS action.

Tried with a fresh new table and very simple SQL statement and got the same 
error.

I would really love a way to actually log the SQL statement generated and sent 
by the Search Action. The one in the Debug uses aliases and you can’t see the 
steps beforehand to test it out.

Wayne

> On 12 Jul 2019, at 10:23 am, Wayne Irvine  wrote:
>
> This is Mac OSX Sierra Server 10.12.6 and Filemaker Server Advanced 12.
>
> What i would like to be able to log is the call the Search action makes to 
> the JDBC plugin. Then I could emulate tis is a Direct_DBMS action and modify 
> from there.
>
> One thing that has got me thinking is the actions next to Direct_DBMS. 
> Begin_Transaction and End_Transaction. Do these need to be before and after 
> the Direct_DBMS action? I’ve never seen documentation for how these work.
>
> Wayne
>
>> On 12 Jul 2019, at 9:12 am, ubslab  wrote:
>>
>> Wayne,
>>
>> Am I correct assume this is all on a MacOS server?
>>
>> If so, which version of OS and FileMaker are you using?
>>
>> - Steve K
>>
>> On 7/10/2019 7:18 PM, ubs...@uw.edu wrote:
>>> Wayne,
>>>
>>> I recall needing to adjust datatype(s) in FM databases to work
>>> correctly with Wtango and JDBC/ODBC.
>>>
>>> Perhaps a test FM db with only integer columns.
>>>
>>> - Steve K
>>>
>>>
>>> On 7/10/19 7:06 PM, ubslab wrote:
>>>> Wayne,
>>>>
>>>> Are you able to connect to FM table.columns in the Terascribe editor
>>>> JDBC/ODBC panel?
>>>>
>>>> - Steve K
>>>>
>>>> On 7/10/19 6:45 PM, Wayne Irvine wrote:
>>>>>> On 11 Jul 2019, at 12:38 am, Robert Shubert 
>>>>>> wrote:
>>>>>>
>>>>>> Wayne,
>>>>>>
>>>>>> First do a simple query like "SELECT 1" just to double check the DBMS.
>>>>> I tried:
>>>>> SELECT 1
>>>>> SELECT 1 FROM Packages
>>>>>
>>>>> both gave an error.
>>>>>> Then try grabbing just one row "SELECT packagename FROM Packages
>>>>>> WHERE packagename = '{known name}’"
>>>>> SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’
>>>>>
>>>>> Error
>>>>>> If that works, then we may be looking for a bug dealing with
>>>>>> non-value. Try "SELECT packagename FROM Packages WHERE packagename
>>>>>> IS NOT NULL”
>>>>> SELECT packagename FROM Packages WHERE packagename IS NOT NULL
>>>>>
>>>>> Error
>>>>>> What version of TS are you running? There was a JDBC fix in 7.1.1
>>>>>> and I have another fix (which may be your problem) coming in 7.1.5.
>>>>> 7.1.3.1
>>>>>
>>>>> Wayne
>>>>>
>>>>> Byteserve Pty Ltd
>>>>> w: http://www.byteserve.com.au/
>>>>> e: i...@byteserve.com.au
>>>>> p: +61 02 9960 6099
>>>>> m: 0409 960 609
>>>>> f: +61 02 9960 6088
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 
>>>>>
>>>>> To unsubscribe from this list, please send an email to
>>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>>
>>>>
>>>> 
>>>>
>>>> To unsubscribe from this list, please send an email to
>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Strip leading 0 (zeros)

[Wayne Irvine]

I did a <@CALC EXPR=“05”>

Works but is clumsy.

> On 17 Jul 2019, at 4:01 pm, Wayne Irvine  wrote:
>
> I am returning some numeric values (actual parts of dates) and many have 
> leading zeros.
>
> How do I format a numeric string without leading 0s?
>
> 05 -> 5 for example.
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Strip leading 0 (zeros)

[Wayne Irvine]

I am returning some numeric values (actual parts of dates) and many have 
leading zeros.

How do I format a numeric string without leading 0s?

05 -> 5 for example.

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

> On 11 Jul 2019, at 12:38 am, Robert Shubert  wrote:
>
> Wayne,
>
> First do a simple query like "SELECT 1" just to double check the DBMS.

I tried:
SELECT 1
SELECT 1 FROM Packages

both gave an error.
>
> Then try grabbing just one row "SELECT packagename FROM Packages WHERE 
> packagename = '{known name}’"

SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’

Error
>
> If that works, then we may be looking for a bug dealing with non-value. Try 
> "SELECT packagename FROM Packages WHERE packagename IS NOT NULL”

SELECT packagename FROM Packages WHERE packagename IS NOT NULL

Error
>
> What version of TS are you running? There was a JDBC fix in 7.1.1 and I have 
> another fix (which may be your problem) coming in 7.1.5.


7.1.3.1

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

I hadn’t noticed the user vars previously. They are left over from previous 
searches with the Search action. I added a Purge as the first action and they 
no longer appear.

I also changed the Select to retrieve a field that is not user generated, so 
more predictable and alphanumeric.

Still gives an error.

Error

An error occurred while processing your request:

File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101

General error during data source operation.



[Application File]  [2] START /sandbox/SQLfindpkgs.taf  TeraScript 
Server 7
[Results Action][2] Results1
[Direct DBMS Action][2] Direct_DBMS : over60_db
[Datasource][286]   No existing connection to the data source found, 
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2636]  SELECT PackageUID FROM Packages
[Error] [4900]  -101 General error during data source operation.
[request$ Vars] [4900]  variableTimeout=30;













> On 10 Jul 2019, at 10:33 pm, ubslab  wrote:
>
> If the expected result set is in the range of "[Array:553x36]" I would
> suspect characters that the ODBC/JDBC connector can't pass or parse.
>
> Is it reasonable to refill the database with values not containing
> special, symbol, or punctuation characters to diagnose?
>
> Had a similar issue with a FM Witango configuration years ago; Can't
> recall specifics, but involved filtering/substitution to solve.
>
> - Steve K
>
> On 7/9/19 11:33 PM, Wayne Irvine wrote:
>>> On 10 Jul 2019, at 4:26 pm, ubslab  wrote:
>>>
>>> Wayne,
>>> So none the following forms will work in the action?
>>>
>>> SELECT packagename FROM Packages
>>>
>> Error
>>
>> An error occurred while processing your request:
>>
>> File: SQLfindpkgs.taf
>> Position: Direct_DBMS
>> Class: Internal
>> Main Error Number: -101
>>
>> General error during data source operation.
>>
>>
>>
>> [Application File]   [2] START /sandbox/SQLfindpkgs.taf  TeraScript 
>> Server 7
>> [user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
>> [Direct DBMS Action] [2] Direct_DBMS : over60_db
>> [Datasource] [288]   No existing connection to the data source found, 
>> creating a new connection. DSN: jdbc.over60_db; User: witango;
>> [Query]  [2580]  SELECT packagename FROM Packages
>> [Error]  [4965]  -101 General error during data source operation.
>> [user$ Vars] [4965]  variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
>> [request$ Vars]  [4965]  variableTimeout=30;
>>
>>> SELECT P1.packagename FROM Packages P1
>>>
>> Error
>>
>> An error occurred while processing your request:
>>
>> File: SQLfindpkgs.taf
>> Position: Direct_DBMS
>> Class: Internal
>> Main Error Number: -101
>>
>> General error during data source operation.
>>
>>
>>
>> [Application File]   [2] START /sandbox/SQLfindpkgs.taf  TeraScript 
>> Server 7
>> [user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
>> [Direct DBMS Action] [2] Direct_DBMS : over60_db
>> [Datasource] [289]   No existing connection to the data source found, 
>> creating a new connection. DSN: jdbc.over60_db; User: witango;
>> [Query]  [2635]  SELECT P1.packagename FROM Packages P1
>> [Error]  [5055]  -101 General error during data source operation.
>> [user$ Vars] [5055]  variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
>> [request$ Vars]  [5055]  variableTimeout=30;
>>
>>> SELECT P1.packagename FROM Packages AS P1
>>>
>> Error
>>
>> An error occurred while processing your request:
>>
>> File: SQLfindpkgs.taf
>> Position: Direct_DBMS
>> Class: Internal
>> Main Error Number: -101
>>
>> General error during data source operation.
>>
>>
>>
>> [Application File]   [1] START /sandbox/SQLfindpkgs.taf  TeraScript 
>> Server 7
>> [user$ Vars] [1] variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
>> [Direct DBMS Action] [1] Direct_DBMS : over60_db
>> [Datasource] [304]   No existing connection to the data source found, 
>> creating a new connection. DSN: jdbc.over60_db; User: witango;
>> [Query]  [2608]  SELECT P1.packagename FROM Packages AS P1
>> [Error]  [5006]  -101 General error during data source operation.
>> [user$ Vars] [5007]  variableTimeout=30; foundset=[Array:553x36]; 
>> elcount=20; endpoint=20;
&

Re: TeraScript-Talk: First time doing Direct_DBMS

[Wayne Irvine]

> On 10 Jul 2019, at 4:26 pm, ubslab  wrote:
>
> Wayne,
> So none the following forms will work in the action?
>
> SELECT packagename FROM Packages
>

Error

An error occurred while processing your request:

File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101

General error during data source operation.



[Application File]  [2] START /sandbox/SQLfindpkgs.taf  TeraScript 
Server 7
[user$ Vars][2] variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[Direct DBMS Action][2] Direct_DBMS : over60_db
[Datasource][288]   No existing connection to the data source found, 
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2580]  SELECT packagename FROM Packages
[Error] [4965]  -101 General error during data source operation.
[user$ Vars][4965]  variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[request$ Vars] [4965]  variableTimeout=30;

>
> SELECT P1.packagename FROM Packages P1
>

Error

An error occurred while processing your request:

File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101

General error during data source operation.



[Application File]  [2] START /sandbox/SQLfindpkgs.taf  TeraScript 
Server 7
[user$ Vars][2] variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[Direct DBMS Action][2] Direct_DBMS : over60_db
[Datasource][289]   No existing connection to the data source found, 
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2635]  SELECT P1.packagename FROM Packages P1
[Error] [5055]  -101 General error during data source operation.
[user$ Vars][5055]  variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[request$ Vars] [5055]  variableTimeout=30;

> SELECT P1.packagename FROM Packages AS P1
>
Error

An error occurred while processing your request:

File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101

General error during data source operation.



[Application File]  [1] START /sandbox/SQLfindpkgs.taf  TeraScript 
Server 7
[user$ Vars][1] variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[Direct DBMS Action][1] Direct_DBMS : over60_db
[Datasource][304]   No existing connection to the data source found, 
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2608]  SELECT P1.packagename FROM Packages AS P1
[Error] [5006]  -101 General error during data source operation.
[user$ Vars][5007]  variableTimeout=30; foundset=[Array:553x36]; 
elcount=20; endpoint=20;
[request$ Vars] [5007]  variableTimeout=30;






Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Randomise Resultset

[Wayne Irvine]

This is much more elegant, but unfortunately FileMaker via JDBC doesn’t seem to 
want to play ball.

I’m still looking into it.

Wayne

> On 9 Jul 2019, at 10:02 pm, Peter Dobbs  wrote:
>
> SELECT * FROM table ORDER BY NEWID()
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151  | F: 
> 416.901.6150  | enginess.io 
>
> This message may have been dictated and poorly interpreted by Siri. If this 
> message contains any content that is offensive or unusual/confusing in 
> anyway, please disregard as Siri is useful despite being incompetent.
>
> This email and any attachments are confidential and are intended only for the 
> person(s) to whom it is addressed. It you are not the addressee named above, 
> any use, copying, distribution or disclosure is strictly unauthorized. If you 
> have received this information in error, please delete it and any attachments 
> and notify me immediately.
>
>
> On Jul 9, 2019, at 8:00 AM, Peter Dobbs  <mailto:pe...@enginess.io>> wrote:
>
>> You should do that in your sql, it’s much more efficient.
>>
>>
>> Peter Dobbs
>> President | ENGINESS | P: 416.901.6151  | F: 
>> 416.901.6150  | enginess.io 
>>
>> This message may have been dictated and poorly interpreted by Siri. If this 
>> message contains any content that is offensive or unusual/confusing in 
>> anyway, please disregard as Siri is useful despite being incompetent.
>>
>> This email and any attachments are confidential and are intended only for 
>> the person(s) to whom it is addressed. It you are not the addressee named 
>> above, any use, copying, distribution or disclosure is strictly 
>> unauthorized. If you have received this information in error, please delete 
>> it and any attachments and notify me immediately.
>>
>>
>> On Jul 9, 2019, at 1:07 AM, ubslab mailto:ubs...@uw.edu>> 
>> wrote:
>>
>>> I don't recall that, but I used something like this:
>>>
>>> <@ASSIGN NAME="ResultSet" VALUE="<@ARRAY ROWS='10' COLS='1' CDELIM=','
>>> RDELIM='|' VALUE='1|2|3|4|5|6|7|8|9|10|'>">
>>>
>>> <@VAR ResultSet>
>>>
>>> <@ASSIGN NAME='RandomizedArray' VALUE=<@ARRAY ROWS='<@NUMROWS
>>> array='ResultSet'>' COLS='1'>>
>>> <@ASSIGN NAME='OriginalResultSetCols' VALUE='<@NUMROWS array='ResultSet'>'>
>>>
>>> <@WHILE EXPR="<@VAR RandomizedArray[<@VAR OriginalResultSetCols>,1]><1">
>>>
>>> <@ASSIGN NAME='ResultSetRowPos' VALUE="<@RANDOM HIGH='<@NUMROWS
>>> array=ResultSet>' LOW='1'>">
>>> <@ASSIGN NAME='RandomizedArray[<@CURROW>,1]' VALUE='<@VAR
>>> ResultSet[<@VAR ResultSetRowPos>,1]>'>
>>>
>>> <@DELROWS ARRAY='ResultSet' POSITION='<@VAR ResultSetRowPos>' NUM='1'>
>>>
>>> 
>>>
>>> <@VAR RandomizedArray>
>>>
>>>
>>> -Steve K
>>>
>>> On 7/8/19 7:23 PM, Wayne Irvine wrote:
>>>> Is there a built in method to randomise the order of the resultset from a 
>>>> search?
>>>>
>>>> Wayne Irvine
>>>>
>>>> Byteserve Pty Ltd
>>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>>>> p: +61 02 9960 6099
>>>> m: 0409 960 609
>>>> f: +61 02 9960 6088
>>>>
>>>>
>>>>
>>>>
>>>> 
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body.
>>>>
>>>
>>>
>>> 
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Randomise Resultset

[Wayne Irvine]

Is there a built in method to randomise the order of the resultset from a 
search?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: ELEMENTATTRIBUTE deprecated?

[Wayne Irvine]

Cool.

Not had any luck installing 7.0.3.

W

> On 9 Jul 2019, at 12:20 am, Robert Shubert  wrote:
>
> Wayne,
>
> It's a bug in 7.0.1 that the highlighting for that tag (and a couple of 
> others) didn't work correctly.
>
> It was addressed in 7.0.3
>
> Robert
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
> <mailto:wa...@byteserve.com.au>]
> Sent: Sunday, July 07, 2019 7:36 PM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: TeraScript-Talk: ELEMENTATTRIBUTE deprecated?
>
> <@ELEMENTATTRIBUTE …> comes up as purple in Terascribe 7.0.1.
>
> 
>
> I assume it is deprecated? What replaces it?
>
> It still seems to work however.
>
> Wayne
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: ELEMENTATTRIBUTE deprecated?

[Wayne Irvine]

<@ELEMENTATTRIBUTE …> comes up as purple in Terascribe 7.0.1.



I assume it is deprecated? What replaces it?

It still seems to work however.

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: From name not showing in emails

[Wayne Irvine]

Cheers.

Tried that, and double quotes around the name.



Still no go unfortunately.

Wayne

> On 27 Mar 2019, at 1:42 am, Peter Dobbs  wrote:
>
> This works:
>
> 
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151  | F: 
> 416.901.6150  | www.enginess.io 
> 
>
>
> From: Stefan Gonick  <mailto:ste...@healinghearts.com>> on behalf of Stefan Gonick 
> mailto:ste...@healinghearts.com>>
> Reply-To: "TeraScript-Talk@terascript.com 
> <mailto:TeraScript-Talk@terascript.com>"  <mailto:TeraScript-Talk@terascript.com>>
> Date: Tuesday, March 26, 2019 at 10:00 AM
> To: "TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>" 
> mailto:TeraScript-Talk@terascript.com>>
> Subject: re: TeraScript-Talk: From name not showing in emails
>
> Would it help to put quotes around "<@arg name>"?
>
> Stefan
>
>
> From: "Wayne Irvine" mailto:wa...@byteserve.com.au>>
> Sent: Tuesday, March 26, 2019 1:11 AM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: TeraScript-Talk: From name not showing in emails
>
> I noticed that when I generate emails from a TAF the name of the sender 
> doesn’t appear in Apple Mail:
> 
>
> I have tried changing around the way the From: field is composed but had no 
> luck as of yet:
> 
>
> Any clues?
>
> Wayne
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: From name not showing in emails

[Wayne Irvine]

I noticed that when I generate emails from a TAF the name of the sender doesn’t 
appear in Apple Mail:


I have tried changing around the way the From: field is composed but had no 
luck as of yet:


Any clues?

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Old editor, new server

[Wayne Irvine]

Thought I would give this a try. Used the newer tag <@POSTARGFILENAME 
NAME=Files[]> in the old editor, on the newer server.



Of course the editor picks up a syntax error but the server processes it fine.

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Terascript and scribe updates on OSX

[Wayne Irvine]

Haven’t heard back about install procedure for Terascript 7.1.3 on OSX 
10.12.6.I tried running the install on my laptop and replacing the 
terascriptd.app on the server with the new one created on the laptop and all 
seems to function well so far. Not sure if other files have differences though.

Terascribe is a different story. Install goes fine but the app quits on start. 
I have seen some errors in the Console such as:
Nov  6 00:57:59 waynesmacbook TeraScribe7[28034]: assertion failed: 16G1510: 
libxpc.dylib + 74307 [ABC3BB29-BCE6-3E50-8A71-4E56AEE28991]: 0x89
Nov  6 00:59:46 waynesmacbook TeraScribe7[28416]: assertion failed: 16G1510: 
libxpc.dylib + 74307 [ABC3BB29-BCE6-3E50-8A71-4E56AEE28991]: 0x89
Nov  6 01:04:27 waynesmacbook com.apple.xpc.launchd[1] 
(com.apple.lateragent[612]): Service exited due to signal: Killed: 9 sent by 
loginwindow[119]
Nov  6 01:11:01 waynesmacbook TeraScript Server 7[107]: START  WARNING  
Cannot retrieve the machine name, using localhost (127.0.0.1) instead
Nov  6 01:13:51 waynesmacbook TeraScribe7[770]: assertion failed: 16G1618: 
libxpc.dylib + 74307 [ABC3BB29-BCE6-3E50-8A71-4E56AEE28991]: 0x89

Tried replacing just the app file but no go.

Wayne Irvine


Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Install 7.1.3 (actually 7.1.5.1) on OS X 10.12.6 Server

[Wayne Irvine]

Is there any possibility of an install script for OS X 10.12.6 Server? I tried 
the 10.9 Server Script but no go. I know I’ve been through this before with 
great help from Robert but can’t recall all the steps to do it manually.

Or alternatively, a list of files that need to be replace to upgrade 7.0.X to 
7.1.X

Wayne

Apache lives at:
/etc/apache2/
Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: File Upload

[Wayne Irvine]

I’ve used basic multipart/form-data and the File action for ages.

I thought I’d spice it up a little with drag and drop and found this nice 
Jquery library.

https://blueimp.github.io/jQuery-File-Upload/ 
<https://blueimp.github.io/jQuery-File-Upload/>

It supports things like max file size and a progress bar. I guess these are all 
clients side parameters.

But I am having trouble distinguishing between the file data and the file name. 
Previously I used some javascript that on submission would calculate a name 
from the file's field and populate another field to be submitted at the same 
time.






I can’t do this with the system above.

Assuming a single field of type=file how do I populate the the File Action with 
both
File:
Data to write:

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: macOS and Homebrew

[Wayne Irvine]

I have some experience with the issues of changing versions of MacOS and also 
with Homebrew.

I’m in favour but realise it may be daunting for others.

Wayne

> On 13 Oct 2018, at 2:07 am, Robert Shubert  wrote:
>
> macOS users:
>
> Since Apple tends to change things around with each release of macOS, we're 
> considering changing TeraScript to depend on software installed by Homebrew 
> (https://brew.sh/ )
>
> Therefore we'd like to ask our macOS users if they have experience with 
> Homebrew, and if they would be opposed to (or prefer) using Homebrew to 
> install certain packages to better support TS functionality. Please reply 
> here or to supp...@terascript.com . Your 
> feedback is important.
>
> Thank you,
>
> Robert
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com  with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

Guess again!

Mac OS X

> On 13 Sep 2018, at 7:18 pm, Peter Dobbs  wrote:
>
> Windows or Linux?
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151 | F: 416.901.6150 | www.enginess.io
>
>
>
> This email and any attachments are confidential and are intended only for the 
> person(s) to whom it is addressed. It you are not the addressee named above, 
> any use, copying, distribution or disclosure is strictly unauthorized. If you 
> have received this information in error, please delete it and any attachments 
> and notify me immediately.
>
>
> On Sep 13, 2018, at 12:53 AM, Wayne Irvine  wrote:
>
>> Any idea on a timeframe for a fix?
>>
>> Or should I investigate the curl option?
>>
>> Wayne
>>
>>> On 12 Sep 2018, at 11:46 pm, Robert Shubert  wrote:
>>>
>>> Looks like you just reported a bug.
>>>
>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
>>> Sent: Tuesday, September 11, 2018 5:07 PM
>>> To: TeraScript-Talk@terascript.com
>>> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>>>
>>> 7.1.3.1
>>>
>>>
>>>> On 12 Sep 2018, at 4:53 am, Robert Shubert  wrote:
>>>>
>>>> Version of TS?
>>>>
>>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
>>>> Sent: Tuesday, September 11, 2018 12:42 AM
>>>> To: TeraScript-Talk@terascript.com
>>>> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>>>>
>>>> I have this and get the error:
>>>> 
>>>>
>>>>
>>>>> On 11 Sep 2018, at 1:12 pm, Robert Shubert  wrote:
>>>>>
>>>>> You just need to use an https:// url and the server will switch to SSL.
>>>>>
>>>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
>>>>> Sent: Monday, September 10, 2018 5:15 PM
>>>>> To: TeraScript-Talk@terascript.com
>>>>> Subject: TeraScript-Talk: Webcalls and HTTPS
>>>>>
>>>>> Hi all,
>>>>>
>>>>> I have a platform that gets it’s content from another site (all 
>>>>> authorised) via Webcalls. They recently implemented SSL for all their 
>>>>> site and my Webcalls no longer work:
>>>>>
>>>>> Unable to send data when processing URL request.
>>>>> wrong when connecting with SSL Server aborted the SSL handshake
>>>>>
>>>>> I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other 
>>>>> options.
>>>>>
>>>>> Is it possible to do a Webcall using HTTPS?
>>>>>
>>>>> What is involved?
>>>>>
>>>>> Wayne
>>>>>
>>>>>
>>>>> Byteserve Pty Ltd
>>>>> w: http://www.byteserve.com.au/
>>>>> e: i...@byteserve.com.au
>>>>> p: +61 02 9960 6099
>>>>> m: 0409 960 609
>>>>> f: +61 02 9960 6088
>>>>>
>>>>>
>>>>> To unsubscribe from this list, please send an email to 
>>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>>
>>>>> To unsubscribe from this list, please send an email to 
>>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>
>>>>
>>>> Byteserve Pty Ltd
>>>> w: http://www.byteserve.com.au/
>>>> e: i...@byteserve.com.au
>>>> p: +61 02 9960 6099
>>>> m: 0409 960 609
>>>> f: +61 02 9960 6088
>>>>
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>
>>>
>>> Byteserve Pty Ltd
>>> w: http://www.byteserve.com.au/
>>> e: i...@byteserve.com.au
>>> p: +61 02 9960 6099
>>> m: 0409 960 609
>>> f: +61 02 9960 6088
>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.





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

Re: TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

Any idea on a timeframe for a fix?

Or should I investigate the curl option?

Wayne

> On 12 Sep 2018, at 11:46 pm, Robert Shubert  wrote:
>
> Looks like you just reported a bug.
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Tuesday, September 11, 2018 5:07 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>
> 7.1.3.1
>
>
>> On 12 Sep 2018, at 4:53 am, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> Version of TS?
>>
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Tuesday, September 11, 2018 12:42 AM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>>
>> I have this and get the error:
>> 
>>
>>
>>> On 11 Sep 2018, at 1:12 pm, Robert Shubert >> <mailto:rshub...@tronics.com>> wrote:
>>>
>>> You just need to use an https:// url and the server will switch to SSL.
>>>
>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>>> <mailto:wa...@byteserve.com.au>]
>>> Sent: Monday, September 10, 2018 5:15 PM
>>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>>> Subject: TeraScript-Talk: Webcalls and HTTPS
>>>
>>> Hi all,
>>>
>>> I have a platform that gets it’s content from another site (all authorised) 
>>> via Webcalls. They recently implemented SSL for all their site and my 
>>> Webcalls no longer work:
>>>
>>> Unable to send data when processing URL request.
>>> wrong when connecting with SSL Server aborted the SSL handshake
>>>
>>> I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other 
>>> options.
>>>
>>> Is it possible to do a Webcall using HTTPS?
>>>
>>> What is involved?
>>>
>>> Wayne
>>>
>>>
>>> Byteserve Pty Ltd
>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>>> p: +61 02 9960 6099
>>> m: 0409 960 609
>>> f: +61 02 9960 6088
>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

bugGER!

Wayne

> On 12 Sep 2018, at 11:46 pm, Robert Shubert  wrote:
>
> Looks like you just reported a bug.
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Tuesday, September 11, 2018 5:07 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>
> 7.1.3.1
>
>
>> On 12 Sep 2018, at 4:53 am, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> Version of TS?
>>
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Tuesday, September 11, 2018 12:42 AM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>>
>> I have this and get the error:
>> 
>>
>>
>>> On 11 Sep 2018, at 1:12 pm, Robert Shubert >> <mailto:rshub...@tronics.com>> wrote:
>>>
>>> You just need to use an https:// url and the server will switch to SSL.
>>>
>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>>> <mailto:wa...@byteserve.com.au>]
>>> Sent: Monday, September 10, 2018 5:15 PM
>>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>>> Subject: TeraScript-Talk: Webcalls and HTTPS
>>>
>>> Hi all,
>>>
>>> I have a platform that gets it’s content from another site (all authorised) 
>>> via Webcalls. They recently implemented SSL for all their site and my 
>>> Webcalls no longer work:
>>>
>>> Unable to send data when processing URL request.
>>> wrong when connecting with SSL Server aborted the SSL handshake
>>>
>>> I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other 
>>> options.
>>>
>>> Is it possible to do a Webcall using HTTPS?
>>>
>>> What is involved?
>>>
>>> Wayne
>>>
>>>
>>> Byteserve Pty Ltd
>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>>> p: +61 02 9960 6099
>>> m: 0409 960 609
>>> f: +61 02 9960 6088
>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

7.1.3.1


> On 12 Sep 2018, at 4:53 am, Robert Shubert  wrote:
>
> Version of TS?
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Tuesday, September 11, 2018 12:42 AM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Webcalls and HTTPS
>
> I have this and get the error:
> 
>
>
>> On 11 Sep 2018, at 1:12 pm, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> You just need to use an https:// url and the server will switch to SSL.
>>
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Monday, September 10, 2018 5:15 PM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: TeraScript-Talk: Webcalls and HTTPS
>>
>> Hi all,
>>
>> I have a platform that gets it’s content from another site (all authorised) 
>> via Webcalls. They recently implemented SSL for all their site and my 
>> Webcalls no longer work:
>>
>> Unable to send data when processing URL request.
>> wrong when connecting with SSL Server aborted the SSL handshake
>>
>> I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other 
>> options.
>>
>> Is it possible to do a Webcall using HTTPS?
>>
>> What is involved?
>>
>> Wayne
>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

I have this and get the error:



> On 11 Sep 2018, at 1:12 pm, Robert Shubert  wrote:
>
> You just need to use an https:// url and the server will switch to SSL.
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Monday, September 10, 2018 5:15 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Webcalls and HTTPS
>
> Hi all,
>
> I have a platform that gets it’s content from another site (all authorised) 
> via Webcalls. They recently implemented SSL for all their site and my 
> Webcalls no longer work:
>
> Unable to send data when processing URL request.
> wrong when connecting with SSL Server aborted the SSL handshake
>
> I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other 
> options.
>
> Is it possible to do a Webcall using HTTPS?
>
> What is involved?
>
> Wayne
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Webcalls and HTTPS

[Wayne Irvine]

Hi all,

I have a platform that gets it’s content from another site (all authorised) via 
Webcalls. They recently implemented SSL for all their site and my Webcalls no 
longer work:

Unable to send data when processing URL request.
wrong when connecting with SSL Server aborted the SSL handshake

I notice the Protocol drop down says ‘HTTP/1.1’ but there are no other options.

Is it possible to do a Webcall using HTTPS?

What is involved?

Wayne


Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Insert action results

[Wayne Irvine]

That’s exactly what I do at present. Before I insert I create a GUID, then 
after I search for that GUID.

Wayne

> On 21 Jul 2018, at 2:51 am, D Mark Weiss  wrote:
>
> If I understand...Years ago I was taught this technique which I am sure you 
> know already.
>
> Prior to an insert create a unique variable.
> When you make the insert save that variable into a column for that record
> Then select row ID or unique ID for that row using that same variable on that 
> column.
>
> I suppose it’s not elegant. But it really doesn’t create that much overhead I 
> don’t think
>
> Mark
>
>
>
> D Mark Weiss
> CM Harbor, LLC
> PonyTracker
> 435-363-6363
>
>> On Jul 20, 2018, at 10:16 AM, Wayne Irvine  wrote:
>>
>> <@NUMAFFECTED> returns 1
>>> On 21 Jul 2018, at 1:52 am, Robert Shubert  wrote:
>>>
>>> It may now. Check @NUMAFFECTED afterwards.
>>>
>>> This is something we're looking at supporting better in v8 with an explicit 
>>> flag to obtain the identity after insert. JDBC supports a mechanism for 
>>> doing so, but we need to explicitly invoke it.
>>>
>>> Robert
>>>
>>> -Original Message-
>>> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
>>> Sent: Thursday, July 19, 2018 7:56 PM
>>> To: TeraScript-Talk@terascript.com
>>> Subject: Re: TeraScript-Talk: Insert action results
>>>
>>> Scratch that. Seems I asked the same question 5 years ago. The answer in 
>>> the case of FMS as a JDBC datasource is no.
>>>
>>>> On 20 Jul 2018, at 12:48 pm, Wayne Irvine  wrote:
>>>>
>>>> The Search action returns @@resultset. Does the Insert action return any 
>>>> results (a row ID for example) and if so how do we access it?
>>>>
>>>> Wayne
>>>>
>>>> Byteserve Pty Ltd
>>>> w: http://www.byteserve.com.au/
>>>> e: i...@byteserve.com.au
>>>> p: +61 02 9960 6099
>>>> m: 0409 960 609
>>>> f: +61 02 9960 6088
>>>>
>>>>
>>>>
>>>>
>>>> 
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>>
>>>
>>> Byteserve Pty Ltd
>>> w: http://www.byteserve.com.au/
>>> e: i...@byteserve.com.au
>>> p: +61 02 9960 6099
>>> m: 0409 960 609
>>> f: +61 02 9960 6088
>>>
>>>
>>>
>>>
>>> 
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>
>>>
>>>
>>>
>>> 
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: maxlength="0"

[Wayne Irvine]

Type is text:


Wayne

> On 21 Jul 2018, at 1:53 am, Robert Shubert  wrote:
>
> Is this a FM data source? If so, what’s the data type of that column in 
> FileMaker?
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
> <mailto:wa...@byteserve.com.au>]
> Sent: Thursday, July 19, 2018 5:56 PM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: Re: TeraScript-Talk: maxlength="0"
>
> Size: 0
>
> 
>
> Wayne
>
>> On 20 Jul 2018, at 6:50 am, Robert Shubert > <mailto:rshub...@tronics.com>> wrote:
>>
>> This should work as expected, meaning, it should set the maxlength attribute 
>> on the form to the length of the field in the database.
>>
>> Can you tell me what kind of column it is? When you click on the column in 
>> the database tab, what does the size: property say? (at the bottom of the 
>> tab)
>>
>> -Original Message-
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Wednesday, July 18, 2018 6:51 PM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: TeraScript-Talk: maxlength="0"
>>
>> I still use the Builders to start many projects. One bug that has crept in 
>> and I find most annoying is how the INPUT fields default to MAXLENGTH=“0”.
>>
>> 
>> Packagename:
>> > maxLength="0"> 
>>
>> I’m running 7.0.1 (OSX) and all efforts to upgrade to 7.0.3 (to hopefully 
>> alleviate this bug) have been unsuccessful. Today I thought I’d have a look 
>> around the code (specifically Snippets) for any mention of MAXLENGTH but 
>> alas, was unsuccessful.
>>
>> Any pointers on where I might look?
>>
>> Wayne Irvine
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Insert action results

[Wayne Irvine]

<@NUMAFFECTED> returns 1
> On 21 Jul 2018, at 1:52 am, Robert Shubert  wrote:
>
> It may now. Check @NUMAFFECTED afterwards.
>
> This is something we're looking at supporting better in v8 with an explicit 
> flag to obtain the identity after insert. JDBC supports a mechanism for doing 
> so, but we need to explicitly invoke it.
>
> Robert
>
> -----Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Thursday, July 19, 2018 7:56 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Insert action results
>
> Scratch that. Seems I asked the same question 5 years ago. The answer in the 
> case of FMS as a JDBC datasource is no.
>
>> On 20 Jul 2018, at 12:48 pm, Wayne Irvine  wrote:
>>
>> The Search action returns @@resultset. Does the Insert action return any 
>> results (a row ID for example) and if so how do we access it?
>>
>> Wayne
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Insert action results

[Wayne Irvine]

Scratch that. Seems I asked the same question 5 years ago. The answer in the 
case of FMS as a JDBC datasource is no.

> On 20 Jul 2018, at 12:48 pm, Wayne Irvine  wrote:
>
> The Search action returns @@resultset. Does the Insert action return any 
> results (a row ID for example) and if so how do we access it?
>
> Wayne
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Insert action results

[Wayne Irvine]

The Search action returns @@resultset. Does the Insert action return any 
results (a row ID for example) and if so how do we access it?

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Remove non-alphanumeric characters

[Wayne Irvine]

That is awesome! I wasn’t aware of KEEP and suspect it will do what I need.

Thanks also for the explanation on REGEX. I wondered why I couldn’t get it to 
work.

Wayne

> On 20 Jul 2018, at 7:17 am, Robert Shubert  wrote:
>
> Before we get into the regex, @KEEP might be an option:
>
> <@! "remove everything but letters and numbers">
> <@KEEP <@ARG input> abcdefghijklmnopqrstuvwxyz1234567890>
>
> Regex in @REPLACE works a little differently than what the SO article says. I 
> adapted one of the answers to this:
>
> <@REPLACE <@ARG input> findstr="[^0-9a-zA-Z]" replacestr="" type="regex">
>
> Lastly, there's an easy way to use the bit of JavaScript right from the SO 
> answer, which you can run server-side:
>
> <@SCRIPT expr='"<@ARG input encoding=javascript>".replace(/\W/g, "")'>
>
> Robert
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Wednesday, July 18, 2018 7:21 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Remove non-alphanumeric characters
>
> I have a situation where users might type in a string and I need to make a 
> simple alphanumeric code from it.
>
> Previously I’ve used a bunch of REPLACE statements, but you can never 
> underestimate fools. ;)
>
> I’m playing around with REGEX (again) and as usual, it has me stumped. I 
> would like to code a simple REGEX (oxymoron) statement that will take a 
> string of characters and return either a string with only alphanumerics and 
> spaces, or an array of strings with only alphanumerics.
>
> Wayne
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: maxlength="0"

[Wayne Irvine]

Size: 0



Wayne

> On 20 Jul 2018, at 6:50 am, Robert Shubert  wrote:
>
> This should work as expected, meaning, it should set the maxlength attribute 
> on the form to the length of the field in the database.
>
> Can you tell me what kind of column it is? When you click on the column in 
> the database tab, what does the size: property say? (at the bottom of the tab)
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Wednesday, July 18, 2018 6:51 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: maxlength="0"
>
> I still use the Builders to start many projects. One bug that has crept in 
> and I find most annoying is how the INPUT fields default to MAXLENGTH=“0”.
>
> 
>   Packagename:
>maxLength="0"> 
>
> I’m running 7.0.1 (OSX) and all efforts to upgrade to 7.0.3 (to hopefully 
> alleviate this bug) have been unsuccessful. Today I thought I’d have a look 
> around the code (specifically Snippets) for any mention of MAXLENGTH but 
> alas, was unsuccessful.
>
> Any pointers on where I might look?
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Remove non-alphanumeric characters

[Wayne Irvine]

Because I am interested in the Terascript implementation of REGEX.

Wayne

> On 19 Jul 2018, at 2:02 pm, Peter Dobbs  wrote:
>
> Why not implement in JavaScript and bounce any requests that don’t comply?
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151  | F: 
> 416.901.6150  | www.enginess.io 
>
>
>
> This email and any attachments are confidential and are intended only for the 
> person(s) to whom it is addressed. It you are not the addressee named above, 
> any use, copying, distribution or disclosure is strictly unauthorized. If you 
> have received this information in error, please delete it and any attachments 
> and notify me immediately.
>
>
> On Jul 18, 2018, at 11:24 PM, Wayne Irvine  <mailto:wa...@byteserve.com.au>> wrote:
>
>> Cheers. I was viewing this exact StackOverflow article prior to submitting 
>> my question.
>>
>> The question is more on implementing the REGEX statement in terascript, than 
>> the actual REGEx statement.
>>
>> Wayne
>>
>>> On 19 Jul 2018, at 12:55 pm, Peter Dobbs >> <mailto:pe...@enginess.io>> wrote:
>>>
>>> https://stackoverflow.com/questions/9364400/remove-not-alphanumeric-characters-from-string-having-trouble-with-the-char
>>>  
>>> <https://stackoverflow.com/questions/9364400/remove-not-alphanumeric-characters-from-string-having-trouble-with-the-char>
>>>
>>>
>>> Peter Dobbs
>>> President | ENGINESS | P: 416.901.6151  | F: 
>>> 416.901.6150  | www.enginess.io 
>>> 
>>>
>>>
>>>
>>> This email and any attachments are confidential and are intended only for 
>>> the person(s) to whom it is addressed. It you are not the addressee named 
>>> above, any use, copying, distribution or disclosure is strictly 
>>> unauthorized. If you have received this information in error, please delete 
>>> it and any attachments and notify me immediately.
>>>
>>>
>>> On Jul 18, 2018, at 10:19 PM, Wayne Irvine >> <mailto:wa...@byteserve.com.au>> wrote:
>>>
>>>> I have a situation where users might type in a string and I need to make a 
>>>> simple alphanumeric code from it.
>>>>
>>>> Previously I’ve used a bunch of REPLACE statements, but you can never 
>>>> underestimate fools. ;)
>>>>
>>>> I’m playing around with REGEX (again) and as usual, it has me stumped. I 
>>>> would like to code a simple REGEX (oxymoron) statement that will take a 
>>>> string of characters and return either a string with only alphanumerics 
>>>> and spaces, or an array of strings with only alphanumerics.
>>>>
>>>> Wayne
>>>>
>>>> Byteserve Pty Ltd
>>>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>>>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>>>> p: +61 02 9960 6099
>>>> m: 0409 960 609
>>>> f: +61 02 9960 6088
>>>>
>>>>
>>>>
>>>>
>>>> 
>>>>
>>>> To unsubscribe from this list, please send an email to 
>>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>>> terascript-talk" in the body.
>>>>
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>>> terascript-talk" in the body.
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Remove non-alphanumeric characters

[Wayne Irvine]

Cheers. I was viewing this exact StackOverflow article prior to submitting my 
question.

The question is more on implementing the REGEX statement in terascript, than 
the actual REGEx statement.

Wayne

> On 19 Jul 2018, at 12:55 pm, Peter Dobbs  wrote:
>
> https://stackoverflow.com/questions/9364400/remove-not-alphanumeric-characters-from-string-having-trouble-with-the-char
>  
> <https://stackoverflow.com/questions/9364400/remove-not-alphanumeric-characters-from-string-having-trouble-with-the-char>
>
>
> Peter Dobbs
> President | ENGINESS | P: 416.901.6151  | F: 
> 416.901.6150  | www.enginess.io 
>
>
>
> This email and any attachments are confidential and are intended only for the 
> person(s) to whom it is addressed. It you are not the addressee named above, 
> any use, copying, distribution or disclosure is strictly unauthorized. If you 
> have received this information in error, please delete it and any attachments 
> and notify me immediately.
>
>
> On Jul 18, 2018, at 10:19 PM, Wayne Irvine  <mailto:wa...@byteserve.com.au>> wrote:
>
>> I have a situation where users might type in a string and I need to make a 
>> simple alphanumeric code from it.
>>
>> Previously I’ve used a bunch of REPLACE statements, but you can never 
>> underestimate fools. ;)
>>
>> I’m playing around with REGEX (again) and as usual, it has me stumped. I 
>> would like to code a simple REGEX (oxymoron) statement that will take a 
>> string of characters and return either a string with only alphanumerics and 
>> spaces, or an array of strings with only alphanumerics.
>>
>> Wayne
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Remove non-alphanumeric characters

[Wayne Irvine]

I have a situation where users might type in a string and I need to make a 
simple alphanumeric code from it.

Previously I’ve used a bunch of REPLACE statements, but you can never 
underestimate fools. ;)

I’m playing around with REGEX (again) and as usual, it has me stumped. I would 
like to code a simple REGEX (oxymoron) statement that will take a string of 
characters and return either a string with only alphanumerics and spaces, or an 
array of strings with only alphanumerics.

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: maxlength="0"

[Wayne Irvine]

I still use the Builders to start many projects. One bug that has crept in and 
I find most annoying is how the INPUT fields default to MAXLENGTH=“0”.


Packagename:



I’m running 7.0.1 (OSX) and all efforts to upgrade to 7.0.3 (to hopefully 
alleviate this bug) have been unsuccessful. Today I thought I’d have a look 
around the code (specifically Snippets) for any mention of MAXLENGTH but alas, 
was unsuccessful.

Any pointers on where I might look?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: text/chat/forum

[Wayne Irvine]

I’m looking to add some conversation to pages in a site I am developing.

The plan is to use some AJAX to submit comments and update an almost live feed.

I could use periodic checks of the server for new messages, but a push system 
would use less resources and be more responsive.

Has anyone worked on something like this in Terascript?

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Terascribe 7.0.3

[Wayne Irvine]

Just found this:

Jun 25 15:23:32 waynesmacbook com.apple.xpc.launchd[1] 
(com.apple.xpc.launchd.oneshot.0x1023.TeraScribe7[84831]): Service exited 
due to signal: Killed: 9 sent by CoreServicesUIAgent[540]
Jun 25 15:23:58 waynesmacbook TeraScribe7[84869]: assertion failed: 16G1408: 
libxpc.dylib + 74307 [BF896DF0-D8E9-31A8-A4B3-01120BFEEE52]: 0x89
Jun 25 15:26:28 waynesmacbook TeraScribe7[85341]: assertion failed: 16G1408: 
libxpc.dylib + 74307 [BF896DF0-D8E9-31A8-A4B3-01120BFEEE52]: 0x89

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Mail relaying

[Wayne Irvine]

> On 13 Jun 2018, at 8:56 am, Robert Shubert  wrote:
>
> The Relay Access Denied error should be simple to address – do a search for 
> that and postfix. There should be a setting to allow local relay without 
> credentials.
>
> Looks like something along the lines of:
>
> smtpd_recipient_restrictions = permit_mynetworks

The file main.cf has a load of very confusing options and it’s not unless you 
scroll to the bottom do you find the parameters that Apple actually uses.

Adding:
smtpd_recipient_restrictions = permit_sasl_authenticated  permit_mynetworks 
reject_unauth_destination permit
did the trick.

Thanks Robert.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Mail relaying

[Wayne Irvine]

I’m having an issue with T7 sending mail through the Mac OS X Server mail 
server (on the same machine).

server.ini is setup correctly:
MAILDEFAULTFROM=i...@byteserve.com.au
MAILPORT=25
MAILSERVER=mail.byteserve.com.au
MAILSWITCH=on

When using the defaults in the mail actions and I try to send an email to an 
external address (not one of the local accounts) i get:
Error occured when sending email message.
[Start]:Session Id: Protocol: SMTP Server: mail.byteserve.com.au Port: 25 User: 
(null) Password [Response]: 220 macstadium.byteserve.com.au ESMTP Postfix 
[Command]: HELO macstadium.byteserve.com.au [Response]: 250 
macstadium.byteserve.com.au [Command]: MAIL FROM: [Response]: 250 2.1.0 Ok 
[Command]: RCPT TO: [Response]: 554 5.7.1 : Relay access denied [Command]: RSET 
[Response]: 250 2.0.0 Ok [Command]: QUIT [Response]: 221 2.0.0 Bye 
[End]:Session Id: (null)

Mac OS X Server no longer has an Allowed Networks option so I’ve edited Postfix 
main.cf and added a bunch of IPs in the mynetworks section to no avail.

I’ve also tried using Authenticated SMTP in Terascript:
Error occured when sending email message.
[Start]:Session Id: Protocol: SMTP Server: mail.byteserve.com.au Port: 587 
User: wayneirvine Password  [Response]: 220 macstadium.byteserve.com.au 
ESMTP Postfix [Command]: HELO macstadium.byteserve.com.au [Response]: 250 
macstadium.byteserve.com.au [Command]: MAIL FROM: [Response]: 530 5.7.0 Must 
issue a STARTTLS command first [Command]: RSET [Response]: 530 5.7.0 Must issue 
a STARTTLS command first [Command]: QUIT [Response]: 221 2.0.0 Bye 
[End]:Session Id: (null)

Bit stuck as to what to try next.

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: longbinary

[Wayne Irvine]

Never done this before so not even sure if it is possible.

I’m returning a Container field from FileMaker. It is an image stored in the 
database.

Terascript sees it as a longbinary. What tags/syntax should I use to display? 
I’ve seen images returned with some base64 nomenclature and expect it is 
similar to that.

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Won't open

[Wayne Irvine]

I saved a TAF today and it now won’t open in Terascribe. No error message about 
bad structure, just no response.

Still runs successfully but I can’t edit it.






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


tourscraperGlobustest.taf
Description: Binary data


Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Request timeout

[Wayne Irvine]

That sounds familiar.

So at the head of the TAF:

<@assign user$configPasswd value=“password">
<@ASSIGN system$querytimeout 1200>
<@purge user$configPasswd>


At the bottom:
<@assign user$configPasswd value=“password">
<@ASSIGN system$querytimeout 300>
<@purge user$configPasswd>

Wayne
> On 17 Apr 2018, at 12:45 am, Robert Shubert <rshub...@tronics.com> wrote:
>
> This is accurate.
>
> You can also edit the server.ini file and change the value on line 
> QUERYTIMEOUT=
>
> If you do the @ASSIGN below, you need to <@ASSIGN system$querytimeout 1234>
>
> The <@RELOADCONFIG> tag is used to reload changes to the server.ini file 
> without restarting.
>
> If you don’t want the timeout to be permanently changed, then you need to 
> raise it at the top of this TAF and lower it again when it’s done.
>
> One last thing. Servers tend to run better with lower timeouts, since long 
> running requests can be problematic. Consider instead forking a new thread 
> like this:
>
> <@IF “<@TIMER> > <@CALC “@@querytimeout *900”>>
> <@URL <@DOMAIN><@APPFILE>?start={where to pickup} 
> waitforresult=false>
> 
>
> If you’re thinking about using v8, there are other methods there can do this 
> as well.
>
> Robert
>
> From: Fogelson, Steve [mailto:foge...@askics.net <mailto:foge...@askics.net>]
> Sent: Monday, April 16, 2018 6:40 AM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: RE: TeraScript-Talk: Request timeout
>
> I have done that before, but I don’t remember how. I do recall I had to 
> provide the system password as defined in server.ini file
>
> It may be similar to this
>
> <@assign user$configPasswd value="x">
> <@reloadconfig> or <@assign > in your case
> <@purge user$configPasswd>
>
> Steve
>
> From: Wayne Irvine <wa...@byteserve.com.au <mailto:wa...@byteserve.com.au>>
> Sent: Monday, April 16, 2018 12:17 AM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: Re: TeraScript-Talk: Request timeout
>
> Yes it is. And there is a procedure to override it per TAF.
>
> It is this procedure that I am not sure of.
>
> W
>
>> On 16 Apr 2018, at 11:50 am, Fogelson, Steve <foge...@askics.net 
>> <mailto:foge...@askics.net>> wrote:
>>
>> Hi Wayne,
>>
>> Don’t know if this is what you are looking for. Hope it helps.
>> QueryTimeout
>>
>> System scope only
>> This configuration file variable causes queries that exceed the specified 
>> number of seconds to time out and return the HTML page specified in 
>> timeoutHTML. This variable is specified in seconds. The default value of 
>> queryTimeout is 300.
>> timeoutHTML
>>
>> System scope only
>> This configuration variable points to the HTML file that is returned when a 
>> query times out in TeraScript Server. The file is by default called 
>> timeout.html and resides in the configuration directory. See “A Note on 
>> Default Locations” on page 381.
>>
>> Steve Fogelson
>>
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
>> <mailto:wa...@byteserve.com.au>]
>> Sent: Sunday, April 15, 2018 6:02 PM
>> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
>> Subject: TeraScript-Talk: Request timeout
>>
>> I know I have come across this before, but not in the last decade and I 
>> can’t find the example.
>>
>> I have a TAF that takes a while to run. It is using the Web Call action to 
>> load pages and extracting information from them. It just came up with:
>>
>> Request timeout.
>>
>> If I remember correctly queryTimeout is a configuration variable and a 
>> certain process needs to be followed to change it (and change it back at the 
>> end of the query. But I can’t remember the syntax.
>>
>> Any help would be appreciated.
>>
>> Wayne
>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
>> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
>> terascript-talk" in the body.
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com <ma

Re: TeraScript-Talk: Request timeout

[Wayne Irvine]

Yes it is. And there is a procedure to override it per TAF.

It is this procedure that I am not sure of.

W

> On 16 Apr 2018, at 11:50 am, Fogelson, Steve <foge...@askics.net> wrote:
>
> Hi Wayne,
>
> Don’t know if this is what you are looking for. Hope it helps.
> QueryTimeout
>
> System scope only
> This configuration file variable causes queries that exceed the specified 
> number of seconds to time out and return the HTML page specified in 
> timeoutHTML. This variable is specified in seconds. The default value of 
> queryTimeout is 300.
> timeoutHTML
>
> System scope only
> This configuration variable points to the HTML file that is returned when a 
> query times out in TeraScript Server. The file is by default called 
> timeout.html and resides in the configuration directory. See “A Note on 
> Default Locations” on page 381.
>
> Steve Fogelson
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au 
> <mailto:wa...@byteserve.com.au>]
> Sent: Sunday, April 15, 2018 6:02 PM
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: TeraScript-Talk: Request timeout
>
> I know I have come across this before, but not in the last decade and I can’t 
> find the example.
>
> I have a TAF that takes a while to run. It is using the Web Call action to 
> load pages and extracting information from them. It just came up with:
>
> Request timeout.
>
> If I remember correctly queryTimeout is a configuration variable and a 
> certain process needs to be followed to change it (and change it back at the 
> end of the query. But I can’t remember the syntax.
>
> Any help would be appreciated.
>
> Wayne
>
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au <mailto:i...@byteserve.com.au>
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Request timeout

[Wayne Irvine]

I know I have come across this before, but not in the last decade and I can’t 
find the example.

I have a TAF that takes a while to run. It is using the Web Call action to load 
pages and extracting information from them. It just came up with:

Request timeout.

If I remember correctly queryTimeout is a configuration variable and a certain 
process needs to be followed to change it (and change it back at the end of the 
query. But I can’t remember the syntax.

Any help would be appreciated.

Wayne


Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: XML help

[Wayne Irvine]

> On 13 Apr 2018, at 8:51 am, ubslab  wrote:
>
> regex between '' and first/next occurrence of 
> '' ?
In the meantime I’ve converted to an array of lines and grabbed the lines 
between 'http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: <@ELEMENTATTRIBUTE> is pink!

[Wayne Irvine]

I’m trying to get the src value of an element in XML but <@ELEMENTATTRIBUTE... 
comes up pink in the editor.

Has this been deprecated? I’m working off old Witango 6 Programmers manual.

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: @DOM

[Wayne Irvine]

I have used the @DOM tag previously to encapsulate XML and then referred to 
various elements within it.

Does it also work for HTML? Can I encapsulate a page then refer to various 
nodes in it using the Document Object Model nomenclature?

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Facebook social login

[Wayne Irvine]

I have most of the javascript example working but am stuck on how it returns 
information.

Wayne

> On 21 Mar 2018, at 2:30 am, Robert Shubert <rshub...@tronics.com> wrote:
>
> I haven't worked with the current API version. But let me know if you any 
> help, it's fairly straight forward.
>
> Robert
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Monday, March 19, 2018 5:36 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Facebook social login
>
> Years ago I wrote some Terascript to do social login via Janrain, which 
> provides login through a number of social media platforms. Kinda cumbersome 
> and a lot of unnecessary stuffing about and expense with Janrain.
>
> Before I embark on a ‘direct to Facebook’ venture, has anyone done this 
> already? My Facebook app is set up and just waiting for me hook up to it. I’d 
> rather not re-invent the wheel though.
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Facebook social login

[Wayne Irvine]

It looks interesting but I’m wondering if I’d just be chasing another goose.

W

> On 21 Mar 2018, at 7:32 am, Robert Shubert <rshub...@tronics.com> wrote:
>
> The suggestion was made to check out Amazon Cognito.
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Monday, March 19, 2018 5:36 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Facebook social login
>
> Years ago I wrote some Terascript to do social login via Janrain, which 
> provides login through a number of social media platforms. Kinda cumbersome 
> and a lot of unnecessary stuffing about and expense with Janrain.
>
> Before I embark on a ‘direct to Facebook’ venture, has anyone done this 
> already? My Facebook app is set up and just waiting for me hook up to it. I’d 
> rather not re-invent the wheel though.
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Facebook social login

[Wayne Irvine]

Years ago I wrote some Terascript to do social login via Janrain, which 
provides login through a number of social media platforms. Kinda cumbersome and 
a lot of unnecessary stuffing about and expense with Janrain.

Before I embark on a ‘direct to Facebook’ venture, has anyone done this 
already? My Facebook app is set up and just waiting for me hook up to it. I’d 
rather not re-invent the wheel though.

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Accessing tafs in other folders

[Wayne Irvine]

> On 24 Feb 2018, at 2:08 am, Robert Shubert <rshub...@tronics.com> wrote:
>
> Yes, it does.

Ah bugger, not sure why I didn’t know about that. I assume my method pre-dates 
the metatag. Or I really should be more aware (again).

Wayne

>
> Note that on my servers, I have @WEBROOT set in the absolutepathprefix, so 
> all paths are automatically prefixed to your webroot.
>
> Therefore, typing: /file.txt
> is as if you typed: <@WEBROOT>file.txt
>
> -Original Message-
> From: D Mark Weiss [mailto:dadwe...@mac.com]
> Sent: Thursday, February 22, 2018 4:16 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Accessing tafs in other folders
>
> THis is a great idea.
>
> Does <@webroot> do the same thing?
>
> Mark
>
>> On Feb 22, 2018, at 4:51 PM, Wayne Irvine <wa...@byteserve.com.au> wrote:
>>
>> For an @INCLUDE I just use the web path ‘/includes/header.txt’.
>>
>>
>> For an absolute file path (like in the File Action) I have a file 
>> ‘filepath.txt’ in the root of each website that contains the absolute path 
>> to the root of the site.
>> /Library/Server/Web/Data/Sites/~website/
>>
>> So whenever I want to reference a file or directory in that website I use:
>> <@INCLUDE FILE=‘/filepath.txt’>the/path/to/the/file
>>
>> Wayne
>>
>>> On 23 Feb 2018, at 3:31 am, D Mark Weiss <dadwe...@mac.com> wrote:
>>>
>>> I have a folder. In that folder I have a taf.  I would like that taf to 
>>> access an includes document in another folder.  Like a header and footer 
>>> for example. How do I create a path back out of a folder and Into another..
>>>
>>> Like <@appfilepath>../otherfolder/otherdocument.html
>>>
>>> Or is there an easier way?
>>>
>>> Mark
>>>
>>>
>>>
>>>
>>> 
>>>
>>> To unsubscribe from this list, please send an email to 
>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>>
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>> 
>>
>> To unsubscribe from this list, please send an email to 
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Accessing tafs in other folders

[Wayne Irvine]

For an @INCLUDE I just use the web path ‘/includes/header.txt’.


For an absolute file path (like in the File Action) I have a file 
‘filepath.txt’ in the root of each website that contains the absolute path to 
the root of the site.
/Library/Server/Web/Data/Sites/~website/

So whenever I want to reference a file or directory in that website I use:
<@INCLUDE FILE=‘/filepath.txt’>the/path/to/the/file

Wayne

> On 23 Feb 2018, at 3:31 am, D Mark Weiss  wrote:
>
> I have a folder. In that folder I have a taf.  I would like that taf to 
> access an includes document in another folder.  Like a header and footer for 
> example. How do I create a path back out of a folder and Into another..
>
> Like <@appfilepath>../otherfolder/otherdocument.html
>
> Or is there an easier way?
>
> Mark
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Return a directory listing

[Wayne Irvine]

Oh wow, I must really be more aware.

Wayne

> On 22 Feb 2018, at 5:36 am, Robert Shubert <rshub...@tronics.com> wrote:
>
> As of version 6 there's a Directory Listing action.
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Tuesday, February 20, 2018 5:30 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Return a directory listing
>
> As usual, 5 seconds after I press send I come up with the solution.
>
> I wrote a script ‘listSPAMdirectory.sh’:
>
> #!/bin/sh
> # list SPAM directory
> cd /Library/Server/Web/Data/Sites/~byteserve/SPAM/
> ls -1
>
> I then called it from the Command Line action.
>
> And then displayed ‘@@resultset’
>
> DONE!
>
> Wayne Irvine
>
> _
>
> I would like to return the list of files in a directory
>
> ls -1
>
> I use the Command Line Action and type the absolute path followed by the 
> above command.
>
> How do I direct the results to a var?
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Distinct IPs

[Wayne Irvine]

I am building a tool to allow me to add addresses to Postfix list of banned IPs.

I’ve got it parsing the files and extracting the IPs and sorting them in order, 
but I can’t get @DISTINCT to work.

<@ASSIGN NAME=DistinctBadIPs VALUE=<@DISTINCT ARRAY=BadIPs COLS="1 DICT" 
SCOPE=local>>


173.240.14.31   Your IP is SPAM!
173.240.14.61   Your IP is SPAM!
185.153.229.0/24Your IP is SPAM!
185.162.146.0/24Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.244.77  Your IP is SPAM!
185.179.246.28  Your IP is SPAM!
185.65.246.142  Your IP is SPAM!
185.70.187.118  Your IP is SPAM!


I’ve tried default (SMART), NUM, and DICT comparison types. Is it due to the 
‘.’s or something dumb I’m doing?

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Return a directory listing

[Wayne Irvine]

As usual, 5 seconds after I press send I come up with the solution.

I wrote a script ‘listSPAMdirectory.sh’:

#!/bin/sh
# list SPAM directory
cd /Library/Server/Web/Data/Sites/~byteserve/SPAM/
ls -1

I then called it from the Command Line action.

And then displayed ‘@@resultset’

DONE!

Wayne Irvine

_

I would like to return the list of files in a directory

ls -1

I use the Command Line Action and type the absolute path followed by the above 
command.

How do I direct the results to a var?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Return a directory listing

[Wayne Irvine]

I would like to return the list of files in a directory

ls -1

I use the Command Line Action and type the absolute path followed by the above 
command.

How do I direct the results to a var?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Requesting a bit of ELEMENTVALUE help

[Wayne Irvine]

Thanks Robert, the *: prefix does the trick.

Wayne

> On 18 Sep 2016, at 4:38 PM, Robert Shubert <rshub...@tronics.com> wrote:
>
> You have to deal with the namespace.
>
> Your xpath is correct except for the wildcard on the namespace prefix, so 
> this works:
>
> <@ELEMENTVALUE myDom 
> xpath='/*:ABRPayloadSearchResults/*:request/*:identifierSearchRequest/*:authenticationGUID'>
>
> Note that all the elements are in the namespace, so you need to wildcard them 
> all.
>
> In simple XML like this, you can just go straight to the element:
>
> <@ELEMENTVALUE myDom xpath='//*:authenticationGUID'>
>
> In the case of this XML, there is a default namespace being setup by this 
> portion of the root node:
>
> xmlns="http://abr.business.gov.au/ABRXMLSearchRPC/literalTypes;
>
> Since it's the default (it's unnamed) you use the wildcard *: to look for any 
> namespace. TS7 doesn't really have namespace interaction, so it's best to do 
> that for everything. In theory, a named namespace and a prefixed element 
> should work in TS xpath.
>
> So, if you don't want to bother with the wildcards, you can @REPLACE that 
> portion of the root element with nothing before you @DOM the XML, then your 
> xpaths would work as you originally had them.
>
> Robert
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Saturday, September 17, 2016 8:29 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Requesting a bit of ELEMENTVALUE help
>
> I have a webcall that returns some XML.
>
> 
> http://www.w3.org/2001/XMLSchema; 
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; 
> xmlns="http://abr.business.gov.au/ABRXMLSearchRPC/literalTypes;>
>  
>
>  
> dd9afbd8-969d-4f7d-aa02-3f742abba131
>  ABN
>  95151285933
>  N
>
>  
> 
>
> I can return a value via XPOINTER.
>
> <@ASSIGN NAME=“GUID" SCOPE="user" VALUE="<@VAR NAME='MyDom' 
> XPOINTER='root().child(1).child(1).child(1)'>">
> @@GUID
>
> returns: dd9afbd8-969d-4f7d-aa02-3f742abba131
>
> But can’t work out the ELEMENTVALUE path to return same:
>
> <@ELEMENTVALUE myDom 
> xpath='/ABRPayloadSearchResults/request/identifierSearchRequest/authenticationGUID’>
>
> returns nothing.
>
> I’m sure it’s something simple (it always is) but it’s got me stumped.
>
> Any help would be appreciated.
>
> Wayne
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
> f: +61 02 9960 6088
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

TeraScript-Talk: Requesting a bit of ELEMENTVALUE help

[Wayne Irvine]

I have a webcall that returns some XML.


http://www.w3.org/2001/XMLSchema; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; 
xmlns="http://abr.business.gov.au/ABRXMLSearchRPC/literalTypes;>
  

  
dd9afbd8-969d-4f7d-aa02-3f742abba131
  ABN
  95151285933
  N

  


I can return a value via XPOINTER.

<@ASSIGN NAME=“GUID" SCOPE="user" VALUE="<@VAR NAME='MyDom' 
XPOINTER='root().child(1).child(1).child(1)'>">
@@GUID

returns: dd9afbd8-969d-4f7d-aa02-3f742abba131

But can’t work out the ELEMENTVALUE path to return same:

<@ELEMENTVALUE myDom 
xpath='/ABRPayloadSearchResults/request/identifierSearchRequest/authenticationGUID’>

returns nothing.

I’m sure it’s something simple (it always is) but it’s got me stumped.

Any help would be appreciated.

Wayne

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088






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

Re: TeraScript-Talk: Invoking Terascript

[Wayne Irvine]

This is Apache 2.4.16 btw.

Wayne




> On 12 Feb 2016, at 10:48 PM, Dale Graham <dale.gra...@gmail.com> wrote:
>
> Did you run the install script after doing the installation? That writes the 
> info needed for Apache. Be sure to run the correct script (e.g., client or 
> server, and the one for the OS).
>
I did but that is for OSX 10.6. In 10.10.5 the folder structure is a little 
different so I went through the steps manually and corrected where necessary.

> The TS conf file ends up located in etc/apache2/others, I believe. The mod 
> file stays at the root of your server application.

Done
>
> Httpd.conf points to the others folder for third party modules
>
> Also, check out the Console. Search on Apache and you might get some insight 
> there if you're still having issues.

I thought I’d first see if there was a verbose mode for starting apache but 
when I quit apache from the terminal I got the following message:
httpd: Syntax error on line 537 of /private/etc/apache2/httpd.conf: Syntax 
error on line 1 of /private/etc/apache2/other/terascript.conf: Cannot load 
/Applications/TeraScript Server 6/terascript60_OSX_apache22_64.so into server: 
dlopen(/Applications/TeraScript Server 6/terascript60_OSX_apache22_64.so, 10): 
Symbol not found: _ap_log_error\n  Referenced from: /Applications/TeraScript 
Server 6/terascript60_OSX_apache22_64.so\n  Expected in: flat namespace\n in 
/Applications/TeraScript Server 6/terascript60_OSX_apache22_64.so


Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609







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

Re: TeraScript-Talk: Invoking Terascript

[Wayne Irvine]

Still working on this.

Thanks Naveen, there is a file ‘terascript60_OSX_apache22_64.so’ in the 
Terascript Server 6 folder.

This file is referenced by ‘terascript.conf’ which is copied by the Install 
script to the /etc/apache2/sites. This folder doesn’t exist in Yosemite so I 
have manually moved it to '/etc/apache2/other’.

The ‘other’ folder is mentioned in httpd.conf as:
Include /private/etc/apache2/other/*.conf
(note: /etc is an alias of /private/etc)

Wayne


> On 12 Feb 2016, at 6:51 PM, Naveen Iyer <naveen.i...@outlook.com> wrote:
>
> Hi Wayne,
>
> There should be some types available, similar to mod_witango55_apache2.so / 
> mod_witango55_apache22.so.
>
> Above is available for version 5.5, so google away and you should find 
> something similar, I hope.
>
> Regards,
> Naveen.
> +919791053598
>
> Sent from my Lumia.
> From: Wayne Irvine <mailto:wa...@byteserve.com.au>
> Sent: ‎12-‎02-‎2016 12:16
> To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com>
> Subject: TeraScript-Talk: Invoking Terascript
>
> I am upgrading my webserver from OSX Server Lion (10.7.5) to OSX Server 
> Yosemite (10.10.5).
>
> I’ve got through most of the process and have Apache running and serving 
> sites and Terascriptd running in the background, but I’m not sure how to get 
> .taf files to get Apache to invoke Terascript and process them.
>
> I tried the ‘Install TeraScript’ script and it seemed to complete 
> successfully but no go. I’ve looked in Apache2/mime.types but there is no 
> mention of taf, terascript or witango there. Same with http.conf.
>
> Any clues as to how Apache needs to know .taf files are processed by 
> Terascript?
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/ <http://www.byteserve.com.au/>
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
>
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe 
> terascript-talk" in the body.

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609







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

TeraScript-Talk: Invoking Terascript

[Wayne Irvine]

I am upgrading my webserver from OSX Server Lion (10.7.5) to OSX Server 
Yosemite (10.10.5).

I’ve got through most of the process and have Apache running and serving sites 
and Terascriptd running in the background, but I’m not sure how to get .taf 
files to get Apache to invoke Terascript and process them.

I tried the ‘Install TeraScript’ script and it seemed to complete successfully 
but no go. I’ve looked in Apache2/mime.types but there is no mention of taf, 
terascript or witango there. Same with http.conf.

Any clues as to how Apache needs to know .taf files are processed by Terascript?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609







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

Re: TeraScript-Talk: Retrieving data from XML

[Wayne Irvine]

Cheers, this seems to do the trick:
<@NUMROWS ARRAY='<@ELEMENTVALUE OBJECT="myDom" 
XPATH="/ppproduct/relateditems/relateditem/title">’>

I’m returning a specific value within the data to an array and NUMROWing it. 
Will have to find a value that all records have.

I still think using the count() prarameter on the ‘relateditem’s would be more 
reliable but can’t work out the syntax.

Wayne

> On 8 Jan 2016, at 9:06 AM, Robert Shubert <rshub...@tronics.com> wrote:
>
> Yes, XPATH is a general way of accessing data in a XML document. It has 
> nothing to do with TeraScript specifically, we just pass your input into 
> third party tools that return results.
>
> As for counting, I think the best way to do this is to get the array and then 
> @NUMROWS it.
>
> You can get an array of matching elements with @ELEMENTVALUE type=array
>
> -Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Thursday, January 07, 2016 1:21 PM
> To: TeraScript-Talk@terascript.com
> Subject: Re: TeraScript-Talk: Retrieving data from XML
>
> Cheers Robert, not sure why I have never come across that before in the 
> manual.
>
> It seems to do all I want to do, but doesn’t give examples for how to do 
> things like count(). I’ll look up XPATH in general on Google (assuming it’s a 
> standard implementation) but would it be possible for you to specify an 
> example which returns the number of relateditems?
>
> Wayne
>
>> On 8 Jan 2016, at 4:48 AM, Robert Shubert <rshub...@tronics.com> wrote:
>>
>> Wayne,
>>
>> You need to switch to the XPATH syntax. You can do all of what you are 
>> looking for with that.
>>
>> XPOINTER is long dead, and won't be supported in future versions. It's 
>> important that you switch to XPATH.
>>
>> Robert
>>
>> -Original Message-
>> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
>> Sent: Thursday, January 07, 2016 3:32 AM
>> To: TeraScript-Talk@terascript.com
>> Subject: TeraScript-Talk: Retrieving data from XML
>>
>> I’ve been tasked with converting a large static site to dynamic database 
>> driven CMS.
>>
>> The first step was downloading all the pages and then converting them to a 
>> XML structure (see example below). I then load the text file into a DOM and 
>> can pull out ELEMENTVALUES at will and inject them into tables.
>>
>> <@ASSIGN NAME="myDom" SCOPE="request" VALUE="<@DOM VALUE='@@datafile'>">
>>
>> <@ELEMENTVALUE OBJECT="myDom" ATTRIBUTE+"UID" 
>> XPOINTER="root().child(1).child(1)”>
>>
>> Returns 'Dinner Time Mr Wolf’.
>>
>> Can I refer to this by it’s name instead (UID)?
>>
>> Also, there are some pages that have repeating fields (one or more 
>> relateditems). I would like to extract this data and inject it into a 
>> related table.
>>
>> I can either got through each of the iterations and insert them individually 
>> (requires a count of instances), or extract as an array and cycle through 
>> the array.
>>
>> Is there a way of extracting the number of instances of a given field in an 
>> XML DOM?
>>
>> Is there a way of extracting all instances at once as an array?
>>
>> Wayne Irvine
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>>
>> 
>>  
>>  Dinner Time Mr Wolf
>>  A traditional playground game that can be used by 
>> one or more children at a time, measuring approximately 7000mm x 
>> 3000mm
>>  
>> http://projectplaygrounds.com.au/playground-marking/traditional-games/dinner-time-mr-wolf
>>  Mr Wolf, traditional Playground game, Feet, 
>> thermoplastic, playground marking, thermal
>>  A traditional playground game that can be used by 
>> one or more children at a time, measuring approximately 7000mm x 
>> 3000mm
>>  Project Playgrounds Australia - Dinner Time Mr 
>> Wolf
>>  dinner-time-mr-wolf
>>  Traditional Games
>>  Dinner Time Mr Wolf" 
>> href="dinner-time-mr-wolf">Dinner Time Mr Wolf
>>  MRW1_1d4b061cb18e1df1af78940b6b43f4a9.jpg
>>  MRW1_b9eeb4ce2e9e34768f77132648731760.jpg
>>  1770.00
>>  MRW2
>>  Thermapply
>>  300cm
>>  700cm
>> 

TeraScript-Talk: Retrieving data from XML

[Wayne Irvine]

I’ve been tasked with converting a large static site to dynamic database driven 
CMS.

The first step was downloading all the pages and then converting them to a XML 
structure (see example below). I then load the text file into a DOM and can 
pull out ELEMENTVALUES at will and inject them into tables.

<@ASSIGN NAME="myDom" SCOPE="request" VALUE="<@DOM VALUE='@@datafile'>">

<@ELEMENTVALUE OBJECT="myDom" ATTRIBUTE+"UID" 
XPOINTER="root().child(1).child(1)”>

Returns 'Dinner Time Mr Wolf’.

Can I refer to this by it’s name instead (UID)?

Also, there are some pages that have repeating fields (one or more 
relateditems). I would like to extract this data and inject it into a related 
table.

I can either got through each of the iterations and insert them individually 
(requires a count of instances), or extract as an array and cycle through the 
array.

Is there a way of extracting the number of instances of a given field in an XML 
DOM?

Is there a way of extracting all instances at once as an array?

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609



Dinner Time Mr Wolf
A traditional playground game that can be used by 
one or more children at a time, measuring approximately 7000mm x 
3000mm

http://projectplaygrounds.com.au/playground-marking/traditional-games/dinner-time-mr-wolf
Mr Wolf, traditional Playground game, Feet, 
thermoplastic, playground marking, thermal
A traditional playground game that can be used by 
one or more children at a time, measuring approximately 7000mm x 
3000mm
Project Playgrounds Australia - Dinner Time Mr 
Wolf
dinner-time-mr-wolf
Traditional Games
Dinner Time Mr Wolf" 
href="dinner-time-mr-wolf">Dinner Time Mr Wolf
MRW1_1d4b061cb18e1df1af78940b6b43f4a9.jpg
MRW1_b9eeb4ce2e9e34768f77132648731760.jpg
1770.00
MRW2
Thermapply
300cm
700cm
0.00kg




hopscotch
Hopscotch
HOP1_2e34efbbc8dec3603114c23b8e245f67
Hopscotch
34
120


hopscotch-rocket-blue-fins
Hopscotch Rocket - Blue Fins
HOP3_07baf173863162a1d671d3fc39940761
Hopscotch Rocket - Blue Fins
64
120


hopscotch-rocket-red-fins
Hopscotch Rocket - Red Fins
HOP2_26cd42dbcfde0aadc5a4633f31b8945a
Hopscotch Rocket - Red Fins
59
120


mr-wolf
Mr Wolf
MRW1A_fbc5ff63ca013fb60a9ee0cd429a064e
Mr Wolf
114
120



hopscotch







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

Re: TeraScript-Talk: Retrieving data from XML

[Wayne Irvine]

Cheers Robert, not sure why I have never come across that before in the manual.

It seems to do all I want to do, but doesn’t give examples for how to do things 
like count(). I’ll look up XPATH in general on Google (assuming it’s a standard 
implementation) but would it be possible for you to specify an example which 
returns the number of relateditems?

Wayne

> On 8 Jan 2016, at 4:48 AM, Robert Shubert <rshub...@tronics.com> wrote:
>
> Wayne,
>
> You need to switch to the XPATH syntax. You can do all of what you are 
> looking for with that.
>
> XPOINTER is long dead, and won't be supported in future versions. It's 
> important that you switch to XPATH.
>
> Robert
>
> -----Original Message-
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Thursday, January 07, 2016 3:32 AM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Retrieving data from XML
>
> I’ve been tasked with converting a large static site to dynamic database 
> driven CMS.
>
> The first step was downloading all the pages and then converting them to a 
> XML structure (see example below). I then load the text file into a DOM and 
> can pull out ELEMENTVALUES at will and inject them into tables.
>
> <@ASSIGN NAME="myDom" SCOPE="request" VALUE="<@DOM VALUE='@@datafile'>">
>
> <@ELEMENTVALUE OBJECT="myDom" ATTRIBUTE+"UID" 
> XPOINTER="root().child(1).child(1)”>
>
> Returns 'Dinner Time Mr Wolf’.
>
> Can I refer to this by it’s name instead (UID)?
>
> Also, there are some pages that have repeating fields (one or more 
> relateditems). I would like to extract this data and inject it into a related 
> table.
>
> I can either got through each of the iterations and insert them individually 
> (requires a count of instances), or extract as an array and cycle through the 
> array.
>
> Is there a way of extracting the number of instances of a given field in an 
> XML DOM?
>
> Is there a way of extracting all instances at once as an array?
>
> Wayne Irvine
>
> Byteserve Pty Ltd
> w: http://www.byteserve.com.au/
> e: i...@byteserve.com.au
> p: +61 02 9960 6099
> m: 0409 960 609
>
> 
>   
>   Dinner Time Mr Wolf
>   A traditional playground game that can be used by 
> one or more children at a time, measuring approximately 7000mm x 
> 3000mm
>   
> http://projectplaygrounds.com.au/playground-marking/traditional-games/dinner-time-mr-wolf
>   Mr Wolf, traditional Playground game, Feet, 
> thermoplastic, playground marking, thermal
>   A traditional playground game that can be used by 
> one or more children at a time, measuring approximately 7000mm x 
> 3000mm
>   Project Playgrounds Australia - Dinner Time Mr 
> Wolf
>   dinner-time-mr-wolf
>   Traditional Games
>   Dinner Time Mr Wolf" 
> href="dinner-time-mr-wolf">Dinner Time Mr Wolf
>   MRW1_1d4b061cb18e1df1af78940b6b43f4a9.jpg
>   MRW1_b9eeb4ce2e9e34768f77132648731760.jpg
>   1770.00
>   MRW2
>   Thermapply
>   300cm
>   700cm
>   0.00kg
>   
>
>   
>   
>   hopscotch
>   Hopscotch
>   HOP1_2e34efbbc8dec3603114c23b8e245f67
>   Hopscotch
>   34
>   120
>   
>   
>   hopscotch-rocket-blue-fins
>   Hopscotch Rocket - Blue Fins
>   HOP3_07baf173863162a1d671d3fc39940761
>   Hopscotch Rocket - Blue Fins
>   64
>   120
>   
>   
>   hopscotch-rocket-red-fins
>   Hopscotch Rocket - Red Fins
>   HOP2_26cd42dbcfde0aadc5a4633f31b8945a
>   Hopscotch Rocket - Red Fins
>   59
>   120
>   
>   
>   mr-wolf
>   Mr Wolf
>   MRW1A_fbc5ff63ca013fb60a9ee0cd429a064e
>   Mr Wolf
>   114
>       120
>   
>   
>   
>   hopscotch
> 
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
>
>
>
> 
>
> To unsubscribe from this list, please send an email to 
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>

Wayne Irvine

Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609







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

Re: TeraScript-Talk: escaping @@varname shorthand

[Wayne Irvine]

Would @LITERAL be usable in this situation?

Wayne

 On 26 Jul 2015, at 8:56 am, Ian Evans ia...@ubookstore.com wrote:

 Hi,

 I need to use a special sql name (@@IDENTITY) in a sql action but this
 name gets rendered by TeraScript as an empty variable. Is there a way to
 escape it such that TeraScript does not try to process it, and the text
 @@IDENTITY makes it to the sql server as part of the statement?

 Thanks,
 -Ian



 

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


Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: Word count (MS Word and PDF)

[Wayne Irvine]

I’m doing some work for a publisher and they require word counts for submitted 
documents in Ms Word and PDF format. Has anyone done any work with this sort of 
thing?

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: Ghostscript is a poltergeist

[Wayne Irvine]

Not sure if this is the right place to ask this but I’m sure some of you guys 
have been through similar situations.

I use Imagemagick (6.7.6-0) to convert manipulate images on my Terascript 
Server (Mac OSX 10.7.5, Terascript 6.2.1). Works well and resizing, blurring 
and combining images. My latest task is to create a jpeg thumbnail from a PDF.

convert -thumbnail x300 /path/to/file/sample.pdf -flatten 
/path/to/image/sample.jpg

If I enter the above in the terminal it works fine. The small jpeg is created 
in the images folder. However, if I use an External action in Terascript to 
call a shell script and pass the arguments through (which is how I do resizes) 
it fails.

The errors in Console are:
29/06/15 10:39:38.114 PM terascript: convert: `%s' (%d) /opt/local/bin/gsx -q 
-dQUIET -dSAFER -dBATCH -dNOPAUSE -dNOPROMPT -dMaxBitmap=5 
-dAlignToPixels=0 -dGridFitTT=2 -sDEVICE=pngalpha -dTextAlphaBits=4 
-dGraphicsAlphaBits=4 -r72x72  
-sOutputFile=/var/folders/vj/scmvh99n6sl0h152_6mrsjw8gn/T/magick-wYNS9NxZ--001
 -f/var/folders/vj/scmvh99n6sl0h152_6mrsjw8gn/T/magick-q1vOyVrY 
-f/var/folders/vj/scmvh99n6sl0h152_6mrsjw8gn/T/magick-VFa6s5rk @ 
error/utility.c/SystemCommand/1896.
29/06/15 10:39:38.114 PM terascript: convert: Postscript delegate failed 
`/path/to/file/sample.pdf': No such file or directory @ 
error/pdf.c/ReadPDFImage/668.
29/06/15 10:39:38.114 PM terascript: convert: missing an image filename 
/path/to/image/sample.jpg' @ error/convert.c/ConvertImageCommand/3017.

I believe the first line is Imagemagick (convert) calling Ghostscript (gsx).
The second is 'Postscript delegate failed' but then erroneously says 'No such 
file or directory’
The third says the target file is missing which is correct.

I also tested the TAF using a jpeg as the input file and it creates the 
thumbnail correctly.

So what we know is:
Terminal/Imagemagick/Ghostscript set up works
Terascript/Imagemagick/Ghostscript doesn’t work
Terascript/Imagemagick works

From this I conclude that it is a permissions or path issue between Terascript 
and Ghostscript.
Terascript is running under my local user account which is a member of the 
group ‘admin'.
gsx has the following permissions -rwxr-xr-x.

That is as far as I have got up to now. Any helps in next steps would be 
appreciated.

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Ghostscript is a poltergeist

[Wayne Irvine]

 On 30 Jun 2015, at 1:25 pm, Robert Shubert rshub...@tronics.com wrote:

 This is usually permissions.

 In the script that TS writes and calls, have it do sudo convert …

Presto!

I changed the script to:
sudo -u $user -p $pass convert….

And passed user and pass as arguments from the external action.

I then strated mucking about with 'echo “password” |…’ before I realised it had 
actually worked.

Thanks for that. Spent all yesterday mucking about with it.

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: External function. Return stdout.

[Wayne Irvine]

Wow, yeah, @@resultset works!

Cheers

Wayne

 On 16 Jun 2015, at 3:02 am, Robert Shubert rshub...@tronics.com wrote:

 What is the @@resultset after executing the external action without pushing 
 stdout to a file (remove the “ pagoda_sm.txt”)

 From: Wayne Irvine [mailto:wa...@byteserve.com.au 
 mailto:wa...@byteserve.com.au]
 Sent: Sunday, June 14, 2015 7:15 PM
 To: TeraScript-Talk@terascript.com mailto:TeraScript-Talk@terascript.com
 Subject: TeraScript-Talk: External function. Return stdout.

 I’ve been using ImageMagick via the External Function action to resize and 
 reformat images for years,

 I’d now like to retrieve EXIF information from uploaded files. ImageMagick 
 handles this in the shell nicely:
 identify -format '%[exif:orientation]' pagoda_sm.jpg

 Returns data like:
 exif:DateTime=2005:07:09 14:05:15
 exif:DateTimeDigitized=2005:07:09 14:05:15
 exif:DateTimeOriginal=2005:07:09 14:05:15
 exif:ExposureTime=10/800
 etc...
 Using the External Function action how to I retrieve this stdout for use in 
 Terascript?

 I have got a solution by piping it to a text file:

 identify -format '%[exif:orientation]' pagoda_sm.jpg  pagoda_sm.txt

 but wonder if there is a direct, more elegant solution.

 Wayne Irvine
 w: http://www.byteserve.com.au/ http://www.byteserve.com.au/
 p: +61 2 9960 6099
 m: 0409 960 609


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

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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: tokenize behavior

[Wayne Irvine]

I had just came across this bug (or a similar one) but am running 6.2.1 on OSX. 
Can you confirm that this bug exists in 6.2.1 also?

Wayne Irvine

 On 16 Jun 2015, at 9:40 am, Robert Shubert rshub...@tronics.com wrote:

 That bug was fixed in 7.0.7

 www.terascript.com/products/releases/server


 -Original Message-
 From: Ian Evans [mailto:ia...@ubookstore.com]
 Sent: Monday, June 15, 2015 3:05 PM
 To: TeraScript-Talk@terascript.com
 Subject: TeraScript-Talk: tokenize behavior

 I've encountered some unexpected behavior from @TOKENIZE and I'm wondering 
 if I'm simply not understanding it right, or if it's not doing what it should 
 be doing.

 Given the string: foo,bar;bat,baz

 I would expect

 @TOKENIZE STR=foo,bar;bat,baz CDELIM=, RDELIM=;

 to behave exactly like

 @ARRAY VALUE=foo,bar;bat,baz CDELIM=, RDELIM=;

 but instead, I get the following array:

 foo | empty | empty
 bat | empty | baz

 This is happening in TeraScript Server Advanced 7.0.1 Mac OS X (32-bit)

 Thanks,
 -Ian



 

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




 

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


Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: External function. Return stdout.

[Wayne Irvine]

I’ve been using ImageMagick via the External Function action to resize and 
reformat images for years,

I’d now like to retrieve EXIF information from uploaded files. ImageMagick 
handles this in the shell nicely:
identify -format '%[exif:orientation]' pagoda_sm.jpg

Returns data like:
exif:DateTime=2005:07:09 14:05:15
exif:DateTimeDigitized=2005:07:09 14:05:15
exif:DateTimeOriginal=2005:07:09 14:05:15
exif:ExposureTime=10/800
etc...
Using the External Function action how to I retrieve this stdout for use in 
Terascript?

I have got a solution by piping it to a text file:

identify -format '%[exif:orientation]' pagoda_sm.jpg  pagoda_sm.txt

but wonder if there is a direct, more elegant solution.

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Cloud

[Wayne Irvine]

I set up Windows Server 2012, Terascript and FileMaker on AWS quite 
successfully.

W

 On 1 Apr 2015, at 5:26 pm, sm...@media88.com wrote:

 Hi,

 Does anyone know is there any cloud that would support Windows, TeraScripts, 
 and Oracle RDBMS so that I can just host my TeraScripts/Witango apps on the 
 cloud?

 Thanks!

 MC

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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Print Friendly Button

[Wayne Irvine]

Hi Rich,

Not sure what you mean by 'print Friendly Button'. Do you mean a button that 
doesn't appear in printed form (CSS) or a button that takes you to the same 
content in a print friendly format (store results in user vars and redisplay in 
print friendly format).

Or something else?

Wayne Irvine

 On 30 Jan 2015, at 7:40 am, Rich r...@ogdengroup.com wrote:

 How do I add a print Friendly Button to a TAF?

 Rich

 Richard V. Jasinski
 President
 The Ogden Group of Rochester, Inc.
 930 East Avenue
 Suite 1000
 Rochester, NY 14607
 585-321-1060 ex 24
 585-321-0043 Fax
 r...@ogdengroup.com mailto:r...@ogdengroup.com
 www.ogdengroup.com http://www.ogdengroup.com/   www.wealth-lion.com 
 http://www.wealth-lion.com/

 Providing database marketing, marketing communications, lead generation and 
 fundraising services to for profit and non profit organizations for over 20 
 years.


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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: DISTINCT

[Wayne Irvine]

Thanks for your work!

Breaking it up into distinct (funny that) lines fixed the issue. Still not sure 
why though.

@ASSIGN NAME=blocktext VALUE=@LOWER STR='@arg blocktext' 
SCOPE=REQUEST

@ASSIGN NAME=blocktext VALUE='@KEEP STR=@@blocktext CHARS= 
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_' 
SCOPE=request

@ASSIGN NAME=rawtagarray VALUE=@TOKENIZE STR='@@blocktext' CHARS=' ' 
SCOPE=REQUEST
@VAR rawtagarray

@ASSIGN NAME=rawtagarray VALUE=@TRANSPOSE ARRAY='rawtagarray'
SCOPE=REQUEST

@ASSIGN NAME=tagarray VALUE=@DISTINCT ARRAY='rawtagarray'
SCOPE=REQUEST

@@tagarray

brown
dog
fox
jumps
lazy
over
quick
the

Nice!

Wayne Irvine

 On 27 Dec 2014, at 5:01 pm, ubslab ubs...@u.washington.edu wrote:

 Wayne,

 I tried to replicate the error using:

 @ASSIGN NAME=rawtagarray VALUE=@TOKENIZE STR=' the quick brown fox
 jumps over the lazy dog ' CHARS=' ' SCOPE=REQUEST
 @VAR rawtagarray
 @ASSIGN NAME=tagarray VALUE=@TRANSPOSE ARRAY='rawtagarray'
 SCOPE=REQUEST
 @ASSIGN NAME=tagarray VALUE=@DISTINCT ARRAY='tagarray'
 SCOPE=REQUEST
 @ASSIGN NAME=tagarray VALUE=@TRANSPOSE ARRAY='tagarray'
 SCOPE=REQUEST
 @VAR tagarray

 The error shows when the first transpose is is commented out.
 So possibly rows vs columns for the @distinct?



 On 12/26/14 3:36 AM, Wayne Irvine wrote:
 Local and request are the same. Local is deprecated and I really should get 
 in the habit of writing request.




 On 26 Dec 2014, at 8:29 pm, ubslab ubs...@u.washington.edu wrote:

 Wayne,

 In @DISTINCT ARRAY='rawtagarray' SCOPE=local  you are looking for
 rawtagarray  in local scope.

 In @ASSIGN NAME=rawtagarray VALUE=@LOWER str='@TRANSPOSE
 ARRAY=@TOKENIZE STR='@KEEP STR=@arg blocktext CHARS=
 abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_'
 CHARS=' ''  unless you have changed server preferences the default
 scope assignment is likely to be request.


 On 12/25/14 9:17 PM, Wayne Irvine wrote:
 @DISTINCT ARRAY='rawtagarray' SCOPE=local



 

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



 

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





 

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


Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: WebCall is crashing Terascript

[Wayne Irvine]

Upgrading fixed the issue, thanks.

Wayne

 On 5 Dec 2014, at 3:32 am, Robert Shubert rshub...@tronics.com wrote:

 Yesterday PayPal stopped allowing SSL connections as part of the POODLE 
 attack mitigation.

 I suspect that TeraScript 6.1 and all versions of Witango may not be able to 
 use TLS, this would be platform dependent, as that code called into system 
 APIs to handle SSL connections.

 Starting in TeraScript 6.2, we replaced that code as part of our 
 modernization efforts. As of writing this I am not aware of any problems with 
 6.2.

 I suspect that your only option will be to update to TeraScript Server 6.2.1 
 or higher.

 Robert

 From: Wayne Irvine [mailto:wa...@byteserve.com.au 
 mailto:wa...@byteserve.com.au]
 Sent: Thursday, December 04, 2014 2:55 AM
 To: TeraScript-Talk@terascript.com mailto:TeraScript-Talk@terascript.com
 Subject: TeraScript-Talk: WebCall is crashing Terascript

 Having a weird issue. Any invocation of the WebCall action is crashing the 
 Terascript process.

 It started today whilst doing development of a PayPal taf but happens with 
 some older WebCall functions I have developed as well.

 Any clues or pointers where to look?

 Terascript Server 6.1.3.0
 Mac OSX 10.9.5

 Event log follows.

 Wayne Irvine
 w: http://www.byteserve.com.au/ http://www.byteserve.com.au/
 p: +61 2 9960 6099
 m: 0409 960 609


 [ 3008] 2014-12-04 18:14:34 START  INFO Starting TeraScript 
 Application Server Process
 [ 3008] 2014-12-04 18:14:34 RUNTIMEINFO Application File Cache: 
 Disabled
 [ 3008] 2014-12-04 18:14:34 RUNTIMEINFO Include File Cache: Disabled
 [ 3008] 2014-12-04 18:14:34 RUNTIMEINFO Web Service File Cache: 
 Disabled
 [ 3008] 2014-12-04 18:14:34 START  INFO Application Scope: 
 Registering Default
 [ 3008] 2014-12-04 18:14:34 VERSIONINFO Version: TeraScript Server 
 6.1.3.0 [Standard Edition]
 [ 3008] 2014-12-04 18:14:34 LICENSEINFO License: Registered to Byte 
 Services
 [ 3008] 2014-12-04 18:14:34 START  INFO Configuration: Loading 
 configuration stanza 'TeraScript Server 6'
 [ 3008] 2014-12-04 18:14:34 START  INFO Configuration: Maximum heap 
 size 5000 bytes
 [ 3008] 2014-12-04 18:14:34 LICENSEINFO HyperThreading Enabled. 
 Logical Processors 4; Cores 2; Physical processor packages 1.
 [ 3008] 2014-12-04 18:14:34 START  INFO Java Virtual Machine: 
 Attempting to load /System/Library/Frameworks/JavaVM.framework/JavaVM
 [ 3008] 2014-12-04 18:14:34 START  INFO Java Virtual Machine: Enabled
 [ 3008] 2014-12-04 18:14:34 START  INFO JAVABEAN Interface: Enabled
 [ 3008] 2014-12-04 18:14:34 START  INFO JavaScript-C 1.6 pre-release 
 1 2006-04-04 (OSSP js 1.6.20060820)
 [ 3008] 2014-12-04 18:14:34 START  INFO Web Service: Disabled
 [ 3008] 2014-12-04 18:14:34 START  INFO ODBC Interface: Enabled
 [ 3008] 2014-12-04 18:14:34 START  INFO JDBC Interface: Enabled
 [ 3008] 2014-12-04 18:14:34 START  INFO Oracle Call Interface (OCI): 
 Disabled
 [ 3008] 2014-12-04 18:14:34 START  INFO Listener Address: Any
 [ 3008] 2014-12-04 18:14:34 START  INFO Listener Port: 18160
 [ 3008] 2014-12-04 18:14:34 RUNTIMEINFO Received restart signal
 [ 3008] 2014-12-04 18:14:34 STOP   WARNING  Variable Store contained 80 
 variables on shutdown.
 [ 3008] 2014-12-04 18:14:34 STOP   WARNING  Variable Store contained 10 
 variables on shutdown.
 [ 3012] 2014-12-04 18:14:44 START  INFO Starting TeraScript 
 Application Server Process
 [ 3012] 2014-12-04 18:14:44 RUNTIMEINFO Application File Cache: 
 Disabled
 [ 3012] 2014-12-04 18:14:44 RUNTIMEINFO Include File Cache: Disabled
 [ 3012] 2014-12-04 18:14:44 RUNTIMEINFO Web Service File Cache: 
 Disabled
 [ 3012] 2014-12-04 18:14:44 START  INFO Application Scope: 
 Registering Default
 [ 3012] 2014-12-04 18:14:44 VERSIONINFO Version: TeraScript Server 
 6.1.3.0 [Standard Edition]
 [ 3012] 2014-12-04 18:14:44 LICENSEINFO License: Registered to Byte 
 Services
 [ 3012] 2014-12-04 18:14:44 START  INFO Configuration: Loading 
 configuration stanza 'TeraScript Server 6'
 [ 3012] 2014-12-04 18:14:44 START  INFO Configuration: Maximum heap 
 size 5000 bytes
 [ 3012] 2014-12-04 18:14:44 LICENSEINFO HyperThreading Enabled. 
 Logical Processors 4; Cores 2; Physical processor packages 1.
 [ 3012] 2014-12-04 18:14:44 START  INFO Java Virtual Machine: 
 Attempting to load /System/Library/Frameworks/JavaVM.framework/JavaVM
 [ 3012] 2014-12-04 18:14:45 START  INFO Java Virtual Machine: Enabled
 [ 3012] 2014-12-04 18:14:45 START  INFO JAVABEAN Interface: Enabled
 [ 3012] 2014-12-04 18:14:45 START  INFO JavaScript-C 1.6 pre-release 
 1 2006-04-04 (OSSP js 1.6.20060820)
 [ 3012] 2014-12-04 18:14:45 START  INFO Web Service: Disabled
 [ 3012] 2014-12-04 18:14:45 START  INFO

TeraScript-Talk: Case

[Wayne Irvine]

A lot of my code was written for Witango/FileMaker which is not case sensitive. 
These days we are using Terascript and Filemaker via JDBC. It's case sensitive.

The way we've been handling it is by using a calculation field in the table to 
calculate the lowercase of the entered string, then when a string from 
Terascript is compared against it we use the @LOWER tag. Works, but is a lot 
of work to set up.

I'm thinking there might be a built in method to switch or handle case 
sensitivity. Or is everybody doing it like this?

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: manage images

[Wayne Irvine]

Images are just files, so use the typical HTML form with 
ENCTYPE=multipart/form-data and an element like INPUT NAME=Picture 
TYPE=file

You then write the @ARG Picture to your file structure (use a unique name).

If you want to edit it you'll have to use something like Imagemagick, but 
building the interface to allow you to crop specific sections is where the fun 
happens. Good luck and love to see your work.

Wayne



On 18 Sep 2014, at 5:05 am, David Mark Weiss bishop...@gmail.com wrote:

 I need to provide a way for users to upload images, even perhaps edit the 
 image files i.e. crop, etc. witango 5.5  mac osx 10.4  osx server

 any ideas?






 

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


Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Geolocation

[Wayne Irvine]

On a recent project I did some work with geolocation working with addresses. 
Not sure what 'eel las' is but my project involved a database of business 
locations with street addresses. When a business was added the address was sent 
to a Google API for geocoding and the lon/lat returned to the record.

Then when a user did a 'nearby' search from a mobile device the system did a 
generous approximation (in Syd, Aus 0.01 lat and lon is approximately 1km iirc) 
to get a reduced square set, then used pythagorus to work out circle radius 
lengths and filtered out those above the specified radius.

You could do all this on the fly with AJAX calls but it would be the same 
methodology.

If you can explain a little more about your project I may be able to assist.

Wayne Irvine


On 1 Jul 2014, at 4:20 am, Dan Stein d...@dss-db.com wrote:

 I am adding a search radius based on a street address as eel las directions 
 to my clients site. I have the the addresses in the database geocoded. But I 
 need to be able to do it on the fly with the address entered. Rather then 
 reinventing the wheel I was hoping someone else might have already take the 
 usual PHP -Google code and ported it to TS.

 Dare I hope to much?

 --
 Dan Stein MSN CPNP
 Digital Software Solutions
 d...@dss-db.com
 www.dss-db.com




 

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


Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: Many returns

[Wayne Irvine]

I often ask a friend to have a look at the source code of a website for me. 
Several times he has come back with 'It's just a blank page!'.

I have to explain that all my working before rendering a page results in lots 
return characters so you'll have to scroll down a bit.

If there a way to turn off these superfluous returns? Per action? Per code 
block perhaps?

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: WS12 and IIS on AWS

[Wayne Irvine]

Still stuck.

I have gone through the W6 set up instructions again and confirm they are all 
correct.
Moved iis_terascript.dll to \inetpub\scripts\
Changed permissions to Everyone Full Control

No luck.

I turned up the detail on the Error message and got this:
HTTP Error 404.17 - Not Found
The requested content appears to be script and will not be served by the static 
file handler.

Most likely causes:
The request matched a wildcard mime map. The request is mapped to the static 
file handler. If there were different pre-conditions, the request will map to a 
different handler.
I looked up 404.17:
404.17 - Dynamic content mapped to the static file handler via a wildcard MIME 
mapping.
I checked the MIME type for the server and website and there is no .taf entry 
and no apparent wildcards.

Should there be a MIME entry for .taf and what should it be?

Wayne

On 25 Mar 2014, at 3:31 pm, Robert Shubert rshub...@tronics.com wrote:


 Moving the file doesn't guarantee that the permissions will be changed, but 
 feel free to try.


 Otherwise, right-click on the dll - Properies - Security - Edit - 
 Advanced - Find Now - select Everyone - OK - highlight Everyone - check 
 Full control - OK


 (it could be different on WS2012)


 For better security, select the same user that the IIS process runs under. By 
 default it's IIS_IUSRS.

 Robert



 From: Wayne Irvine wa...@byteserve.com.au
 Sent: Monday, March 24, 2014 10:36 PM
 To: TeraScript-Talk@terascript.com
 Subject: Re: TeraScript-Talk: WS12 and IIS on AWS


 On 25 Mar 2014, at 1:18 pm, Robert Shubert rshub...@tronics.com wrote:
 Wayne, you can get that error if the ISAPI plugin isn't executable by the 
 IIS process. Try setting more open permissions on the iis_terascript.dll or 
 moving it to c:\inetpub\scripts

 Is it a case of one or the other? I'm not sure how to change permissions but 
 I can certainly move a file.


 Wayne Irvine
 w: http://www.byteserve.com.au/
 p: +61 2 9960 6099
 m: 0409 960 609


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

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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: WS12 and IIS on AWS

[Wayne Irvine]

On 26 Mar 2014, at 3:07 pm, Robert Shubert rshub...@tronics.com wrote:
 Did you add the handler mapping?

 It should be from *.taf to the ISAPI module pointing to the dll.

Yes, I did that step
 Did you set the Enable 32-bit Applications to True? Since you are using TS 7, 
 a 64-bit App, you should leave that set to False.

I set it to Enable 32bit. I'll try changing that back.

Wayne

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Last call for TS Server 7.0.3

[Wayne Irvine]

The installer says 7.0.0.3.

Wayne

On 20 Mar 2014, at 1:15 am, Robert Shubert rshub...@tronics.com wrote:

 Wayne,

 I’d like to make sure this is fixed. Doing a quick test it seems to be 
 working properly. Which version of TeraScript Server are you running ?

 Robert

 From: Wayne Irvine [mailto:wa...@byteserve.com.au]
 Sent: Tuesday, March 18, 2014 10:43 PM
 To: TeraScript-Talk@terascript.com
 Subject: Re: TeraScript-Talk: Last call for TS Server 7.0.3

 I still had the problem of not being able to submit individual Post Data 
 Arguments in the Web Call action on OSX Terascribe (server is WS12 
 Terascript). Still have to create an array to submit arguments.

 Not sure if the issue is with OSX Terascribe or Windows 64bit Terascript but 
 it's still there.

 Wayne Irvine

 On 19 Mar 2014, at 12:48 am, Robert Shubert rshub...@tronics.com wrote:


 I am prepping the 7.0.3 release of TeraScript Server.

 Below is the list of items that are addressed in this release.

 If anyone knows of an issue not listed below, please bring it to my attention 
 (either reply here or email support@) as soon as you can.

 Thanks,

 Robert

 TS Server 7.0.3 release notes

 Fixed a crash when formatting a year before 1900
 Corrected DST calculation on OS X and Linux
 JavaScript (Script action and @SCRIPT tag) is now disabled on Windows 64-bit
 The user reference cookie will now be set with the HttpOnly flag
 Removed several cases where CRLFs were being stripped inappropriately
 The COUNT(DISTINCT) column name will now work with @COLUMN correctly
 Cron jobs to non-https URLs will now fire correctly
 If the client needs to write a stanza into clients.ini, it will now use the 
 v7 port (18170)
 @SETCOOKIES will now output correct Set-Cookie header syntax
 Fixed trivial bugs in the Close Transaction action
 Corrected @DOM when XML declaration isn't present (fallback to ISO-8859-1 for 
 backwards compatibility)
 @DOMINSERT to document root (xpath=/)
 Various DOM issues

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

 Wayne Irvine
 w: http://www.byteserve.com.au/
 p: +61 2 9960 6099
 m: 0409 960 609


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

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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: Trying to work out what country I'm in.

[Wayne Irvine]

Another XML question.

I'm writing a small taf to determine the country of origin of the browser by IP 
address.

I'm using the hostip.info API.

http://bigreviewtv.byteserve.com.au/ipcountry.taf

This returns httpData:

?xml version=1.0 encoding=ISO-8859-1 ?
!DOCTYPE DETAILED_RESPONSE_SYSTEM 
HTTP_RESPONSE Version=0x0202
STATUS
CODE200/CODE
TEXTOK/TEXT
/STATUS
HEADER NAME=Date![CDATA[Tue, 11 Mar 2014 04:08:31 GMT]]/HEADER
HEADER NAME=Server![CDATA[LiteSpeed]]/HEADER
HEADER NAME=Connection![CDATA[close]]/HEADER
HEADER NAME=X-Powered-By![CDATA[PHP/5.4.16]]/HEADER
HEADER NAME=Content-Type![CDATA[text/xml; 
charset=iso-8859-1]]/HEADER
HEADER NAME=Expires![CDATA[Wed, 12 Mar 2014 04:08:31 
GMT]]/HEADER
HEADER NAME=Last-Modified![CDATA[Thu, 01 Jan 1970 00:00:00 
GMT]]/HEADER
HEADER NAME=Cache-Control![CDATA[public, max-age=86400]]/HEADER
HEADER NAME=Pragma![CDATA[!invalid]]/HEADER
HEADER NAME=Access-Control-Allow-Origin![CDATA[*]]/HEADER
HEADER NAME=Content-Length![CDATA[921]]/HEADER
HEADER NAME=Vary![CDATA[User-Agent]]/HEADER
BODY![CDATA[?xml version=1.0 encoding=ISO-8859-1 ?
HostipLookupResultSet version=1.0.1 xmlns:gml=http://www.opengis.net/gml; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xsi:noNamespaceSchemaLocation=http://www.hostip.info/api/hostip-1.0.1.xsd;
 gml:descriptionThis is the Hostip Lookup Service/gml:description
 gml:namehostip/gml:name
 gml:boundedBy
  gml:Nullinapplicable/gml:Null
 /gml:boundedBy
 gml:featureMember
  Hostip
   ip203.24.144.202/ip
   gml:nameSydney/gml:name
   countryNameAUSTRALIA/countryName
   countryAbbrevAU/countryAbbrev
   !-- Co-ordinates are available as lng,lat --
   ipLocation
gml:pointProperty
 gml:Point srsName=http://www.opengis.net/gml/srs/epsg.xml#4326;
  gml:coordinates151,-34/gml:coordinates
 /gml:Point
/gml:pointProperty
   /ipLocation
  /Hostip
 /gml:featureMember
/HostipLookupResultSet
]]/BODY
/HTTP_RESPONSE

I am stuck defining the @ELEMENTVALUE string to pull out the value of country. 
I think the colons on gml data is messing things up.

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

Re: TeraScript-Talk: Social Media login

[Wayne Irvine]

Thanks for this Robert.

Facebook is the first choice. I have set up an 'app' in Facebook to respond to 
the requests.

I'll dig up the details and forward them to you.

Wayne

On 25 Feb 2014, at 1:38 pm, Robert Shubert rshub...@tronics.com wrote:

 Wayne,

 If you would be willing to work with me on these APIs, I should be able to 
 get something working.

 Which service would you like to get working first?

 Robert



 From: Wayne Irvine wa...@byteserve.com.au
 Sent: Saturday, February 22, 2014 1:40 AM
 To: TeraScript-Talk@terascript.com
 Subject: TeraScript-Talk: Social Media login

 I'm using Janrain as a service to allow users to login to a website using 
 Social Media credentials (Facebook, Google+, Twitter).

 Unfortunately Janrain's service has very low limits considering the costs 
 involved.

 Has anyone done any development in Terascript to work with the SM APIs? There 
 are PHP libraries for this sort of thing but I'm having enough trouble 
 redeveloping the PHP libraries for Youtube upload and don't even know where 
 to start with SM APIs.

 Wayne Irvine
 w: http://www.byteserve.com.au/
 p: +61 2 9960 6099
 m: 0409 960 609


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

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

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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

TeraScript-Talk: Social Media login

[Wayne Irvine]

I'm using Janrain as a service to allow users to login to a website using 
Social Media credentials (Facebook, Google+, Twitter).

Unfortunately Janrain's service has very low limits considering the costs 
involved.

Has anyone done any development in Terascript to work with the SM APIs? There 
are PHP libraries for this sort of thing but I'm having enough trouble 
redeveloping the PHP libraries for Youtube upload and don't even know where to 
start with SM APIs.

Wayne Irvine
w: http://www.byteserve.com.au/
p: +61 2 9960 6099
m: 0409 960 609






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