I'm trying to execute a database query using coldfusion. For some reason it is
not executing the insert portion of the queries. It is not throwing an error.
It would appear that it had executed normally, but nothing is inserted into the
database. ----- I also have the code sending me an email everytime it passes
the insert query (and mail me the sql statement it was attempting insert into
tbl_xapp_contacts (user_id, app_id, bureau_id, role_id) values
('0DBB57F2-C754-58F6-79A8-84AC072DDBDC',
'F3702120-DC46-30B8-D79F-6FEE8122ADC2', '00', 1) which is valid sql, and when
I run it in sql plus - it works fine SQL> insert into tbl_xapp_contacts
(user_id, app_id, bureau_id, role_id) values
('27A6CC84-CAAB-F141-C1AF-DD0A3DAD4C7E', 'F3702120
-DC46-30B8-D79F-6FEE8122ADC2', '00', 0) ; 1 row created. ======= see code ref
2 ======= It clears out the records that I had previously in the database, and
tries to insert them back into the database. The Actual output of the code (as
I may have said already) is that it clears out the records, but does not put
the info back into the database. ---- Throughly confused, Gus

insert into tbl_xapp_contacts
(user_id, app_id, bureau_id, role_id)
values
(<cfqueryparam value = "#basic_cfc.sqlSafe(arguments.user_id)#"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "50">,
<cfqueryparam value = "#basic_cfc.sqlSafe(arguments.app_id)#"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "50">,
<cfqueryparam value = "#basic_cfc.sqlSafe(arguments.bureau_id)#"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "50">,
<cfqueryparam value = "#basic_cfc.sqlSafe(arguments.alternate)#"
CFSQLType = "CF_SQL_FLOAT"
maxLength = "10"
scale="1">)

=======
code ref 2
=======

<cfinvoke
component="#request.componentPath#.application"
method="clearApplicationOwners">
<cfinvokeargument name="app_id" value="#url.app_id#"/>
<cfinvokeargument name="bureau_id" value="#url.bureau_id#"/>
</cfinvoke>

<!--- Primary Approver --->
<cfinvoke
component="#request.componentPath#.application"
method="addAppOwners">
<cfinvokeargument name="user_id" value="#form.primary_approver#"/>
<cfinvokeargument name="app_id" value="#url.app_id#"/>
<cfinvokeargument name="bureau_id" value="#url.bureau_id#"/>
<cfinvokeargument name="alternate" value="0"/>
</cfinvoke>

<cfloop list="#form.alternate_Approvers#" index="pointer">
<!--- Alternate Approvers --->
<cfinvoke
component="#request.componentPath#.application"
method="addAppOwners">
<cfinvokeargument name="user_id" value="#pointer#"/>
<cfinvokeargument name="app_id" value="#url.app_id#"/>
<cfinvokeargument name="bureau_id" value="#url.bureau_id#"/>
<cfinvokeargument name="alternate" value="1"/>
</cfinvoke>
</cfloop>


<cfloop list="#form.voting_Reviewers#" index="pointer">
<!--- Voting Reviewers --->
<cfinvoke
component="#request.componentPath#.application"
method="addAppOwners">
<cfinvokeargument name="user_id" value="#pointer#"/>
<cfinvokeargument name="app_id" value="#url.app_id#"/>
<cfinvokeargument name="bureau_id" value="#url.bureau_id#"/>
<cfinvokeargument name="alternate" value="2"/>
</cfinvoke>
</cfloop>