Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfloop index="FieldName" list="#fieldNames#">
- <cfset field_name = #FieldName#>
- <cfset firstThreeChars = #Mid(field_name,1,3)#>
- <cfif firstThreeChars eq "CQI">
- <cfset checkQuestionId = #RemoveChars(field_name,1,3)#>
- <cfset checkRatingId = #Evaluate("#field_name#")#>
- <cfquery name="InsQuestions" datasource="#variables.dbdsn#" username="#variables.dbuser#" password="#variables.dbpw#">
- insert into quality.employee_quality_call_detail
- (quality_call_detail_id, check_question_id, check_rating_id, quality_call_id,
- last_user, last_update)
- values
- (quality.seq_emp_quality_call_detail.nextval, '#checkQuestionId#','#checkRatingId#',
- '#qualityCallId#', '#currentHRID#',sysdate)
- </cfquery>
- </cfif>
- </cfloop>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement