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 trysomething like:[founditems][listwords words=3D[region]&delimiter=3D;][showif [word]=3D.com][/showif][/listwords][/founditems]BillOn 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:
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 trysomething like:[founditems][listwords words=3D[region]&delimiter=3D;][showif [word]=3D.com][/showif][/listwords][/founditems]BillOn 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)