Re: [WebDNA] WA,WO or how to find products with multiple selects ....

This WebDNA talk-list message is from

2018


It keeps the original formatting.
numero = 114367
interpreted = N
texte = 1984 --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I did a table also formed from the formvaribles of the search which = created a table like this one: Searchnamevalue=09 WAhdd_SeriesRed WAhdd_Cache32MB WAhdd_connectivitySATA III WOhdd_capacity1TB 2TB=20 WOhdd_rpm5400 5900=20 and it decide if it=E2=80=99ll need to be WA or WO and then from this = it=E2=80=99s suppose to work on the main DB below What you offer is to build a table also with the products ? somehow i = believe that the fastest way is 1 search on one DB if there is no = limitation of the amount of =E2=80=9Cgroup1=E2=80=A6..100Field=E2=80=9D i know i have a conceptual problem and i try to find the fastest way to = draw the data. Yours, Yariv > On 16 Aug 2018, at 11:17, Lawrence Banahan = wrote: >=20 > In your case I would make several db for each kind of stuff. Each dB = would be faster to open and search. > If you want to keep going with your actual db I think that the best = solution would be to use a table. > Once you have the first search you store everything in a table, then = you make your different search from that table. >=20 > Lawrence >=20 > Le jeu. 16 ao=C3=BBt 2018 =C3=A0 09:22, Office > a =C3=A9crit : > Then the problem will grow >=20 > I just gave a sample of 6 hard drives that have around 10 types of = variables > But then i have also Monitors with 10 other ones, And another 20 for = computer motherboards and another 10 for memories =E2=80=A6.. >=20 > All together i have 200-400 different families of variables and each = of them with 3-20 options and it=E2=80=99ll be crazy to open fields for = all of it. >=20 > I search for a way to make a search on one field to rule them all. or = any other smarter fast method. >=20 > i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D field = that look like that: and this one processed into the DATA: >=20 > skuattribute_codeattribute_valuelast_updatelast_update_at= ipproduct_catproduct_divproduct_slfproduct_mfg= sort_order > WD10EFRXhdd_capacity1TB21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD10EFRXhdd_rpmIntelliPower21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD10EFRXhdd_Cache64MB21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD10EFRXhdd_SeriesRed21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD10EFRXhdd_connectivitySATA III21/07/2018= 12:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD10EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:49:27141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD20EFRXhdd_capacity2TB21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD20EFRXhdd_rpmIntelliPower21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD20EFRXhdd_Cache64MB21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD20EFRXhdd_SeriesRed21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD20EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:49:54141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD20EFRXhdd_connectivitySATA III21/07/2018= 12:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD30EFRXhdd_capacity3TB21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD30EFRXhdd_rpmIntelliPower21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD30EFRXhdd_Cache64MB21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD30EFRXhdd_SeriesRed21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD30EFRXhdd_connectivitySATA III21/07/2018= 12:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD40EFRXhdd_capacity4TB21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD40EFRXhdd_rpmIntelliPower21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD40EFRXhdd_Cache64MB21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD40EFRXhdd_SeriesRed21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD40EFRXhdd_connectivitySATA III21/07/2018= 12:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD40EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:51:13141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD60EFRXhdd_capacity6TB21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD60EFRXhdd_rpmIntelliPower21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD60EFRXhdd_Cache64MB21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD60EFRXhdd_SeriesRed21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD60EFRXhdd_connectivitySATA III21/07/2018= 12:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD60EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:51:29141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD30EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201814:40:33141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 >=20 >=20 >=20 >=20 >> On 16 Aug 2018, at 9:58, Lawrence Banahan > wrote: >>=20 >> Hello Yariv, >> Your problem is your database. >> You should have one column to search for one type of data. >> Not one field with all the stuff put in it >>=20 >> Lawrence >>=20 >> Le jeu. 16 ao=C3=BBt 2018 =C3=A0 08:09, Office > a =C3=A9crit : >> I have a DB file of products that look like that >> I made 2 type of delimiters. the =E2=80=9C|=E2=80=9D between each = subject and =E2=80=9C,=E2=80=9D between the =E2=80=9CName=E2=80=9D and = the =E2=80=9CValue=E2=80=9D. I hope i did it smartly :-) >>=20 >> idxskudata >> 1WD40EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 2WD20EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,2TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_Series,Red|hdd= _connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 = =D7=A9=D7=A0=D7=99=D7=9D|mfg,Western Digital >> 3WD10EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,1TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 4WD10EZEX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,1TB|hdd_rpm,7200|hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,SATA = III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western = Digital >> 5WD30EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 6WD60EFRX= hdd_dimension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99|hdd_ca= pacity,6TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connecti= vity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D= |mfg,Western Digital >>=20 >> i made a page (under construction) to find stuff but i have many = issues with it >> https://www.plonter.com/att.tmpl >>=20 >> i want to be able to search multiple searches. i need many searches = on the same field in order to find all the products which fits to my = demands. >>=20 >> Like all the =E2=80=9Chdd_capacity=E2=80=9D which are =E2=80=9C1TB" = & =E2=80=9C2TB" Which are also "hdd_Series" =E2=80=9CRed=E2=80=9D and = (it=E2=80=99s easy when you do WO to the 1TB,2TB and WA to the Red) >> But in order to search the =E2=80=9CDATA=E2=80=9D field few times it = seems like i need to put the field DATA inside a Group1Field ? >> But if i put the DATA field in group1 i need to put it also in = group2,3,4,5,6,7,8,9=E2=80=A6=E2=80=A6 in order to be able to fine 10 = options or more. >>=20 >> When i=E2=80=99m searching for 1TB & Red (One option from each = different variable) it works fine. >>=20 >> After playing with it for few hours i didn=E2=80=99t manage to make = it work and i guess something is really wrong with what i do ? >>=20 >> Another issue is to transfer the selections to the next page but this = will be the next issue :-) >>=20 >> Please advice, >>=20 >> Yours, >>=20 >> Yariv Nachshon >> http://www.plonter.co.il >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list talk@webdna.us To unsubscribe, = E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: support@webdna.us --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 I = did a table also formed from the formvaribles of the search which = created a table like this one:

