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:
>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)