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 = 114366
interpreted = N
texte = 1983 --00000000000050124c0573891514 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 a =C3=A9= crit : > 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: > > sku attribute_code attribute_value last_update last_update_at ip > product_cat product_div product_slf product_mfg sort_order > WD10EFRX hdd_capacity 1TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD10EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD10EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD10EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD10EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD10EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:49:27 141.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 SSD SATA Western Digital 6 > WD20EFRX hdd_capacity 2TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD20EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD20EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD20EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD20EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:49:54 141.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 SSD SATA Western Digital 6 > WD20EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD30EFRX hdd_capacity 3TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD30EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD30EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD30EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD30EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD40EFRX hdd_capacity 4TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD40EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD40EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD40EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD40EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD40EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:51:13 141.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 SSD SATA Western Digital 6 > WD60EFRX hdd_capacity 6TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD60EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD60EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD60EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD60EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD60EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:51:29 141.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 SSD SATA Western Digital 6 > WD30EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 14:40:33 141.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 SSD SATA Western Digital 6 > > > > > On 16 Aug 2018, at 9:58, Lawrence Banahan 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 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 subjec= t 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 :-) >> >> idx sku data >> 1 WD40EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 2 WD20EFRX 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_Se= ries,Red|hdd_connectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 3 WD10EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 4 WD10EZEX 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_connectiv= ity,SATA >> III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digita= l >> 5 WD30EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 6 WD60EFRX 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_connectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> >> i made a page (under construction) to find stuff but i have many issues >> with it >> https://www.plonter.com/att.tmpl >> >> 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 demand= s. >> >> 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 W= O 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 see= ms 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 op= tions or more. >> >> When i=E2=80=99m searching for 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 w= ork 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 i= s >> sent to you because you are subscribed to the mailing list talk@webdna.u= s >> 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.u= s > > > --------------------------------------------------------- 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.u= s --00000000000050124c0573891514 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In your case I would make several db for each kind of stu= ff. Each dB would be faster to open and search.
If you wan= t 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 201= 8 =C3=A0 09:22, Office <yariv.n@gma= il.com> a =C3=A9crit=C2=A0:
=
Then the p= roblem will grow

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

All together i have 2= 00-400 different families of variables and each of them with 3-20 options a= nd 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 t= hat 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_atipprodu= ct_catproduct_divproduct_slfproduct_mfgsort_order
WD10EFRXhdd_capacity1TB21/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 SSD= SATAWestern Digital1
WD10E= FRXhdd_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_SeriesRed= 21/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_w= arranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3=8C= 22/07/201808:49:27141.226.2= 18.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 Digit= al6
WD20EFRXhdd_capacity= 2TB21/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 SSDSATAW= estern Digital1
WD20EFRXhdd_rpmIntelliPower21/07/201812:34:5= 5141.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 SSDSATA<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">Western Digital2
WD20EFRX= hdd_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
WD20EFR= Xhdd_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 SSDSA= TAWestern Digital6
WD20EFRXhdd_connectivitySATA III21/07/201= 812: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 SSD= SATAWestern Digital5
<= div>WD30EFRXhdd_capacity3TB= 21/07/201812:35:25141.226.009.023<= /span>=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 Digital<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">2
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_c= onnectivitySATA 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
WD= 40EFRXhdd_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_Cache64MB= 21/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_SeriesRed= 21/07/201812:35:45141.226.0= 09.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 Digit= al4
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.22= 6.218.022=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">=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 Di= gital6
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_r= pmIntelliPower21/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 SSDSA= TAWestern Digital2
WD60EFRXhdd_Cache64MB21/07/2018<= /span>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 SSD= SATAWestern Digital3
WD60E= FRXhdd_SeriesRed21/07/2018<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">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 SSD= SATAWestern Digital4
<= div>WD60EFRXhdd_connectivitySATA III21/07/201812:36:12141.226.009.023<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">=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/2= 01808: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
<= br>



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 st= uff put in it

Lawrence

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