Search= namevalue
WA= hdd_SeriesRed
=09 WAhdd_Cache32MB
=09 WAhdd_connectivitySATA III
=09 WOhdd_capacity1TB 2TB
=09 WOhdd_rpm5400 5900 

and it decide if it=E2=80=99= ll need to be WA or WO and then from this it=E2=80=99s suppose to work = on the main DB below

What you offer is to build a table also with the products ? = somehow i believe that the fastest way is 1 search on one DB if there is = no limitation of the amount of =E2=80=9Cgroup1=E2=80=A6..100Field=E2=80=9D=

i know i have = a conceptual problem and i try to find the fastest way to draw the = data.

Yours,

Yariv


On 16 Aug 2018, at 11:17, Lawrence Banahan = <banahan.l@gmail.com> wrote:

In your case I would make several db for each kind of stuff. = Each dB would be faster to open and search.
If= you want to keep going with your actual db I think that the best = solution would be to use a table.
Once = you have the first search you store everything in a table, then you make = your different search from that table.

Lawrence

Le jeu. 16 ao=C3=BBt = 2018 =C3=A0 09:22, Office <yariv.n@gmail.com> a =C3=A9crit :
Then the problem will grow

I just gave a sample of 6 hard drives = that have around 10 types of variables
But then i = have also Monitors with 10 other ones, And another 20 for computer = motherboards and another 10 for memories =E2=80=A6..

All together i have = 200-400 different families of variables and each of them with 3-20 = options and it=E2=80=99ll be crazy to open fields for all of = it.

I search = for a way to make a search on one field to rule them all. or any other = smarter fast method.

i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D = field that look like that: and this one processed into the = DATA:

