Have the keywordId as value of your dropdown. This will give you a list
of keywordID
Dan use a loop in your sql
cfset aKeyword = ListToArray(form.keywordID)
cfset max = ArrayLen(aKeyword)
cfquery name=qMyQuery datasource=#request.dsn#
SELECT e.symbol, e.equityID
FROM equities AS e
cfloop from=1
Error in the 2nd option :
SELECT equityID
FROM keyword_equity_join
-Original Message-
From: Pascal Peters
Sent: maandag 7 juni 2004 17:52
To: CF-Talk
Subject: RE: Keyword Lookup
cfquery name=qMyQuery datasource=#request.dsn# SELECT
e.symbol, e.equityID FROM equities AS e
At 18:03 6/7/2004 +0200, you wrote:
Error in the 2nd option :
SELECT equityID
FROM keyword_equity_join
-Original Message-
From: Pascal Peters
Sent: maandag 7 juni 2004 17:52
To: CF-Talk
Subject: RE: Keyword Lookup
cfquery name=qMyQuery datasource=#request.dsn# SELECT
3 matches
Mail list logo