Re: Word Breaks

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17709
interpreted = N
texte = >Is it possible to word break a comma delimited list and do an exact >search for one item in that list? > >------------------- >ex: > >The list contains 111,121,131,141,1111,1311,1411 > > >[SEARCH >db=../../total.db&eqRECORDIDdatarq=[PVRECORDID]&CLwbrk=[url],[/url]&woCLda >tarq=1111][/SEARCH] > >--------------------- > >The search will come back with a result of 2 items found items 1111 >and 111. I just want 1111 to be returned. If I use eq instead of >wo there are no found items, because with an exact search 1111, is >found. How would I go about doing an exact search? > > I do something similar by putting a space before and a comma after the item in the list. Then I pad my search criteria with a space before and a comma after the search item.name=[PVRECORDID] value= [searchphrase],So instead of a comma deliminated list, it is a ', ' delimited listed where the space really belongs to the item after the delimiter. good luck!Sandy Associated Messages, from the most recent to the oldest:

    
  1. Substring matches, word breaks, groups, and forms (Dennis J. Bonsall, Jr. 2002)
  2. Re: Word Breaks (Peter Ostry 1998)
  3. Re: Word Breaks (PCS Technical Support 1998)
  4. Re: Word Breaks (Sandra L. Pitner 1998)
  5. Word Breaks (webmaster@textileweb.net (Bill Norman) 1998)
>Is it possible to word break a comma delimited list and do an exact >search for one item in that list? > >------------------- >ex: > >The list contains 111,121,131,141,1111,1311,1411 > > >[SEARCH >db=../../total.db&eqRECORDIDdatarq=[PVRECORDID]&CLwbrk=[url],[/url]&woCLda >tarq=1111][/SEARCH] > >--------------------- > >The search will come back with a result of 2 items found items 1111 >and 111. I just want 1111 to be returned. If I use eq instead of >wo there are no found items, because with an exact search 1111, is >found. How would I go about doing an exact search? > > I do something similar by putting a space before and a comma after the item in the list. Then I pad my search criteria with a space before and a comma after the search item.name=[PVRECORDID] value= [searchphrase],So instead of a comma deliminated list, it is a ', ' delimited listed where the space really belongs to the item after the delimiter. good luck!Sandy Sandra L. Pitner

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:

using listfiles to build a database? more (2000) WCS Newbie question (1997) creator code (1997) Problems w/ heavy use of cart header fields? (1998) Duplicate Items in the Cart (1998) Problems with [Applescript] (1997) [WebDNA] WebDNA and simple password systems (2009) TCPSend/Replace DB Records (2002) Paths relative to root not working (2000) nslookup (2000) Displaying backgrounds (1999) Paranoid about serial numbers...not (1998) Review comparison by PC Magazine: Open for On-line Business (1997) Does ".tpl" index with SE's? (2003) Uploading out of FMP (2001) [NT] ie 4.0 required (1997) E-Mail Formatting (2000) [WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012) [WebDNA] WebDNA not parsing php files (2012) ODBC Control panel for Mac - Where to find? (2001)