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 a store on BOTH http and https (1998) HideIf ip= OR ip= (1998) Database Options (1997) [WebDNA] WebDNA & VPS (2009) Upload Text File/ Append to DB (2003) SQL Error 22003 : Found the workaround (2001) Quit revisited (1997) Cold Fusion Buster (1997) Help!!!! Purchases not going through! (1997) Encrypt a page/template (2002) Search returns all, not 20 (1997) I've been thinking (2002) WebTen and WebCat (1997) WebCat2 several catalogs? (1997) [WebDNA] Problem with administration (2009) Cart ID (1999) Ruby on Rails (was Looping Search) (2006) Day of the week (2006) Latest beta slow on [order] and [purchase] (1997) 2.1b2 was SLOW ... but 2.1b3 is FAST! (1997)