File:cn/products.html
Method:query.dataPager(columns,where,order,size,page,*countVar)
资源池 'internal' 没有足够的系统内存来运行此查询。
select * from (select top 9 * from (select top 17298 * from jxpgoods where Status>0 and CatalogPath like '%.5.%' order by Goodshao asc) as tab1 order by goodshao desc) as tab2 order by Goodshao asc
数据库执行错误
cn/xmls/product.xmls
...
<td>{*Goodshao}</td>
</tr>
<tr>
<td><p>CAS No：</p></td>
<td>{*CAS}</td>
</tr>
</table>
<div class="pidous">
{@ahref}
</div>
</li>
#];
@querygoods=$query(goods,goods);
@CatalogId=$http.get(CId,$null);
@PId=$http.get(PId,$null);
@querygoods[CatalogId]=@CatalogId;
@keywords=$http.get(sv);
@sqwher=$empty;
@CatalogPath=[".{@PId}."];
@querygoods[CatalogPath]=@CatalogPath;
@sqwher=['Status>0 {?} and CatalogPath like {#like(%CatalogPath%)}'];
@sqheres=@querygoods.sql(@sqwher);
@goodslist=@querygoods.dataPager(*,@sqheres,['Goodshao asc'],9,$http.get(page,1));
@Pager=$control.execute(pager,[#
{?option}<a href="{*link}" class="cf">{*text}</a>
{?selected}<a href="{*link}" class="oncalass">{*text}</a>
{?pager}
<a href="{*home}" class="dala">首页</a>
<a href="{*prev}" class="dala">上一页</a>
{*list}
<a href="{*next}" class="bort">下一页</a>
<a href="{*last}" class="bort">尾页</...