numero = 18428
interpreted = N
texte = >Hello,>> I'm trying to put together a WebCatatlog with a database similar>in structure to this:>>SKU Manufacturer Name Color>2345234 Jerseys Tiger In Field Red>2345235 Jerseys Tiger In Field White>2345236 Jerseys Tiger In Field Navy>6523243 Cafters Lily Pads Red>6523244 Cafters Lily Pads White>6523245 Cafters Lily Pads Yellow>>When a search is performed, I want to return only one listing of each>Manufacturer/Name item instead of all three versions of that item. I want>to then>put a listing of each color available on the details page and a checkbox>for each color on the shopping cart page. Can anyone share a solution to>this kind of Multiple Variety of Same Item type of data?Here, this should get you started. The outer search puts one item from each Manufacturer/Name on the page. The inner search creates a popup with the available colors for that item:[search db=products.db&eqManufacturerdatarq=Jerseys&eqNamedatarq=Tiger In Field&ManufacturerSumm=T][founditems][search db=products.db&eqManufacturerdatarq=[manufacturer]&eqNamedatarq=[name]&neColordatarq=[blank]&ColorSumm=T][/search][/founditems][/search]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>Hello,>> I'm trying to put together a WebCatatlog with a database similar>in structure to this:>>SKU Manufacturer Name Color>2345234 Jerseys Tiger In Field Red>2345235 Jerseys Tiger In Field White>2345236 Jerseys Tiger In Field Navy>6523243 Cafters Lily Pads Red>6523244 Cafters Lily Pads White>6523245 Cafters Lily Pads Yellow>>When a search is performed, I want to return only one listing of each>Manufacturer/Name item instead of all three versions of that item. I want>to then>put a listing of each color available on the details page and a checkbox>for each color on the shopping cart page. Can anyone share a solution to>this kind of Multiple Variety of Same Item type of data?Here, this should get you started. The outer search puts one item from each Manufacturer/Name on the page. The inner search creates a popup with the available colors for that item:[search db=products.db&eqManufacturerdatarq=Jerseys&eqNamedatarq=Tiger In Field&ManufacturerSumm=T][founditems][search db=products.db&eqManufacturerdatarq=[manufacturer]&eqNamedatarq=[name]&neColordatarq=[blank]&ColorSumm=T][/search][/founditems][/search]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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...