OK the full story: The xml file that is the generator is as follows:
<doregister/> This is then passed through an XSL file : <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";> <!-- Make the request parameter available --> <xsl:param name="username"/> <xsl:param name="password"/> <xsl:param name="first"/> <xsl:param name="last"/> <xsl:template match="doregister"> <user> <detail> <name><xsl:value-of select="$username"/></name> <password><xsl:value-of select="$password"/></password> <first><xsl:value-of select="$first"/></first> <last><xsl:value-of select="$last"/></last> </detail> <existing-user> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query> SELECT * from user_info where USERNAME = '<xsl:value-of select="$username"/>' </query> </execute-query> </existing-user> </user> </xsl:template> </xsl:stylesheet> After this it is then passed to the XSL that fails <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <xsl:template match="user"> <page> <xsl:choose> <xsl:when test="existing-user/sql:rowset/sql:row"> <title>Registration Error: Autorevs - UK Car Reviews</title> <heading>Registration Error</heading> <navigation> <item> <link>home</link> <display>Home</display> </item> <item> <link>login</link> <display>Login</display> </item> <item> <link>register</link> <display>Register</display> </item> <item> <link>about</link> <display>About</display> </item> </navigation> <main> <item> <title>Username Already Taken!</title> <body>The Username you selected is already in use by another member. Please select a different one.</body> </item> </main> </xsl:when> <xsl:otherwise> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query> insert into user_info (USER_ID, USERNAME) values ('', 'test') </query> </execute-query> <title>Registration Success: Autorevs - UK Car Reviews</title> <heading>Registration Success</heading> <navigation> <item> <link>home</link> <display>Home</display> </item> <item> <link>login</link> <display>Login</display> </item> <item> <link>register</link> <display>Register</display> </item> <item> <link>about</link> <display>About</display> </item> </navigation> <main> <item> <title>Registration Successful!</title> <body>Congratulations <xsl:value-of select="detail/first"/> . Your details have now been stored by the autorevs system. Please login!</body> </item> </main> </xsl:otherwise> </xsl:choose> </page> </xsl:template> </xsl:stylesheet> -----Original Message----- From: Luca Morandini [mailto:spectrum.morandini@;ipzs.it] Sent: 28 October 2002 14:45 To: [EMAIL PROTECTED] Subject: R: Cocoon SQL Transformation Tom, could you post the XML document that fails ? Best regards, Luca Morandini [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Tom Place [mailto:psyttrp@;nottingham.ac.uk] > Inviato: luned́ 28 ottobre 2002 15.38 > A: [EMAIL PROTECTED] > Oggetto: RE: Cocoon SQL Transformation > > > I have tried it like you say however am still getting an internal server > error: > > org.apache.cocoon.ProcessingException: Exception during processing of > file:/C:/tomcat/webapps/cocoon/autorevs/docs/doregister.xml: > java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.NullPointerException > > The page will run with the sql commented out so that’s not the problem > and the sql actually does insert into the db, but then you get the > above! > > Tom > > -----Original Message----- > From: Luca Morandini [mailto:spectrum.morandini@;ipzs.it] > Sent: 28 October 2002 14:06 > To: [EMAIL PROTECTED] > Subject: R: Cocoon SQL Transformation > > Tom, > > every "query" element should live within a separate "execute-query" one, > like in: > > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> > <query> > insert into my_table (Col1, Col2) values ('1', '2') > </query> > </execute-query> > > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> > <query> > insert into my_table (Col1, Col2) values ('2', '3') > </query> > </execute-query> > > I suppose you've already try this... then, what's the error you get ? > > Best regards, > > Luca Morandini > [EMAIL PROTECTED] > > > > -----Messaggio originale----- > > Da: Tom Place [mailto:psyttrp@;nottingham.ac.uk] > > Inviato: luned́ 28 ottobre 2002 14.27 > > A: [EMAIL PROTECTED] > > Oggetto: Cocoon SQL Transformation > > > > > > Hi all, > > > > Quick question to do with the way the cocoon SQL parser copes with > > multiple SQL statements. > > There is probably a very quick fix for this but I'm tearing my hair > out > > trying to find it! > > > > When inserting using and SQL statement based in XSL like so: > > > > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> > > <query> > > insert into my_table (Col1, Col2) values ('1', '2') > > </query> > > </execute-query>> > > This is fine, but when you want to add a second it wont do it! > > I have tried with a second set of <execute-query> tags, I have tried > > putting a second set of <query> tags within an <execute-query> > > > > Any Ideas? > > > > Cheers > > Tom > > > > > > --------------------------------------------------------------------- > > Please check that your question has not already been answered in the > > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > We are protected from the virus by Norton Antivirus Corporate > Edition > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > We are protected from the virus by Norton Antivirus Corporate Edition --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
