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:

Help name our technology! (1997) Tenon and PCS Partner (1998) ShowNext (1997) customer.db and forms (1999) [delete] problem (1997) WebCat2 - [format thousands] (1997) Help! (2000) Order not created error (1997) Problem with version 4 browsers (1998) Limit to Field Length in DB (1998) [WebDNA] How to stop cutting a word (2008) Email Format (Umlaut) (2004) when is date system date or order date? (1997) RE: creating writefile data from a nested search (1997) [cart] not being interpreted inside [founditems] (1997) NT Setup (1998) [WebDNA] Spambots, message boards and such (2008) Shopping Cart variation... (1997) [OT] Friday Time Waster (2003) Exclamation point (1997)