FR: SELECT as XML

[Mr. Bart Pietercil]

Hi Ruslan
On 22-nov-07, at 20:06, Ruslan Zasukhin wrote:

> On 22/11/07 8:55 PM, "Mr. Bart Pietercil"  
> <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> Hi Ruslan, List,
>>
>> we are faced with the problem of loading Valentina data into Flash
>> (and out of Flash). For the time being I am sure we well be able to
>> cook a solution working with PHP (selecting and converting the cursor
>> to xml)
>>
>> However I think it is still a good thing (TM) to have this as a
>> Valentina feature.
>
> Yes, and our plan is implement this as support of
>
>     SQL 2003 Extention  SQL/XML.
>
> ----------
>> So my question is :
>>
>> How hard would it be to implement the call SELECT(SELECT * FROM
>> tbl_x) AS XML which would return a nice formatted xml text.
>
> Problem with this solution is -- it is not flexible.
>     format of XML will be hardcode into kernel.
>
> SQL2003 gives absolutly flexible way produce XML as you want
>
>
>> Of course once you have this, I will be knocking on the door with the
>> next question: implement a HTTP server so the generated xml can be
>> served over port 80
>>
>> (does this smell like SOAP ;-))
>
> Valentina Server in fact already have support of HTTP :-)
>
> Just it have no sense until we make SQL 2003 thing.
>

OK, I give up, you just keep amazing me :-)
Any idea on a timeframe for implementing the 2003 Extension  
( according to the name you are 4 years late :-))


Thx

Bart