Re: Multiple Search Fields
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18702
interpreted = N
texte = 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???? >
Associated Messages, from the most recent to the oldest:
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???? >
talk
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:
Multiple catalog databases and showcart (1997)
Protecting webdelivery (1997)
Am I going senile? (Price recalc based on quantity) (1997)
OT: AppleScript question (2003)
Absolute path (2003)
Web Catalog 2 demo (1997)
[addlineitems] (1997)
multi-paragraph fields (1997)
Not really WebCat (1997)
PCS Emailer's role ? (1997)
For those of you not on the WebCatalog Beta... (1997)
WebCatalog not running after upgrade (2000)
PCS Frames-Default page is solution! (1997)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
OS X problem: when using [ShowCart] or [orderfile]... (2000)
Date problems-more (1997)
What is a TAB (2003)
Purchased cart being overwritten - still !?? (1997)
no global [username] or [password] displayed ... (1997)
Emailer choke (1997)