Hello all,
I'm trying to run a standard CFQUERY search using results found in a VERITY
query. Heres what my code looks like:
-----------------------------------------------
<CFSEARCH
name = "GetResults"
collection = "#SearchCollection#"
criteria = "#ResumeKeyword#"
>
<!--- Make a List of results--->
<CFSET ResumeResults="">
<CFOUTPUT QUERY="getresults">
<CFSET ResumeResults=ListAppend(ResumeResults, "#getfilefrompath(key)#")>
</cfoutput>
<
CFQUERY
DATASOURCE="Stars"
NAME="Talent"
>
SELECT *
FROM Talent
WHERE TalentID=TalentID
AND Resume IN ('#ResumeResults#')
</cfquery>
---------------------------------------------------------
For some reason, I keep coming up with no results! What am I doing wrong?
Any suggestions?
Thanks,
Dave :)
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists