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]

Reply via email to