[align=left][align=left][align=center][align=right][align=justify][align=justify][align=justify][align=right][align=center][align=left][align=left][align=left][align=right]<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<title>title</title>
</head>
<body>
<form BOTID="0" METHOD="POST" ACTION="title.asp">
<table BORDER="0">
<tr>
<td>title</td>
<td>
<input NAME="title" VALUE="<%=Request("title")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"></p>
<p> </p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td>title</td>
<td>zamine</td>
<td>mahall</td>
<td>name</td>
<td>family</td>
<td>hamkaran</td>
<td>begindate</td>
<td>enddate</td>
</tr>
</thead>
<tbody>
<% if 0 then %>
<% end if %>
<%
Title=request("title")
fp_sQry="SELECT * FROM table5 WHERE (title LIKE '%"&Title&"%')"
fp_sDefault="title=111111111111111"
fp_sNoRecords="<tr><td colspan=8 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
if title<>"" then
Set dbSe = CreateObject("ADODB.Connection")
dbSe.open fp_sDataConn '*
' ريخته ايfp_sDataConn رو تو متيغر Dns چيه فرض كردم اسم Dns من نميدونستم اسم
Set rs=Server.CreateObject("ADODB.Recordset")
SqlT="Select * from table where title like '% "& title & "%' or zamine like '%" & title & "%' or mahall like '%" & name & "%'" & _
" or family like '%" & title & "%' or hamkaran like '%" & title & "%' or begindate like '%" & Title & "%' or enddate like '%" & title & "%'"
rs.CursorType=adOpenStatic
rs.PageSize=10 '10 تا 10 تا نشون بده
rs.Open Sqlstr,Conn
mpage=request(mpage)
rs.AbsolutePage=mpage
if rs.eof=true then
response.write "<h3>هيچ فردى پيدا نشد</h3>"
else
rsNo=0
do while rs.eof=false and rsNo<RS.PageSize
%>
<tr>
<td>
<%=rs(fp_rs,"title")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"zamine")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"mahall")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"name")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"family")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"hamkaran")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"begindate")%>&nbsp;</td>
<td>
<%=rs(fp_rs,"enddate")%>&nbsp;</td>
</tr>
<%
rs.movenext
rsNo=rsNo+1
loop
%>
</tbody>
</table>
<br><hr width=50%>
شماره صفحه مورد نظر خود را انتخاب كنيد<br>
<%
for i=1 to rs.PageCount
%>
<a href="title.asp?mpage=<%=i%>&title=<%=title%>"><%=i%></a>
<%
next
end if
rs.close
set rs=nothing
dbSe.close
set dbSe=nothing
%>
</body>
</html>