[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-17007A72A3B0Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiHi GuysI have a product db that sells different product to different regions.The db looks something like thisSKU PRODUCTNAME REGION1 red .com;2 blue .com;.com.au;3 green .com.au;4 yellow .co.ukAs 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 thoughThis 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 TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au--Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiHi =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=3D=ww®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
=div>
=--Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiHi GuysI have a product db that sells different product to different regions.The db looks something like thisSKU PRODUCTNAME REGION1 red .com;2 blue .com;.com.au;3 green .com.au;4 yellow .co.ukAs 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 thoughThis 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 TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au--Apple-Mail=_10E1F601-FDCA-4107-A3DD-17007A72A3B0Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiHi =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=3D=ww®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 :)