i've tried the following replacement,
and this far it works ..
Name Code Number Code Glyph Description
�-
 unused
	 horizontal tab
line feed
 unused
  space
! ! exclamation mark
" " " double quotation mark
# # number sign
$ $ dollar sign
% % percent sign
& & & ampersand
' ' apostrophe
( ( left parenthesis
) ) right parenthesis
* * asterisk
+ + plus sign
, , comma
- - hyphen
. . period
so, you have to replace on the query
(or whenever you'd like)
like this :
replace(fieldName,'&','&') as fieldName
or if you already have the .xml files,
you can perform the process
right before sending it into parser.
hope it helps,
yudo.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:46 AM
Subject: Parsing failures with '&'
> We have a situation where a client has the ampersand character in product
> descriptions submitted to us in XML. For a fictious example, assume
> <description>M & M</description>. The crimson parser fails with "Illegal
> character or entity reference syntax".
>
> Is there anyway around this problem short of writing a replacement script
> before sending it to the parser?
>
> Thanks in advance.
>
> Scott
>
>
> ---------------------------------------------------------------------
> In case of troubles, e-mail: [EMAIL PROTECTED]
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
