Hi Peter, I applied your patch to the HEAD of the CVS (2.1-dev). Could you please cross-check.
Thanks for your patch, Carsten > -----Original Message----- > From: Peter Seiderer [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 26, 2001 9:21 PM > To: [EMAIL PROTECTED] > Subject: PATCH: add advanced error handling in SQLTransformer plus > escape-string element > > > Hello, > the patch attached above brings the following two changes to the > SQLTransformer: > > 1. SQLExceptions coming from query.execute() are catched and the following > output is added to the resulting xml documenters set > <sql:rowset> > <sql:error>The error messge from the SQLException.<sql:error> > </sql:rowset> > > 2. The element <sql:escape-string> is added. The purpose of this is, that > you can write the following statement: > <sql:execute-query> > <sql:query isupdate="true"> > update test_table set test1 = '<sql:escape-string>A string > with tick ' and backslash \ in it.</sql:escape-string>' > </sql:query> > </sql:execute-query> > > The tick ' will be escaped with a double tick '' and the backslash will > be escaped with a double backlslash \\ befor adding to the query string. > > With this it is although possible to create sql queries from stylesheets > using form paramters like in the following example: > > <sql:execute-query> > <sql:query isupdate="true"> > update test_table set > test = '<sql:escape-string><xsl:value-of > select="$input_test1"/></sql:escape-string>' > </sql:query> > </sql:execute-query> > > Cheers, > Peter Seiderer > > I am not subscribed to the mailing list. Please reply via > CC to [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
