搜索优化网站程序 SXWO EC VER3.0,在createproduct.asp文件有BUG。 在后台管理调整产品排序以后,索引页显示正常, 但产品细节页翻页功能出错, 产品细节页实际排序没有根据后台管理调整, 到达后台管理调整前的最后一个产品时, 不再往后翻页, 并出现错误循环。
75行修正后源代码如下:
rs.open "select top 1 * from products where btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid<"&orderid&" or id>"&sid&" and orderid="&orderid&") order by orderid desc,id",conn,1,1
75行修正前源代码如下:
rs.open "select * from products where isvip=0 and btypeid="&btypeid&" and stypeid="&stypeid&" and id<>"&sid&" and (orderid<"&orderid&" or id>"&sid&") order by orderid desc,id",conn,1,1
91行修正后源代码如下:
rs.open "select top 1 * from products where btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid>"&orderid&" or id<"&sid&" and orderid="&orderid&") order by orderid,id desc",conn,1,1
91行修正前源代码如下:
rs.open "select * from products where isvip=false and id<>"&sid&" and btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid>"&orderid&" or id<"&sid&") order by orderid,id desc",conn,1,1
205行修正后源代码如下:
rs.open "select top 1 * from products where btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid<"&orderid&" or id>"&sid&" and orderid="&orderid&") order by orderid desc,id",conn,1,1
205行修正前源代码如下:
rs.open "select * from products where btypeid="&btypeid&" and stypeid="&stypeid&" and id<>"&sid&" and (orderid<"&orderid&" or id>"&sid&") order by orderid desc,id",conn,1,1
221行修正后源代码如下:
rs.open "select top 1 * from products where btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid>"&orderid&" or id<"&sid&" and orderid="&orderid&") order by orderid,id desc",conn,1,1
221行修正前源代码如下:
rs.open "select * from products where id<>"&sid&" and btypeid="&btypeid&" and stypeid="&stypeid&" and (orderid>"&orderid&" or id<"&sid&") order by orderid,id desc",conn,1,1
“中国推广”电子商务型网站使用手册
http://www.chinapromoter.cn/cat-4/chinapromoter-ec-ver-2-manual-guide.html
符合搜索优化的网站建设程序方案
http://www.chinapromoter.cn/cat-4/html-programme-site-plan.html