Search Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51376
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Webcatalog quitting (1997)
New Command prefs ... (1997)
WebDNA 5.0 freeBSD?!!? (2003)
WebCat2final1 crashes (1997)
[WebDNA] Strange MATH result (2010)
is there a global includes directory? (1998)
FAX orders (1996)
WebCatalog losing Data (2001)
Combining search criteria in a context? (1998)
Bug or syntax error on my part? (1997)
Sendmail Question (2001)
WebCat2b15MacPlugin - [protect] (1997)
File Upload and Platform (2001)
searching illegal HTML (2002)
Nav. 4 probs with cart - Serious problem (1997)
[WebDNA] XML vars from Flash (2009)
OT: Spam (2000)
Error Log.db --however (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Using [Include] Context (1999)