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 = 114369
interpreted = N
texte = 1986 --00000000000029350505738fc1b8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I would make the table the other way round with the form name has the name of the table column Le jeu. 16 ao=C3=BBt 2018 =C3=A0 10:51, Office a =C3=A9= crit : > I did a table also formed from the formvaribles of the search which > created a table like this one: > > Search name value > WA hdd_Series Red > WA hdd_Cache 32MB > WA hdd_connectivity SATA III > WO hdd_capacity 1TB 2TB > WO hdd_rpm 5400 5900 > > 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: > > In your case I would make several db for each kind of stuff. Each dB woul= d > 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= =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 an= y >> other smarter fast method. >> >> i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D field tha= t 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 subje= ct and =E2=80=9C,=E2=80=9D >>> between the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2=80=9D. I h= ope 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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= _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 >>> 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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_connec= tivity,SATA >>> III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digit= al >>> 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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,R= ed|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 >>> >>> 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 deman= ds. >>> >>> 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 se= ems 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 o= ptions or more. >>> >>> When i=E2=80=99m searching for 1TB & Red (One option from each differen= t >>> 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 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 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 --00000000000029350505738fc1b8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I would make the table the other way round with the form = name has the name of the table column

<= div dir=3D"ltr">Le jeu. 16 ao=C3=BBt 2018 =C3=A0 10:51, Office <yariv.n@gmail.com> a =C3=A9crit=C2=A0:=
I did a table also formed from the formvarib= les of the search which created a table like this one:

S= earchnamevalue
WAhdd_SeriesRed
=09 WAhdd_Cache32MB
=09 WAhdd_connectivitySATA III
=09 WOhdd_capacity1TB 2TB
=09 WOhdd_rpm5400 5900=C2=A0

and it decide if it=E2= =80=99ll need to be WA or WO and then from this it=E2=80=99s suppose to wor= k 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=9Cgrou= p1=E2=80=A6..100Field=E2=80=9D

i know i have a con= ceptual 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 w= ith your actual db I think that the best solution would be to use a table.<= /div>
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, O= ffice <yariv.n@gmail.com> a =C3=A9crit=C2=A0:
Then the problem will grow

I just gave a sampl= e of 6 hard drives that have around 10 types of variables
But the= n i have also Monitors with 10 other ones, And another 20 for computer moth= erboards and another 10 for memories =E2=80=A6..

A= ll 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_value<= /span>last_updatelast_update_atipp= roduct_catproduct_divproduct_slfprod= uct_mfgsort_order
WD10EFRXhdd_capacity1TB21/07/2018<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">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 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_Cach= e64MB<= /span>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 Digital3
WD10EFRXhdd_S= eriesRed21/07/201812:32:51141.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 SSDSATA<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">Western Digital4
WD10EFRXhd= d_connectivitySATA III21/07/201812:3= 2: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_capa= city2TB= 21/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_r= pmIntelliPower21/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:55<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">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
WD20EFRX= hdd_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 SSD= SATAWestern Digital4
WD20EFRXhdd_warranty=CB=98=C3=8F=C3= =82=CB=98 =CB=98=EF=A3=BF=C3=88=C3=8C= 22/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 Digital<= /span>6
WD20EFRXhdd_connect= ivitySATA 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:2= 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 SSDSATAWestern Digital1
WD30EFRX= hdd_rpmIntelliPower21/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 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 Digital<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">3
WD30EFRXhdd_SeriesRed21/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 Digit= al4
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
WD40EFRX= hdd_capacity4TB21/07/201812:35:4514= 1.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
WD40E= FRXhdd_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/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 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 Digital= 4
WD40EFRXhdd_connectivity<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">SATA III= 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 Digital5
WD40EFRXhdd_w= arranty=CB=98=C3=8F=C3=82=CB=98 =CB= =98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:13<= /span>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 SSDSATAWestern Digital6
=
WD60EFRXhdd_capacity6TB21/07/2= 01812: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 Digital= 1
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_Cach= e64MB<= /span>21/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_S= eriesRed21/07/201812:36:12141.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 SSDSATA<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">Western Digital4
WD60EFRXhd= d_connectivitySATA III21/07/201812:3= 6: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_warr= anty=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.
<= div dir=3D"auto">Not one field with all the stuff put in it

Lawrence

Le jeu. 16 ao=C3=BBt 2018 =C3=A0 08:09, Offi= ce <yariv.n@gmail.com> a =C3=A9crit=C2=A0:
I have a DB file of produc= ts that look like that
I mad= e 2 type of delimiters. the=C2=A0=E2=80=9C|=E2=80=9D between each subject a= nd=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
= 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_connecti= vity,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_dim= ension,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_connecti= vity,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_dim= ension,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,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_dim= ension,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<= br>5WD30EFRXhdd_dimension,3.5|hd= d_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,3TB|hdd_rpm,IntelliP= ower|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
6WD60EFRXhdd_dim= ension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99|hdd_capacity,6= TB|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 sear= ches. i need many searches on the same field in order to find all the produ= cts which fits 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,2= TB and WA to the Red)
But i= n order to search the=C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems = like i need to put the field DATA inside a Group1Field ?
<= span style=3D"font-size:14px">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 abl= e to fine 10 options or more.

