|
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--00000000000029350505738fc1b8--. Lawrence BanahanI did a table also formed from the formvarib=les of the search which created a table like this one:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.usS=earchnamevalueWAhdd_SeriesRed
=09WAhdd_Cache32MB
=09WAhdd_connectivitySATA III
=09WOhdd_capacity1TB 2TB
=09WOhdd_rpm5400 5900=C2=A0and 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 belowWhat 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=9Di know i have a con=ceptual problem and i try to find the fastest way to draw the data. Yours,YarivOn 16 Aug 2018, at 11:17=, Lawrence Banahan <banahan.l@gmail.com> wrote:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.usIn your case I would make several db for each kind of stuff. Each dB would= be faster to open and search.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero==3D55Bug Reporting: support@webdna.usIf 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.LawrenceLe 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 growI just gave a sampl=e of 6 hard drives that have around 10 types of variablesBut 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_orderWD10EFRXhdd_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=div> 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 Digital2WD10EFRXhdd_Cach=e64MB<=/span>21/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 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 Digital4WD10EFRXhd=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 Digital5WD10EFRXhdd_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 Digital6WD20EFRXhdd_capa=city2TB=21/07/201812:34:55141.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 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 Digital3WD20EFRX=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 Digital4WD20EFRXhdd_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>6WD20EFRXhdd_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 Digital5WD30EFRXhdd_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 Digital1WD30EFRX=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 Digital2WD30EFRXhdd_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">3WD30EFRXhdd_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=SATA=span>Western Digital1WD40E=FRXhdd_rpmIntelliPower21/07/2018=12:35:45=span>141.226.009.023=C3=81=C3=8F=CB==9C=C3=88 =C3=93=C3=81=CB=98=C2=B7=E2==80=9E=C3=88=C3=92=CB=9C=C3=88=C3=8C =CB=9C=CB=98=C3=88=C3=81=C3=88=C3=8C ==C3=82 SSDSATAWestern Digital2 WD40EFRXhdd_Cache64MB21/07/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=div>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=4WD40EFRXhdd_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=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 Digital5 WD40EFRXhdd_w=arranty=CB=98=C3=8F=C3=82=CB=98 =CB==98=EF=A3=BF=C3=88=C3=8C22/07/2018=08: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=1WD60EFRXhdd_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 Digital2WD60EFRXhdd_Cach=e64MB<=/span>21/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 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 Digital4WD60EFRXhd=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 Digital5WD60EFRXhdd_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 Digital6WD30EFRXhdd_warr=anty=CB=98=C3=8F=C3=82=CB=98 =CB=98==EF=A3=BF=C3=88=C3=8C22/07/201814:40:33=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=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero==3D55Bug Reporting: support@webdna.us 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 itLawrence---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.d=na?numero=3D55Bug Reporting: support@webdna.usLe 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 thatI 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 Digitali made a page (under construction) t=o find stuff but i have many issues with iti 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
=
DOWNLOAD WEBDNA NOW!
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...