<%
If action="search" Then
'*********************************************************************************************************************************
'搜索
'*********************************************************************************************************************************
Select Case(hav)
Case "back"
CursorBegin=CursorEnd
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 and ("&stypes&" like '%"&key&"%' "&www&") and addtime>'"&CursorBegin&_
"' And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 and ("&stypes&" like '%"&key&"%' "&www&") and addtime>'"&CursorBegin&"') Order by addtime desc"
Case "next"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 and ("&stypes&" like '%"&key&"%' "&www&") and addtime<'"&CursorBegin&_
"' Order by addtime desc"
Case "last"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table where tg=1 and ("&stypes&" like '%"&key&"%' "&www&") And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 and ("&stypes&" like '%"&key&"%' "&www&") Order by addtime) Order by addtime desc"
End Select
'sql1="第一个SQL语句"&SQLstr
elseif action="S" Then
'*********************************************************************************************************************************
'模糊搜索
'*********************************************************************************************************************************
Select Case(hav)
Case "back"
CursorBegin=CursorEnd
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 and (area like '%"&key&"%' or pdname like '%"&key&"%' or cname like '%"&key&"%' or pdgx like '%"&key&"%') and addtime>'"&CursorBegin&_
"' And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 and (area like '%"&key&"%' or pdname like '%"&key&"%' or cname like '%"&key&"%' or pdgx like '%"&key&"%') and addtime>'"&CursorBegin&"') Order by addtime desc"
Case "next"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 and (area like '%"&key&"%' or pdname like '%"&key&"%' or cname like '%"&key&"%' or pdgx like '%"&key&"%') and addtime<'"&CursorBegin&_
"' Order by addtime desc"
Case "last"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table where tg=1 and (area like '%"&key&"%' or pdname like '%"&key&"%' or cname like '%"&key&"%' or pdgx like '%"&key&"%') And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 and (area like '%"&key&"%' or pdname like '%"&key&"%' or cname like '%"&key&"%' or pdgx like '%"&key&"%') Order by addtime) Order by addtime desc"
End Select
'sql2="第二个SQL语句"&SQLstr
Else
'*********************************************************************************************************************************
'列表
'*********************************************************************************************************************************
Select Case(hav)
Case "back"
CursorBegin=CursorEnd
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 "&abc&" and kind like '%"&kind&"%' and addtime>'"&CursorBegin&_
"' And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 "&abc&" and kind like '%"&kind&"%' and addtime>'"&CursorBegin&"') Order by addtime desc"
Case "next"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table Where tg=1 "&abc&" and kind like '%"&kind&"%' and addtime<'"&CursorBegin&_
"' Order by addtime desc"
Case "last"
SQLstr="Select Top "&DefRecordNum&" addtime,id,pdname,cname,seltypes,kind,lsprice,zsprice,pic,uid,province,city From xxx_table where tg=1 "&abc&" and kind like '%"&kind&"%' And addtime In (Select Top "&DefRecordNum&" addtime From xxx_table Where tg=1 "&abc&" and kind like '%"&kind&"%' Order by addtime) Order by addtime desc"
End Select
'sql3="第三个SQL语句"&SQLstr
End If
%>