Re: [WebDNA] Search Problem

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 107316
interpreted = N
texte = --Apple-Mail-4--574614069Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiYes you should be able to do it the way you were intending Stuart.. with =just a proper set of search params.If you do not have luck with Brian's suggestion below, then I will =recreate the data locally.. and play with it until I get it and post =back. PLMK.- Govinda--------------Old WebDNA talklist archives:http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talkOn 2011-09-01, at 10:21 AM, Brian Fries wrote:> Add "®IONfbrk=3D;" to your search. "fbrk" specifies the break =characters for the field's value. "wbrk" specifies the break characters =for the comparison value you are passing in.>=20> Brian Fries> BrainScan Software>=20>=20>=20> On Sep 1, 2011, at 12:54 AM, Stuart Tremain wrote:>=20>> Hi Guys>>=20>> I have a product db that sells different product to different =regions.>>=20>> The db looks something like this>> SKU PRODUCTNAME REGION>> 1 red .com;>> 2 blue .com;.com.au;>> 3 green .com.au;>> 4 yellow .co.uk>>=20>> As you can see I am determining the regions from the HTTP_HOST - =[ListMIMEHeaders name=3DHTTP_HOST][value][/ListMIMEHeaders]>>=20>> I am having a bit of a problem with the search though>>=20>> This works OK due to .co.uk>>=20>> [SEARCH =db=3D^data/celmecproducts.db&woREGIONSdatarq=3D.co.uk®IONword=3Dww®I=ONSwbrk=3D;]>>=20>> But if I use .com the green product also shows ( I should only get =red & blue)>>=20>> I could do the db in a different format but it would be nice to get =this to work.>>=20>> Any ideas ??>>=20>> Thanks :)>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au--Apple-Mail-4--574614069Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiYes =you should be able to do it the way you were intending Stuart.. with =just a proper set of search params.