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
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
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
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.