RE: ++ ASP search Results Page (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

archangelwes -> 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 -> 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



Spooky -> RE: ++ ASP search Results Page (3/13/2006 14:10:45)

quote:

and if you copy the ml_results.asp file to front page its between lines 180 - 362


What makes you say that?
When I asked you to post the source (from the browser) ALL of the asp code was showing?
An asp page should be parsed by the server and if an error is created, generally it will display a serverside error message

Using the response end code, if asp was running, the output to the browser should have stopped immediately and no further code would display



Spooky -> RE: ++ ASP search Results Page (3/13/2006 14:29:06)

Heres an example of the source code I see in the browser after running the asp code (but no data as I dont have the database)
Youll see there is no source code nor any error. 



<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="Kalptaru Infotech Ltd. [www.a2zhelp.com]">
<title>ML</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%">
  <tr>
    <td colspan="3" width="100%">Search Results</td>

  </tr>
  <tr>
    <td width="10%"></td>
    <td width="80%">

<table border=0><tr>
    
</tr>

     <tr>
       <td colspan=100 align=center>

        Data Available 
       
   <tr align=center>
    <td align=center colspan=30> 
       
   </td>
  </tr>
</table></td>
    <td width="10%"></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="center"><font face="Tahoma" size="1" color="#0000FF"><br>
             </font></td>
        </tr>
      </table>
    </td>
  </tr>

</table>
</body>
</html>



archangelwes -> 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 -> 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...



Spooky -> RE: ++ ASP search Results Page (3/15/2006 14:01:03)

What sort of change are you making and is there an error when you load the page?



archangelwes -> 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 -> 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



Spooky -> RE: ++ ASP search Results Page (3/15/2006 15:02:27)

If anything, I would revert to the default files first and check those are working again?



archangelwes -> 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 -> 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..



Spooky -> RE: ++ ASP search Results Page (3/17/2006 13:53:48)

You can change an outputted number to currency using :

<%=formatcurrency(fp_field(fp_rs,("your money field"))%>



archangelwes -> 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



Spooky -> RE: ++ ASP search Results Page (3/17/2006 14:11:28)

For example, you could simply do this :

$<%=objRst("SalePrice")%>

or this :

<%=formatcurrency(objRst("SalePrice"))%>



archangelwes -> RE: ++ ASP search Results Page (3/17/2006 14:19:00)

ok where do I do that at =P



archangelwes -> RE: ++ ASP search Results Page (3/17/2006 14:19:38)

and does that cover searching from one number to another number?



archangelwes -> 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



Spooky -> RE: ++ ASP search Results Page (3/17/2006 15:22:50) 

<%'-------Getting SalePrice
dim SalePrice
SalePrice=Request("SalePrice")
SalePrice2= Request("SalePrice2")
%>
<%if trim(SalePrice) <>"" AND trim(SalePrice2) <>""  then
   sWhereCondition=sWhereCondition & " AND [SalePrice] BETWEEN "& SalePrice & " AND "& SalePrice2
end if%>


You would need to add another search box called "SalePrice2" and then modify the SQL
It should however be a numeric field? yours seems to be text?



archangelwes -> 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 -> 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.



Spooky -> RE: ++ ASP search Results Page (3/20/2006 15:06:47)

In di_results.asp, you should add "response.write sSQL" sp you can see what values are being passed around



archangelwes -> 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>



Page: <<   < prev  1 [2]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.296875