NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: walter.dasilva on July 23, 2014, 10:19:49 AM

Title: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on July 23, 2014, 10:19:49 AM

HI,

i´m getting this error trying webservicemethod returning TABLE

This page contains the following errors:

error on line 4 at column 12: error parsing attribute name
error on line 4 at column 12: Encoding error
Below is a rendering of the page up to the first error.

And this one returning VIEW

This page contains the following errors:

error on line 6 at column 15: Encoding error
Below is a rendering of the page up to the first error.
Thanks,

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: Bruce on July 23, 2014, 10:00:03 PM

Hi Walter,

I will need an example app to duplicate the problem here.

cheers
Bruce

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on July 24, 2014, 10:43:42 AM

Hi Bruce,

Attached a sample make with wswizard.
I´m using MSSQL

Thanks
Walter - SOFTVALE


[attachment deleted by admin]

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on July 24, 2014, 12:07:19 PM

Hi Bruce,

1. Works with TopSpeed but not with MSSQL since you left FIELD in RETURN tab in blank
2. Error if content of field has (in my case) portuguese character

Regards,
Walter - SOFTVALE

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: Bruce on July 24, 2014, 10:14:17 PM

please explain more Walter... I'm not following exactly what you mean...

cheers
Bruce

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on July 25, 2014, 04:35:12 AM

Hi Bruce,

I made two samples, one using topspeed, another one using MSSQL. The sample with topspeed works fine, but that one with MSSQL are getting error. But, if you define fields into RETURN TAB/FIELDS that sample MSSQL works fine, since the content don´t use Portuguese character.

That´s clear?

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: JZL on July 25, 2014, 05:03:10 AM

Hi W


I have added the following line to make Danish characters set works

xml.SaveEncoding = 'utf-8'  to the BuildResult routine it is not inherited from the template setting

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on July 25, 2014, 05:22:09 AM

Yes Yes Yes,

that works

Cheers,
Walter - SOFTVALE

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on August 20, 2014, 07:09:55 AM

Hi Bruce,

JZL´s tips solved problem when we use utf-8 character with web service. is this the only way or WS must respect NT global properties?

Cheers
Walter

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: Bruce on August 20, 2014, 10:25:06 PM

this is automatic in build 8.25
(ie _all_ SOAP output is utf-8, regardless of the charset of your web site.)

cheers
Bruce

Title: Re: WebService - Method with returning TABLE and VIEW
Post by: walter.dasilva on August 21, 2014, 12:54:16 PM

Right,

I'm using POST this time

Thanks Bruce