skuattribute_codeattribute_valuelast_updatelast_update_atipproduct_catproduct_divproduct_slfproduct_mfgsort_order
WD10EFRXhdd_capacity1TB21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD10EFRXhdd_rpmIntelliPower21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD10EFRXhdd_Cache64MB21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD10EFRXhdd_SeriesRed21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD10EFRXhdd_connectivitySATA III21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD10EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:49:27141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD20EFRXhdd_capacity2TB21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD20EFRXhdd_rpmIntelliPower21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD20EFRXhdd_Cache64MB21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD20EFRXhdd_SeriesRed21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD20EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:49:54141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD20EFRXhdd_connectivitySATA III21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD30EFRXhdd_capacity3TB21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD30EFRXhdd_rpmIntelliPower21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD30EFRXhdd_Cache64MB21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD30EFRXhdd_SeriesRed21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD30EFRXhdd_connectivitySATA III21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD40EFRXhdd_capacity4TB21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD40EFRXhdd_rpmIntelliPower21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD40EFRXhdd_Cache64MB21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD40EFRXhdd_SeriesRed21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD40EFRXhdd_connectivitySATA III21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD40EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:13141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD60EFRXhdd_capacity6TB21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD60EFRXhdd_rpmIntelliPower21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD60EFRXhdd_Cache64MB21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD60EFRXhdd_SeriesRed21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD60EFRXhdd_connectivitySATA III21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD60EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:29141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD30EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201814:40:33141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6




On 16 = Aug 2018, at 9:58, Lawrence Banahan <banahan.l@gmail.com> wrote:

Hello Yariv,
Your problem is your database.
You should have one column to search for one type of = data.
Not one field with all the stuff = put in it

Lawrence

Le jeu. 16 ao=C3=BBt = 2018 =C3=A0 08:09, Office <yariv.n@gmail.com> = a =C3=A9crit :
I have a DB file of = products that look like that
I made 2 type of delimiters. = the =E2=80=9C|=E2=80=9D between each subject and =E2=80=9C,=E2=80= =9D between the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2= =80=9D. I hope i did it smartly :-)

idxskudata
1WD40EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
2WD20EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,2TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_Series,= Red|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
3WD10EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,1TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
4WD10EZEX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,1TB|hdd_rpm,7200|hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western = Digital
5WD30EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
6WD60EFRX= hdd_dimension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99= |hdd_capacity,6TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_c= onnectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital

i made a page (under construction) = to find stuff but i have many issues with it

i want to be able to search multiple searches. i need many = searches on the same field in order to find all the products which fits = to my demands.

Like all the =E2=80=9Chdd_capacit= y=E2=80=9D which are  =E2=80=9C1TB" & =E2=80=9C2TB" = Which are also "hdd_Series"  =E2=80=9CRed=E2=80=9D and  (it=E2=80=99s easy = when you do WO to the 1TB,2TB and WA to the Red)
But in order to = search the =E2=80=9CDATA=E2=80=9D field few times it seems like i = need to put the field DATA inside a Group1Field ?
But if i put the = DATA field in group1 i need to put it also in group2,3,4,5,6,7,8,9=E2=80=A6= =E2=80=A6 in order to be able to fine 10 options or = more.

When i=E2=80=99m searching f= or 1TB & Red (One option from each different variable) it works = fine.

After playing with = it for few hours i didn=E2=80=99t manage to make it work and i guess = something is really wrong with what i do ?

Another issue is to transfer the = selections to the next page but this will be the next issue = :-)

Please advice,

Yours,

Yariv = Nachshon
http://www.plonter.co.il

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Office 2018)
  2. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Lawrence Banahan 2018)
  3. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Office 2018)
  4. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Lawrence Banahan 2018)
  5. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Office 2018)
  6. Re: [WebDNA] WA,WO or how to find products with multiple selects .... (Lawrence Banahan 2018)
  7. [WebDNA] WA,WO or how to find products with multiple selects .... (Office 2018)
