Hello, Currently I have an aplication which stores the information in an MsSQL database in a straight forward manner, "insert into blah blah"
However, I retrieve the information in XML format using the FOR XML EXPLICIT statements that come with MsSQL 2000. The select stament looks something like select 1 as tag, null as parent, login as [info!1!first_name!element] from user_info FOR XML EXPLICIT Without the FOR XML EXPLICIT statement this returns a the following recordset: TAG PARENT info!1!first_name!element 1 NULL Marcelo 1 NULL Pablo WITH the FOR XML EXPLICIT statement, this query returns the following STRING <info><first_name>marcelo</first_name></info><info><first_name>pablo</first_ name></info> I then i just throw that XML STRING to the XSL pages and voila! I have an html page. I have been reading alot about XML support in this mailing list. But this XML support has NOTHING to do with how the information is being stored, just how the information is being delivered to the client. Any idea if something like this will ever be implemented in MySQL? If so when? If not I am afraid that if we decide to switch from MsSQL 2000 to MySQL will be a painfull one. Thanks. Marcelo PS. I do realize that the "FOR XML EXPLICIT " statement is NOT SQL Standard and that I made a pact with the devil when I decided to use it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
