Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 13th, 2004, 05:52 AM
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default how can give Keyword facality in product ?

Hi,
I would like to assign KEYWORD to my products.
Whats the good way for it.
1)Create trans. table and assign each keyword to each products?
2) Assign all keyword with separation of comma
like : key1,key2,key3

Note: i want a search related to keyword.

please gguid me.. i am waiting for your reply.

Thanks
~Storage
 
Old September 13th, 2004, 08:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

What is the DB you are using? How is you search operation going to work? Can you explain on that?

_________________________
- Vijay G
Strive for Perfection
 
Old September 14th, 2004, 05:34 AM
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks...

I am going to use MSSQL 2000 and when enduser going to search with plain word ... we have to search given keyword with alocated products.

and display distict product list.

thanks for interest...
Hopping for proper help

~Storage
 
Old September 16th, 2004, 02:55 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

When you go for the 2nd solution mentioned in your first post, you got to use that with like operator, which is a little slow. If data is not going to be huge, then you can opt for that.

But the 1st option should be a viable solution in case of huge data, where you got to use join to get the product. But the one who provides keyword should be aware of what keywords exist in the db, any mistake or half spelt would result in any product.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection




Similar Threads
Thread Thread Starter Forum Replies Last Post
Product code generator yogeshyl Excel VBA 1 October 3rd, 2007 10:50 AM
Change image to product name zulf BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 June 14th, 2007 12:55 AM
A product development problem. madhukp Pro VB 6 3 December 8th, 2005 01:44 PM
Advice, please. understanding product tracking macinslaw MySQL 0 December 29th, 2004 01:39 PM
Prevent Product Duplicates lucian Dreamweaver (all versions) 1 September 20th, 2003 02:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.