idxskudata
1WD40EFRXhdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|h= dd_capacity,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_conn= ectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
2WD20EFRXhdd_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_Serie= s,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,Wes= tern Digital
3WD10EFRXhdd_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_Serie= s,Red|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
4WD10EZEXhdd_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|h= dd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital<= br>5WD30EFRXhdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hd= d_capacity,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_conne= ctivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
6WD60EFRXhdd_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_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital

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

i want to be able to search multiple searches. i nee= d many searches on the same field in order to find all the products which f= its to my demands.

Like all the=C2=A0=E2=80=9Chdd= _capacity=E2=80=9D which are=C2=A0=C2=A0=E2=80=9C1TB" &=C2=A0=E2= =80=9C2TB" Which are also "= hdd_Series"=C2=A0 =E2=80=9CRed= =E2=80=9D and =C2=A0(it=E2=80=99s easy when you do WO to the 1TB,2TB and WA= to the Red)
But in order t= o search the=C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems like i ne= ed 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=C2=A0search= ing=C2=A0for 1TB & Red (One option from each different variable) it wor= ks fine.

Aft= er playing with it for few hours i didn=E2=80=99t manage to make it work an= d i guess something is=C2=A0really=C2=A0wrong with what i do ?
=

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

Please advice,

Yours,

Yariv Nachshon

--------------------------------------------------------- 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 --00000000000050124c0573891514-- . 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)
1983 --00000000000050124c0573891514 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 a =C3=A9= crit : > 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: > > sku attribute_code attribute_value last_update last_update_at ip > product_cat product_div product_slf product_mfg sort_order > WD10EFRX hdd_capacity 1TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD10EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD10EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD10EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD10EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD10EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:49:27 141.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 SSD SATA Western Digital 6 > WD20EFRX hdd_capacity 2TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD20EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD20EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD20EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD20EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:49:54 141.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 SSD SATA Western Digital 6 > WD20EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD30EFRX hdd_capacity 3TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD30EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD30EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD30EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD30EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD40EFRX hdd_capacity 4TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD40EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD40EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD40EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD40EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD40EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:51:13 141.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 SSD SATA Western Digital 6 > WD60EFRX hdd_capacity 6TB 21/07/2018 12: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 SSD SATA Western Digital 1 > WD60EFRX hdd_rpm IntelliPower 21/07/2018 12: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 SSD SATA Western Digital 2 > WD60EFRX hdd_Cache 64MB 21/07/2018 12: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 SSD SATA Western Digital 3 > WD60EFRX hdd_Series Red 21/07/2018 12: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 SSD SATA Western Digital 4 > WD60EFRX hdd_connectivity SATA III 21/07/2018 12: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 SSD SATA Western Digital 5 > WD60EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 08:51:29 141.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 SSD SATA Western Digital 6 > WD30EFRX hdd_warranty =CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3= =8C 22/07/2018 14:40:33 141.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 SSD SATA Western Digital 6 > > > > > On 16 Aug 2018, at 9:58, Lawrence Banahan 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 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 subjec= t 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 :-) >> >> idx sku data >> 1 WD40EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 2 WD20EFRX 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_Se= ries,Red|hdd_connectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 3 WD10EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 4 WD10EZEX 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_connectiv= ity,SATA >> III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digita= l >> 5 WD30EFRX 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_co= nnectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> 6 WD60EFRX 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_connectivity,SATA >> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,W= estern Digital >> >> i made a page (under construction) to find stuff but i have many issues >> with it >> https://www.plonter.com/att.tmpl >> >> 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 demand= s. >> >> 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 W= O 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 see= ms 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 op= tions or more. >> >> When i=E2=80=99m searching for 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 w= ork 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 i= s >> sent to you because you are subscribed to the mailing list talk@webdna.u= s >> 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.u= s > > > --------------------------------------------------------- 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.u= s --00000000000050124c0573891514 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In your case I would make several db for each kind of stu= ff. Each dB would be faster to open and search.
If you wan= t 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 201= 8 =C3=A0 09:22, Office <yariv.n@gma= il.com> a =C3=A9crit=C2=A0:
=
Then the p= roblem will grow

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

