Re: catagories
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14941
interpreted = N
texte = >>Can one product be assigned to more than one catagory? For example: I >>have a calvin klein cotton robe that I want to show up in the cotton >>catagory, the sleepware catagory, and the calvin catagory. How would I >>do this?>I believe you can put all three options under you category field seperated >by a space, then your category search [search >db=xxx.db&eqCategorydata=[category]] and it should find that category your >searching for. >Ray Ray's got the right idea here!There's only one change to be made in Ray's suggestion above. The search context will have to be changed so that the search field parameter begins with wa, wo, ws, etc. -- instead of eq -- because eq means equal to ALL the data in that field. One of these searches should work for you, depending on how you want to search the Category field:[search db=xxx.db&waCategorydata=[category]] [search db=xxx.db&woCategorydata=[category]] [search db=xxx.db&wsCategorydata=[category]] >Yes, yes and yes. You would put the categories into a text list all in >one field. If you have categories that are multiple words, then you'd >have to separate each category with a comma (or similar delimeter) to >match the search better. > >you'd be looking for category=, sleepware for instance. > >SandySandy's suggestion gives you yet another way to do this, and it will work, provided you're careful to remember that you have to enter EVERY item in the field with the same delimiter -- in exactly the same relative position to the words you want to search.In general, this technique is a bit more error-prone than simply using spaces in between the category names, simply because your searches will rely on the proper placement of the commas and blank spaces relative to EVERY word in the database field.In most cases, it's easier to separate the category names with spaces, then use the proper prefix in your search parameter (wo, wa, ws, etc.) to get the right results ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/.
Associated Messages, from the most recent to the oldest:
>>Can one product be assigned to more than one catagory? For example: I >>have a calvin klein cotton robe that I want to show up in the cotton >>catagory, the sleepware catagory, and the calvin catagory. How would I >>do this?>I believe you can put all three options under you category field seperated >by a space, then your category search [search >db=xxx.db&eqCategorydata=[category]] and it should find that category your >searching for. >Ray Ray's got the right idea here!There's only one change to be made in Ray's suggestion above. The search context will have to be changed so that the search field parameter begins with wa, wo, ws, etc. -- instead of eq -- because eq means equal to ALL the data in that field. One of these searches should work for you, depending on how you want to search the Category field:[search db=xxx.db&waCategorydata=[category]] [search db=xxx.db&woCategorydata=[category]] [search db=xxx.db&wsCategorydata=[category]] >Yes, yes and yes. You would put the categories into a text list all in >one field. If you have categories that are multiple words, then you'd >have to separate each category with a comma (or similar delimeter) to >match the search better. > >you'd be looking for category=, sleepware for instance. > >SandySandy's suggestion gives you yet another way to do this, and it will work, provided you're careful to remember that you have to enter EVERY item in the field with the same delimiter -- in exactly the same relative position to the words you want to search.In general, this technique is a bit more error-prone than simply using spaces in between the category names, simply because your searches will rely on the proper placement of the commas and blank spaces relative to EVERY word in the database field.In most cases, it's easier to separate the category names with spaces, then use the proper prefix in your search parameter (wo, wa, ws, etc.) to get the right results ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/.
Kenneth Grome
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:
Re2: Calculating multiple shipping... (1997)
Webcat causing crashes left and right! (1997)
NetSplat and WebCat2 (1997)
OT: Poll Please (2002)
Help! WebCat2 bug (1997)
forming a SKU (1999)
Problem with ShoppingCart.tpl refresh (2000)
HELP! Only 1/2 of pricing.db loading!?! (1999)
acrobat -> wc (1998)
I give up!! (1997)
FW: 2.01 upgrade problems (1997)
Tag Corruption (2000)
Problems getting parameters passed into email. (1997)
A multi-processor savvy WebCatalog? (1997)
service stop and restart (1997)
listfiles-looking for slick solution (1997)
creating a ShipCosts database (1997)
Need relative path explanation (1997)
emailer error 103 part ii (1997)
Bug Report, maybe (1997)