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 WHERE e.equityID IN (
> SELECT equityID, COUNT(equityID)
> FROM keyword_equity_join
> WHERE keywordID IN (<cfqueryparam cfsqltype="CF_SQL_NUMERIC"
> value="#form.keywordID#" list="Yes">)
> GROUP BY equityID
> HAVING COUNT(equityID) = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
> value="#ListLen(form.keywordID)#">
> )
> </cfquery>
>
> (but you can't have duplicate keywordid in the last one)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
