Re: a search based on ^(contains)
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21582
interpreted = N
texte = just shooting a guess within minutes after i got up...try use following[search db=products.txt&eqakudatarq=[aku]&wnSKUdata=.&SKUtype=num]wn=Word not equal, so maybe that would help you out!/Martin>High all>>I don't think it is possible but I'm trying to search a data base and>return results for only sku's that do not contain a decimal point. I know>i could use [hideif [sku]^.] after the search, but I also need to base the>layout of the results on [numfound].>>Here is the scenario. I'm use one data base that contains the product>photos catagoies and descriptions tag lines etc. .. each of these line>items has an [aku] #.>>After they are displayed they search for and call up a table of sku>numbers that have mini descriptions of what they are for, sizes etc.>Sku's that have a decimal point in them denote cases of Items and are>desplayed in different areas.>>So I need a search that accomplishes something like this...>[search db=products.txt&eqakudatarq=[aku]&sku!^.] But that syntax>doesn't seem possible. I guess alternatly It could check to see if the sku>is divisible by 1. (seems like sound thinking) but...>[search db=products.txt&eqakudatarq=[aku]&eqskudatarq\1&skudata=num]>although this search looks better it doesn't work either.>>Does anyone know if what I'm trying to do will work?>>Tim Taylor>Webmaster>http://www.growzone.com>Tim@versa.com>t h e s i t e f o r t h e>g r e e n i n d u s t r y>1.888.800.5904Konsulentfirmaet Bech.dkDynamic HTML, WebDNA programming, Lasso & Filemaker Pro development
Associated Messages, from the most recent to the oldest:
just shooting a guess within minutes after i got up...try use following[search db=products.txt&eqakudatarq=[aku]&wnSKUdata=.&SKUtype=num]wn=Word not equal, so maybe that would help you out!/Martin>High all>>I don't think it is possible but I'm trying to search a data base and>return results for only sku's that do not contain a decimal point. I know>i could use [hideif [sku]^.] after the search, but I also need to base the>layout of the results on [numfound].>>Here is the scenario. I'm use one data base that contains the product>photos catagoies and descriptions tag lines etc. .. each of these line>items has an [aku] #.>>After they are displayed they search for and call up a table of sku>numbers that have mini descriptions of what they are for, sizes etc.>Sku's that have a decimal point in them denote cases of Items and are>desplayed in different areas.>>So I need a search that accomplishes something like this...>[search db=products.txt&eqakudatarq=[aku]&sku!^.] But that syntax>doesn't seem possible. I guess alternatly It could check to see if the sku>is divisible by 1. (seems like sound thinking) but...>[search db=products.txt&eqakudatarq=[aku]&eqskudatarq\1&skudata=num]>although this search looks better it doesn't work either.>>Does anyone know if what I'm trying to do will work?>>Tim Taylor>Webmaster>http://www.growzone.com>Tim@versa.com>t h e s i t e f o r t h e>g r e e n i n d u s t r y>1.888.800.5904Konsulentfirmaet Bech.dkDynamic HTML, WebDNA programming, Lasso & Filemaker Pro development
Martin Gertz Bech
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:
FW: Shipping calculations (1997)
[WebDNA] Crontab to execute DNA (2012)
removelineitems (2000)
Math Problem - Format? (1997)
Show if time tags (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
Re:no [search] with NT (1997)
Re[2]: Field Problem (2000)
How long until WebDNA makes the list? :( (2004)
Math Context (2001)
Bug or syntax error on my part? (1997)
Re:Help name our technology! (1997)
[TaxableTotal] - not working with AOL and IE (1997)
remotely creating and populating a stock inventory db -almost there! (1999)
Editing two databases in one form using [replace]? (1998)
San Diego WebCat/Network Position (2000)
[OT] Colored source code in IE? (2007)
[SearchString] usage (1997)
PIXO support (1997)
Re[2]: New syntax feedback for 4.0 (2000)