1984 --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I did a table also formed from the formvaribles of the search which = created a table like this one: Searchnamevalue=09 WAhdd_SeriesRed WAhdd_Cache32MB WAhdd_connectivitySATA III WOhdd_capacity1TB 2TB=20 WOhdd_rpm5400 5900=20 and it decide if it=E2=80=99ll need to be WA or WO and then from this = it=E2=80=99s suppose to work on the main DB below What you offer is to build a table also with the products ? somehow i = believe that the fastest way is 1 search on one DB if there is no = limitation of the amount of =E2=80=9Cgroup1=E2=80=A6..100Field=E2=80=9D i know i have a conceptual problem and i try to find the fastest way to = draw the data. Yours, Yariv > On 16 Aug 2018, at 11:17, Lawrence Banahan = wrote: >=20 > In your case I would make several db for each kind of stuff. Each dB = would be faster to open and search. > If you want to keep going with your actual db I think that the best = solution would be to use a table. > Once you have the first search you store everything in a table, then = you make your different search from that table. >=20 > Lawrence >=20 > Le jeu. 16 ao=C3=BBt 2018 =C3=A0 09:22, Office > a =C3=A9crit : > Then the problem will grow >=20 > I just gave a sample of 6 hard drives that have around 10 types of = variables > But then i have also Monitors with 10 other ones, And another 20 for = computer motherboards and another 10 for memories =E2=80=A6.. >=20 > All together i have 200-400 different families of variables and each = of them with 3-20 options and it=E2=80=99ll be crazy to open fields for = all of it. >=20 > I search for a way to make a search on one field to rule them all. or = any other smarter fast method. >=20 > i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D field = that look like that: and this one processed into the DATA: >=20 > skuattribute_codeattribute_valuelast_updatelast_update_at= ipproduct_catproduct_divproduct_slfproduct_mfg= sort_order > WD10EFRXhdd_capacity1TB21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD10EFRXhdd_rpmIntelliPower21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD10EFRXhdd_Cache64MB21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD10EFRXhdd_SeriesRed21/07/201812:32:51= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD10EFRXhdd_connectivitySATA III21/07/2018= 12:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD10EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:49:27141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD20EFRXhdd_capacity2TB21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD20EFRXhdd_rpmIntelliPower21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD20EFRXhdd_Cache64MB21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD20EFRXhdd_SeriesRed21/07/201812:34:55= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD20EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:49:54141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD20EFRXhdd_connectivitySATA III21/07/2018= 12:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD30EFRXhdd_capacity3TB21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD30EFRXhdd_rpmIntelliPower21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD30EFRXhdd_Cache64MB21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD30EFRXhdd_SeriesRed21/07/201812:35:25= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD30EFRXhdd_connectivitySATA III21/07/2018= 12:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD40EFRXhdd_capacity4TB21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD40EFRXhdd_rpmIntelliPower21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD40EFRXhdd_Cache64MB21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD40EFRXhdd_SeriesRed21/07/201812:35:45= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD40EFRXhdd_connectivitySATA III21/07/2018= 12:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD40EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:51:13141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD60EFRXhdd_capacity6TB21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital1 > WD60EFRXhdd_rpmIntelliPower21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital2 > WD60EFRXhdd_Cache64MB21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital3 > WD60EFRXhdd_SeriesRed21/07/201812:36:12= 141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7= =E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C= =C3=82 SSDSATAWestern Digital4 > WD60EFRXhdd_connectivitySATA III21/07/2018= 12:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98= =C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3= =88=C3=8C =C3=82 SSDSATAWestern Digital5 > WD60EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201808:51:29141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 > WD30EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3= =88=C3=8C22/07/201814:40:33141.226.218.022=C3=81=C3=8F= =CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern = Digital6 >=20 >=20 >=20 >=20 >> On 16 Aug 2018, at 9:58, Lawrence Banahan > wrote: >>=20 >> Hello Yariv, >> Your problem is your database. >> You should have one column to search for one type of data. >> Not one field with all the stuff put in it >>=20 >> Lawrence >>=20 >> Le jeu. 16 ao=C3=BBt 2018 =C3=A0 08:09, Office > a =C3=A9crit : >> I have a DB file of products that look like that >> I made 2 type of delimiters. the =E2=80=9C|=E2=80=9D between each = subject and =E2=80=9C,=E2=80=9D between the =E2=80=9CName=E2=80=9D and = the =E2=80=9CValue=E2=80=9D. I hope i did it smartly :-) >>=20 >> idxskudata >> 1WD40EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 2WD20EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,2TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_Series,Red|hdd= _connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 = =D7=A9=D7=A0=D7=99=D7=9D|mfg,Western Digital >> 3WD10EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,1TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 4WD10EZEX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,1TB|hdd_rpm,7200|hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,SATA = III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western = Digital >> 5WD30EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity= ,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg= ,Western Digital >> 6WD60EFRX= hdd_dimension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99|hdd_ca= pacity,6TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connecti= vity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D= |mfg,Western Digital >>=20 >> i made a page (under construction) to find stuff but i have many = issues with it >> https://www.plonter.com/att.tmpl >>=20 >> i want to be able to search multiple searches. i need many searches = on the same field in order to find all the products which fits to my = demands. >>=20 >> Like all the =E2=80=9Chdd_capacity=E2=80=9D which are =E2=80=9C1TB" = & =E2=80=9C2TB" Which are also "hdd_Series" =E2=80=9CRed=E2=80=9D and = (it=E2=80=99s easy when you do WO to the 1TB,2TB and WA to the Red) >> But in order to search the =E2=80=9CDATA=E2=80=9D field few times it = seems like i need to put the field DATA inside a Group1Field ? >> But if i put the DATA field in group1 i need to put it also in = group2,3,4,5,6,7,8,9=E2=80=A6=E2=80=A6 in order to be able to fine 10 = options or more. >>=20 >> When i=E2=80=99m searching for 1TB & Red (One option from each = different variable) it works fine. >>=20 >> After playing with it for few hours i didn=E2=80=99t manage to make = it work and i guess something is really wrong with what i do ? >>=20 >> Another issue is to transfer the selections to the next page but this = will be the next issue :-) >>=20 >> Please advice, >>=20 >> Yours, >>=20 >> Yariv Nachshon >> http://www.plonter.co.il >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list talk@webdna.us To unsubscribe, = E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: support@webdna.us --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 I = did a table also formed from the formvaribles of the search which = created a table like this one:

