Hi all,
I've got a verity search resultset and an additional resultset that I'm trying to join
with a QoQ -- however it seems that CF don't like doing that- I'm getting errors like
"Incorrect Select list" for the verity key column -- anyone know what I need to do or
what I'm doing wrong? Here's the code:
<cfsearch collection="eventsMatrix" type="SIMPLE" criteria='(#request.s_searchString#)
OR #replace(form.searchKeywords,' ', ', ', "ALL")#' name="keywordSearch">
<cfquery name="selectEventsAdvanced" datasource="#request.dsn#">
SELECT eventID,eventTitle,eventAims
FROM contentEvents
WHERE
<cfif isDate(form.dateFrom)>dateFrom >=
#form.dateFrom#</cfif>
</cfquery>
<cfquery name="selectJoinResults" dbtype="query">
SELECT
keywordSearch.score,
selectEventsAdvanced.eventID,selectEventsAdvanced.eventTitle,selectEventsAdvanced.eventAims
FROM keywordSearch, selectEventsAdvanced
WHERE selectEventsAdvanced.eventID = keywordSearch.key
ORDER BY keywordSearch.score
</cfquery>
Cheers
d
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
