Messages

1

Web Server - Ask For Help / Re: Apostraphe value in sql

« on: September 11, 2024, 06:59:53 PM »

hi bruce,

you want me to produce example in sql ? because i am trying to highlight about sql here.

Let me elaborate:

Let's say Product Name is King's Kong
I want to search for all the invoice with that value. I will issue the sql query in my embed code

InvoiceItems{Prop:Sql} = 'Select * from dbo.InvoiceItems where ProductName = ''' & p_web.GSV('SelectedProductName') & ''''

the above query will fail because apostraphe in the Product Name because in sql query, my code produce Select * from dbo.InvoiceItems where ProductName = 'King's Kong'    which is wrong.
i need to do this:

Select * from dbo.InvoiceItems where ProductName = 'King''s Kong'


Right now, i can rectify the issue using string theory.

What i am asking is if there is a nettalk method to convert single apostraphe to double apostraphe then it would be useful.

regards,
Jason

2

Web Server - Ask For Help / Re: Apostraphe value in sql

« on: September 09, 2024, 07:10:52 PM »

Hi Sean,
Yes, that's what i did. Use the string theory to detect single ' and made it double '' before passing it to the filter.
What i want to know if there is a nettalk class that can does that for us. p_web.jsok converts single ' but to a different value.

regards,
Jason

3

Web Server - Ask For Help / Apostraphe value in sql

« on: September 03, 2024, 11:42:47 PM »

hi bruce,
when i filter a browse with a value, say King's Speech, i found that the filter fails.
The value inside the sql database is indeed King's Speech.
If i use jsok, then nettalk would convert it as King's Speech. Again the filter will fail.
For now, what i did is i check the value of filter. If it contains ', then i will replace it with '' using string theory.
then the filter works.

may i know if there is any nettalk method or a setting to handle the apostraphe? thanks.

regards,
jason
nt14.20
c11.1

4

Web Server - Ask For Help / Re: EIP Lookup in Netbrowse

« on: July 15, 2024, 01:45:14 AM »

update:
For now, the lookup button appears only IF we check the popup lookup .

Thanks bruce for the guide.

regards,
Jason
C11.1
Nt14.20

5

Web Server - Ask For Help / Re: EIP Lookup in Netbrowse

« on: July 10, 2024, 11:29:42 PM »

thanks bruce,
i have emailed the modified example 21 to you.

regards,
jason
nt14.20
c11.1

6

Web Server - Ask For Help / Re: EIP Lookup in Netbrowse

« on: July 08, 2024, 06:51:03 PM »

and for the browse, even though i have enabled all columns for eip, if i insert record, it still open the form. if i take out the form, the insert dont open up the eip.

7

Web Server - Ask For Help / EIP Lookup in Netbrowse

« on: July 03, 2024, 11:44:35 PM »

Hi
Anyone tried using eip lookup in netbrowse?
I have enabled the lookup for a string (eg lookup for product name) and in the browse, i dont see any lookup button.
Just an open string box. if i enable the autocomplete, no suggestion appear. If i type wrong value, then it pops up invalid value
The lookup for date and checkbox works in eip though.

regards,
Jason
nt14.20
c11.1

8

Web Server - Ask For Help / Re: css of Other button in a netbrowse

« on: June 18, 2024, 09:59:03 PM »

noted.
thanks bruce.

regards,
Jason

9

Web Server - Ask For Help / Re: css of Other button in a netbrowse

« on: June 18, 2024, 06:50:56 PM »

hi bruce,
Alright. I have emailed you the example.
Thanks.

regards,
Jason

10

Web Server - Ask For Help / css of Other button in a netbrowse

« on: June 15, 2024, 01:15:00 AM »

hi bruce,
if i add other button in a netbrowse, it was ok. If i call a procedure on a click, then the css disappears. I have to manually put the css for now (' ui-button ui-corner-all ui-widget').


regards,
jason
c11.1
nt14.20

11

Web Server - Ask For Help / Point of Sale (Cashier Screen) in Nettalk

« on: April 19, 2024, 12:58:24 AM »

hi,
Has anyone created a responsive web point of sale screen (Cashier Interface) using NetTalk?


regards,
jason
nt14.20
c11.1

12

Web Server - Ask For Help / Re: Multi host certificate

« on: March 11, 2024, 01:55:38 AM »

update:
bruce solved it.
the domain is not listed in the hostserversetting.xml
but shown at calculated domains. i manually add the domain in the xml and website loads fine.
thanks bruce.

jason
nt12.62
c11

13

Web Server - Ask For Help / Multi host certificate

« on: March 07, 2024, 05:33:37 PM »

Hi,
I am running a multi host using nt12.62
The security certificates generate correctly for each domain.
For example:

www.abc.com   ---> ssl ok
www.def.com   ----> ssl ok
www.ghi.com   ----> ssl ok

Now i have added demo.def.com in a domain management and it points to the server correctly.
host.exe able to generate the certificate too.

However, when i load the site, it shows certificate not valid and the common name is www.abc.com

Is there any step that i have missed out?

jason
nt12.62
c11

14

Web Server - Ask For Help / Re: json group in queue

« on: December 12, 2023, 01:38:53 AM »

thanks bruce,
i overlooked something. so eager to solve it and didnt see a minor thing.

the tested working code should be:

  planjson &= json.GetByName('plan')

  if not planjson &= null
        planid = planjson.GetValueByName('id')       
  end 

15

Web Server - Ask For Help / Re: json group in queue

« on: December 11, 2023, 11:09:25 PM »

hi bruce,
i capture the api, remove the header and save response values (which is in json) into a string theory (st)
and then i did the following

  json.start()
  json.SetTagCase(jf:CaseAsIs)
  json.LoadString(st)


   i could get non queue values such as element.id

  the word id is used several times in the returned json. so if i use getvaluebyname, most likely it will get the first one only,
  right?

  also, planjson &= GetByName('plan')   gives error  -> no matching prototype available.
but i have declared it in the local declaration as planjson  &jsonclass