UC知道关于动力文章后台管理搜索的问题
来源：百度知道 编辑：UC知道 时间：2024/06/05 05:21:35
使用过动力文章的朋友应该都遇过这样的问题，如果是按Content或其它几项搜索，则第一面显示很正常，点下一页的时候就变成以Title搜索了，不知道是什么原因，请高手赐教
。搜索的源码简单点如下：
=============================================================================================================================================
if ManageType="MyArticle" then
sql=sql & " and A.Editor='" & AdminName & "' "
else
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and A.Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and A.Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and A.Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and A.Editor like '%" & keyword & "%' "
case else
sql=sql & " and A.Title like &#
。搜索的源码简单点如下：
=============================================================================================================================================
if ManageType="MyArticle" then
sql=sql & " and A.Editor='" & AdminName & "' "
else
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and A.Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and A.Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and A.Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and A.Editor like '%" & keyword & "%' "
case else
sql=sql & " and A.Title like &#
换页没有把搜索类型的参数也递送到下一页,所以strField为空,搜索类型自动转换为else里的title!
strField=Request.querystring("strField") 这句看情况而定,如果strField是用Request.Form来获取数据的话就把Request.Form改为Request
if ManageType="MyArticle" then
sql=sql & " and A.Editor='" & AdminName & "' "
else
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and A.Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and A.Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and A.Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and A.Editor like '%" & keyword & "%' "
case else
sql=sql & " and A.Title like '%" & keyword & "%' "
end select
end if
end if
========