FR: SELECT as XML

[Ruslan Zasukhin]

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.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]