Hi,
On Sun, 23 Feb 2003, I-Lin Kuo wrote:
> I'm trying to replace something like
>
> <SQLStatement>
> INSERT INTO MyTable(text)
> VALUES ('& What's the matter?')
> </SQLStatement>
>
> with
>
> <SQLStatement>
> INSERT INTO MyTable(text)
> VALUES ('\& What''s the matter\?')
> </SQLStatement>
You probably don't really want to do this ... the database should hold the
"proper" value of the text, not a value modified for display (or
whatever).
> I'd like to take the contents of the first <SQLStatement> and pipe it into
> an XSP page (while preserving whitespace) but can't figure out how to do
> that. Is this the right approach, or is there another way?
Not sure what you're trying to achieve here. Why do you need the \
escaping?
Andrew.
--
Andrew Savory Email: [EMAIL PROTECTED]
Managing Director Tel: +44 (0)870 741 6658
Luminas Internet Applications Fax: +44 (0)700 598 1135
This is not an official statement or order. Web: www.luminas.co.uk
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]