[WebDNA] Search Problem

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107306
interpreted = N
texte = --Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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®IONword=3Dww®I= ONSwbrk=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 --Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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




= --Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0-- 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=_10E1F601-FDCA-4107-A3DD-17007A72A3B0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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®IONword=3Dww®I= ONSwbrk=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 --Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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




= --Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0-- Stuart Tremain

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:

PSC recommends what date format yr 2000??? (1997) Encrypting the URL Query String (2003) Programmer Needed (1998) Banners (1997) WebCat2 - [format thousands] (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) Outsourcing & copyrights (2005) Recycling fee (1998) [WebDNA] WebDNA & Mod_rewrite (2010) This list needs a digest: rant, rave... (1997) Table Trouble... (2005) WebCat2 - Getting to the browser's username/password data (1997) [OT] - Block Traffic to DevBox (2003) Showif with an or (2003) Max Record length restated as maybe bug (1997) creating a ShipCosts database (1997) [defined]ish (1997) Emailer setup (1997) Itools, WEBCAT OSX (2003) WebCatalog 2.0 & WebDNA docs in HTML ... (1997)