WebService - Method with returning TABLE and VIEW

[walter.dasilva]

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,

[Bruce]

Hi Walter,

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

cheers
Bruce

[walter.dasilva]

Hi Bruce,

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

Thanks
Walter - SOFTVALE


[attachment deleted by admin]

[walter.dasilva]

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

[Bruce]

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

cheers
Bruce

[walter.dasilva]

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?

[JZL]

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

[walter.dasilva]

Yes Yes Yes,

that works

Cheers,
Walter - SOFTVALE

[walter.dasilva]

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

[Bruce]

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

cheers
Bruce

[walter.dasilva]

Right,

I'm using POST this time

Thanks Bruce