Re: [Exist-open] sql:execute() without types

[Pieter L. <pie...@be...>]

We do the following when we don't need the full shebang:

inside a <data> element we return

             $sql-result/* except $sql-result/(sql:row|sql:stack-trace),

             for $row in $sql-result/sql:row

           return

             <row>

             {

               for $column in $row/sql:*

               return

                 element {local-name($column)} {string($column)}

             }

             </row>

Good enough in most cases. You could tidy it up further by escaping 
$column names that are not XML compliant.

-p

On 10/07/2022 11:07, Adam Retter wrote:
> I am afraid not. You would be welcome to add a config option for the
> module or function to control this though...
>
> On Sun, 10 Jul 2022 at 01:16, Len Schultz<le...@wi...>  wrote:
>> Hello,
>>
>> For size reasons and the fact that I don’t need to know the types, I’d like to have sql:execute return results which don’t have type attributes.  Is this possible?
>>
>> --len
>>
>> _______________________________________________
>> Exist-open mailing list
>> Exi...@li...
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>
>
-- 
Pieter Lamers
John Benjamins Publishing Company
Postal Address: P.O. Box 36224, 1020 ME AMSTERDAM, The Netherlands
Visiting Address: Klaprozenweg 75G, 1033 NN AMSTERDAM, The Netherlands
Warehouse: Kelvinstraat 11-13, 1446 TK PURMEREND, The Netherlands
tel: +31 20 630 4747
web:www.benjamins.com