Re: [GENERAL] how to store whole XML file in database

2007-02-12 Thread Richard Huxton
Brandon Aiken wrote: You'll have to escape any quotation marks or your SQL will not parse your strings correctly. And you have to do this for all your data, not just XML. Otherwise the first Mr. O'Malley you have a record for will break your application. -- Richard Huxton Archonet Ltd

Re: [GENERAL] how to store whole XML file in database

2007-02-12 Thread Brandon Aiken
AM To: PostgreSQL - General Subject: [GENERAL] how to store whole XML file in database hi,, i have to insert whole xml file in database ,there is a text field for that.but it shows error parse error where there are attribute ..plz help m

Re: [GENERAL] how to store whole XML file in database

2007-02-12 Thread Tommy Gildseth
deepak pal wrote: hi,, i have to insert whole xml file in database ,there is a text field for that.but it shows error parse error where there are attribute ..plz help me out. I'm guessing you have a quoting problem. Try escaping the XML-data before inserting it into the database, so

[GENERAL] how to store whole XML file in database

2007-02-12 Thread deepak pal
hi,, i have to insert whole xml file in database ,there is a text field for that.but it shows error parse error where there are attribute ..plz help me out.