0 Replies Latest reply on Apr 25, 2008 7:18 AM by (amystephenson)

    Results in Nested Looper from Dropdown Search Page

    Level 1
      I would like to display the results in a looper (doesn't even have to be nested) I have build the search page (easy), but I can not figure out how to get the result to pul by a "reference_area". Any help will be appreciated.

      SELECT tbl_reference.ref_name, Games.GameName, Games.GameShortDesc, Games.GameURL, Games.GameType, Games.GameRef, Games.LibraryUseOnly, Games.GameImage
      FROM Games INNER JOIN tbl_reference ON Games.GameRef = tbl_reference.ref_name
      WHERE GameRef=KTColParam1
      ORDER BY GameName

      I think the item goes in the KTColParam1 Variable, but I don't know what to put there.