I have special characters such as &,<,>," already in the data i'm trying to read from my database. I am using ASP with xml. I can use a "Replace function" to replace some of these characters with the replacement entities such as "<" as I loop through to output the fields. But I have no clue what to do about the quote. Is there a way in XML of hiding these characters if they are already in the database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
special characters in database
- Thread starter nam4520
- Start date
What database are you retrieving the data from?
Could you give an example snippet of your code so that I can get an idea of what is going on?
James
James Culshaw
james@miniaturereview.co.uk
Could you give an example snippet of your code so that I can get an idea of what is going on?
James
James Culshawjames@miniaturereview.co.uk
- Thread starter
- #3
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
End tag 'note_body' does not match the start tag 'PF8'. Error processing resource ' Line 107, Position 46
USE <PF7> AND <PF8> TO NAVIGATE REPORT LIST</note_body><note_dt>8/28/99 11:30:11 AM</note_dt><note_user>DREYNOLDS</note_user><note_body>FMID(s) SWJR371, SWJR381, SWJR382, SWJR410 are not being addressed by this Change because:
---------------------------------------------^
above is the error message that i get when i run my asp page. the <PF7> and others are data in the database.
below is my code. the Xml processor interpretes that as a tag.
<% @language="vbscript" %>
<% Response.ContentType="text/xml" %>
<?xml version="1.0"?>
<!-- xml file generated by asp -->
<notes xml:space="preserve">
dim omsg, rst
set omsg= Server.CreateObject("ADODB.Connection"
omsg.ConnectionString="Provider=MSDASQL;DSN=SwisODBC;UID=SYSDBA;PWD=asdf"
omsg.open
set rst= Server.CreateObject("ADODB.Recordset"
set rst=omsg.Execute(" Select * from CHGNOTE;"
do until rst.EOF
Response.Write "<note_dt>" & (replace(rst("NOTE_DT", "&", "&") & "</note_dt>"
Response.Write "<note_user>" & (replace(rst("NOTE_USER", "&", "&") & "</note_user>"
Response.Write "<note_body>" & (replace(rst("NOTES", "&", "&") & "</note_body>"
rst.MoveNext
loop
rst.Close
set rst=nothing
%>
</notes>
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
End tag 'note_body' does not match the start tag 'PF8'. Error processing resource ' Line 107, Position 46
USE <PF7> AND <PF8> TO NAVIGATE REPORT LIST</note_body><note_dt>8/28/99 11:30:11 AM</note_dt><note_user>DREYNOLDS</note_user><note_body>FMID(s) SWJR371, SWJR381, SWJR382, SWJR410 are not being addressed by this Change because:
---------------------------------------------^
above is the error message that i get when i run my asp page. the <PF7> and others are data in the database.
below is my code. the Xml processor interpretes that as a tag.
<% @language="vbscript" %>
<% Response.ContentType="text/xml" %>
<?xml version="1.0"?>
<!-- xml file generated by asp -->
<notes xml:space="preserve">
dim omsg, rst
set omsg= Server.CreateObject("ADODB.Connection"
omsg.ConnectionString="Provider=MSDASQL;DSN=SwisODBC;UID=SYSDBA;PWD=asdf"
omsg.open
set rst= Server.CreateObject("ADODB.Recordset"
set rst=omsg.Execute(" Select * from CHGNOTE;"
do until rst.EOF
Response.Write "<note_dt>" & (replace(rst("NOTE_DT"
, "&", "&") & "</note_dt>"Response.Write "<note_user>" & (replace(rst("NOTE_USER"
, "&", "&") & "</note_user>"Response.Write "<note_body>" & (replace(rst("NOTES"
, "&", "&") & "</note_body>"rst.MoveNext
loop
rst.Close
set rst=nothing
%>
</notes>
You need to replace the & with &.
James James Culshaw
james@miniaturereview.co.uk
James
James Culshawjames@miniaturereview.co.uk
Response.Write "<note_dt>" & (replace(rst("NOTE_DT", "&", "&") & "</note_dt>"
Response.Write "<note_user>" & (replace(rst("NOTE_USER", "&", "&") & "</note_user>"
Response.Write "<note_body>" & (replace(rst("NOTES", "&", "&") & "</note_body>"
The problem you're seeing is because you're doing string concatenation to build your XML, and the special characters (Entity Reference, in XML-speak) aren't being escaped. The absolutely correct way to do this is instantiate a DOM document object, and add your nodes to it programmatically. Assigning a value to a NodeElement's Text property does the escaping for you.
If you really want to continue doing it the way you are, you can write a function to replace the ampersand, left angle-bracket, right angle-bracket, and the single & double quote marks with their escaped equivalents (& amp; & lt; & gt; & apos; & quot (get rid of the excess spaces), but it's a band-aid solution.
Chip H.
, "&", "&") & "</note_dt>"Response.Write "<note_user>" & (replace(rst("NOTE_USER"
, "&", "&") & "</note_user>"Response.Write "<note_body>" & (replace(rst("NOTES"
, "&", "&") & "</note_body>"The problem you're seeing is because you're doing string concatenation to build your XML, and the special characters (Entity Reference, in XML-speak) aren't being escaped. The absolutely correct way to do this is instantiate a DOM document object, and add your nodes to it programmatically. Assigning a value to a NodeElement's Text property does the escaping for you.
If you really want to continue doing it the way you are, you can write a function to replace the ampersand, left angle-bracket, right angle-bracket, and the single & double quote marks with their escaped equivalents (& amp; & lt; & gt; & apos; & quot
(get rid of the excess spaces), but it's a band-aid solution.Chip H.
- Status
Similar threads
- Locked
- Question