When i=E2=80=99m=C2= =A0searching=C2=A0for 1TB & Red (One option from each different variabl= e) it works fine.

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

Another issue i= s to transfer the selections to the next page but this will be the next iss= ue :-)

Please advice,

Y= ours,

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.d= na?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 --------------------------------------------------------- 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 --00000000000029350505738fc1b8-- . 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)
1986 --00000000000029350505738fc1b8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I would make the table the other way round with the form name has the name of the table column Le jeu. 16 ao=C3=BBt 2018 =C3=A0 10:51, Office a =C3=A9= crit : > I did a table also formed from the formvaribles of the search which > created a table like this one: > > Search name value > WA hdd_Series Red > WA hdd_Cache 32MB > WA hdd_connectivity SATA III > WO hdd_capacity 1TB 2TB > WO hdd_rpm 5400 5900 > > 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: > > In your case I would make several db for each kind of stuff. Each dB woul= d > 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= =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 an= y >> other smarter fast method. >> >> i also have a db that create this crazy =E2=80=9CDATA=E2=80=9D field tha= t 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 subje= ct and =E2=80=9C,=E2=80=9D >>> between the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2=80=9D. I h= ope 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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= _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 >>> 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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_connec= tivity,SATA >>> III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digit= al >>> 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= _connectivity,SATA >>> III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,= Western 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,R= ed|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 >>> >>> 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 deman= ds. >>> >>> 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 se= ems 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 o= ptions or more. >>> >>> When i=E2=80=99m searching for 1TB & Red (One option from each differen= t >>> 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 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 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 --00000000000029350505738fc1b8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I would make the table the other way round with the form = name has the name of the table column

<= div dir=3D"ltr">Le jeu. 16 ao=C3=BBt 2018 =C3=A0 10:51, Office <yariv.n@gmail.com> a =C3=A9crit=C2=A0:=
I did a table also formed from the formvarib= les of the search which created a table like this one:

S= earchnamevalue
WAhdd_SeriesRed
=09 WAhdd_Cache32MB
=09 WAhdd_connectivitySATA III
=09 WOhdd_capacity1TB 2TB
=09 WOhdd_rpm5400 5900=C2=A0

and it decide if it=E2= =80=99ll need to be WA or WO and then from this it=E2=80=99s suppose to wor= k 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=9Cgrou= p1=E2=80=A6..100Field=E2=80=9D

i know i have a con= ceptual 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 w= ith your actual db I think that the best solution would be to use a table.<= /div>
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, O= ffice <yariv.n@gmail.com> a =C3=A9crit=C2=A0:
Then the problem will grow

I just gave a sampl= e of 6 hard drives that have around 10 types of variables
But the= n i have also Monitors with 10 other ones, And another 20 for computer moth= erboards and another 10 for memories =E2=80=A6..

A= ll 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_value<= /span>last_updatelast_update_atipp= roduct_catproduct_divproduct_slfprod= uct_mfgsort_order
WD10EFRXhdd_capacity1TB21/07/2018<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">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 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_Cach= e64MB<= /span>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 Digital3
WD10EFRXhdd_S= eriesRed21/07/201812:32:51141.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 SSDSATA<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">Western Digital4
WD10EFRXhd= d_connectivitySATA III21/07/201812:3= 2: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_capa= city2TB= 21/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_r= pmIntelliPower21/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:55<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">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
WD20EFRX= hdd_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 SSD= SATAWestern Digital4
WD20EFRXhdd_warranty=CB=98=C3=8F=C3= =82=CB=98 =CB=98=EF=A3=BF=C3=88=C3=8C= 22/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 Digital<= /span>6
WD20EFRXhdd_connect= ivitySATA 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:2= 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 SSDSATAWestern Digital1
WD30EFRX= hdd_rpmIntelliPower21/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 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 Digital<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">3
WD30EFRXhdd_SeriesRed21/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 Digit= al4
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
WD40EFRX= hdd_capacity4TB21/07/201812:35:4514= 1.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
WD40E= FRXhdd_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/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 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 Digital= 4
WD40EFRXhdd_connectivity<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">SATA III= 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 Digital5
WD40EFRXhdd_w= arranty=CB=98=C3=8F=C3=82=CB=98 =CB= =98=EF=A3=BF=C3=88=C3=8C22/07/201808:51:13<= /span>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 SSDSATAWestern Digital6
=
WD60EFRXhdd_capacity6TB21/07/2= 01812: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 Digital= 1
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_Cach= e64MB<= /span>21/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_S= eriesRed21/07/201812:36:12141.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 SSDSATA<= span class=3D"m_-8948240996886989456m_4314865709412783450Apple-tab-span" st= yle=3D"white-space:pre-wrap">Western Digital4
WD60EFRXhd= d_connectivitySATA III21/07/201812:3= 6: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_warr= anty=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.
<= div dir=3D"auto">Not one field with all the stuff put in it

Lawrence

Le jeu. 16 ao=C3=BBt 2018 =C3=A0 08:09, Offi= ce <yariv.n@gmail.com> a =C3=A9crit=C2=A0:
I have a DB file of produc= ts that look like that
I mad= e 2 type of delimiters. the=C2=A0=E2=80=9C|=E2=80=9D between each subject a= nd=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
= 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_connecti= vity,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_dim= ension,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_connecti= vity,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_dim= ension,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,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_dim= ension,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<= br>5WD30EFRXhdd_dimension,3.5|hd= d_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,3TB|hdd_rpm,IntelliP= ower|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
6WD60EFRXhdd_dim= ension,3.5|hdd_location,=D7=97=D7=99=D7=A6=D7=95=D7=A0=D7=99|hdd_capacity,6= TB|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 sear= ches. i need many searches on the same field in order to find all the produ= cts which fits 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,2= TB and WA to the Red)
But i= n order to search the=C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems = like i need to put the field DATA inside a Group1Field ?
<= span style=3D"font-size:14px">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 abl= e to fine 10 options or more.

When i=E2=80=99m=C2= =A0searching=C2=A0for 1TB & Red (One option from each different variabl= e) it works fine.

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

Another issue i= s to transfer the selections to the next page but this will be the next iss= ue :-)

Please advice,

Y= ours,

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.d= na?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 --------------------------------------------------------- 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 --00000000000029350505738fc1b8-- . 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:

# fields limited? (1997) Has anyone integrated ZipBurst with WebCat? (2000) What am I missing (1997) Help with database strategy (1998) Re:2nd WebCatalog2 Feature Request (1996) shipcost - cleaner with a table (1998) retain raw [cart] submitted value (2004) WebMerchant 1.6 and https (1997) Signal Raised Error (Part II) (1997) Combining search criteria (2000) Where's Cart Created ? (1997) Simple Page (2000) listing [text] variables? (1999) One other big addition... (1997) OT: Sendmail (2005) Problems getting parameters passed into email. (1997) [WebDNA] Admin Login Required to Serve any TPL Page (2009) [WebDNA] Need some PHP help (2009) /Page Editor Not found (1998) Encrypting the seed (2001)