DM,<br><br>This is what i included as suggested by you.<br><cfquery name="Homes" datasource="db1"><br> SELECT * from Property<br> WHERE PropBedrooms >= #PropBedrooms# and<br> PropBathrooms >= #PropBathrooms#<br> and PropState = '#PropState#'<br> and PropType = '#PropType#'<br> and PropPrice = '#MaxPrice#' <br></cfquery><br><br>From the previous prblem i got. I got this new error.<br><br>ODBC Error Code = 22005 (Error in assignment)<br>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.<br>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (31:1) to (31:39).<br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
To Darkman from Potinenip
- Thread starter potinenip
- Start date
Check your datatypes in your Property table... The values that are numbers should not have single quotes, and all others should have them. My guess is your that your '#MaxPrice#' should be #MaxPrice# (no quotes) since it is probably a numerical value... Also, I would think that people inputting a price want to find something that price or lower, so you may want to consider making that portion of the statement<br><FONT FACE=monospace><br>and PropPrice <= #MaxPrice#<br></font><br>This will let them find properties that are cheaper than the price they input...<br><br>Hope this helps.<br>DM
- Thread starter
- #3
DM,<br>Thanks for the suggestion. It worked finally.<br>But i am not getting the previous and next button thing. i wrote code to diplay 5 records at a time. but all the records are displayed.<br>Can u look at my code suggest where i am wrong.<br><br><br><CFSET MaxRows=5><br><!--- Initialize all fields if they do not exist ---><br><CFPARAM NAME="start" DEFAULT="1"><br><br><!--- What are the previous and next row to start positions ---><br><CFSET PrevStart = Start - MaxRows><br><CFSET NextStart = Start + MaxRows><br><br><!--- Previous button code ---><br><TD COLSPAN="3" ALIGN="LEFT"><br><CFIF PrevStart GTE 1><br> <CFOUTPUT><br> <FORM ACTION="PostNewHome_searchAction.cfm" METHOD="POST"><br> <INPUT TYPE="hidden" NAME="start" VALUE="#PrevStart#"><br> <INPUT TYPE="hidden" NAME="PropState" VALUE="#PropState#"><br> <INPUT TYPE="hidden" NAME="PropType" VALUE="#PropType#"><br> <INPUT TYPE="hidden" NAME="PropPrice" VALUE="#PropPrice#"><br> <INPUT TYPE="hidden" NAME="PropBedrooms" VALUE="#PropBedrooms#"><br> <INPUT TYPE="hidden" NAME="PropBathrooms" VALUE="#PropBathrooms#"><br> <INPUT TYPE="submit" VALUE="Previous #MaxRows#"><br> </FORM><br> </CFOUTPUT><br></CFIF><br></TD><br><br><br><TD COLSPAN="3" ALIGN="RIGHT"><br><!--- Next button code ---><br><CFIF NextStart LTE GetHouse.RecordCount><br> <CFOUTPUT><br> <FORM ACTION="PostNewHome_SearchAction.cfm" METHOD="POST"><br> <INPUT TYPE="hidden" NAME="start" VALUE="#NextStart#"><br> <INPUT TYPE="hidden" NAME="PropState" VALUE="#PropState#"><br> <INPUT TYPE="hidden" NAME="PropType" VALUE="#PropType#"><br> <INPUT TYPE="hidden" NAME="PropPrice" VALUE="#PropPrice#"><br> <INPUT TYPE="hidden" NAME="PropBedrooms" VALUE="#PropBedrooms#"><br> <INPUT TYPE="hidden" NAME="PropBathrooms" VALUE="#PropBathrooms#"><br> <INPUT TYPE="submit" VALUE="Next #MaxRows#"><br> </FORM><br> </CFOUTPUT><br>
- Thread starter
- #5
- Thread starter
- #6
DM,<br>Sorry for pestering you. I'm new to Development in Coldfusion and i'm learning from u.<br>Need one more suggestion. How do we create the list of records. Instead of next button, an we put numbers <br>1 2 3... as links which will diplay the records accordingly.<br>Praveen
- Status
Similar threads
- Locked
- Question