 					#nextTransId.nextTransactionId#,
 					#auth_agent_id#,
 					'authorized by')
-			</cfquery>--->
+			</cfquery>
 			<cfif len(#in_house_contact_agent_id#) is not 0 and len(#in_house_contact_agent_name#) is not 0>
-				<script>alert("posting an inhouse contact")</script>
-				<!---<cfquery name="in_house_contact" datasource="user_login" username="#client.username#" password="#decrypt(client.epw,cfid)#">
+				<!---<script>alert("posting an inhouse contact")</script>--->
+				<cfquery name="in_house_contact" datasource="user_login" username="#client.username#" password="#decrypt(client.epw,cfid)#">
 					INSERT INTO trans_agent (
 					    transaction_id,
 					    agent_id,

						#nextTransId.nextTransactionId#,
						#in_house_contact_agent_id#,
						'in-house contact')
				</cfquery>--->
			</cfif>
			<cfif len(#outside_contact_agent_id#) is not 0 and len(#outside_contact_agent_name#) is not 0>
				<script>alert("posting an outside contact")</script>
				<!---<cfquery name="outside_contact" datasource="user_login" username="#client.username#" password="#decrypt(client.epw,cfid)#">
					INSERT INTO trans_agent (
					    transaction_id,
					    agent_id,

		
	
	<cftransaction>
			<cfquery name="newLoanTrans" datasource="user_login" username="#client.username#" password="#decrypt(client.epw,cfid)#">
				INSERT INTO trans (
					TRANSACTION_ID,
					TRANS_DATE,
