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]
