Hi I'm trying to generate an xml file from a database using sql, but I want the element names to be something other than the field names in the table eg: the sql statement select Field1, Field2, Field3 from Table generates elements Field1 Field2 Field3 I want to call them Somethingelse1 Somethingelse2 Somethingelse3 I've tried select Field1 ans Somethingelse1 but it doesn't like it Is there a quick way to do this or do I have to treat the generated xml as a string and replace etc etc etc Thanks anyone who can help! Kath Prescott Tel: 01242 573869 Mobile: 07984 717299 > The NSPCC FULL STOP Campaign is entering a new phase. Its latest TV > advertising urges the public to do something if they suspect a child is > being abused. This is one of a range of activities to communicate a > simple message: Together we can stop child abuse. FULL STOP. > For more information on the FULL STOP Campaign and the work of the NSPCC, > visit www.nspcc.org.uk > If you have concerns about the welfare of a child, please call the NSPCC > National Child Protection Helpline on Freephone 0808 800 5000. This is a > 24 hour, seven days a week service and calls are free. >Received on Saturday, 20 April 2002 18:38:57 GMT
This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 11 January 2011 00:14:30 GMT