Skip navigation
Currently Being Moderated

Using Contain in Query Return

Jul 4, 2012 6:53 AM

I have a databse table the contains questions (1 fireld) for the user to answer.  I also have table with  words and word definitions ( 2 fields).  I want the questions to feed into the page and I want to some how check the question for the words in the definition table and if that word is contained in the word definition  table that it create that word as a link.  Is this possible?

 
Replies
  • Currently Being Moderated
    Jul 4, 2012 7:27 AM   in reply to TheScarecrow

    It's probably possible but your post is unclear.  If the question was, "What is the airspeed velocity of an unladen swallow?", what do you want to happen?

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 4, 2012 9:24 AM   in reply to TheScarecrow

    Something like this:

     

    select word, definition

    from word_defintion

    where word in (<cfqueryparam value="#yourquestion#" list ="yes" separator = " ">)

     

    should get you started.  You'll probably have to do something about capital letters.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points