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 / NTWS Form Multi-select example app?
« on: January 01, 2019, 12:57:49 PM »
I my locum database I would like a DROP using a table called preferredareas and it must be multi-select. An dput the selections into a column called clientpreferredareas.
Areas like Pretoria/EastRand/Johannesburg/VaalTriangle etc. I cannot get it to work - in the drop it shows me the contents of the table - but I cannot select say one or two or many/any?
Coming to think of it - maybe a drop is not the answer - the table will have too many items and it will take over my update form.
Any other suggestions?
Areas like Pretoria/EastRand/Johannesburg/VaalTriangle etc. I cannot get it to work - in the drop it shows me the contents of the table - but I cannot select say one or two or many/any?
Coming to think of it - maybe a drop is not the answer - the table will have too many items and it will take over my update form.
Any other suggestions?
2
Web Server - Ask For Help / NTWS UpdateForm with many potential selections
« on: September 24, 2018, 11:30:08 AM »
NTWS 10.33 Clarion 10
I need help with my Locum app/db. medxinfo.co.za
When a locum is registered they fill in the normal stuff like name, cellno, email address etc.
Then I will require PreferredAreas, RegisteredWithPharmacyGroups and DispensingApplications, etc. With each there could be one or many selected.
What will be best way to achieve this in WebUpdateForm? Because each of those could have multiple choices that could result in a very long UpdateForm.
I would think that each choice would a Boolean checkbox?
I need help with my Locum app/db. medxinfo.co.za
When a locum is registered they fill in the normal stuff like name, cellno, email address etc.
Then I will require PreferredAreas, RegisteredWithPharmacyGroups and DispensingApplications, etc. With each there could be one or many selected.
What will be best way to achieve this in WebUpdateForm? Because each of those could have multiple choices that could result in a very long UpdateForm.
I would think that each choice would a Boolean checkbox?
3
Web Server - Ask For Help / NTWS On Delete want to write out deleted record detaisl to another table
« on: April 30, 2018, 11:24:11 AM »
Hi
I have some Audit code that works well to write all inserted or updated info to the audit tables.
In case of Delete and I would also like to write the deleted record's details to a deletetable/archive.
In the case of Insert and Update the audit code goes into PostInsert and PostUpdate and it works as intended.
It does not work in PostDelete as the record has been deleted. Which would be the correct embed points to put the code for Audit and delete table?
NOTE:In all the Pre embeds I have "p_web.FileToSessionQueue(tpeople,false,'HIS')"
UPDATE: Ok In PostDelete the code writes to the Audit Files - it gets old values from "p_web.FileToSessionQueue(tpeople,false,'HIS')" and then writes a record for each field. For archive I would want the whole record to be written out in one go.
I have some Audit code that works well to write all inserted or updated info to the audit tables.
In case of Delete and I would also like to write the deleted record's details to a deletetable/archive.
In the case of Insert and Update the audit code goes into PostInsert and PostUpdate and it works as intended.
It does not work in PostDelete as the record has been deleted. Which would be the correct embed points to put the code for Audit and delete table?
NOTE:In all the Pre embeds I have "p_web.FileToSessionQueue(tpeople,false,'HIS')"
UPDATE: Ok In PostDelete the code writes to the Audit Files - it gets old values from "p_web.FileToSessionQueue(tpeople,false,'HIS')" and then writes a record for each field. For archive I would want the whole record to be written out in one go.
4
Web Server - Ask For Help / NetTalk Webinar 20180426
« on: April 26, 2018, 06:16:46 AM »
NetTalk Webinar 20180426
Clicking a button on a NetWebForm or in Emded code after Saving a Form
calling a
NetWebSource
What can and can you not do with NetWebSource
Can you just use it with some XMTML included and nothing else
or
NetWebForm
What can and can you not do with NetWebForm (except for the normal being called from a browse to Insert/Edit)
Can you just use it with some XMTML included and nothing else
Would it be possible to have web pages created by NTWS to have "rotating" content, maybe not just graphics but text as well.
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?
What is the max number of characters per XHMLT routine/procedure inside NetWebForm or NetWebSource?
Is it beter to put HTML code in a NetWebForm or NetWebSource or HTML file?
When would one use routine or procedure for XHMLT?
Clicking a button on a NetWebForm or in Emded code after Saving a Form
calling a
NetWebSource
What can and can you not do with NetWebSource
Can you just use it with some XMTML included and nothing else
or
NetWebForm
What can and can you not do with NetWebForm (except for the normal being called from a browse to Insert/Edit)
Can you just use it with some XMTML included and nothing else
Would it be possible to have web pages created by NTWS to have "rotating" content, maybe not just graphics but text as well.
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?
What is the max number of characters per XHMLT routine/procedure inside NetWebForm or NetWebSource?
Is it beter to put HTML code in a NetWebForm or NetWebSource or HTML file?
When would one use routine or procedure for XHMLT?
5
Web Server - Ask For Help / NTWS Rotating Banners and other animals
« on: April 26, 2018, 04:38:29 AM »
Would it be possible to have web pages created by NTWS to have "rotating" content, maybe not just graphics but text as well.
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?
6
Web Server - Ask For Help / NTWS UpdateForm Click Button to call NetWebSource and pass parameters
« on: April 24, 2018, 01:05:29 PM »
Would like to click on the Register button on NetWebForm to call a NetWebSource and at the same time pass contents of some of the already entered fields as p;arameters,
Looks like I cannot do this
'peopleguid='&tpe:guid,'peoplecellno='&tpe:cellno,'peopleemail='&tpe:email,'peoplepassword='&tpe:password
Only one parameter at a time then?
Or which embed point can I use for Register button to try and achieve this.
I would like to send SMS/email to the person busy registering use his already entered email and cellno.
Or can by clicking Register button the form can be saved and only pass the peopleguid to Source? Then with code there I get Fetch the fields from DB?
Looks like I cannot do this
'peopleguid='&tpe:guid,'peoplecellno='&tpe:cellno,'peopleemail='&tpe:email,'peoplepassword='&tpe:password
Only one parameter at a time then?
Or which embed point can I use for Register button to try and achieve this.
I would like to send SMS/email to the person busy registering use his already entered email and cellno.
Or can by clicking Register button the form can be saved and only pass the peopleguid to Source? Then with code there I get Fetch the fields from DB?
7
Web Server - Ask For Help / NTWS NetWebSource error
« on: April 24, 2018, 08:20:41 AM »
Calling this NetWebSource from button on Update - and get this error.
8
Web Server - Ask For Help / NetWebYear Calendar changing date and tim to startdatetimestamp_DATE etc problem
« on: April 24, 2018, 01:30:41 AM »
1. it would appear that NetWebYear does not like startdatetimestamp_DATE and startdatetimestamp_TIME. The dates that have been activated before does not appear on calendar anymore.
And now one cannot add any dates, the Update form comes up with no default dates in From and To and no dates can be selected.
And now one cannot add any dates, the Update form comes up with no default dates in From and To and no dates can be selected.
9
Web Server - Ask For Help / NTWS Print Calanders NetWebYear
« on: April 23, 2018, 01:30:23 AM »
Hi,
Can one print either/or/both as attached
Can one print either/or/both as attached
10
Web Server - Ask For Help / NetWebServerSettings Control Template WebServer Settings Tab Update
« on: April 22, 2018, 08:02:36 AM »
Installed NT 10.19 trying to update the WebServer Settings Tab.
Cannot find NetWebServerSettings Control Template as per NetTalk Webinar 185 at 12:50
Cannot find NetWebServerSettings Control Template as per NetTalk Webinar 185 at 12:50
11
Web Server - Ask For Help / NTWS app - changed TPS table to ODBC(PostGreSQL) PROBLEMS?
« on: April 19, 2018, 01:58:39 PM »
THIS IS A SHOWSTOPPER!
Started this table (tpeople) as TPS and have been using it for a while, have now changed File Driver to ODBC using global connection string.
That table can be browsed but one cannot insert or edit anything. On Save it just bombs out of server app.
This site can?t be reached
localhost refused to connect.
Search Google for localhost Browse People
ERR_CONNECTION_REFUSED
Also, the locator on that browse does not work as it should, if you type one letter it will filter the browse on that one letter, which is still fine, but if you type anymore than one, the browse becomes empty.
people
Locate (Contains) fullname:
zy
Search
Clear
no people
How now brown cow?
Started this table (tpeople) as TPS and have been using it for a while, have now changed File Driver to ODBC using global connection string.
That table can be browsed but one cannot insert or edit anything. On Save it just bombs out of server app.
This site can?t be reached
localhost refused to connect.
Search Google for localhost Browse People
ERR_CONNECTION_REFUSED
Also, the locator on that browse does not work as it should, if you type one letter it will filter the browse on that one letter, which is still fine, but if you type anymore than one, the browse becomes empty.
people
Locate (Contains) fullname:
zy
Search
Clear
no people
How now brown cow?
12
Web Server - Ask For Help / user must >= level
« on: April 19, 2018, 10:36:28 AM »
user must >= level
What exactly does one put there
I have users and userlevels tables.
Login and password is verified against users and the userlevel is in the same table usr:userlevel.
Must I SSV this usr:userlevel on login and here I put the GSV?
OK resolved.
p_web.GSV('loggedinuseruserlevel') did the trick.
Couldn't find this any docs.
Wait - what did it verify it against?
What exactly does one put there
I have users and userlevels tables.
Login and password is verified against users and the userlevel is in the same table usr:userlevel.
Must I SSV this usr:userlevel on login and here I put the GSV?
OK resolved.
p_web.GSV('loggedinuseruserlevel') did the trick.
Couldn't find this any docs.
Wait - what did it verify it against?
13
Web Server - Ask For Help / NTWS Buttons on Browse and filter NetWebYear
« on: April 03, 2018, 02:46:06 AM »
Hi
http://www.medxinfo.co.za/Browsetpeople
click on Calendar to call www.medxinfo.co.za/CalendarBookingsLocums (CalendarBookingsLocums not on LIVE site yet)
then it must filter CalendarBookingsLocums on tpe:guid
http://www.medxinfo.co.za/CalendarBookings
(at the moment it will only show MY bookings - no filter as yet)
see attached for FILTER on NetWebYear
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('tpe:guid')) & ''''
or
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('somesessionvariable')) & ''''
which does not work at the moment.
Obviously I must execute the correct SSV in the Browse - but where - which embed point or otherwise?
And what must the filter look like.
Many thanks - this is a showstopper for me!
http://www.medxinfo.co.za/Browsetpeople
click on Calendar to call www.medxinfo.co.za/CalendarBookingsLocums (CalendarBookingsLocums not on LIVE site yet)
then it must filter CalendarBookingsLocums on tpe:guid
http://www.medxinfo.co.za/CalendarBookings
(at the moment it will only show MY bookings - no filter as yet)
see attached for FILTER on NetWebYear
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('tpe:guid')) & ''''
or
'UPPER(boo:peopleguid) = ''' & upper(p_web.GSV('somesessionvariable')) & ''''
which does not work at the moment.
Obviously I must execute the correct SSV in the Browse - but where - which embed point or otherwise?
And what must the filter look like.
Many thanks - this is a showstopper for me!
14
Web Server - Ask For Help / NTWS HotDates web12.app day buttons not colorized
« on: March 30, 2018, 11:34:43 AM »
Hi
I have included some edited HotDates procedures into my NTWS app, everything seems to be working fine except that the buttons do not get colorized after a booking.
How do I fix this?
And what is Container ID?
OK - Resolved! Finally got the linking between tables correct!
By what is Container ID?
I have included some edited HotDates procedures into my NTWS app, everything seems to be working fine except that the buttons do not get colorized after a booking.
How do I fix this?
And what is Container ID?
OK - Resolved! Finally got the linking between tables correct!
By what is Container ID?
15
Web Server - Ask For Help / NTWS 8.71 C8 Compile errors caused by s_web.AddStyle()
« on: October 12, 2017, 09:59:02 AM »
Get 2 compile errors in my own app but not in example web1.app?
The compile errors are both
"No Matching Prototype Available"
The problem is here in both cases
this
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
should be
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
i.e. this must not be there
s_web.AddStyle() &|
Cannot edit the code as it is template generated.
How can I fix it?
IF(1)
s_web._SitesQueue.Defaults.HtmlCommonStyles = |
s_web.AddStyle(clip('shoestrap3') & '/theme.css',true) &|
''
Else
s_web._SitesQueue.Defaults.HtmlCommonStyles = |
s_web.AddStyle(clip('shoestrap3') & '/jquery-ui.css',true) & |
s_web.AddStyle('jquery-nt-color.css') &|
s_web.AddStyle('jquery-nt-menu.css') &|
s_web.AddStyle('jquery-nt-cal.css') &|
s_web.AddStyle('jquery.ad-gallery.css') &|
s_web.AddStyle('redactor.css') &|
s_web.AddStyle('jquery.fileupload-ui.css') &|
s_web.AddStyle('netweb.css') &|
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
End
IF(1)
s_web._SitesQueue.Defaults.HtmlCommonStylesMobile = |
s_web.AddStyle(clip('shoestrap3') & '/mobiletheme.css',true) &|
''
ELSE
s_web._SitesQueue.Defaults.HtmlCommonStylesMobile = |
s_web.AddStyle('jquery.mobile.structure.css') & |
s_web.AddStyle(clip('shoestrap3') & '/jquery.mobile.theme.css',true) & |
s_web.AddStyle(clip('shoestrap3') & '/jqm-icon-pack.css',true) &|
s_web.AddStyle('jquery-nt-color.css') &|
s_web.AddStyle('jquery-nt-menu.css') &|
s_web.AddStyle('jquery-nt-cal.css') &|
s_web.AddStyle('jquery.ad-gallery.css') &|
s_web.AddStyle('jquery.fileupload-ui.css') &|
s_web.AddStyle('redactor.css') &|
s_web.AddStyle('netweb.css') &|
s_web.AddStyle(clip('shoestrap3') & '/nettalk-mobile.css',true) & |
s_web.AddStyle() &|
''
End
The compile errors are both
"No Matching Prototype Available"
The problem is here in both cases
this
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
should be
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
i.e. this must not be there
s_web.AddStyle() &|
Cannot edit the code as it is template generated.
How can I fix it?
IF(1)
s_web._SitesQueue.Defaults.HtmlCommonStyles = |
s_web.AddStyle(clip('shoestrap3') & '/theme.css',true) &|
''
Else
s_web._SitesQueue.Defaults.HtmlCommonStyles = |
s_web.AddStyle(clip('shoestrap3') & '/jquery-ui.css',true) & |
s_web.AddStyle('jquery-nt-color.css') &|
s_web.AddStyle('jquery-nt-menu.css') &|
s_web.AddStyle('jquery-nt-cal.css') &|
s_web.AddStyle('jquery.ad-gallery.css') &|
s_web.AddStyle('redactor.css') &|
s_web.AddStyle('jquery.fileupload-ui.css') &|
s_web.AddStyle('netweb.css') &|
s_web.AddStyle(clip('shoestrap3') & '/nettalk-ui.css',true) & |
s_web.AddStyle() &|
''
End
IF(1)
s_web._SitesQueue.Defaults.HtmlCommonStylesMobile = |
s_web.AddStyle(clip('shoestrap3') & '/mobiletheme.css',true) &|
''
ELSE
s_web._SitesQueue.Defaults.HtmlCommonStylesMobile = |
s_web.AddStyle('jquery.mobile.structure.css') & |
s_web.AddStyle(clip('shoestrap3') & '/jquery.mobile.theme.css',true) & |
s_web.AddStyle(clip('shoestrap3') & '/jqm-icon-pack.css',true) &|
s_web.AddStyle('jquery-nt-color.css') &|
s_web.AddStyle('jquery-nt-menu.css') &|
s_web.AddStyle('jquery-nt-cal.css') &|
s_web.AddStyle('jquery.ad-gallery.css') &|
s_web.AddStyle('jquery.fileupload-ui.css') &|
s_web.AddStyle('redactor.css') &|
s_web.AddStyle('netweb.css') &|
s_web.AddStyle(clip('shoestrap3') & '/nettalk-mobile.css',true) & |
s_web.AddStyle() &|
''
End