Re: Search Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51378
interpreted = N
texte = Would this not do it?[search db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004]>Is there no way for Webcat to be able to perform a search that looks >for a couple fields to match and for one that doesn't?>>I know if SQL you can do a search that reads "select make, model, >year from database where make = 'Honda', model = 'Accord', year != >'2004'". I'm having trouble with just such a search.>>I know you can achieve something like this in the [founditems] and >you can use [ELSE], but I'm having trouble with the number of >results shown in the [founditems] gives me the number of results for >the search, where excluding records with [ELSE] will trim the >results in half.>>Any ideas?>>Tom>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list
.>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/-- Daryl MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: http://www.pwgroup.ca/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Would this not do it?[search db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004]>Is there no way for Webcat to be able to perform a search that looks >for a couple fields to match and for one that doesn't?>>I know if SQL you can do a search that reads "select make, model, >year from database where make = 'Honda', model = 'Accord', year != >'2004'". I'm having trouble with just such a search.>>I know you can achieve something like this in the [founditems] and >you can use [ELSE], but I'm having trouble with the number of >results shown in the [founditems] gives me the number of results for >the search, where excluding records with [ELSE] will trim the >results in half.>>Any ideas?>>Tom>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/-- Daryl MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: http://www.pwgroup.ca/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Daryl Mitchell
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:
Examples of cross-selling with WebCatalog? (1998)
[format 40s]text[/format] doesn't work (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WC1.6 to WC2 date formatting (1997)
[WebDNA] PayPal IPN harvester (2013)
I am dumb. No see [variable] (2003)
Upload Graphic Problem (2004)
how do you and/or in a search? (1997)
Formatting a .txt file (1998)
b12 cannot limit records returned and more. (1997)
Webcat causing crashes left and right! (1997)
Searching help needed (1998)
Associative lookup style? + bit more (1997)
Limitations on fields? Server is crashing (1997)
Re1000001: Setting up shop (1997)
[WebDNA] Two questions about sending email on Ubuntu 14.04 (2014)
Nested tags count question (1997)
WebCatalog Plug-in for Webstar. (1997)
Searching an Email database (1997)
Out of the woodwork (2007)