GroupGetAll

Zapytanie:

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

//BEGIN// <?xml version="1.0" encoding="UTF-8"?> <Net47>     <SessionID>9859c16379c2f22e2db8dde9f41cc6a8</SessionID>     <Priority>3</Priority>     <Request>         <Type>GroupGetAll</Type>         <GroupGetAll>             <Offset>1</Offset>             <Limit>100</Limit>             <SortName>id</SortName>             <SortType>ASC</SortType>         </GroupGetAll>     </Request> </Net47> //BEGINEND//

Odpowiedź:

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

//BEGIN// <?xml version="1.0" encoding="UTF-8"?> <Net47>     <Request>         <Type>GroupGetAll</Type>         <GroupGetAll>             <Pages>15</Pages>             <Group>                 <ID>1</ID>                 <Name>testowy</Name>                 <Description>Jan</Description>             </Group>             <Group>                 <ID>2</ID>                 <Name>testowy</Name>                 <Description>Jan</Description>             </Group>         </GroupGetAll>     </Request> </Net47> //BEGINEND//

Błędy:

?

1 2 3 4 5 6 7 8 9

//BEGIN// <?xml version="1.0" encoding="UTF-8"?> <Net47>     <Request>         <Type>Error</Type>         <Error>Nie ma takiej strony</Error>     </Request> </Net47> //BEGINEND//

SELECT * FROM groups_getall(ofs INT, lmt bigint, pole TEXT, typs TEXT) ofs = <Offset>1</Offset> lmt = <Limit>100</Limit> pole = <SortName>id</SortName> typs = <SortType>ASC</SortType>