In your XSP you're not allowed to use < > and other xml characters that serve special purposes (you're still in xml while writing java!) thus replace "i <" in for with "i <" or set a CDATA section around it so that xml will copy it literally.
Kind Regards, Jan ----- Original Message ----- From: "olivier demah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 20, 2004 10:11 AM Subject: XSP : for (...) > Hi, > > When i submit a form which contains a select multiple ; i need to store > the selected datas in a table > so i try to do > > <?xml version="1.0" encoding="iso-8859-1"?> > <xsp:page xmlns:xsp= "http://apache.org/xsp"; > xmlns:xsp-request= "http://apache.org/xsp/request/2.0"; > xmlns:esql="http://apache.org/cocoon/SQL/v2"; > xmlns:cinclude="http://apache.org/cocoon/include/1.0";> > <root> > <cinclude:include src="cocoon:/admin_index.xml" /> > <players> > <xsp:logic> > > String id_player = request.getParameter("id_player"); > String[] id_club = request.getParameter("id_club"); > int nbClub = id_club.length; > int i = 0; > > for (i = 0; i < nbClub ; i++) { > <esql:connection> > <esql:pool>my_pool</esql:pool> > <esql:execute-query> > <esql:query>INSERT INTO m_club_player (id_player,id_club) > VALUES ( > id_player = <esql:parameter > type="string"><xsp:expr>id_player</xsp:expr></esql:parameter>, > id_club = <esql:parameter > type="string"><xsp:expr>id_club[i]</xsp:expr></esql:parameter> ); > </esql:query> > <esql:error-results/> > <esql:update-results> > <esql:get-update-count/> > </esql:update-results> > </esql:execute-query> > </esql:connection> > } > > </xsp:logic> > </players> > </root> > </xsp:page> > > i know i dont test if id_club.length > 0 but anyway ; the previous code > just display : > org.apache.cocoon.ProcessingException: The content of elements must > consist of well-formed character data or markup.: > file:/home/fox_cocoon/build/webapp/vieira/admin/xsp/player.xsp:29:16:org.xml.sax.SAXParseException: > The content of elements must consist of well-formed character data or > markup. > and the line 29 is the "for (i=0"... > > could not we do a for loop to execute multiple queries ? > do i have to merge to flow ? :-( > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
