Re: [WebDNA] Search Problem

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 107317
interpreted = N
texte = --Apple-Mail=_5FE46273-FCC0-4BA8-8A6A-FB0EA54D25D2Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiBrianA little know gem !! I have used the wbrk before but didn't know about =the fbrk, it is not in my version of the docs that I use locally.A pity I hade rebuilt the db and searches before I saw your post.A handy one to know :)StuartOn 02/09/2011, at 12: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>>=20>>=20>>=20>>=20>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_5FE46273-FCC0-4BA8-8A6A-FB0EA54D25D2Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiBrian

On 02/09/2011, at 12:21 AM, Brian Fries wrote:

Add "&REGIONfbrk=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.



Brian =Fries

BrainScan =Software





On Sep 1, 2011, at 12:54 AM, Stuart Tremain =wrote:

Hi =Guys

I have a product db that sells different product =to different regions.

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

As you can see I am determining the =regions from the HTTP_HOST - [ListMIMEHeaders =name=3DHTTP_HOST][value][/ListMIMEHeaders]

I am having a bit of a =problem with the search though

This works OK due to =.co.uk

[SEARCH =db=3D^data/celmecproducts.db&woREGIONSdatarq=3D.co.uk&REGIONword=3D=ww&REGIONSwbrk=3D;]

But if I use .com the green =product also shows ( I should only get red & blue)

I could do the db in a different format but it =would be nice to get this to work.

Any ideas ??

Thanks :)

Stuart =Tremain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au





---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

A little know gem !! I have used the wbrk =before but didn't know about the fbrk, it is not in my version of the =docs that I use locally.

A pity I hade rebuilt =the db and searches before I saw your post.

A =handy one to know =:)

Stuart