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