Search= namevalue
WA= hdd_SeriesRed
=09 WAhdd_Cache32MB
=09 WAhdd_connectivitySATA III
=09 WOhdd_capacity1TB 2TB
=09 WOhdd_rpm5400 5900 

and it decide if it=E2=80=99= ll need to be WA or WO and then from this it=E2=80=99s suppose to work = on the main DB below

What you offer is to build a table also with the products ? = somehow i believe that the fastest way is 1 search on one DB if there is = no limitation of the amount of =E2=80=9Cgroup1=E2=80=A6..100Field=E2=80=9D=

i know i have = a conceptual problem and i try to find the fastest way to draw the = data.

Yours,

Yariv


On 16 Aug 2018, at 11:17, Lawrence Banahan = <banahan.l@gmail.com> wrote:

In your case I would make several db for each kind of stuff. = Each dB would be faster to open and search.
If= you want to keep going with your actual db I think that the best = solution would be to use a table.
Once = you have the first search you store everything in a table, then you make = your different search from that table.

Lawrence

Le jeu. 16 ao=C3=BBt = 2018 =C3=A0 09:22, Office <yariv.n@gmail.com> a =C3=A9crit :
Then the problem will grow

I just gave a sample of 6 hard drives = that have around 10 types of variables
But then i = have also Monitors with 10 other ones, And another 20 for computer = motherboards and another 10 for memories =E2=80=A6..

All together i have = 200-400 different families of variables and each of them with 3-20 = options and it=E2=80=99ll be crazy to open fields for all of = it.

I search = for a way to make a search on one field to rule them all. or any other = smarter fast method.

i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D = field that look like that: and this one processed into the = DATA:

