Re: How is it done?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17583
interpreted = N
texte = >>Does using the rn parameter in a search like this require that we also >>put FieldNameType=num into the search parameters? > >Yes, ranges actually do work for numbers and dates (and text), but you have >to tell it what type they are, just as you would for sorting. For a text >range, E is in between C and K. rn searching does *NOT* work properly when you tell WebCat to do a numeric range search by adding fieldNameType=num to the search parameters.The only way I can get rn searching to work is to leave the fieldNameType=num parameter out, then it works okay -- provided the number of digits in the field is exactly the same in every record ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>Does using the rn parameter in a search like this require that we also >>put FieldNameType=num into the search parameters? > >Yes, ranges actually do work for numbers and dates (and text), but you have >to tell it what type they are, just as you would for sorting. For a text >range, E is in between C and K. rn searching does *NOT* work properly when you tell WebCat to do a numeric range search by adding fieldNameType=num to the search parameters.The only way I can get rn searching to work is to leave the fieldNameType=num parameter out, then it works okay -- provided the number of digits in the field is exactly the same in every record ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Kenneth Grome
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:
search vs lookup (1998)
WebCat2: Items xx to xx shown, etc. (1997)
missing records (1998)
Quantity (1998)
WCS Newbie question (1997)
[quantity] within formulas (1997)
Date Range search (1997)
[WebDNA] Converting minutes to hours (2008)
[WebDNA] Raspberry Pi (2013)
multi-paragraph fields (1997)
Thankyou Ronny (2003)
Alais Shopping Cart Directory (1998)
Bug alert! (1997)
3RD POST Character limit in [Search]? (1998)
CyberSource component for WebCatalog? (2000)
AAAH: stupid sendmail (2001)
https validation (2001)
Using [purchase] (1998)
and passing to a cart (1997)
PCS Emailer's role ? (1997)