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.5904 Konsulentfirmaet Bech.dk Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro development Associated Messages, from the most recent to the oldest:

    
  1. Re: a search based on ^(contains) (Brian B. Burton 1998)
  2. Re: a search based on ^(contains) (Kenneth Grome 1998)
  3. Re: a search based on ^(contains) (Tim Taylor 1998)
  4. Re: a search based on ^(contains) (PCS Technical Support 1998)
  5. Re: a search based on ^(contains) (Tim Taylor 1998)
  6. Re: a search based on ^(contains) (Martin Gertz Bech 1998)
  7. a search based on ^(contains) (Tim Taylor 1998)
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.5904 Konsulentfirmaet Bech.dk Dynamic 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)