Re: creating xml formatted out from table in database

2007-05-29 Thread James Wolfe
> The first part is easy, just wondering if someone could advise on the > second part getting to XML formatted output from the table in the > database. MS SQL Server 2000 and 2005 have a special feature for this: SELECT * FROM [tableName] FOR XML AUTO you can even control the fo

Re: creating xml formatted out from table in database

2007-05-28 Thread Peter Tanswell
Hi there Thanks for that. I'm trying to do something on the fly in the next half hour. This is what I have so far select * from users order by lname #fname# #lname#

Re: creating xml formatted out from table in database

2007-05-28 Thread Jim Wright
Ray Camden has a handy CFC that will help with that... http://ray.camdenfamily.com/projects/toxml/ On 5/28/07, Peter Tanswell <[EMAIL PROTECTED]> wrote: > Hi there > > Just trying to figure something out. > > I have a form and an action page to write data to a table in the database. I > am colle

creating xml formatted out from table in database

2007-05-28 Thread Peter Tanswell
Hi there Just trying to figure something out. I have a form and an action page to write data to a table in the database. I am collecting a persons first and last name and email address. I want to be able to send this information to an xml formatted output so it can be used in a flash applica