Search multiple fields
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14622
interpreted = N
texte = Hi,I’m trying to allow a search to access multiple fields within a databse.Mac running WebStar 2.1 and WebCatalog 2.1 MacOS8The database is pretty standard: SKU Title Description Company Category OSSupport Price Picture ...At the moment I have the following code below, one search for title and the other for description. I would like to keep the searches down to a minimum, ie I don’t want to a search for each of the fields. I would like to have one search to gather results from more than one field. Just like most search engines, you enter any text and it will search the whole database (but in my case I just need to search the following feilds: SKU, Title, Description, Company, Category, OSSupport).The manual does mention you can search multiple fields, but not how to do it. The manual also mentions how to group fields, but not how to implement them into your code with examples.
Regards, Marko---------------------------------- Marko Bernyk ---------------------------------- Senior System Engineer Technical Services Conexus Pty Ltd Sydney, Australia e-mail: marko@conexus.com.au http://www.conexus.com.au ---------------------------------- e-mail: marko.bernyk@earthling.net http://www.conexus.com.au/marko/
Associated Messages, from the most recent to the oldest:
Hi,I’m trying to allow a search to access multiple fields within a databse.Mac running WebStar 2.1 and WebCatalog 2.1 MacOS8The database is pretty standard: SKU Title Description Company Category OSSupport Price Picture ...At the moment I have the following code below, one search for title and the other for description. I would like to keep the searches down to a minimum, ie I don’t want to a search for each of the fields. I would like to have one search to gather results from more than one field. Just like most search engines, you enter any text and it will search the whole database (but in my case I just need to search the following feilds: SKU, Title, Description, Company, Category, OSSupport).The manual does mention you can search multiple fields, but not how to do it. The manual also mentions how to group fields, but not how to implement them into your code with examples.
Regards, Marko---------------------------------- Marko Bernyk ---------------------------------- Senior System Engineer Technical Services Conexus Pty Ltd Sydney, Australia e-mail: marko@conexus.com.au http://www.conexus.com.au ---------------------------------- e-mail: marko.bernyk@earthling.net http://www.conexus.com.au/marko/
Marko Bernyk
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:
PIXO Support (1997)
Quickie question on the email templates (1997)
WSDL Wizard (2003)
SendMail - Idea (2000)
[WebDNA] [OT] BBEdit Glossary (2012)
WebCat for mass emailings (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Remote stockroom ? (1998)
expired beta (1997)
Unusual characters in the db ... (2002)
WebDNA Monitor (2005)
problems with 2 tags (1997)
TRAINING videos - Prove IT. (1998)
[Capitalize] (1998)
No. of items in shopping cart (2000)
Showing unopened cart (1997)
SSL, WebSTAR, WebCatalog (1998)
WebCatalog and Bar Code Scanners (1999)
Associative lookup style? (1997)
Mac Vs WindowsNT (1997)