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 = 114364
interpreted = N
texte = 1981 --0000000000004d9740057387faef Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=A9= crit : > I have a DB file of products that look like that > I made 2 type of delimiters. the =E2=80=9C|=E2=80=9D between each subject= and =E2=80=9C,=E2=80=9D between > the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2=80=9D. I hope i did = it smartly :-) > > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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_Ser= ies,Red|hdd_connectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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_connectivi= ty,SATA > III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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,We= stern 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 th= e > same field in order to find all the products which fits to my demands. > > 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 seem= s 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 opt= ions 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 wo= rk and i > guess something is really wrong with what i do ? > > Another issue is to transfer the selections to the next page but this wil= l > 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.u= s --0000000000004d9740057387faef Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Yariv,
Your problem is your databa= se.
You should have one column to search for one typ= e of data.
Not one field with all the stuff put in i= t

Lawrence
Le jeu. 16 ao=C3=BBt 2018 =C3= =A0 08:09, Office <yariv.n@gmail.co= m> 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 between each subject and=C2=A0=E2=80=9C,=E2=80=9D betwe= en 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 :-)
<= br>
idxskudata
1WD40EFRXhdd_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_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,Wes= tern Digital
2WD20EFRXhdd_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,2TB|hdd_rpm,Intel= liPower|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,Wes= tern Digital
3WD10EFRXhdd_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,1TB|hdd_rpm,Intel= liPower|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_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,1TB|hdd_rpm,7200|= hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital<= br>5WD30EFRXhdd_dimension,3.5|hdd_location,= =D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,3TB|hdd_rpm,IntelliPower|hdd_Ca= che,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_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 need many sear= ches on the same field in order to find all the products which fits to my d= emands.

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&q= uot; Which are also "hdd_Series&= quot;=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)<= /span>
But in order to search the= =C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems like i need to put th= e field DATA inside a Group1Field ?
But if i put the DATA field in group1 i need to put it also in gro= up2,3,4,5,6,7,8,9=E2=80=A6=E2=80=A6 in order to be able to fine 10 options = or more.

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

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

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

Please advice,
=
Yours,

Yariv Nachshon
<= a href=3D"http://www.plonter.co.il" target=3D"_blank" rel=3D"noreferrer">ht= tp://www.plonter.co.il

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --0000000000004d9740057387faef-- . 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)
1981 --0000000000004d9740057387faef Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=A9= crit : > I have a DB file of products that look like that > I made 2 type of delimiters. the =E2=80=9C|=E2=80=9D between each subject= and =E2=80=9C,=E2=80=9D between > the =E2=80=9CName=E2=80=9D and the =E2=80=9CValue=E2=80=9D. I hope i did = it smartly :-) > > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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_Ser= ies,Red|hdd_connectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern Digital > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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_connectivi= ty,SATA > III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital > 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_con= nectivity,SATA > III|hdd_warranty,=D7=A9=D7=9C=D7=95=D7=A9 =D7=A9=D7=A0=D7=99=D7=9D|mfg,We= stern 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,We= stern 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 th= e > same field in order to find all the products which fits to my demands. > > 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 seem= s 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 opt= ions 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 wo= rk and i > guess something is really wrong with what i do ? > > Another issue is to transfer the selections to the next page but this wil= l > 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.u= s --0000000000004d9740057387faef Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Yariv,
Your problem is your databa= se.
You should have one column to search for one typ= e of data.
Not one field with all the stuff put in i= t

Lawrence
Le jeu. 16 ao=C3=BBt 2018 =C3= =A0 08:09, Office <yariv.n@gmail.co= m> 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 between each subject and=C2=A0=E2=80=9C,=E2=80=9D betwe= en 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 :-)
<= br>
idxskudata
1WD40EFRXhdd_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_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,Wes= tern Digital
2WD20EFRXhdd_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,2TB|hdd_rpm,Intel= liPower|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,Wes= tern Digital
3WD10EFRXhdd_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,1TB|hdd_rpm,Intel= liPower|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_dimension,3.5= |hdd_location,=D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,1TB|hdd_rpm,7200|= hdd_Cache,64MB|hdd_Series,Blue|hdd_connectivity,SATA III|hdd_warranty,=D7=A9=D7=A0=D7=AA=D7=99=D7=99=D7=9D|mfg,Western Digital<= br>5WD30EFRXhdd_dimension,3.5|hdd_location,= =D7=A4=D7=A0=D7=99=D7=9E=D7=99|hdd_capacity,3TB|hdd_rpm,IntelliPower|hdd_Ca= che,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_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 need many sear= ches on the same field in order to find all the products which fits to my d= emands.

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&q= uot; Which are also "hdd_Series&= quot;=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)<= /span>
But in order to search the= =C2=A0=E2=80=9CDATA=E2=80=9D field few times it seems like i need to put th= e field DATA inside a Group1Field ?
But if i put the DATA field in group1 i need to put it also in gro= up2,3,4,5,6,7,8,9=E2=80=A6=E2=80=A6 in order to be able to fine 10 options = or more.

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

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

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

Please advice,
=
Yours,

Yariv Nachshon
<= a href=3D"http://www.plonter.co.il" target=3D"_blank" rel=3D"noreferrer">ht= tp://www.plonter.co.il

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

Country & Ship-to address & other fields ? (1997) Yet another db manager (2003) Review comparison by PC Magazine: Open for On-line Business (1997) Search & Sort Question (1999) php + WebCatalog in same files (2001) Strange Crash (1998) [WebDNA] inputed text getting scrambled up in DB (2012) [shell] stopped AGAIN (2003) Country & Ship-to address & other fields ? (1997) Netscape 3.01 can't see db in form (was problems problemsproblems) (1997) Still ignoring the 3.x bugs? (2000) Code BabelFish (was: I've been thinking) (2002) Banners (1997) Change to 5.0 per website licensing (2003) Group search doesn't work. (1997) Location of Browser Info.txt file (1997) Dummy Credit Card Number for debug? (1997) ACGI processing for .html (1997) Typhoon Rev. and PCS store problems (1999) check out page (SSL) not loading on Netscape 4.0+ - fixed? (1999)