Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Professional
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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
Reply With Quote
  #2 (permalink)  
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
Reply With Quote
  #3 (permalink)  
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
Reply With Quote
  #4 (permalink)  
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:50 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.