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.
16
Web Server - Ask For Help / Sitemap and CoffeeCup Website Insight
« on: December 28, 2014, 10:31:02 AM »
http://www.coffeecup.com/help/articles/placement-of-your-sitemap-file/
Any comments/hints?
and an app called
CoffeeCup Website Insight
Any comments/hints?
and an app called
CoffeeCup Website Insight
17
Web Server - Ask For Help / Calling NetWebForm from within embed code
« on: November 11, 2014, 01:28:38 PM »
Hi
A. LoginForm
in ValidateUpdate 2 End
After the User has been validated - i.e. legally logged in, depending what type of User, I would like to call a form populated with THAT users details to be edited by the User himself. How do I call that form inside code and how do I ensure that the form is populated with that users details?
The login and password is validated against the People table which also contains all other details of the logged-in user. Therefore I will have the peopleguid in a Session Value, say called peopleguid.
B. After user is done editing, upon leaving THAT form User must be logged out? How?
A. LoginForm
in ValidateUpdate 2 End
After the User has been validated - i.e. legally logged in, depending what type of User, I would like to call a form populated with THAT users details to be edited by the User himself. How do I call that form inside code and how do I ensure that the form is populated with that users details?
The login and password is validated against the People table which also contains all other details of the logged-in user. Therefore I will have the peopleguid in a Session Value, say called peopleguid.
B. After user is done editing, upon leaving THAT form User must be logged out? How?
18
Web Server - Ask For Help / SSV and GSV
« on: October 20, 2014, 12:41:07 PM »
In LoginForm
Stops 1&2 work - 3&4 do not
LoginForm Validate Update 2 End
stop('1 Loc:Login = '&Loc:Login)
p_web.SSV('Loc:Login','Loc:Login')
stop('2 Loc:Login = '&Loc:Login)
p_web.SSV('loc:savedlogin','Loc:Login')
stop('3 loc:savedlogin = '&loc:savedlogin)
p_web.SSV('loc:savedlogin', p_web.GSV('Loc:Login'))
stop('4 loc:savedlogin ='&loc:savedlogin)
If I cannot even retrieve the Loc:Login on the LoginForm how will I retrieve it in another procedure i.e.
some update form in eg PostUpdate - to store who is logged in and therefore made the changes to the table?
Stops 1&2 work - 3&4 do not
LoginForm Validate Update 2 End
stop('1 Loc:Login = '&Loc:Login)
p_web.SSV('Loc:Login','Loc:Login')
stop('2 Loc:Login = '&Loc:Login)
p_web.SSV('loc:savedlogin','Loc:Login')
stop('3 loc:savedlogin = '&loc:savedlogin)
p_web.SSV('loc:savedlogin', p_web.GSV('Loc:Login'))
stop('4 loc:savedlogin ='&loc:savedlogin)
If I cannot even retrieve the Loc:Login on the LoginForm how will I retrieve it in another procedure i.e.
some update form in eg PostUpdate - to store who is logged in and therefore made the changes to the table?
19
Web Server - Ask For Help / NetWebForm PostGreSQL value of auto incremented column?
« on: October 10, 2014, 12:17:48 PM »
PostGreSQL
I need two values:
table: brandnames
In PostInsert I have this code
Access:auditlogheader.PrimeRecord()
alh:logtimestamp_DATE = Today()
alh:logtimestamp_TIME = Clock()
alh:username = p_web.GSV('usr:userlogin') ! does not work
alh:tablename = 'brandnames'
alh:keyname = 'bra:brandnames_pkey'
alh:keyvalue = bra:brandnamesysid
OR?
alh:keyvalue = p_web.GSV('bra:brandnamesysid')
does not work
In PostUpdate alh:keyvalue = bra:brandnamesysid works just fine
How do I obtain the value bra:brandnamesysid that has has just been created by the PostGreSQL sequence.
How do I obtain the username from a normal login form?
I need two values:
table: brandnames
In PostInsert I have this code
Access:auditlogheader.PrimeRecord()
alh:logtimestamp_DATE = Today()
alh:logtimestamp_TIME = Clock()
alh:username = p_web.GSV('usr:userlogin') ! does not work
alh:tablename = 'brandnames'
alh:keyname = 'bra:brandnames_pkey'
alh:keyvalue = bra:brandnamesysid
OR?
alh:keyvalue = p_web.GSV('bra:brandnamesysid')
does not work
In PostUpdate alh:keyvalue = bra:brandnamesysid works just fine
How do I obtain the value bra:brandnamesysid that has has just been created by the PostGreSQL sequence.
How do I obtain the username from a normal login form?
20
Web Server - Ask For Help / Audit file
« on: October 05, 2014, 01:51:59 PM »
How should this be coded in NTWS?
alh:actiontaken = Choose(ThisWindow.Request,'Add','Change','Delete')
I get these errors when trying to run "normal" code in NTWS
Unknown identifier: THISWINDOW -
Field not found: REQUEST -
Too few parameters -
Must specify identifier -
Unknown identifier: HISTORY::BRA:RECORD -
Too few parameters -
Must specify identifier -
Unknown identifier: HISTORY::BRA:RECORD -
PostUpdate Routine
! Start of "On Update : Form ends : following disk write"
! [Priority 4000]
Access:auditlogheader.PrimeRecord()
alh:logtimestamp_DATE = Today()
alh:logtimestamp_TIME = Clock()
!alh:username = GLO:Username
alh:tablename = 'brandnames'
alh:keyname = 'bra:brandnames_pkey'
alh:keyvalue = bra:brandnamesysid
alh:procedurename = GlobalErrors.GetProcedureName()
alh:actiontaken = Choose(ThisWindow.Request,'Add','Change','Delete')
Access:auditlogheader.Insert()
Stream(auditlogdetail)
Loop i# = 1 to brandnames{Prop:Fields}
If Clip(What(History::bra:Record,i#)) <> Clip(What(bra:Record,i#))
Access:auditlogdetail.PrimeRecord()
ald:auditlogheadersysid = alh:auditlogheadersysid
ald:columnname = Sub(Who(bra:Record,i#),7,Len(Clip(Who(bra:Record,i#))))
ald:oldvalue = What(History::bra:Record,i#)
ald:newvalue = What(bra:Record,i#)
Access:auditlogdetail.Insert()
End
End
! End of "On Update : Form ends : following disk write"
alh:actiontaken = Choose(ThisWindow.Request,'Add','Change','Delete')
I get these errors when trying to run "normal" code in NTWS
Unknown identifier: THISWINDOW -
Field not found: REQUEST -
Too few parameters -
Must specify identifier -
Unknown identifier: HISTORY::BRA:RECORD -
Too few parameters -
Must specify identifier -
Unknown identifier: HISTORY::BRA:RECORD -
PostUpdate Routine
! Start of "On Update : Form ends : following disk write"
! [Priority 4000]
Access:auditlogheader.PrimeRecord()
alh:logtimestamp_DATE = Today()
alh:logtimestamp_TIME = Clock()
!alh:username = GLO:Username
alh:tablename = 'brandnames'
alh:keyname = 'bra:brandnames_pkey'
alh:keyvalue = bra:brandnamesysid
alh:procedurename = GlobalErrors.GetProcedureName()
alh:actiontaken = Choose(ThisWindow.Request,'Add','Change','Delete')
Access:auditlogheader.Insert()
Stream(auditlogdetail)
Loop i# = 1 to brandnames{Prop:Fields}
If Clip(What(History::bra:Record,i#)) <> Clip(What(bra:Record,i#))
Access:auditlogdetail.PrimeRecord()
ald:auditlogheadersysid = alh:auditlogheadersysid
ald:columnname = Sub(Who(bra:Record,i#),7,Len(Clip(Who(bra:Record,i#))))
ald:oldvalue = What(History::bra:Record,i#)
ald:newvalue = What(bra:Record,i#)
Access:auditlogdetail.Insert()
End
End
! End of "On Update : Form ends : following disk write"
21
Web Server - Ask For Help / This XML file does not appear to have any style information associated with it.
« on: September 23, 2014, 12:55:52 PM »
This is the XHTML code I have in a NetWebSource procedure
<img src="images/medxinfocontactinfo004_311x186.png" width="311" height="186" alt="" border="0"/>
that cause this problem:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<ajax-response>
<response type="element" id="contactus_div">
<div id="contactus_div" class="nt-toppanel">
<img src="images/medxinfocontactinfo004_311x186.png" width="311" height="186" alt="" border="0"/>
</div>
<!-- contactus_div -->
</response>
</ajax-response>
<img src="images/medxinfocontactinfo004_311x186.png" width="311" height="186" alt="" border="0"/>
that cause this problem:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<ajax-response>
<response type="element" id="contactus_div">
<div id="contactus_div" class="nt-toppanel">
<img src="images/medxinfocontactinfo004_311x186.png" width="311" height="186" alt="" border="0"/>
</div>
<!-- contactus_div -->
</response>
</ajax-response>
22
Web Server - Ask For Help / send sms and email from one set of code
« on: September 23, 2014, 03:56:51 AM »
For instance - when somebody logs into (enters UserName and Password and clicks "Request OTP" ) www.medxinfo.co.za an OTP One Time Password must be sent to the user's cell phone and/or email address. Once the user has entered the correct OTP and clicks Login, he will be logged in.
The "Request OTP" button calls another NetWebForm?
This form generates the OTP and sends sms and/or email to user?
Which embed points would be optimal?
The "Request OTP" button calls another NetWebForm?
This form generates the OTP and sends sms and/or email to user?
Which embed points would be optimal?
23
Web Server - Ask For Help / NetWebForm - filter on Drop
« on: May 18, 2014, 10:22:23 AM »
First a Country is selected via a Drop from Country Table
Then I would like to select a Province from Province table filtered on CountrySysID
neither of these filters work
‘pro:countrysysid = ' & p_web.GSV(‘cou:countrysysid')
'pro:countrysysid = <39>' & p_web.GSV('cou:countrysysid') & '<39>'
Drop Filter web33.app does not seem to apply here.
Then I would like to select a Province from Province table filtered on CountrySysID
neither of these filters work
‘pro:countrysysid = ' & p_web.GSV(‘cou:countrysysid')
'pro:countrysysid = <39>' & p_web.GSV('cou:countrysysid') & '<39>'
Drop Filter web33.app does not seem to apply here.
24
Web Server - Ask For Help / Sending SMSs en Emails
« on: April 17, 2014, 12:31:56 PM »
see attached
www.medxinfo.co.za
Click Login | Register
Here is the code I'm trying to fit into a XHTML routine on the Help NetWebPage as mentioned my other topic just now.
"Why Register?
You do not have to register as a USER but if you are not registered you cannot Login and certain pages and information will not be visible to you and we will not be able to contact you.
To Register:
NOTE: OTP = One Time Password - only valid for this current session.
You MUST register with a valid Email Address. Once that has been verified you may register, if so desired, your cell phone number. In the case of certain types of USERS like LOCUMS it would be advantageous to be contactable via email AND cell phone!
The Email Address and Cell No supplied must be valid as they will be verified.
Choose option A. or B.
A. If you want to Register with your Email Address AND your Cell No:
Login, Password, Last Name, First Name, Gender, Home Town, Country, Email Address AND Cell No must be filled in.
After all required fields have been filled in then click Request Email OTP.
An Email OTP will be generated and sent to the Email address typed in by you supplying you with an Email OTP - which must then be typed into the field Email OTP.
Now Click Request Cell No OTP.
If the Email OTP typed in by you matches generated Email OTP then a Cell OTP will be generarated and sent to the Cell No typed in by you supplying you with a Cell OTP - which must then be typed into the field Cell OTP.
Now click Register.
If the Email OTP AND Cell OTP typed in by you matches the generated OTPs you will be registered as a User and you will be taken back to the Login Form - with the Login and Password already filled in - now just click Login.
B. If you want to register with your Email Address ONLY:
Login, Password, Last Name, First Name, Gender, Home Town, Country and Email Address must be filled in.
After all required fields have been filled in then click Request Email OTP.
An Email OTP will be generated and sent to the Email address typed in by you supplying you with an Email OTP - which must then be typed into the field Email OTP.
Now click Register.
If the Email OTP typed in by you matches the generated Email OTP you will be registered as a User and you will be taken back to the Login Form - with the Login and Password already filled in - now just click Login."
OK - The Register Button at the bottom is the Save button.
Then there is the Request Email OTP and Request Cell OTP buttons.
When the Request Email OTP is clicked and Email OTP is generated and this Email OTP must then mailed to the email address supplied.
How do I achieve this - must that button call a NetWebForm? - modified Send Email From WebBrowser (11) but with no fields showing on the form as all info is passed from calling form?? Can I pass parameters to it like the First Name, Last Name and Email Address from the calling Form (RegisterForm)?
And if the Request Cell OTP is clicked and I now must send a sms? Have been using ClickAtall HTTP with success but not in NTWS mode.
The code to create OTPs and to verify that a valid Email OTP has been entered should be OK
Well the Email address, generated Email OTP and the Email OTP entered by user are all local variable? - these two OTP's must match - how do I display a message if they don't match to allow for a retry?
[attachment deleted by admin]
www.medxinfo.co.za
Click Login | Register
Here is the code I'm trying to fit into a XHTML routine on the Help NetWebPage as mentioned my other topic just now.
"Why Register?
You do not have to register as a USER but if you are not registered you cannot Login and certain pages and information will not be visible to you and we will not be able to contact you.
To Register:
NOTE: OTP = One Time Password - only valid for this current session.
You MUST register with a valid Email Address. Once that has been verified you may register, if so desired, your cell phone number. In the case of certain types of USERS like LOCUMS it would be advantageous to be contactable via email AND cell phone!
The Email Address and Cell No supplied must be valid as they will be verified.
Choose option A. or B.
A. If you want to Register with your Email Address AND your Cell No:
Login, Password, Last Name, First Name, Gender, Home Town, Country, Email Address AND Cell No must be filled in.
After all required fields have been filled in then click Request Email OTP.
An Email OTP will be generated and sent to the Email address typed in by you supplying you with an Email OTP - which must then be typed into the field Email OTP.
Now Click Request Cell No OTP.
If the Email OTP typed in by you matches generated Email OTP then a Cell OTP will be generarated and sent to the Cell No typed in by you supplying you with a Cell OTP - which must then be typed into the field Cell OTP.
Now click Register.
If the Email OTP AND Cell OTP typed in by you matches the generated OTPs you will be registered as a User and you will be taken back to the Login Form - with the Login and Password already filled in - now just click Login.
B. If you want to register with your Email Address ONLY:
Login, Password, Last Name, First Name, Gender, Home Town, Country and Email Address must be filled in.
After all required fields have been filled in then click Request Email OTP.
An Email OTP will be generated and sent to the Email address typed in by you supplying you with an Email OTP - which must then be typed into the field Email OTP.
Now click Register.
If the Email OTP typed in by you matches the generated Email OTP you will be registered as a User and you will be taken back to the Login Form - with the Login and Password already filled in - now just click Login."
OK - The Register Button at the bottom is the Save button.
Then there is the Request Email OTP and Request Cell OTP buttons.
When the Request Email OTP is clicked and Email OTP is generated and this Email OTP must then mailed to the email address supplied.
How do I achieve this - must that button call a NetWebForm? - modified Send Email From WebBrowser (11) but with no fields showing on the form as all info is passed from calling form?? Can I pass parameters to it like the First Name, Last Name and Email Address from the calling Form (RegisterForm)?
And if the Request Cell OTP is clicked and I now must send a sms? Have been using ClickAtall HTTP with success but not in NTWS mode.
The code to create OTPs and to verify that a valid Email OTP has been entered should be OK
Well the Email address, generated Email OTP and the Email OTP entered by user are all local variable? - these two OTP's must match - how do I display a message if they don't match to allow for a retry?
[attachment deleted by admin]
25
Web Server - Ask For Help / NetWebPage - XHTML code in routine - not enough space?
« on: April 17, 2014, 12:10:27 PM »
NT WS 7.39
see attached
www.medxinfo.co.za
click Login | Register | Help
Help is a NetWebPage
I pasted all of the HTML code I created in Visual Web Developer into one routine - but not all of it displays.
Must I split the code up into more that one routine?
After <body>?
Must I paste the css code created by VWD at the top of the HTML page into each routine?
Thx!
[attachment deleted by admin]
see attached
www.medxinfo.co.za
click Login | Register | Help
Help is a NetWebPage
I pasted all of the HTML code I created in Visual Web Developer into one routine - but not all of it displays.
Must I split the code up into more that one routine?
After <body>?
Must I paste the css code created by VWD at the top of the HTML page into each routine?
Thx!
[attachment deleted by admin]
26
Web Server - Ask For Help / Login and Registration with One Time Password OTP
« on: March 16, 2014, 12:47:54 PM »
Hi
NTWS
Has anyone got some example code to Register to be able to Login later?
UserName:
Password:
MobileNo:
EmailAddress:
Click Request OTP and wait for OTP via Mobile and/or EMail? Then enter the OTP
OTP:
Click Register
Any improvement on this?
NTWS
Has anyone got some example code to Register to be able to Login later?
UserName:
Password:
MobileNo:
EmailAddress:
Click Request OTP and wait for OTP via Mobile and/or EMail? Then enter the OTP
OTP:
Click Register
Any improvement on this?
27
Web Server - Ask For Help / ClarionLive NetTalk User Group Meeting - Login and Access Levels
« on: January 07, 2014, 11:18:08 AM »
Hi All,
Suggested topic:
Login and Access Levels (not using SecWin)
On login Form:
If already registered - then just login.
If not registered - button or link to go to Register Form,
supply First Name, Last Name, email address and mobile number.
A OTP (One time password) will be sent to both? email address and mobile number - OTP must be entered on Registration Form - and then the user can be Registered.
I would like if possible that the email address AND mobile number to be validated before registration is allowed.
Tables: Users and UserGroups
Users may be in many groups - access to Browse/Forms will be restricted on certain criteria.
A User be a Locum and if he is only registered as a locum in UeerGroups he may only edit his own data in Locums table.
But he may also be the Responsible Pharmacist linked to a certain pharmacy - then he will be allowed to edit the pharmacy data in Pharmacies table as well. etc. etc.
Thx!
Suggested topic:
Login and Access Levels (not using SecWin)
On login Form:
If already registered - then just login.
If not registered - button or link to go to Register Form,
supply First Name, Last Name, email address and mobile number.
A OTP (One time password) will be sent to both? email address and mobile number - OTP must be entered on Registration Form - and then the user can be Registered.
I would like if possible that the email address AND mobile number to be validated before registration is allowed.
Tables: Users and UserGroups
Users may be in many groups - access to Browse/Forms will be restricted on certain criteria.
A User be a Locum and if he is only registered as a locum in UeerGroups he may only edit his own data in Locums table.
But he may also be the Responsible Pharmacist linked to a certain pharmacy - then he will be allowed to edit the pharmacy data in Pharmacies table as well. etc. etc.
Thx!
28
Web Server - Ask For Help / New Table/Browse/Form errors
« on: June 13, 2013, 11:05:27 PM »
Suddenly I'm getting this attached error when I add records to a table. Actually, I can add a record but when attempting to add a second record it triggerw the error.
This now happens with new tables/browses/forms - to old ones work perfectly.
[attachment deleted by admin]
This now happens with new tables/browses/forms - to old ones work perfectly.
[attachment deleted by admin]
29
Web Server - Ask For Help / NTWS, GoStats and Google Analytics
« on: June 10, 2013, 09:42:53 PM »
See attachments
It would seem as if the browsers do not "see" the contents of my two js scripts.
When I scracth around in FireBug I do find the contents of all.js but nothing related to GoStas.js or googleanalytics.js?
From GoStats HelpDesk
"Marius, Jun 10 10:17 (COT):
Johan,
The code provided by us it's fine, but it's not copy/pasted as it is within your website's pages code.
Within your site index page, there is only one line added:
"<script src="/scripts/GoStats.js" type="text/javascript"></script>"
You may want to remove that line and add the code fully.
Let me know if you are having any further questions.
Kind regards,
Marius"
[attachment deleted by admin]
It would seem as if the browsers do not "see" the contents of my two js scripts.
When I scracth around in FireBug I do find the contents of all.js but nothing related to GoStas.js or googleanalytics.js?
From GoStats HelpDesk
"Marius, Jun 10 10:17 (COT):
Johan,
The code provided by us it's fine, but it's not copy/pasted as it is within your website's pages code.
Within your site index page, there is only one line added:
"<script src="/scripts/GoStats.js" type="text/javascript"></script>"
You may want to remove that line and add the code fully.
Let me know if you are having any further questions.
Kind regards,
Marius"
[attachment deleted by admin]
30
Web Server - Ask For Help / NT WS a "Window' with MANY buttons?
« on: May 28, 2013, 05:05:40 PM »
How would one create ONE 'window' with many buttons. Seems like it should have been a NetWebForm but can one create MANY buttons on it?
Setting many parameters:
loc:Message
loc:CodeFrom
loc:CodeTo
loc:DateFrom
loc:DateTo
etc
Buttons calling:
Report1
Report2
process1
process2
procedure1
procedure2
procedure3
whatever
how does one do all of this?
on a NetWebForm or what?
Setting many parameters:
loc:Message
loc:CodeFrom
loc:CodeTo
loc:DateFrom
loc:DateTo
etc
Buttons calling:
Report1
Report2
process1
process2
procedure1
procedure2
procedure3
whatever
how does one do all of this?
on a NetWebForm or what?