Re: Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Tod Harter
On Monday 18 February 2002 13:05, Dan Nelson wrote: > In the last episode (Feb 18), Marcelo Iturbe said: > > 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 informa

Re: Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Dan Nelson
In the last episode (Feb 18), Marcelo Iturbe said: > 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

Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Marcelo Iturbe
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