|
| |
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
 |
RE: ++ ASP search Results Page - 3/12/2006 18:26:47
I still don't know whats wrong with it... With the responce.write "end" in the result codes its still displays the same results as the image shows in post 6
|
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/13/2006 13:23:31
ok.. Just to let you know there is an error with the code itself, I'm sure of it....
<tr>
<td colspan=100 align=center>
<%=intRecordCount%> Data Available
<%If intRecordCount > 0 Then
' Display the record that you are starting on and the record
' that you are finishing on for this page by writing out the
' values in the intStart and the intFinish variables.
%>
<br>You are now viewing records
<%=intStart%> through <%=intFinish%>.
</td>
</tr>
<a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomAge&sorttype=<%=current_sort%>&NAV=<%=intPage %>">GroomAge <%=sSortSymbol%>
<%
if not sort_id="IdNumber" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=IdNumber&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Id Number <%=sSortSymbol%></a></th>
<%
if not sort_id="GroomLast" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomLast&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Groom Last <%=sSortSymbol%></a></th>
<%
if not sort_id="GroomFirst" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomFirst&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Groom First <%=sSortSymbol%></a></th>
<%
if not sort_id="GroomAge" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomAge&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Groom Age <%=sSortSymbol%></a></th>
<%
if not sort_id="GroomStreetAddress" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomStreetAddress&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Groom Street Address <%=sSortSymbol%></a></th>
<%
if not sort_id="GroomCity" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=GroomCity&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Groom City <%=sSortSymbol%></a></th>
<%
if not sort_id="BrideLast" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=BrideLast&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Bride Last <%=sSortSymbol%></a></th>
<%
if not sort_id="BrideFirst" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=BrideFirst&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Bride First <%=sSortSymbol%></a></th>
<%
if not sort_id="BrideAge" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=BrideAge&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Bride Age <%=sSortSymbol%></a></th>
<%
if not sort_id="BrideStreetAddress" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=BrideStreetAddress&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Bride Street Address <%=sSortSymbol%></a></th>
<%
if not sort_id="BrideCity" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sortid=BrideCity&sorttype=<%=current_sort%>&NAV=<%=intPage %>">Bride City <%=sSortSymbol%></a></th>
<th>Details</th>
<tr>
<%
dim i
dim iGroupId
%>
</tr>
<%
' Iterate through the recordset until we reach the end of the page
' or the last record in the recordset.
'need to write the following info for deleting the stuff
For intRecord = 1 to objRst.PageSize%>
<tr>
<td><%=objRst("IdNumber").Value%></td>
<td><%=objRst("GroomLast").Value%></td>
<td><%=objRst("GroomFirst").Value%></td>
<td><%=objRst("GroomAge").Value%></td>
<td><%=objRst("GroomStreetAddress").Value%></td>
<td><%=objRst("GroomCity").Value%></td>
<td><%=objRst("BrideLast").Value%></td>
<td><%=objRst("BrideFirst").Value%></td>
<td><%=objRst("BrideAge").Value%></td>
<td><%=objRst("BrideStreetAddress").Value%></td>
<td><%=objRst("BrideCity").Value%></td>
<TD><a href="ml_results_detail.asp?IdNumber=<%=objRst("IdNumber")%>&mVarTable=[tblMarriageLicenses]"> Detail </a></TD>
</tr>
<%objRst.MoveNext
If objRst.EOF Then Exit for
Next
%>
<%End IF%> <%
' Check to see if the current page is less than the last page
' in the recordset. If it is, then add a "Next" link.
%>
<tr align=center>
<td align=center colspan=30>
<%
if CInt(intPage)>1 then
%>
<a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sorttype=<%=sort_type%>&NAV=<%=intPage - 1%>&sortid=<%=sort_id%>">
<b><< Prev</b></a>
<%
end if
dim iCounter
for iCounter=1 to cint(intPageCount)
if not cInt(intPage)= iCounter then %>
<a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sorttype=<%=sort_type%>&NAV=<%=iCounter%>&sortid=<%=sort_id%>">
<b> <%=iCounter%> </b></a>
<% else%>
<b> <%=iCounter%> </b>
<% end if
next
If cInt(intPage) < cInt(intPageCount) Then %>
<a href="<%=Request.ServerVariables("PATH_INFO")%>?IdNumber=<%=IdNumber%>&GroomLast=<%=GroomLast%>&GroomFirst=<%=GroomFirst%>&GroomAge=<%=GroomAge%>&GroomStreetAddress=<%=GroomStreetAddress%>&GroomCity=<%=GroomCity%>&BrideLast=<%=BrideLast%>&BrideFirst=<%=BrideFirst%>&BrideAge=<%=BrideAge%>&BrideStreetAddress=<%=BrideStreetAddress%>&BrideCity=<%=BrideCity%>&sorttype=<%=sort_type%>&NAV=<%=intPage + 1%>&sortid=<%=sort_id%>">
<b>Next >></b></a>
<%End If%>
and if you copy the ml_results.asp file to front page its between lines 180 - 362
< Message edited by Spooky -- 3/13/2006 14:02:44 >
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/14/2006 12:17:24
Spooky assisted me in finishing the file.. the problem was #1 I wasn't calling it useing http I was calling it with windows EXPLORE (which doesn't run asp) To solve the problem move the files into a folder in the localhost on your own computer if its running the IIS and call them from there... use frontpage to view results.. everything works out great...
Thanks again Spooky...
Wes
PS I problem will need more help later on but I want you to know I appreciate your help.
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/15/2006 13:01:04
spooky as you said.. I will need your help again.... everytime I try to make a change to the ASP... it will no longer load.
when you get this please respond... thanks...
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/15/2006 14:25:22
I need the di.asp and the di_results_details.asp split into 2 collums and some fields in the same asp files set as check boxes and Thumbnails setup for the Sketch Image and Map Fields.
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/15/2006 14:43:06
And when it stoped working I tried to devide the table up to have 4 coloms v/s the 2
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/15/2006 19:21:04
yeah still haveing problems getting colom 3 and 4 to act with the search button for the deed information... so I know I'm bothersome... I'm a newb with asp.
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 13:33:08
I was wondering if anyone knew how to have the asp search a currency for example .. Sales [ ] to [ ] where [ ] = text box
and to get the $ signs on the search results. Change the display to currency..
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 13:59:09
I think these codes are what needs to be changed
<td align="left" width="22%"><b>Sale Price</b></td>
<td width="25%"><input type="text" name="SalePrice"> </td>
<td align="left" width="22%"><b>Unfinished Basement</b></td>
<td width="25%"><input type="text" name="UnfinishedBasement0"> </td>
</tr>
for the di.asp
<%'-------Getting SalePrice
dim SalePrice
SalePrice=Request("SalePrice")%>
<%if trim(SalePrice) <>"" then
sWhereCondition=sWhereCondition & " AND [SalePrice] like '%" & SalePrice & "%'"
end if%>
or
%>
<th nowrap><a href="<%=Request.ServerVariables("PATH_INFO")%>?AccountNumber=<%=AccountNumber%>&InsturmentNumber=<%=InsturmentNumber%>&DeedBookNumber=<%=DeedBookNumber%>&PageNumber=<%=PageNumber%>&PlatBookNumber=<%=PlatBookNumber%>&Page=<%=Page%>&Year=<%=Year%>&Month=<%=Month%>&Day=<%=Day%>&DeedType=<%=DeedType%>&Amount=<%=Amount%>&SalePrice=<%=SalePrice%>&WholeMapNumber=<%=WholeMapNumber%>&MapNumber=<%=MapNumber%>&Insert=<%=Insert%>&DblCircle=<%=DblCircle%>&Block=<%=Block%>&Section=<%=Section%>&Lot=<%=Lot%>&Lender=<%=Lender%>&GrantorLast=<%=GrantorLast%>&GrantorFirst=<%=GrantorFirst%>&GranteeLast=<%=GranteeLast%>&GranteeFirst=<%=GranteeFirst%>&PropertyType=<%=PropertyType%>&GLA=<%=GLA%>&HouseNumber=<%=HouseNumber%>&StreetName=<%=StreetName%>&TownCity=<%=TownCity%>&District=<%=District%>&LegalDescription=<%=LegalDescription%>&Subdivision=<%=Subdivision%>&YearBuilt=<%=YearBuilt%>&StructureValue=<%=StructureValue%>&ImprovedValue=<%=ImprovedValue%>&LandValue=<%=LandValue%>&TotalAssessedValue=<%=TotalAssessedValue%>&Site=<%=Site%>&TypeOfConstructions=<%=TypeOfConstructions%>&Room=<%=Room%>&Bedrooms=<%=Bedrooms%>&FullBathrooms=<%=FullBathrooms%>&HalfBathrooms=<%=HalfBathrooms%>&FinishedBasement=<%=FinishedBasement%>&UnfinishedBasement=<%=UnfinishedBasement%>&Garage=<%=Garage%>&Utilities=<%=Utilities%>&Heating=<%=Heating%>&Cooling=<%=Cooling%>&Porch=<%=Porch%>&Patio=<%=Patio%>&Deck=<%=Deck%>&Fence=<%=Fence%>&Fireplace=<%=Fireplace%>&Stove=<%=Stove%>&Refridgerator=<%=Refridgerator%>&Dishwasher=<%=Dishwasher%>&Washer=<%=Washer%>&Dryer=<%=Dryer%>&Pool=<%=Pool%>&Spa=<%=Spa%>&Peviously Appraised=<%=Peviously_Appraised%>&Sketch=<%=Sketch%>&Image=<%=Image%>&Map=<%=Map%>&sortid=InsturmentNumber&sorttype=<%=current_sort%>&NAV=<%=intPage %>">
Instrument Number <%=sSortSymbol%></a></th>
<%
if not sort_id="SalePrice" then
sSortSymbol=""
current_sort= "ASC"
else
sSortSymbol= sTempSymbol
current_sort= new_sort_type
End If
%>
for the di_results.asp
<tr>
<td align="left" width="25%"><b>Sale Price </b></td>
<td width="25%"><%=objRst("SalePrice")%></td>
<td align="left" width="25%"><b>Full Bathrooms</b></td>
<td width="25%"><%=objRst("FullBathrooms")%></td>
</tr>
for the di_results_detial.asp
< Message edited by Spooky -- 3/17/2006 14:33:09 >
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 14:19:00
ok where do I do that at =P
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 14:19:38
and does that cover searching from one number to another number?
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 14:54:42
Ok I got it to display the $ signs and all that... but I would still like to be able to search between 2 numbers
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/17/2006 15:49:53
I went and changed the code for the di.asp
<td align="left" width="22%"><b>Sale Price</b></td>
<td width="25%"><input type="text" name="SalePrice" size="9"> to
<input type="text" name="SalePrice0" size="9"></td>
and then changed the di_results.asp
<%'-------Getting SalePrice
dim SalePrice
SalePrice=Request("SalePrice")
SalePrice0= Request("SalePrice0")
%>
<%if trim(SalePrice) <>"" AND trim(SalePrice0) <>"" then
sWhereCondition=sWhereCondition & " AND [SalePrice] BETWEEN "& SalePrice & " AND "& SalePrice0
end if%>
But when I click the next link which displays the next 10 results it displays all records.
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/20/2006 13:58:40
Here is the di.asp code
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Company" content="The Designed Group">
<title>Deed Information</title>
<style>
<!--
td { font-family: Tahoma; font-size: 8pt; background-color: #E6F2FF;
border-style: solid; border-width: 1 }
th { font-family: Tahoma; font-size: 8pt; font-weight: bold; background-color:
#E6E6E6; border: 1 outset #FF9900 }
input { font-family: Tahoma; font-size: 8pt; border: 1 inset #E6E6E6 }
table { }
-->
</style>
</head>
<body>
<table border="0" cellpadding="2" width="100%" id="table1">
<tr>
<td width="100%"><br>
<b><font size="4"> </font></b>
<font size="4"><b>Deed Information</b></font><br>
</td>
</tr>
</table>
<table border="0" cellpadding="2" width="100%">
<tr>
<td width="10%"></td>
<td width="78%">
<form method="GET" action="di_results.asp">
<table border="0" width="100%">
<tr><th colspan=4>Search data using the following criteria</th></tr>
<tr>
<td align="left" width="22%"><b>Account Number</b></td>
<td width="25%"><input type="text" name="AccountNumber"> </td>
<td align="left" width="22%"><b>Structure Value</b></td>
<td width="25%"><input type="text" name="StructureValue0" size="9"> to
<input type="text" name="StructureValue1" size="9"></td>
</tr>
<tr>
<td align="left" width="22%"><b>Instrument Number</b></td>
<td width="25%"><input type="text" name="InsturmentNumber"> </td>
<td align="left" width="22%"><b>Improved Value</b></td>
<td width="25%"><input type="text" name="ImprovedValue0" size="9"> to
<input type="text" name="ImprovedValue1" size="9"></td>
</tr>
<tr>
<td align="left" width="22%"><b>Deed Book Number</b></td>
<td width="25%"><input type="text" name="DeedBookNumber"> </td>
<td align="left" width="22%"><b>Land Value</b></td>
<td width="25%"><input type="text" name="LandValue0" size="9"> to
<input type="text" name="LandValue1" size="9"></td>
</tr>
<tr>
<td align="left" width="22%"><b>Page Number</b></td>
<td width="25%"><input type="text" name="PageNumber"> </td>
<td align="left" width="22%"><b>Total Assessed Value</b></td>
<td width="25%"><input type="text" name="TotalAssessedValue0" size="9"> to
<input type="text" name="TotalAssessedValue1" size="9"></td>
</tr>
<tr>
<td align="left" width="22%"><b>Plat Book Number</b></td>
<td width="25%"><input type="text" name="PlatBookNumber"> </td>
<td align="left" width="22%"><b>Site</b></td>
<td width="25%"><input type="text" name="Site"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Page</b></td>
<td width="25%"><input type="text" name="Page"> </td>
<td align="left" width="22%"><b>Type Of Constructions</b></td>
<td width="25%"><input type="text" name="TypeOfConstructions"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Year</b></td>
<td width="25%"><input type="text" name="Year"> </td>
<td align="left" width="22%"><b>Room</b></td>
<td width="25%"><input type="text" name="Room"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Month</b></td>
<td width="25%"><input type="text" name="Month"> </td>
<td align="left" width="22%"><b>Bedrooms</b></td>
<td width="25%"><input type="text" name="Bedrooms"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Day</b></td>
<td width="25%"><input type="text" name="Day"> </td>
<td align="left" width="22%"><b>Full Bathrooms</b></td>
<td width="25%"><input type="text" name="FullBathrooms"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Deed Type</b></td>
<td width="25%"><input type="text" name="DeedType"> </td>
<td align="left" width="22%"><b>Half Bathrooms</b></td>
<td width="25%"><input type="text" name="HalfBathrooms"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Amount</b></td>
<td width="25%"><input type="text" name="Amount"> </td>
<td align="left" width="22%"><b>Finished Basement</b></td>
<td width="25%"><input type="text" name="FinishedBasement"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Sale Price</b></td>
<td width="25%"><input type="text" name="SalePrice" size="9"> to
<input type="text" name="SalePrice0" size="9"></td>
<td align="left" width="22%"><b>Unfinished Basement</b></td>
<td width="25%"><input type="text" name="UnfinishedBasement"> </td>
</tr>
<tr>
<td align="left" width="22%" height="23"><b>Whole Map Number</b></td>
<td width="25%" height="23"><input type="text" name="WholeMapNumber"> </td>
<td align="left" width="22%" height="23"><b>Garage</b></td>
<td width="25%" height="23"><input type="text" name="Garage"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Map Number</b></td>
<td width="25%"><input type="text" name="MapNumber"> </td>
<td align="left" width="22%"><b>Utilities</b></td>
<td width="25%"><input type="text" name="Utilities"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Insert</b></td>
<td width="25%"><input type="text" name="Insert"> </td>
<td align="left" width="22%"><b>Heating</b></td>
<td width="25%"><input type="text" name="Heating"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Dbl Circle</b></td>
<td width="25%"><input type="text" name="DblCircle"> </td>
<td align="left" width="22%"><b>Cooling</b></td>
<td width="25%"><input type="text" name="Cooling"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Block</b></td>
<td width="25%"><input type="text" name="Block"> </td>
<td align="left" width="22%"><b>Porch</b></td>
<td width="25%"><input type="checkbox" name="Porch" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Section</b></td>
<td width="25%"><input type="text" name="Section"> </td>
<td align="left" width="22%"><b>Patio</b></td>
<td width="25%"><input type="checkbox" name="Patio" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Lot</b></td>
<td width="25%"><input type="text" name="Lot"> </td>
<td align="left" width="22%"><b>Deck</b></td>
<td width="25%"><input type="checkbox" name="Lot" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Lender</b></td>
<td width="25%"><input type="text" name="Lender"> </td>
<td align="left" width="22%"><b>Fence</b></td>
<td width="25%"><input type="checkbox" name="Fence" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Grantor Last</b></td>
<td width="25%"><input type="text" name="GrantorLast"> </td>
<td align="left" width="22%"><b>Fireplace</b></td>
<td width="25%"><input type="checkbox" name="Fireplace" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Grantor First</b></td>
<td width="25%"><input type="text" name="GrantorFirst"> </td>
<td align="left" width="22%"><b>Stove</b></td>
<td width="25%"><input type="checkbox" name="Stove" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Grantee Last</b></td>
<td width="25%"><input type="text" name="GranteeLast"> </td>
<td align="left" width="22%"><b>Refrigerator</b></td>
<td width="25%"><input type="checkbox" name="Refridgerator" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Grantee First</b></td>
<td width="25%"><input type="text" name="GranteeFirst"> </td>
<td align="left" width="22%"><b>Dishwasher</b></td>
<td width="25%"><input type="checkbox" name="Dishwasher" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Property Type</b></td>
<td width="25%"><input type="text" name="PropertyType"> </td>
<td align="left" width="22%"><b>Washer</b></td>
<td width="25%"><input type="checkbox" name="Washer" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>GLA</b></td>
<td width="25%"><input type="text" name="GLA"> </td>
<td align="left" width="22%"><b>Dryer</b></td>
<td width="25%"><input type="checkbox" name="Dryer" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>House Number</b></td>
<td width="25%"><input type="text" name="HouseNumber"> </td>
<td align="left" width="22%"><b>Pool</b></td>
<td width="25%"><input type="checkbox" name="Pool" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Street Name</b></td>
<td width="25%"><input type="text" name="StreetName"> </td>
<td align="left" width="22%"><b>Spa</b></td>
<td width="25%"><input type="checkbox" name="Spa" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Town/City</b></td>
<td width="25%"><input type="text" name="TownCity"> </td>
<td align="left" width="22%"><b>Previously Appraised</b></td>
<td width="25%"><input type="checkbox" name="Previously Appraised" value="true"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>District</b></td>
<td width="25%"><input type="text" name="District"> </td>
<td align="left" width="22%"> </td>
<td width="25%"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Legal Description</b></td>
<td width="25%"><input type="text" name="LegalDescription"> </td>
<td align="left" width="22%"> </td>
<td width="25%"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Subdivision</b></td>
<td width="25%"><input type="text" name="Subdivision"> </td>
<td align="left" width="22%"> </td>
<td width="25%"> </td>
</tr>
<tr>
<td align="left" width="22%"><b>Year Built</b></td>
<td width="25%"><input type="text" name="YearBuilt"> </td>
<td width="30%"> </td>
<td width="19%"> </td>
</tr>
<td colspan="4" align="left">
<input type=submit value=Search>
<input type=reset value=Clear>
<font size="1" color="#0000FF">To view all records click Search Button without
entering in information to Search by.</font></td></tr>
</table>
</form></td>
<td width="9%"> </td>
</tr>
<tr>
<td colspan="3" width="100%" bgcolor="#FF9900">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td bgcolor="#E6E6E6">
<p align="left"><font face="Tahoma" size="1" color="#0000FF"><br>
</font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
What I am wondering is if perhaps I can have4 different dropdown lists containing all but the check boxes.. and 2 dropdown containing all of the checkboxes with nothing else. That would still work with the search button.
< Message edited by Spooky -- 3/20/2006 15:04:13 >
| |
|
|
|
archangelwes
Posts: 39
Joined: 3/9/2006
Status: offline
|
RE: ++ ASP search Results Page - 3/21/2006 13:31:45
I've added this code to my di.asp page... tell me what cha think
Search for: </b>
<SELECT ID="SearchField" NAME="SearchField" SIZE="1">
<OPTION VALUE="AnyField">Any field</option>
<OPTION VALUE="Shape"><%=Label("Shape")%></option>
<OPTION VALUE="AccountNumber"><%=Label("AccountNumber")%></option>
<OPTION VALUE="InsturmentNumber"><%=Label("InsturmentNumber")%></option>
<OPTION VALUE="DeedBookNumber"><%=Label("DeedBookNumber")%></option>
<OPTION VALUE="PageNumber"><%=Label("PageNumber")%></option>
<OPTION VALUE="PlatBookNumber"><%=Label("PlatBookNumber")%></option>
<OPTION VALUE="Page"><%=Label("Page")%></option>
<OPTION VALUE="Year"><%=Label("Year")%></option>
<OPTION VALUE="Month"><%=Label("Month")%></option>
<OPTION VALUE="Day"><%=Label("Day")%></option>
<OPTION VALUE="DeedType"><%=Label("DeedType")%></option>
<OPTION VALUE="Amount"><%=Label("Amount")%></option>
<OPTION VALUE="SalePrice"><%=Label("SalePrice")%></option>
<OPTION VALUE="WholeMapNumber"><%=Label("WholeMapNumber")%></option>
<OPTION VALUE="MapNumber"><%=Label("MapNumber")%></option>
<OPTION VALUE="Insert"><%=Label("Insert")%></option>
<OPTION VALUE="DblCircle"><%=Label("DblCircle")%></option>
<OPTION VALUE="Block"><%=Label("Block")%></option>
<OPTION VALUE="Section"><%=Label("Section")%></option>
<OPTION VALUE="Lot"><%=Label("Lot")%></option>
<OPTION VALUE="Lender"><%=Label("Lender")%></option>
<OPTION VALUE="GrantorLast"><%=Label("GrantorLast")%></option>
<OPTION VALUE="GrantorFirst"><%=Label("GrantorFirst")%></option>
<OPTION VALUE="GranteeLast"><%=Label("GranteeLast")%></option>
<OPTION VALUE="GranteeFirst"><%=Label("GranteeFirst")%></option>
<OPTION VALUE="PropertyType"><%=Label("PropertyType")%></option>
<OPTION VALUE="GLA"><%=Label("GLA")%></option>
<OPTION VALUE="HouseNumber"><%=Label("HouseNumber")%></option>
<OPTION VALUE="StreetName"><%=Label("StreetName")%></option>
<OPTION VALUE="TownCity"><%=Label("TownCity")%></option>
<OPTION VALUE="District"><%=Label("District")%></option>
<OPTION VALUE="LegalDescription"><%=Label("LegalDescription")%></option>
<OPTION VALUE="Subdivision"><%=Label("Subdivision")%></option>
<OPTION VALUE="YearBuilt"><%=Label("YearBuilt")%></option>
<OPTION VALUE="StructureValue"><%=Label("StructureValue")%></option>
<OPTION VALUE="ImprovedValue"><%=Label("ImprovedValue")%></option>
<OPTION VALUE="LandValue"><%=Label("LandValue")%></option>
<OPTION VALUE="TotalAssessedValue"><%=Label("TotalAssessedValue")%></option>
<OPTION VALUE="Site"><%=Label("Site")%></option>
<OPTION VALUE="TypeOfConstructions"><%=Label("TypeOfConstructions")%></option>
<OPTION VALUE="Room"><%=Label("Room")%></option>
<OPTION VALUE="Bedrooms"><%=Label("Bedrooms")%></option>
<OPTION VALUE="FullBathrooms"><%=Label("FullBathrooms")%></option>
<OPTION VALUE="HalfBathrooms"><%=Label("HalfBathrooms")%></option>
<OPTION VALUE="FinishedBasement"><%=Label("FinishedBasement")%></option>
<OPTION VALUE="UnfinishedBasement"><%=Label("UnfinishedBasement")%></option>
<OPTION VALUE="Garage"><%=Label("Garage")%></option>
<OPTION VALUE="Utilities"><%=Label("Utilities")%></option>
<OPTION VALUE="Heating"><%=Label("Heating")%></option>
<OPTION VALUE="Cooling"><%=Label("Cooling")%></option>
<OPTION VALUE="Porch"><%=Label("Porch")%></option>
<OPTION VALUE="Patio"><%=Label("Patio")%></option>
<OPTION VALUE="Deck"><%=Label("Deck")%></option>
<OPTION VALUE="Fence"><%=Label("Fence")%></option>
<OPTION VALUE="Fireplace"><%=Label("Fireplace")%></option>
<OPTION VALUE="Stove"><%=Label("Stove")%></option>
<OPTION VALUE="Refridgerator"><%=Label("Refridgerator")%></option>
<OPTION VALUE="Dishwasher"><%=Label("Dishwasher")%></option>
<OPTION VALUE="Washer"><%=Label("Washer")%></option>
<OPTION VALUE="Dryer"><%=Label("Dryer")%></option>
<OPTION VALUE="Pool"><%=Label("Pool")%></option>
<OPTION VALUE="Spa"><%=Label("Spa")%></option>
<OPTION VALUE="Peviously Appraised"><%=Label("Peviously Appraised")%></option>
<OPTION VALUE="Sketch"><%=Label("Sketch")%></option>
<OPTION VALUE="Image"><%=Label("Image")%></option>
<OPTION VALUE="Map"><%=Label("Map")%></option>
</SELECT>
<SELECT ID="SearchOption" NAME="SearchOption" SIZE="1">
<OPTION VALUE="Contains">Contains</option>
<OPTION VALUE="Equals">Equals</option>
<OPTION VALUE="Starts with ...">Starts with ...</option>
<OPTION VALUE="More than ...">More than ...</option>
<OPTION VALUE="Less than ...">Less than ...</option>
<OPTION VALUE="Equal or more than ...">Equal or more than ...</option>
<OPTION VALUE="Equal or less than ...">Equal or less than ...</option>
</SELECT>
<input type=text size=20 name=SearchFor>
<input type=button class=button name="SearchButton" value="Search"
onClick="javascript: document.forms.frmAdmin.action.value = 'Search';
document.forms.frmAdmin.submit();">
its giveing me an error... starting on the line like this
<OPTION VALUE="Shape"><%=Label("Shape")%></option>
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 