On Mon, 24 Feb 2003, I-Lin Kuo wrote: > 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.
Ah, ouch. One thought does occur to me: would it be worth storing the XML in an XML db like XIndice instead? It would save the XML->Text conversion step, and you'd be able to use XPath to pull text back out. > 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. Good luck! 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]