Re: searching for items that begin with a number
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58309
interpreted = N
texte = This just insures that the field being compared to is being evaluated as a text field and not a number. "Idno" and "NAMES" were left over from my original code, which I changed slightly (but incompletely) for my example. Sorry for the confusion.DaveOn Jun 10, 2004, at 12:57 PM,
wrote:> Hello Dave,>> The code works. One favor though,> please explain "idnoType=text".>> &leNAMESdatarq=9999999&idnoType=text>> Thanks>> Eduardo>>> ----- Original Message -----> From: "Dave Hurley" > To: "WebDNA Talk" > Sent: Thursday, June 10, 2004 12:36 PM> Subject: Re: searching for items that begin with a number>>>> I use this (with a dummy example table search):>>>> [table name=temp&fields=f1,f2,f3]>> 12foo foo12 foo12>> 34foo foo34 foo34>> foo56 foo56 foo56>> [/table]>>>> [Search table=temp&geF1dataRQ=9999999&idnoType=text]>> [FoundItems]>> [f1]
>> [/FoundItems]>> [/Search]>>>> A search comparison of "ge" will find only those records that _don't_>> start with a number. Using "le" finds those that _do_.>>>> Dave Hurley>> Biology Department>> University of Washington>>>>>> On Jun 10, 2004, at 11:29 AM, wrote:>>>>> Is there a way to search for items that begin with a number. Code >>> below>>> doesn't work.>>>>>> [search db=data.db&woNAMESdatarq=1,2,3,4,5,6,7,8,9,0&NAMEScomp=bw]>>>>>>>>> Eduardo>>>>>> ------------------------------------------------------------->>> 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/>>>>>>>>> ------------------------------------------------------------->> 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/>>> -------------------------------------------------------------> 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/>-------------------------------------------------------------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:
This just insures that the field being compared to is being evaluated as a text field and not a number. "Idno" and "NAMES" were left over from my original code, which I changed slightly (but incompletely) for my example. Sorry for the confusion.DaveOn Jun 10, 2004, at 12:57 PM, wrote:> Hello Dave,>> The code works. One favor though,> please explain "idnoType=text".>> &leNAMESdatarq=9999999&idnoType=text>> Thanks>> Eduardo>>> ----- Original Message -----> From: "Dave Hurley" > To: "WebDNA Talk" > Sent: Thursday, June 10, 2004 12:36 PM> Subject: Re: searching for items that begin with a number>>>> I use this (with a dummy example table search):>>>> [table name=temp&fields=f1,f2,f3]>> 12foo foo12 foo12>> 34foo foo34 foo34>> foo56 foo56 foo56>> [/table]>>>> [Search table=temp&geF1dataRQ=9999999&idnoType=text]>> [founditems]>> [f1]
>> [/FoundItems]>> [/Search]>>>> A search comparison of "ge" will find only those records that _don't_>> start with a number. Using "le" finds those that _do_.>>>> Dave Hurley>> Biology Department>> University of Washington>>>>>> On Jun 10, 2004, at 11:29 AM, wrote:>>>>> Is there a way to search for items that begin with a number. Code >>> below>>> doesn't work.>>>>>> [search db=data.db&woNAMESdatarq=1,2,3,4,5,6,7,8,9,0&NAMEScomp=bw]>>>>>>>>> Eduardo>>>>>> ------------------------------------------------------------->>> 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/>>>>>>>>> ------------------------------------------------------------->> 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/>>> -------------------------------------------------------------> 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/>-------------------------------------------------------------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/
Dave Hurley
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:
Error:Too many nested [xxx] contexts (1997)
WC Database Format (1997)
Duplicate Hell (1999)
Web requests in que... (2007)
last word listed (2000)
multi-paragraph fields (1997)
what the... (2004)
Building Calendars (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Possible Bug in 2.0b15.acgi (1997)
searching by date (1998)
[WebDNA] Shucks wendna doesn't work with el capitan (2015)
New NT beta available (1997)
Drop Down Menus (2002)
orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000)
FYI: Error message (1996)
New reserved words for [tags] (2000)
A helpful tip to avoid pulling an Aaron (2000)
WebCat2: Master Counter snippet (1997)
maximu values for sendmail! (1997)