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:

PCS Emailer's role ? (1997) Banner DNA (1997) Re:Help name our technology! (1997) Sorting Results (1999) Banners and sort of random display (1997) Cookie woes with Mac IE4 (1998) Bad suffix error (1997) So what ya working on? (or have you completed?) (2004) SmithMicro announcement at Macworld ?? (2004) RE: automatic reload of frameset (1997) Location of Webcat site in folder hierarchy (1997) WebCat2 beta 11 - new prefs ... (1997) FEA REQ: One .hdr, multiple .db's (2003) Searching multiple fields (1997) Old & New? (2003) carriage returns in data (1997) WebCatalog Features (1997) question: webmerchant connection (1997) Limit on nested [ShowIf]'s? (1997) WC2.0 Memory Requirements (1997)