>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 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>
> >
Will have a look at this. Thanks for putting me on the right direction. =)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
