Results 1 to 2 of 2

Thread: Tag Query Help

  1. 06-29-2010, 10:08 PM #1
    slater333
    slater333 is offline Registered User
    Join Date
    Jun 2010
    Posts
    1

    Tag Query Help

    Hello All,

    I have two tables.

    Products and Articles.

    From the Products Table, I have the ProductName i want to focus on.

    From The Articles Table, i have a tag cloud that the user can input tags as comma separated values.

    What i'm trying to do is display a list of related products for a given article Tag Cloud.

    In Psuedo code, what i want to do is

    Get All related products where the ProductName matches any of the Article Tag Clouds.

    Example table data:

    two products:
    product 1: Products.ProductName: Vitamin C
    product 2: Products.ProductName: Multi-Vitamins
    Aritcles.Tags = Vitamins, Vitamin A, Vitamin C, Multi-Vitamins

    SO i need to query the system and get all products when viewing a given article.

    THank you in advance for the help!
    Reply With Quote Reply With Quote
  2. 06-30-2010, 08:06 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Your Articles table violates NF1.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules