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.
166
Web Server - Ask For Help / Webservice Method Date Format
« on: December 29, 2014, 07:04:13 AM »
Hi:
I am trying to return a view from a file using NetWebServiceMethod and one of the fields has a date. When i see the return, i just see the Clarion date not formatted.
I know i am missing something, but how can i format that field to return the formatted date in the XML?
Thanks for your help!
HTTP/1.1 200 OK
Date: Mon, 29 Dec 2014 14:58:35 GMT
Server: NetTalk-WebServer/8.32
Content-Length: 1486
Content-Type: text/xml
Set-Cookie: SESSIONID=t2g8ZKh2s83Hv36Ksa6g7BoV11vjUm; path=/; HttpOnly
Connection: close
X-Frame-Options: sameorigin
<?xml version="1.0" encoding="utf-8"?>
<RequistionsByPatient_response>
<Results>
<RRH_ACCOUNTNUMBER>1</RRH_ACCOUNTNUMBER>
<RRH_REQUESTNUMBER>1</RRH_REQUESTNUMBER>
<RRH_DATEORDER>76392</RRH_DATEORDER>
<RRH_PATIENT1STLASTNAME>LASTNAME</RRH_PATIENT1STLASTNAME>
<RRH_PATIENT2NDLASTNAME/>
<RRH_PATIENTNAME>NAME</RRH_PATIENTNAME>
<RRH_PATIENTINITIAL/>
</Results>
<Results>
</RequistionsByPatient_response>
I am trying to return a view from a file using NetWebServiceMethod and one of the fields has a date. When i see the return, i just see the Clarion date not formatted.
I know i am missing something, but how can i format that field to return the formatted date in the XML?
Thanks for your help!
HTTP/1.1 200 OK
Date: Mon, 29 Dec 2014 14:58:35 GMT
Server: NetTalk-WebServer/8.32
Content-Length: 1486
Content-Type: text/xml
Set-Cookie: SESSIONID=t2g8ZKh2s83Hv36Ksa6g7BoV11vjUm; path=/; HttpOnly
Connection: close
X-Frame-Options: sameorigin
<?xml version="1.0" encoding="utf-8"?>
<RequistionsByPatient_response>
<Results>
<RRH_ACCOUNTNUMBER>1</RRH_ACCOUNTNUMBER>
<RRH_REQUESTNUMBER>1</RRH_REQUESTNUMBER>
<RRH_DATEORDER>76392</RRH_DATEORDER>
<RRH_PATIENT1STLASTNAME>LASTNAME</RRH_PATIENT1STLASTNAME>
<RRH_PATIENT2NDLASTNAME/>
<RRH_PATIENTNAME>NAME</RRH_PATIENTNAME>
<RRH_PATIENTINITIAL/>
</Results>
<Results>
</RequistionsByPatient_response>
167
Web Server - Ask For Help / Re: Browse start at current record - how?
« on: December 24, 2014, 04:12:32 AM »
Ah Neils different story =D
Let me see if i can get you a solution
Let me see if i can get you a solution
168
Web Server - Ask For Help / Re: Browse start at current record - how?
« on: December 23, 2014, 07:06:52 AM »
Niels, here it is one example using the books dictionary and data files shipped with Bruce examples.
Inside, look at the procedures
FormBrowseInvoice
BrowseInvoice
The FormBrowseInvoice has some additional stuff i made in my apps to go to specific dates including a calendar, Day Forward button and day back button.
In the procedure BrowseInvoice check the filter i set.
Is a quick example, but i hope this gives you some ideas to your project.
The example was made using Clarion 9.1.11396 and NetTalk version 8.32
PD. Any ideas how to make this better are welcome so please don't be shy
[attachment deleted by admin]
Inside, look at the procedures
FormBrowseInvoice
BrowseInvoice
The FormBrowseInvoice has some additional stuff i made in my apps to go to specific dates including a calendar, Day Forward button and day back button.
In the procedure BrowseInvoice check the filter i set.
Is a quick example, but i hope this gives you some ideas to your project.
The example was made using Clarion 9.1.11396 and NetTalk version 8.32
PD. Any ideas how to make this better are welcome so please don't be shy
[attachment deleted by admin]
169
Web Server - Ask For Help / Re: Browse start at current record - how?
« on: December 23, 2014, 06:13:24 AM »
Niels, if i can understand what you are trying to do
Maybe a filter with a LocDate = TODAY() where LocDate refers to the field in the table containing the date you want to set
Then add two buttons with -1 +1 day to move forward and backwards in specific date using this embed in the button
LocDate = p_web.GSV('LocDate') + 1
p_web.SSV('LocDate',LocDate)
Let me know if this helps. I can try to make an example later and make it more clear =D
Maybe a filter with a LocDate = TODAY() where LocDate refers to the field in the table containing the date you want to set
Then add two buttons with -1 +1 day to move forward and backwards in specific date using this embed in the button
LocDate = p_web.GSV('LocDate') + 1
p_web.SSV('LocDate',LocDate)
Let me know if this helps. I can try to make an example later and make it more clear =D
170
Web Server - Ask For Help / Re: Webserver Report - Problems with special caracters (Spanish) Encoding
« on: December 09, 2014, 12:52:37 PM »
Spanish special characters are á é í ó ú ñ ü Á É Í Ó Ú Ñ Ü
I did it manually, not too much records to update, but it will be interesting to know how to make the conversion automatically
Thanks again Bruce
I did it manually, not too much records to update, but it will be interesting to know how to make the conversion automatically
Thanks again Bruce
171
Web Server - Ask For Help / Re: Webserver Report - Problems with special caracters (Spanish) Encoding
« on: December 09, 2014, 05:10:40 AM »
Hi Bruce:
That is correct, it works!
Any way to convert the existing data?
Any recommendation will be appreciated
Thank you again!
That is correct, it works!
Any way to convert the existing data?
Any recommendation will be appreciated
Thank you again!
172
Web Server - Ask For Help / Re: Webserver Report - Problems with special caracters (Spanish) Encoding
« on: December 08, 2014, 08:05:35 AM »
BTW, the screenshot shows utf-8 in both settings, and at least let me store the special characters well but the display in the report is ugly.
Another combination i did use was ISO-8859-1 but no luck
Another combination i did use was ISO-8859-1 but no luck
173
Web Server - Ask For Help / Re: Webserver Report - Problems with special caracters (Spanish) Encoding
« on: December 08, 2014, 08:03:19 AM »
Hi Bruce, it is already done with utf-8 and i am still having the problem.
Even sendmail procedures are having problems too
[attachment deleted by admin]
Even sendmail procedures are having problems too
[attachment deleted by admin]
174
Web Server - Ask For Help / Webserver Report - Problems with special caracters (Spanish) Encoding
« on: December 05, 2014, 08:15:26 AM »
Hi:
I am using C9.1.11396 release and NetTalk 8.32 with the latest of the needed templates.
I am having issues with special characters in the reports. I set the encoding in the web server to UTF-8 (Spanish does not work anymore) and i see the characters like this González-Bianchi Edgardo.
Any recommendations would be great. Thanks in advance
I am using C9.1.11396 release and NetTalk 8.32 with the latest of the needed templates.
I am having issues with special characters in the reports. I set the encoding in the web server to UTF-8 (Spanish does not work anymore) and i see the characters like this González-Bianchi Edgardo.
Any recommendations would be great. Thanks in advance
175
Web Server - Share Knowledge / Re: IIS not playing nice with NTWS?
« on: November 20, 2014, 06:28:18 AM »
Ashely, i hope this helps.
In the Internet Information Services (IIS) Manager found in Administrative tools follow this steps. Remember to restart IIS Server. This is how you setup IIS to bind the ip port combination to whatever you want (even change the default ports 80 and 443 to something else)
[attachment deleted by admin]
In the Internet Information Services (IIS) Manager found in Administrative tools follow this steps. Remember to restart IIS Server. This is how you setup IIS to bind the ip port combination to whatever you want (even change the default ports 80 and 443 to something else)
[attachment deleted by admin]
176
Web Server - Ask For Help / Re: Report Progress Bar Download Link - Broken
« on: October 21, 2014, 08:59:44 AM »
Hi Bruce:
Any work around i can do until I get the 8.29 release?
Thanks in advance
Any work around i can do until I get the 8.29 release?
Thanks in advance
177
Web Server - Ask For Help / Re: Report Progress Bar Download Link - Broken
« on: October 20, 2014, 05:34:39 AM »
Thank you Bruce!
178
Web Server - Ask For Help / Report Progress Bar Download Link - Broken
« on: October 17, 2014, 07:35:55 AM »
Hi Bruce:
I am using NetTalk version 8.27 and Clarion Version 9.1.11242. Using the example Web72 Progress(72) i generate the report and i see the link, but when i click to download the document, the link disappear and do not show any document.
Something similar happen in NetTalk version 7.08
I am using NetTalk version 8.27 and Clarion Version 9.1.11242. Using the example Web72 Progress(72) i generate the report and i see the link, but when i click to download the document, the link disappear and do not show any document.
Something similar happen in NetTalk version 7.08
179
Web Server - Ask For Help / Re: No Private Key included when purchasing a certificate. Help please.
« on: October 07, 2014, 06:18:21 AM »
astahl,
If you use the CreateCertificateSigningRequest.bat script, there's a folder called yourCaRoot and inside another folder called private. The private key is supposed to be there. Keep it safe and use to compliment the certificate you have signed.
If you use the CreateCertificateSigningRequest.bat script, there's a folder called yourCaRoot and inside another folder called private. The private key is supposed to be there. Keep it safe and use to compliment the certificate you have signed.
180
Web Server - Ask For Help / Re: NT8 icon on Page Tab
« on: October 01, 2014, 06:49:22 AM »
Hi:
Inside the web folder the file called defaultfavicon.ico.
Since version 7.17 this change has been made
Change: If browser asks for favicon.ico and one does not exist then defaultfavicon.ico is supplied. This reduces the number of requests from the browser for the file.
Inside the web folder the file called defaultfavicon.ico.
Since version 7.17 this change has been made
Change: If browser asks for favicon.ico and one does not exist then defaultfavicon.ico is supplied. This reduces the number of requests from the browser for the file.