+ -
当前位置:首页 → 问答吧 → 帮我看一下哪里错误。

帮我看一下哪里错误。

时间:2011-02-20

来源:互联网

GotoPage = Request("GotoPage")
  if GotoPage = "" then GotoPage = 1

  if keyword <> "" then
         Query = " and " & search_what & " like '%" & keyword & "%' "
  else
     Query = " "
  end If
  SQL = "select count(board_idx) as recCount from q_Board"
  Set Rs = conn.Execute(SQL)

  recordCount = Rs(0)
  
  pagesize = 20
  pagecount = int((recordCount-1)/pagesize) +1

  SQL = "SELECT TOP " & pagesize & " * FROM q_Board "
  SQL = SQL & " WHERE board_idx not in "
  SQL = SQL & "(SELECT TOP " & ((GotoPage - 1) * pagesize) & " board_idx FROM q_Board"
  SQL = SQL & " " & Query & " "
  SQL = SQL & " ORDER BY board_idx DESC) order by board_idx desc"

  Set Rs = conn.Execute(SQL)

作者: nanqz   发布时间: 2011-02-20

我自己顶一下。提示最下面一行 and附近错了

作者: nanqz   发布时间: 2011-02-20

相关阅读 更多

热门下载

更多