sqlsever

<table border="0" cellpadding="0" cellspacing="0" align="center" width="96%">  
      <tr height="30">  
        <td> 主 题</td>  
        <td><input name="SUBJECT" size="98"></td>  
      </tr>  
<chtml><esql module=base id=count>Select max(WE_SORT) as max1 from SITE_NEWS where CLASSIFY=@{pPage:only}</esql></chtml>  
      <tr height="30">  
        <td> 顺 序</td>  
        <td><input name="we_sort" size="8" value="@{int:@{count:max1}+1}"></td>  
      </tr>  
      <tr>  
        <td> </td>  
        <td></td>  
      </tr><input type="hidden" value="@{pPage:only}" name="only"><input type="hidden" value="@{pPage:n}" name="n">  
    </table>