I don't know why it worked like this before, but I remarked that the error is : while(mytester != null) { <-wrong while(!mytester.equals("")) { <-right Because when SQL returns a NULL value in XSP this value is not NULL, but "" !
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] .org] Sent: Wednesday, June 25, 2003 2:25 PM To: [EMAIL PROTECTED] Subject: Esql error?! what is wrong with my page? It worked before, and since I change the version of cocoon (from 2.0 to 2.1) it doesn't work anymore (the page make a timeout) : ... } else { </xsp:logic> <form action="add-param-configdb_add" method="post"> <table> <th>select</th> <th>column name</th> <xsp:logic> while(mytester != null) { </xsp:logic> <tr> <esql:execute-query> <esql:query> SELECT COL_NAME(OBJECT_ID('<xsp:expr>myDB</xsp:expr>'), <xsp:expr>mycolid</xsp:expr>) as ColName </esql:query> <esql:results> <esql:row-results> <xsp:logic> mytester = <esql:get-string column="ColName"/>; if (mytester != null) { <td><input type="radio" name="radiobut"><xsp:attribute name="value"><esql:get-string column="ColName"/></xsp:attribute></input></td> <td><esql:get-string column="ColName"/></td> } </xsp:logic> </esql:row-results> </esql:results> </esql:execute-query> </tr> <xsp:logic> mycolid = mycolid + 1; } </xsp:logic> </table> ... --------------------------------------------------------------------- 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]