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:

[WebDNA] TCPCONNECT & Timeout (2015) Grouping search fields, etc. (1997) Processing stops (2006) OT - royalty free images (2002) WebCat2b13 Command Reference Doc error (1997) WebTen? (1997) insert graphic in email (2000) Associative lookup style? + bit more (1997) Mime-Version in email header (1997) listfiles shows invisible files ... (1999) WebCat2: Formulas.db question (1997) Special search (1998) PCS Frames (1997) WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004) question: webmerchant connection (1997) template security preferences????? (1998) [isfile] ? (1997) Cobalt RaQ2 and WebCatalog: who uses it? (2000) Re:quit command on NT (1997) MacAuthorize order data fields WAS:How To question... (1997)