<cfquery
name="rsResume"
datasource="#application.datasource#">
SELECT R.resumeIdentity
, CASE
WHEN R.candidateIdentity IS NULL THEN 0
ELSE R.candidateIdentity
END AS candidateIdentity
, R.resumeAsText
, R.uniqueFileName
, R.fileExtension
, R.originalFileName
, R.dateStamp
, S.salutationTitle
, P.firstName
, P.lastName
, CONCAT( COALESCE( S.salutationTitle, "" ), " ", P.firstName, "
",
P.lastName ) AS fullName
FROM db_au_com_exclaimit.tbl_resume R
LEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate C
ON R.candidateIdentity = C.candidateIdentity
<!--- make sure the resume is active --->
AND R.isCurrent = 1
LEFT OUTER JOIN db_au_com_exclaimit.tbl_person P
ON C.personIdentity = P.personIdentity
LEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation S
ON P.salutationIdentity = S.salutationIdentity;
</cfquery>
<!--- update database collection --->
<cftry>
<cfif recordcount GTE 1>
<cfloop query="rsResume" step="" from="1" to="x">
<cfindex
action="update"
collection="col_au_com_exclaimit_query_new"
key="candidateIdentity"
type="custom"
title="fullName"
query="rsResume"
body="resumeAsText,fullName,originalFileName"
custom1="uniqueFileName" />
<cfcatch>
<cfset request.Error.doAppendErrorMessage( "There was an error
updating
the collection" ) />
</cfcatch>
</cfloop>
</cfif>
</cftry>
OR something like that.
Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
