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. Dave On 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:

    
  1. Re: searching for items that begin with a number ( "Gary Krockover" 2004)
  2. Re: searching for items that begin with a number ( Brian Fries 2004)
  3. Re: searching for items that begin with a number ( "Gary Krockover" 2004)
  4. Re: searching for items that begin with a number ( 2004)
  5. Re: searching for items that begin with a number ( Brian Fries 2004)
  6. Re: searching for items that begin with a number ( 2004)
  7. Re: searching for items that begin with a number ( Gary Krockover 2004)
  8. Re: searching for items that begin with a number ( 2004)
  9. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  10. Re: searching for items that begin with a number ( Gary Krockover 2004)
  11. Re: searching for items that begin with a number ( Gary Krockover 2004)
  12. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  13. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  14. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  15. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  16. Re: searching for items that begin with a number ( Gary Krockover 2004)
  17. Re: searching for items that begin with a number ( Gary Krockover 2004)
  18. Re: searching for items that begin with a number ( Dave Hurley 2004)
  19. Re: searching for items that begin with a number ( 2004)
  20. Re: searching for items that begin with a number ( 2004)
  21. Re: searching for items that begin with a number ( Dave Hurley 2004)
  22. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  23. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  24. Re: searching for items that begin with a number ( "Dan Strong" 2004)
  25. searching for items that begin with a number ( 2004)
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. Dave On 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)