skuattribute_codeattribute_valuelast_updatelast_update_atipproduct_catproduct_divproduct_slfproduct_mfgsort_order
WD10EFRXhdd_capacity1TB21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD10EFRXhdd_rpmIntelliPower21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD10EFRXhdd_Cache64MB21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD10EFRXhdd_SeriesRed21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD10EFRXhdd_connectivitySATA III21/07/201812:32:51141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD10EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:49:27141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD20EFRXhdd_capacity2TB21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD20EFRXhdd_rpmIntelliPower21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD20EFRXhdd_Cache64MB21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD20EFRXhdd_SeriesRed21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD20EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:49:54141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD20EFRXhdd_connectivitySATA III21/07/201812:34:55141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD30EFRXhdd_capacity3TB21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD30EFRXhdd_rpmIntelliPower21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD30EFRXhdd_Cache64MB21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD30EFRXhdd_SeriesRed21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD30EFRXhdd_connectivitySATA III21/07/201812:35:25141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD40EFRXhdd_capacity4TB21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD40EFRXhdd_rpmIntelliPower21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD40EFRXhdd_Cache64MB21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD40EFRXhdd_SeriesRed21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD40EFRXhdd_connectivitySATA III21/07/201812:35:45141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD40EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:13141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD60EFRXhdd_capacity6TB21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital1
WD60EFRXhdd_rpmIntelliPower21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital2
WD60EFRXhdd_Cache64MB21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital3
WD60EFRXhdd_SeriesRed21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital4
WD60EFRXhdd_connectivitySATA III21/07/201812:36:12141.226.009.023=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital5
WD60EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:29141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6
WD30EFRXhdd_warranty=CB=98=C3=8F=C3=82=CB=98 = =CB=98=EF=A3=BF=C3=88=C3=8C22/07/201814:40:33141.226.218.022=C3=81=C3=8F=CB=9C=C3=88 = =C3=93=C3=81=CB=98=C2=B7=E2=80=9E=C3=88=C3=92=CB=9C=C3=88=C3= =8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C =C3=82 SSDSATAWestern Digital6




On 16 = Aug 2018, at 9:58, Lawrence Banahan <banahan.l@gmail.com> wrote:

Hello Yariv,
Your problem is your database.
You should have one column to search for one type of = data.
Not one field with all the stuff = put in it

Lawrence

Le jeu. 16 ao=C3=BBt = 2018 =C3=A0 08:09, Office <yariv.n@gmail.com> = a =C3=A9crit :
I have a DB file of = products that look like that
I made 2 type of delimiters. = the =E2=80=9C|=E2=80=9D between each subject and =E2=80=9C,=E2=80= =9D between the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2= =80=9D. I hope i did it smartly :-)

idxskudata
1WD40EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
2WD20EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,2TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_Series,= Red|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
3WD10EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,1TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
4WD10EZEX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,1TB|hdd_rpm,7200|hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,S= ATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western = Digital
5WD30EFRX= hdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_c= apacity,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_connect= ivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital
6WD60EFRX= hdd_dimension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99= |hdd_capacity,6TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_c= onnectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital

i made a page (under construction) = to find stuff but i have many issues with it

i want to be able to search multiple searches. i need many = searches on the same field in order to find all the products which fits = to my demands.

Like all the =E2=80=9Chdd_capacit= y=E2=80=9D which are  =E2=80=9C1TB" & =E2=80=9C2TB" = Which are also "hdd_Series"  =E2=80=9CRed=E2=80=9D and  (it=E2=80=99s easy = when you do WO to the 1TB,2TB and WA to the Red)
But in order to = search the =E2=80=9CDATA=E2=80=9D field few times it seems like i = need to put the field DATA inside a Group1Field ?
But if i put the = DATA field in group1 i need to put it also in group2,3,4,5,6,7,8,9=E2=80=A6= =E2=80=A6 in order to be able to fine 10 options or = more.

When i=E2=80=99m searching f= or 1TB & Red (One option from each different variable) it works = fine.

After playing with = it for few hours i didn=E2=80=99t manage to make it work and i guess = something is really wrong with what i do ?

Another issue is to transfer the = selections to the next page but this will be the next issue = :-)

Please advice,

Yours,

Yariv = Nachshon
http://www.plonter.co.il

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_5CAF7305-2DA8-4858-9C31-E079E93935F0-- . Office

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:

Adding non-SKUs to cart (1998) creative use of webcatalog (1998) WC2b15 File Corruption (1997) [WebDNA] Reserved Cart Headers (2008) Nested vs conditional (1997) Re:Version 2.0 and 1.6 simultaneous (1997) Sort Order on a page search (1997) Email Set-Up? (1997) expire headers in mac305b11 (1999) & problem (1999) A few questions. . . (1997) Clean Code: Rules for inserting keyboard returns? (1997) converting characters in form (1997) WebCat Contest Now: Encrypt and Sell (1998) New servers and new inline cache (1997) WebCatalog NT beta 18 problem (1997) WCS Newbie question (1997) WebCat2 several catalogs? (1997) PCS Frames-Default page is solution! (1997) [WebDNA] WebDNA Showcase? (2008)