Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Re: One browse doesn't sort header
« on: August 09, 2017, 01:45:46 PM »
Hi Sean,
try to set the browse to only show 10 records or whatever so you display the next last buttons etc. If they don't work look at the data for any strange characters or if you have any columns set to allow xhtml. Try to also use the browser debug tool to see if it returns any xml errors when loading the browse.
Cheers,
Kevin
try to set the browse to only show 10 records or whatever so you display the next last buttons etc. If they don't work look at the data for any strange characters or if you have any columns set to allow xhtml. Try to also use the browser debug tool to see if it returns any xml errors when loading the browse.
Cheers,
Kevin
2
Web Server - Ask For Help / NoSQL
« on: April 18, 2017, 12:13:09 AM »
Hi All,
anyone using any NoSQL flavour with clarion\nettalk?
Cheers,
Kevin
anyone using any NoSQL flavour with clarion\nettalk?
Cheers,
Kevin
3
Web Server - Ask For Help / Re: IP address/port conflict
« on: March 16, 2017, 08:42:33 PM »
did you bind nettalk to the IP Address? The setting is the same place in the templates that you set the port to listen on and set ssl etc.
4
Web Server - Ask For Help / Re: Individual URL for download, with UID
« on: March 15, 2017, 09:53:51 PM »
I've always used _SendFile to do the switch. Bruce covers it to some extent in his book.
5
Web Server - Ask For Help / Re: Service Attack. How safe is Nettalk?
« on: March 01, 2017, 04:34:22 AM »
what shows up on your web server and what port is the connection coming through on?
6
Web Server - Ask For Help / Re: Service Attack. How safe is Nettalk?
« on: February 27, 2017, 02:06:56 PM »
It looks like someone is doing a port scan on your server and these are being forwarded to your web app.If so, you should have all ports on your firewall closed and only those you need open.
7
Web Server - Ask For Help / Re: MEMOs have no CR <13> just <10>
« on: February 26, 2017, 10:38:01 PM »
not sure of the cause but as a workaround you could use ST to do a search <10> and replace <13,10>
8
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 15, 2017, 04:28:13 PM »
you could be right that the filter expression does not like quote.
so firstly I would try to prove what dos and doesn't work by hard coding the training adviser value.
'upper(rev:observer) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
'upper(quote(rev:observer)) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
'upper(quote(rev:observer),1) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
You could also create a binded hidden column in the browse and populate that in the view as it is being built.
something like: l:observer = upper(quote(rev:observer)) and then use l:observer in your filter expression.
Last idea is to use the L:Observer method and just strip out any ' using string theory as the browse is being built and out of your trainig advisor variable.
so firstly I would try to prove what dos and doesn't work by hard coding the training adviser value.
'upper(rev:observer) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
'upper(quote(rev:observer)) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
'upper(quote(rev:observer),1) = <39>' & 'ANTHONY D<39>AURIA' & '<39>'
You could also create a binded hidden column in the browse and populate that in the view as it is being built.
something like: l:observer = upper(quote(rev:observer)) and then use l:observer in your filter expression.
Last idea is to use the L:Observer method and just strip out any ' using string theory as the browse is being built and out of your trainig advisor variable.
9
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 14, 2017, 11:21:35 PM »
try
'upper(quote(rev:observer),1) = ''' & upper(quote(p_web.gsv('trainingadvisor')),1) & ''' '
'upper(quote(rev:observer),1) = ''' & upper(quote(p_web.gsv('trainingadvisor')),1) & ''' '
10
Web Server - Ask For Help / Re: How to avoid Deadly embrace
« on: February 06, 2017, 12:14:04 AM »
Hi Terry,
I have a similar table in my app and I created a stored procedure as follows to avoid a similar problem.
HTH's
CREATE Procedure [dbo].[ds_NewTran]
@Type NvarChar(10), @L_Value Int OUTPUT
AS
Declare @SaveError Int
Declare @L_NewValue Int
--Begin Transaction
---CASE STATEMENT TO UPDATE RELEVANT FIELD-----------------------------
If @Type = 'RecordID'
Begin
Update TRANS
Set @L_Value = TRA_RecordID = TRA_RecordID + 1
Where TRA_ID = 1
--Commit Transaction
Return @L_Value
End
If @Type = 'Tran'
Begin
Update TRANS
Set @L_Value = TRA_TRAN = TRA_TRAN + 1
Where TRA_ID = 1
--Commit Transaction
Return @L_Value
End
I have a similar table in my app and I created a stored procedure as follows to avoid a similar problem.
HTH's
CREATE Procedure [dbo].[ds_NewTran]
@Type NvarChar(10), @L_Value Int OUTPUT
AS
Declare @SaveError Int
Declare @L_NewValue Int
--Begin Transaction
---CASE STATEMENT TO UPDATE RELEVANT FIELD-----------------------------
If @Type = 'RecordID'
Begin
Update TRANS
Set @L_Value = TRA_RecordID = TRA_RecordID + 1
Where TRA_ID = 1
--Commit Transaction
Return @L_Value
End
If @Type = 'Tran'
Begin
Update TRANS
Set @L_Value = TRA_TRAN = TRA_TRAN + 1
Where TRA_ID = 1
--Commit Transaction
Return @L_Value
End
11
Web Server - Ask For Help / Re: How to avoid Deadly embrace
« on: February 05, 2017, 11:52:23 PM »
Hi Terry,
are you using TPS or SQL?
edit in both cases it should be in a transaction frame but in SQL there are some other options in how you can construct the statement use stored procedures etc
are you using TPS or SQL?
edit in both cases it should be in a transaction frame but in SQL there are some other options in how you can construct the statement use stored procedures etc
12
Web Server - Ask For Help / Re: IMDD and DFD
« on: January 19, 2017, 03:28:55 AM »
On one app I'm looking to speed up reports and some of my source procedures that do a lot of calculations for tax, fringes and hours to gross. I still get a couple of SQL locks a day on this app so hoping caching some data will take pressure off MSSQL
On another app on an older server its just running slow. 60% requests > .5 The same app on a new highly specked server in Europe runs fine with 86% requests < .5
I'm not in the position to upgrade the slower server yet so just trying to work out how to make the app go faster.
On another app on an older server its just running slow. 60% requests > .5 The same app on a new highly specked server in Europe runs fine with 86% requests < .5
I'm not in the position to upgrade the slower server yet so just trying to work out how to make the app go faster.
13
Web Server - Ask For Help / IMDD and DFD
« on: January 18, 2017, 05:20:14 PM »
Hi All,
just wondering if it is possible to use the combination of these file drivers (dyn.cachefile() ) to cache some data on a thread to make my app go a bit faster? I would just cache the tables where I'm just doing reads (not writes) in the thread. I'm using MSSQL so hoping this will also ease the traffic/workload on that server. Any examples of doing this on forms, browses, source code etc would be great.
Cheers,
Kevin
just wondering if it is possible to use the combination of these file drivers (dyn.cachefile() ) to cache some data on a thread to make my app go a bit faster? I would just cache the tables where I'm just doing reads (not writes) in the thread. I'm using MSSQL so hoping this will also ease the traffic/workload on that server. Any examples of doing this on forms, browses, source code etc would be great.
Cheers,
Kevin
14
Web Server - Ask For Help / Re: Back to menu button
« on: January 15, 2017, 07:25:41 PM »
Hi Edvard,
you might find the server side codes not execute (ie your sql code) if you use on click. If so, use p_web.script after your sql code to return to your menu or close the current form etc
you might find the server side codes not execute (ie your sql code) if you use on click. If so, use p_web.script after your sql code to return to your menu or close the current form etc
15
Web Server - Ask For Help / Re: Webserver run as Service but shutdown without errors
« on: November 22, 2016, 04:11:39 AM »
Hi Johan,
do you get the same problems if you run as an exe not service?
do you get the same problems if you run as an exe not service?