Re: Multiple Search Fields
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18700
interpreted = N
texte = Maybe you could post the relevant code so we can see what's going on instead of just guessing at what you might be doing? At 6:21 PM 7/6/98, talk wrote: >adding the rq at the end of the fields seemed to work at first , but I >went back and referenced the database and search for an exact set of >multiple fields, it doesnt find the item , even though the item is there >with the exact fields , this one seems to work in some cases but not in >all... > anyone got any other sugestions ??? > > > > >At 09:38 AM 7/6/98, you wrote: >>You need to add rq to the end of your search context for each field that >>is required. > > > >>>I'm trying to make a search where there are multiple fields that can be >>>searched. >>>I used the default search template that is made by webcat's database >helper , >>>but that's not doing what I want it to do. here's what I got >>>I have a few fields >>> Area : >>> # of Rooms : >>> price : >>>I want to make it where a user can search the fields and get just what they >>>are looking for. >>>If one field is searched at a time it works fine , but when all search >>>together that's where I >>>have my problem, say my area was New Orleans , # of Rooms is 4 , and price >>>is 122000, >>>the search would find all items in the catalog with any of those matches , >>>I've tried variations >>>of the string match, and , or options but it still pulls up all. >>> >>>I want to make it where a user could search for New Orleans, 4 bedrooms , >>>122000 and have >>>it just get the items that are meant to be found >>> >>>Is this possible???? >> o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
Maybe you could post the relevant code so we can see what's going on instead of just guessing at what you might be doing? At 6:21 PM 7/6/98, talk wrote: >adding the rq at the end of the fields seemed to work at first , but I >went back and referenced the database and search for an exact set of >multiple fields, it doesnt find the item , even though the item is there >with the exact fields , this one seems to work in some cases but not in >all... > anyone got any other sugestions ??? > > > > >At 09:38 AM 7/6/98, you wrote: >>You need to add rq to the end of your search context for each field that >>is required. > > > >>>I'm trying to make a search where there are multiple fields that can be >>>searched. >>>I used the default search template that is made by webcat's database >helper , >>>but that's not doing what I want it to do. here's what I got >>>I have a few fields >>> Area : >>> # of Rooms : >>> price : >>>I want to make it where a user can search the fields and get just what they >>>are looking for. >>>If one field is searched at a time it works fine , but when all search >>>together that's where I >>>have my problem, say my area was New Orleans , # of Rooms is 4 , and price >>>is 122000, >>>the search would find all items in the catalog with any of those matches , >>>I've tried variations >>>of the string match, and , or options but it still pulls up all. >>> >>>I want to make it where a user could search for New Orleans, 4 bedrooms , >>>122000 and have >>>it just get the items that are meant to be found >>> >>>Is this possible???? >> o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--- dave@digitalfrontier.com --+
Dave MacLeay
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[shownext max=?] armed (1997)
[WebDNA] [then] statement not showing (2012)
Username for Admin Group (1997)
[WebDNA] Help with ReplaceFoundItems (2009)
A better WebCat whois (was [OT] Domain Name Scam) (2000)
More WebMerch<->MacAuthoriz (1997)
Sendmail truncation in Eudora Clients (1998)
MacActivity and PCS (1997)
too many nested tags ... (1997)
Still having problems with Authen (1997)
different show next (1997)
Purchase Plugin Missing (1996)
Newbie question (1999)
My new discussion forum (2003)
how to check for no value while using [URL] to prevent crashing? (1999)
Duplicate Hell (1999)
Bug? (1997)
Configuring E-mail (1997)
Banners (1997)
Custom WebCat Prefs ... (1997)