All together i have 2= 00-400 different families of variables and each of them with 3-20 options a= nd 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 t= hat 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_atipprodu= ct_catproduct_divproduct_slfproduct_mfgsort_order
WD10EFRXhdd_capacity1TB21/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 SSD= SATAWestern Digital1
WD10E= FRXhdd_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_SeriesRed= 21/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_w= arranty=CB=98=C3=8F=C3=82=CB=98 =CB=98=EF=A3=BF=C3=88=C3=8C= 22/07/201808:49:27141.226.2= 18.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 Digit= al6
WD20EFRXhdd_capacity= 2TB21/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 SSDSATAW= estern Digital1
WD20EFRXhdd_rpmIntelliPower21/07/201812:34:5= 5141.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 SSDSATA<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">Western Digital2
WD20EFRX= hdd_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
WD20EFR= Xhdd_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 SSDSA= TAWestern Digital6
WD20EFRXhdd_connectivitySATA III21/07/201= 812: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 SSD= SATAWestern Digital5
<= div>WD30EFRXhdd_capacity3TB= 21/07/201812:35:25141.226.009.023<= /span>=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 Digital<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">2
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_c= onnectivitySATA 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
WD= 40EFRXhdd_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_Cache64MB= 21/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_SeriesRed= 21/07/201812:35:45141.226.0= 09.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 Digit= al4
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.22= 6.218.022=C3=81=C3=8F=CB=9C=C3=88 =C3=93=C3=81=CB=98=C2=B7<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">=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 Di= gital6
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_r= pmIntelliPower21/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 SSDSA= TAWestern Digital2
WD60EFRXhdd_Cache64MB21/07/2018<= /span>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 SSD= SATAWestern Digital3
WD60E= FRXhdd_SeriesRed21/07/2018<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">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 SSD= SATAWestern Digital4
<= div>WD60EFRXhdd_connectivitySATA III21/07/201812:36:12141.226.009.023<= span class=3D"m_4314865709412783450Apple-tab-span" style=3D"white-space:pre= -wrap">=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/2= 01808: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
<= br>



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 st= uff put in it

Lawrence

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

idxskudata
1WD40EFRXhdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|h= dd_capacity,4TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_conn= ectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
2WD20EFRXhdd_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_Serie= s,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,Wes= tern Digital
3WD10EFRXhdd_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_Serie= s,Red|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
4WD10EZEXhdd_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|h= dd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital<= br>5WD30EFRXhdd_dimension,3.5|hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hd= d_capacity,3TB|hdd_rpm,IntelliPower|hdd_Cache,64MB|hdd_Series,Red|hdd_conne= ctivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital
6WD60EFRXhdd_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_connectivity,SATA III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,Wes= tern Digital

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

i want to be able to search multiple searches. i nee= d many searches on the same field in order to find all the products which f= its to my demands.

Like all the=C2=A0=E2=80=9Chdd= _capacity=E2=80=9D which are=C2=A0=C2=A0=E2=80=9C1TB" &=C2=A0=E2= =80=9C2TB" Which are also "= hdd_Series"=C2=A0 =E2=80=9CRed= =E2=80=9D and =C2=A0(it=E2=80=99s easy when you do WO to the 1TB,2TB and WA= to the Red)
But in order t= o search the=C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems like i ne= ed 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=C2=A0search= ing=C2=A0for 1TB & Red (One option from each different variable) it wor= ks fine.

Aft= er playing with it for few hours i didn=E2=80=99t manage to make it work an= d i guess something is=C2=A0really=C2=A0wrong with what i do ?
=

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

Please advice,

Yours,

Yariv Nachshon

--------------------------------------------------------- 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 --00000000000050124c0573891514-- . Lawrence Banahan

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:

webcat plugin issue (2001) Emailer setup (1997) Unexpected error (1997) Moment of Thanks (1997) DB Size - MAX (2004) EmailProblem vs EmailComplete (2000) WebCatalog for guestbook ? (1997) BBedit prefs (2002) [OT] Death Clock (2003) [GetRate 1.2] - Any problem? (1999) Secure Server (1997) Other tags inside the founditems context? (1998) multi-paragraph fields (1997) Error -108 (1997) [WebDNA] Group results but continuous (2016) TCPconnect in a DB? (1999) Pre-flight public flag (1997) access denied problem (1997) Lineitems [text*] (2004) too many nested tags ... (1997)