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 / Browser Back button
« on: September 05, 2025, 10:45:32 AM »
HI,
NT 14.21 C11
My young users reflexly swipe the mobile screen from left to right to go back. In my NT app, it says something like "page is not available - cannot resubmit". Then they have to log in again, and again, and again..... I understand why it does that but I need some solution for youngsters who have muscle memory in place....
SOO, can I trap the back button and just take them to the INDEX page so they can go back down the menu tree instead of kicking them out of the program and telling them they have violated the rules??
Thanks,
Ron
NT 14.21 C11
My young users reflexly swipe the mobile screen from left to right to go back. In my NT app, it says something like "page is not available - cannot resubmit". Then they have to log in again, and again, and again..... I understand why it does that but I need some solution for youngsters who have muscle memory in place....
SOO, can I trap the back button and just take them to the INDEX page so they can go back down the menu tree instead of kicking them out of the program and telling them they have violated the rules??
Thanks,
Ron
2
Web Server - Ask For Help / Re: Proxy server for let's encrypt?
« on: September 03, 2025, 03:34:26 PM »
Good work Jeff.
I have found that asking the right question and using responses from NG and a little research and you can get most problems solved! I am happy that you were able to get this to work!
Ron
I have found that asking the right question and using responses from NG and a little research and you can get most problems solved! I am happy that you were able to get this to work!
Ron
3
Web Server - Ask For Help / Re: Proxy server for let's encrypt?
« on: August 29, 2025, 02:52:25 AM »
HI Jeff,
I am not 100% sure about this Proxy Server Stuff. Anyway, to start off, the Security Certificate issuer needs to make sure that you control the DOMAIN NAME and are not posing as a bad actor. TO do that, they have you write a message in the Index page header to show that you can control the domain. There are other methods. Lets Encrypt writes a file to port 80 and then you must act on it - I don't know how, but you must do something to it and return it to show that you control the server. This is what you CAN'T do because port 80 is blocked. So, Bruce has an alternate method of verifying domain ownership using the DNS record. Lets Encrypt is asked or given permission to do something with a record on your DNS domain registry which you then act on and it confirms that you own the DNS listing for your domain. That being said, the DNS provider has to have the functionality available to allow Lets Encrypt to act on your DNS record. That is why Bruce provides the name of a low cost DNS provider for which HE HAS WRITTEN the necessary interfaces. SO, fetching your own certificates from Lets Encrypt won't work with ANY PROVIDER. Now, I purchased my working domain from GoDaddy but I host it on a server in my office. (Port 80 is blocked by ISP). I purchase SSL from GoDaddy for this domain - costs $90.00 per year. I simply take the SSL info and plop it onto my office server and it just keeps working. So, you can do the same thing. Purchase an SSL certificate from Network Solutions but it will be a little more expensive and plop it onto your server. I have found that Network Solutions has become more difficult to work with over the years and I have moved away from them for that exact reason.
SO, you have two viable choices to get your server up and make $$$$ as I see it:
1. Use DNSimple - will cost you maybe less than $100.00 per year . It is fairly cheap.
2. Purchase an SSL Certificate from NetWOrk SOlutions which you can transfer to your server. They already know that you own the domain because it is registered though them. (They will want to put it on a Network Solutions Server that you have purchased from THEM... I had to fight to get mine over to my server. That was a few years ago. You plop the certificate on to your server and you are good to go.
The standard SSL port is 443 and you would be able to use https://jking.com and folks would get to your secure site. With port 443 CLOSED, you are going to have to pick another port - such as 800 and everyone will have to use http://jking.com:800 to get to your site.
Hope this gives you some perspective,
Ron
I am not 100% sure about this Proxy Server Stuff. Anyway, to start off, the Security Certificate issuer needs to make sure that you control the DOMAIN NAME and are not posing as a bad actor. TO do that, they have you write a message in the Index page header to show that you can control the domain. There are other methods. Lets Encrypt writes a file to port 80 and then you must act on it - I don't know how, but you must do something to it and return it to show that you control the server. This is what you CAN'T do because port 80 is blocked. So, Bruce has an alternate method of verifying domain ownership using the DNS record. Lets Encrypt is asked or given permission to do something with a record on your DNS domain registry which you then act on and it confirms that you own the DNS listing for your domain. That being said, the DNS provider has to have the functionality available to allow Lets Encrypt to act on your DNS record. That is why Bruce provides the name of a low cost DNS provider for which HE HAS WRITTEN the necessary interfaces. SO, fetching your own certificates from Lets Encrypt won't work with ANY PROVIDER. Now, I purchased my working domain from GoDaddy but I host it on a server in my office. (Port 80 is blocked by ISP). I purchase SSL from GoDaddy for this domain - costs $90.00 per year. I simply take the SSL info and plop it onto my office server and it just keeps working. So, you can do the same thing. Purchase an SSL certificate from Network Solutions but it will be a little more expensive and plop it onto your server. I have found that Network Solutions has become more difficult to work with over the years and I have moved away from them for that exact reason.
SO, you have two viable choices to get your server up and make $$$$ as I see it:
1. Use DNSimple - will cost you maybe less than $100.00 per year . It is fairly cheap.
2. Purchase an SSL Certificate from NetWOrk SOlutions which you can transfer to your server. They already know that you own the domain because it is registered though them. (They will want to put it on a Network Solutions Server that you have purchased from THEM... I had to fight to get mine over to my server. That was a few years ago. You plop the certificate on to your server and you are good to go.
The standard SSL port is 443 and you would be able to use https://jking.com and folks would get to your secure site. With port 443 CLOSED, you are going to have to pick another port - such as 800 and everyone will have to use http://jking.com:800 to get to your site.
Hope this gives you some perspective,
Ron
4
Web Server - Ask For Help / Re: Table update Netwebform with popup memory forms
« on: August 21, 2025, 02:17:44 AM »
Hi Johan,
Maybe this will shed some light on what is going on under the hood.....
Consider this:
!Access:MailBoxes.Open()
!Access:MailBoxes.UseFile()
!MAI:MailBoxNumber = p_web.GSV('MAI:MailBoxNumber')
!Access:MailBoxes.Fetch(MAI:PrimaryKey)
!p_web.FileToSessionQueue(MailBoxes) <<<<<<<<<<<<======================
!Access:MailBoxes.Close()
This populates the SSV for each field!!!! This happens at the beginning of the FORM After Files are OPEN..
These ae the working statements:
p_web.FileToSessionQueue(file) copies an entire file record buffer to the session data queue.
p_web.FileToSessionQueue(file, Net:AlsoValueQueue) copies the entire record buffer to both the session data queue, and the value queue at the same time.
So, you manipulate SERVER VALUES of the data through the form. ( One of the reasons it is done that way is because the "form" is not persistent. Net Talk goes in and out of the form several times (stages) before it closes - so to keep the data persistent, the field data is stored in SERVER VALUES ( which do persist). Note: SERVER VALUES for each field are persistent and can be changed elsewhere and be updated such that the NEW VALUE is really the one that gets written to the record when SessionQueueToFile is called.
When ALL IS DONE then the SERVER VALUES containing the field values for the record are written back into the file in one go of it:
p_web.SessionQueueToFile(file) primes a record buffer with contents from the session data queue.
After a little more cleanup, the Form is done and the record has been updated.
As an aside, sometimes I need to update another file. Rather than do the whole File to Queue and back, I will fetch the record that I want and stuff in the new value and update it. e.g.
item:ihid = 100
if Access:ITEMS.Fetch(ITM:IHID_KEY) = Level:Benign
itm:amtinstock = 25
itm:descrip = p_web.GSV('My item 100')
Access:ITEMS.Update()
else
! some error message
end
THis sequence remains "in scope" as it processes it all together.
Hope this might help a little.
Ron
Maybe this will shed some light on what is going on under the hood.....
Consider this:
!Access:MailBoxes.Open()
!Access:MailBoxes.UseFile()
!MAI:MailBoxNumber = p_web.GSV('MAI:MailBoxNumber')
!Access:MailBoxes.Fetch(MAI:PrimaryKey)
!p_web.FileToSessionQueue(MailBoxes) <<<<<<<<<<<<======================
!Access:MailBoxes.Close()
This populates the SSV for each field!!!! This happens at the beginning of the FORM After Files are OPEN..
These ae the working statements:
p_web.FileToSessionQueue(file) copies an entire file record buffer to the session data queue.
p_web.FileToSessionQueue(file, Net:AlsoValueQueue) copies the entire record buffer to both the session data queue, and the value queue at the same time.
So, you manipulate SERVER VALUES of the data through the form. ( One of the reasons it is done that way is because the "form" is not persistent. Net Talk goes in and out of the form several times (stages) before it closes - so to keep the data persistent, the field data is stored in SERVER VALUES ( which do persist). Note: SERVER VALUES for each field are persistent and can be changed elsewhere and be updated such that the NEW VALUE is really the one that gets written to the record when SessionQueueToFile is called.
When ALL IS DONE then the SERVER VALUES containing the field values for the record are written back into the file in one go of it:
p_web.SessionQueueToFile(file) primes a record buffer with contents from the session data queue.
After a little more cleanup, the Form is done and the record has been updated.
As an aside, sometimes I need to update another file. Rather than do the whole File to Queue and back, I will fetch the record that I want and stuff in the new value and update it. e.g.
item:ihid = 100
if Access:ITEMS.Fetch(ITM:IHID_KEY) = Level:Benign
itm:amtinstock = 25
itm:descrip = p_web.GSV('My item 100')
Access:ITEMS.Update()
else
! some error message
end
THis sequence remains "in scope" as it processes it all together.
Hope this might help a little.
Ron
5
Web Server - Ask For Help / news.softvelocity.com is VERY VERY SLOW and not useable - am I the only one??
« on: August 20, 2025, 09:14:23 AM »
Hi
news.softvelocity.com has become so slow it is not useable. I am using Firefox and I can download the headers - however, I cannot retrieve any messages..... it just waits and waits. I had set up a Clarion12 link but that doesn't seem to work for me. Is this a Firebird issue or a newsgroup issue. Is there a solution?
THanks,
Ron
news.softvelocity.com has become so slow it is not useable. I am using Firefox and I can download the headers - however, I cannot retrieve any messages..... it just waits and waits. I had set up a Clarion12 link but that doesn't seem to work for me. Is this a Firebird issue or a newsgroup issue. Is there a solution?
THanks,
Ron
6
Web Server - Ask For Help / Re: Icons for Menu
« on: August 14, 2025, 09:28:49 AM »
SOLVED!
For Icon education look at NetTalk Webinar from Today - August 14, 2025.
\Ron
For Icon education look at NetTalk Webinar from Today - August 14, 2025.
\Ron
7
Web Server - Ask For Help / Re: Icons for Menu
« on: August 13, 2025, 05:21:43 AM »
I see the method:
NetWebServerWorkerBase.CreateIcon Procedure(<String pIcon>, <String pIconGroup>, <String pClass>, Long pType=-1)
class1 cstring(255)
spacer cstring(255)
code
class1 = self.CreateIconName(pIcon,pIconGroup,pClass,pType)
if not omitted(pIconGroup) and pIconGroup <> ''
spacer = '<span class="ui-' & clip(pIconGroup) & '-icon-space"></span>'
end
return '<span class="' & class1 & '"></span>' & spacer
MakeIcon method - takes several parameters. Trying to figure out how to get the right information in to the method to make my fontAwesome icon RED.
Ron
NetWebServerWorkerBase.CreateIcon Procedure(<String pIcon>, <String pIconGroup>, <String pClass>, Long pType=-1)
class1 cstring(255)
spacer cstring(255)
code
class1 = self.CreateIconName(pIcon,pIconGroup,pClass,pType)
if not omitted(pIconGroup) and pIconGroup <> ''
spacer = '<span class="ui-' & clip(pIconGroup) & '-icon-space"></span>'
end
return '<span class="' & class1 & '"></span>' & spacer
MakeIcon method - takes several parameters. Trying to figure out how to get the right information in to the method to make my fontAwesome icon RED.
Ron
8
Web Server - Ask For Help / Icons for Menu
« on: August 12, 2025, 03:42:54 PM »
Hi All,
Struggling to figure out this ICON stuff, especially Icons in CSS.
NT 14.21 C11
I have added the fontAwesome.css to my app.
I have a Menu item: HOME to which I added the Icon: 'fas fa-heart' . Great! I get a black heart on my HOME button. But, I want a RED heart icon. I tried various permutations to get a RED heart but no luck.
e.g 'fas fa-heart' & 'style="color:red;"' No luck.
There has to be a trick to this with some specific NT language.
Anyone can help?
Thanks,
Ron
Struggling to figure out this ICON stuff, especially Icons in CSS.
NT 14.21 C11
I have added the fontAwesome.css to my app.
I have a Menu item: HOME to which I added the Icon: 'fas fa-heart' . Great! I get a black heart on my HOME button. But, I want a RED heart icon. I tried various permutations to get a RED heart but no luck.
e.g 'fas fa-heart' & 'style="color:red;"' No luck.
There has to be a trick to this with some specific NT language.
Anyone can help?
Thanks,
Ron
9
Web Server - Ask For Help / Re: AI / machine learning
« on: August 08, 2025, 05:44:16 AM »
Hi Rupert,
I think that there were a few people working on integrating AI into clarion. I think that they presented some stuff and maybe even a simple example at the most recent CWIC - Net Talk development in Orlando last year. If you have the schdule of presentations then give it a look.
Ron
I think that there were a few people working on integrating AI into clarion. I think that they presented some stuff and maybe even a simple example at the most recent CWIC - Net Talk development in Orlando last year. If you have the schdule of presentations then give it a look.
Ron
10
Web Server - Ask For Help / Re: How to debug this slow request?
« on: August 08, 2025, 05:41:07 AM »
Johan,
I have found that reality often tempers our excitement for the glitzy - bottom line becomes simply "just make it work". Have gone down this path many times trying to tell ourself that it would be easier for the end user....and it ends up - just make it work....
Ron
I have found that reality often tempers our excitement for the glitzy - bottom line becomes simply "just make it work". Have gone down this path many times trying to tell ourself that it would be easier for the end user....and it ends up - just make it work....
Ron
11
Web Server - Ask For Help / Re: Let's Encrypt issues
« on: August 05, 2025, 03:22:14 PM »
Hi Jeff,
You must carry some weight there- to ask them to open port 80!
I have switched my DNS provider to the one that Bruce mentions in his documents. The DNS method needs to interact with the DNS record in order to "prove" that you have control over it. So, you have to be able to interact with the DNS host - so, you need one that allows interaction. I was going to try the DNS method but as I mentioned, I have a fixed SSL certificate that I use for this server. So, there is a webinar about this but I don't remember which one it is. Perhaps search Clarion live for it.
Ron
You must carry some weight there- to ask them to open port 80!
I have switched my DNS provider to the one that Bruce mentions in his documents. The DNS method needs to interact with the DNS record in order to "prove" that you have control over it. So, you have to be able to interact with the DNS host - so, you need one that allows interaction. I was going to try the DNS method but as I mentioned, I have a fixed SSL certificate that I use for this server. So, there is a webinar about this but I don't remember which one it is. Perhaps search Clarion live for it.
Ron
12
Web Server - Ask For Help / Re: Let's Encrypt issues
« on: August 05, 2025, 12:09:26 PM »
Hi Jeff,
Yes, it is a problem. Lets encrypt writes to port 80 so that it can verify control of the machine. Most commercial internet providers block port 80. I suspect that your institution does as well. The good news is that there is a work around using DNS. So you are going to have to use an alternate method. Another thing is how are folks getting to your site? Is it a University site? If it is, then maybe you should be under their SSL certificate? I purchase a SSL certificate for a domain that I own - yes, Lets Encrypt is free - but I have other reasons for purchasing this SSL Certificate. With this SSL certificate, I can host my site on any machine and just plop in my SSL certificate and I am up and running. So, maybe you want to purchase your own domain name and SSL and put it on your server and not have to fight with many many many many layers of bureaucracy....
Ron
Yes, it is a problem. Lets encrypt writes to port 80 so that it can verify control of the machine. Most commercial internet providers block port 80. I suspect that your institution does as well. The good news is that there is a work around using DNS. So you are going to have to use an alternate method. Another thing is how are folks getting to your site? Is it a University site? If it is, then maybe you should be under their SSL certificate? I purchase a SSL certificate for a domain that I own - yes, Lets Encrypt is free - but I have other reasons for purchasing this SSL Certificate. With this SSL certificate, I can host my site on any machine and just plop in my SSL certificate and I am up and running. So, maybe you want to purchase your own domain name and SSL and put it on your server and not have to fight with many many many many layers of bureaucracy....
Ron
13
Web Server - Ask For Help / Re: How to debug this slow request?
« on: August 03, 2025, 02:34:42 PM »
Hi Johan,
I was at the webinar. I don't have much to offer but ProcessLink seems to be a focal point for everything that happens. If I were to try to look at this I would look at web_handler and begin to search with maybe what is going through the ProcessLink AFTER your browse procedure. CLOSES.... A very crude way that I can think of is to put a p_web.Trace('hi, I am procedure Browse_city..., etc) at the start of each procedure. Then you can watch your DebugView for what happens AFTER your browse closes. There are probably more elegant ways to do this. Also, it might be doing some housekeeping which might not get you a trace statement. But then you might know what it is NOT.. Also, if you can slice out this browse and part of the program and test it OUTSIDE your full program, you might gain some insights.
Ron
I was at the webinar. I don't have much to offer but ProcessLink seems to be a focal point for everything that happens. If I were to try to look at this I would look at web_handler and begin to search with maybe what is going through the ProcessLink AFTER your browse procedure. CLOSES.... A very crude way that I can think of is to put a p_web.Trace('hi, I am procedure Browse_city..., etc) at the start of each procedure. Then you can watch your DebugView for what happens AFTER your browse closes. There are probably more elegant ways to do this. Also, it might be doing some housekeeping which might not get you a trace statement. But then you might know what it is NOT.. Also, if you can slice out this browse and part of the program and test it OUTSIDE your full program, you might gain some insights.
Ron
14
Web Server - Ask For Help / Re: How to debug this slow request?
« on: July 27, 2025, 03:04:05 AM »
Johan,
I am not sure if it applies here but using the UPPER on any searches really speeds up browses.
e.g instead of where ITM:UID = thisUID go for where UPPER(ITM:UID) = UPPER(thisUID). This takes out the mixed case filtering and speeds up queries.
Ron
I am not sure if it applies here but using the UPPER on any searches really speeds up browses.
e.g instead of where ITM:UID = thisUID go for where UPPER(ITM:UID) = UPPER(thisUID). This takes out the mixed case filtering and speeds up queries.
Ron
15
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« on: July 23, 2025, 01:54:58 PM »
HI Jeff,
I am not running multi-site hosting so I have no answer. Mike McLoughlin has been running a multi-site host for a while. You might drop him an E mail at Sterling Data. He might have some insight for you.
Ron
I am not running multi-site hosting so I have no answer. Mike McLoughlin has been running a multi-site host for a while. You might drop him an E mail at Sterling Data. He might have some insight for you.
Ron