format search comparison Q
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34589
interpreted = N
texte = I have a search context where I need to do a comparison like the following:search: FIELD1 is less than [var] & FIELD2 is greater than [var] return value of FIELD3 based on the above search criterion The following search returns the correct answer ONLY if the variable __wordCount is equal to BOTH MIN_DAYS and MAX_DAYS. If __wordCount falls between the two numbers, numfound is 0.[search db=rates.db&geMIN_DAYSdatarq=[__wordCOUNT]&leMAX_DAYSdatarq=[__wordCount]] [founditems][RATE][/founditems] [/search]How do I formulate such a search in WebCat? I read carefully through the docs for comparisons, and no single comparison meets my needs.I'm going to try to put together an IF..THEN version, but surely there is a way to do it in the search itself?!Thanks!Steve ------------------------------------------------ Steven Jarvis Web Developer sjarvis@nwaonline.netMorning News of Northwest Arkansas http://www.nwaonline.net ------------------------------------------------------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I have a search context where I need to do a comparison like the following:search: FIELD1 is less than [var] & FIELD2 is greater than [var] return value of FIELD3 based on the above search criterion The following search returns the correct answer ONLY if the variable __wordCount is equal to BOTH MIN_DAYS and MAX_DAYS. If __wordCount falls between the two numbers, numfound is 0.[search db=rates.db&geMIN_DAYSdatarq=[__wordCOUNT]&leMAX_DAYSdatarq=[__wordCount]] [founditems][RATE][/founditems] [/search]How do I formulate such a search in WebCat? I read carefully through the docs for comparisons, and no single comparison meets my needs.I'm going to try to put together an IF..THEN version, but surely there is a way to do it in the search itself?!Thanks!Steve ------------------------------------------------ Steven Jarvis Web Developer sjarvis@nwaonline.netMorning News of Northwest Arkansas http://www.nwaonline.net ------------------------------------------------------------------------------------------------------------- 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://search.smithmicro.com/
Steven Jarvis
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:
WebCatalog2 Feature Feedback (1996)
SSL and Webstar 3 with Webcatalog (1998)
Sort Order on a page search (1997)
Order problem (1998)
Help! WebMerchant store suddenly won't process orders... (2001)
[group] ? (1997)
Dark Horse Comics success story (1997)
Fwd: 502 Bad Gateway (1998)
DBServer question (2005)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[date format] w/in sendmail (1997)
Odd [math] behavior (2003)
Lambada for Macintosh is Here! (1996)
Review comparison by PC Magazine: Open for On-line Business (1997)
[WebDNA] thisurlplusget and webdna v8.0.2 and v8.2 (2016)
emailer setup (1997)
Limitations on fields? Server is crashing (1997)
Not really WebCat (1997)
[WebDNA] Enhancements to "list" contexts ... (2015)
websitepro/webcat/registry? (1998)