Re: [WebDNA] Search Problem

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107315
interpreted = N
texte = --Apple-Mail-14--575251331 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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. Brian Fries BrainScan Software On Sep 1, 2011, at 12:54 AM, Stuart Tremain wrote: > 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 --Apple-Mail-14--575251331 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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




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

= --Apple-Mail-14--575251331-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search Problem (Stuart Tremain 2011)
  2. Re: [WebDNA] Search Problem (Govinda 2011)
  3. Re: [WebDNA] Search Problem (Brian Fries 2011)
  4. Re: [WebDNA] Search Problem (Kenneth Grome 2011)
  5. Re: [WebDNA] Search Problem (Stuart Tremain 2011)
  6. Re: [WebDNA] Search Problem (Kenneth Grome 2011)
  7. Re: [WebDNA] Search Problem (Stuart Tremain 2011)
  8. Re: [WebDNA] Search Problem (Tom Duke 2011)
  9. Re: [WebDNA] Search Problem (Stuart Tremain 2011)
  10. Re: [WebDNA] Search Problem (William DeVaul 2011)
  11. Re: [WebDNA] Search Problem (Tom Duke 2011)
  12. [WebDNA] Search Problem (Stuart Tremain 2011)
--Apple-Mail-14--575251331 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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. Brian Fries BrainScan Software On Sep 1, 2011, at 12:54 AM, Stuart Tremain wrote: > 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 --Apple-Mail-14--575251331 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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




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

= --Apple-Mail-14--575251331-- Brian Fries

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:

Running 2 two WebCatalog.acgi's (1996) encrypt/decrypt password with authenticate (2002) WebCatalog/Mac 2.1b2 New Features (1997) What do the &x=5&y=8 mean? (2002) carriage returns in data (1997) Frames and WebCat (1997) & in Lookups (1997) customizing the color of user's pages (1997) WC2.0 Memory Requirements (1997) more info on [setlineitems] (1997) CMSBuilder (2004) Why is deleting so slow? (2002) cc auth with [purchase] (1998) Instructions for Digest (1997) [OT] MACWORLD (2003) Replace context problem ... (1997) webmerch and serials - almost there (1997) unique ascending numbers (2003) Protect vs Authenicate (1997) hidden (phantom) file downloads (2000)