Re: [WebDNA] Search Problem

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107308
interpreted = N
texte = If you want this to work, just inside the founditems of the search (which sounds like it can be over-inclusive but not under) I'd try something like: [founditems] [listwords words=3D[region]&delimiter=3D;] [showif [word]=3D.com] [/showif] [/listwords] [/founditems] Bill On Thu, Sep 1, 2011 at 3: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 =A0 =A0 =A0PRODUCTNAME =A0 =A0 =A0REGION > 1 =A0 =A0 =A0 =A0 =A0 =A0red =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0.com; > 2 =A0 =A0 =A0 =A0 =A0 =A0blue =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0.com;.com.au; > 3 =A0 =A0 =A0 =A0 =A0 =A0green =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0.com.au; > 4 =A0 =A0 =A0 =A0 =A0 =A0yellow =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 .co.uk > As you can see I am determining the regions from the HTTP_HOST > -=A0[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®= IONSwbrk=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 to the mailing list . To unsubscri= be, > E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug > Reporting: support@webdna.us 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)
If you want this to work, just inside the founditems of the search (which sounds like it can be over-inclusive but not under) I'd try something like: [founditems] [listwords words=3D[region]&delimiter=3D;] [showif [word]=3D.com] [/showif] [/listwords] [/founditems] Bill On Thu, Sep 1, 2011 at 3: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 =A0 =A0 =A0PRODUCTNAME =A0 =A0 =A0REGION > 1 =A0 =A0 =A0 =A0 =A0 =A0red =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0.com; > 2 =A0 =A0 =A0 =A0 =A0 =A0blue =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0.com;.com.au; > 3 =A0 =A0 =A0 =A0 =A0 =A0green =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0.com.au; > 4 =A0 =A0 =A0 =A0 =A0 =A0yellow =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 .co.uk > As you can see I am determining the regions from the HTTP_HOST > -=A0[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®= IONSwbrk=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 to the mailing list . To unsubscri= be, > E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug > Reporting: support@webdna.us William DeVaul

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:

[ListFiles] & [loop] (1998) problems with 2 tags (1997) For those of you not on the WebCatalog Beta... (1997) OT: need perl help, and question about switches (2007) [OT] Stuff (2002) WebCat2.0 [format thousands .0f] no go (1997) Securing/hiding database file (2000) Formulas.db + Users.db (1997) smithmicro.com website? (2004) RE: WebDNA-Talk searchable? (1997) Interpreting WebDNA tags (2004) CyberCash Transaction Cost (1999) unable to launch acgi in WebCat (1997) WebCatalog for guestbook ? (1997) NT considerations (1997) Heads up: WebCatalog 4 drops MacTCP, 68K (2000) WebCat2b12 CGI Mac - [shownext] problem (1997) Random Links (2004) [WebDNA] No more SQL in 7.1? (2012) Search bug. Help (2002)