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]