Ah, I see. If you're using XSP and assigning the strings to variables, the escaping is taken care of automatically for you:
I didn't know that. That would work if I had only a single insert statemment, but unfortunately, I'm looping over a collection of nodes in an xml document and generating an insert for each node of the collection. With this approach, it seems I'd have to write the java to extract the collection and then loop, generating an esql insert statement for each. It feels ad hoc even if I could make it work quickly.
For right now, rather than generating SQL where special characters have to be escaped, I've decided to use cocoon to generate a text file where the characters do not need to be escaped and then use SQLLDR to load the data.
I believe my previous problem was my failure to recognize an XSP page can only be a generator. In order to do what I want, I actually need to write a transformer, which I'll learn to do later when I have a little more time.
I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org)
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
