sql - Execution halts at CFQuery -
for unusual reason simple insert statement in cfquery tag halts page load. have plenty of select statements around site, results on screen output "before sql" dump , end.
it must simple missing. have used hard-coded values below test statement before adding dynamic cfpqueryparam submitted form values. datasource declare application in application.cfc
thank assist.
<cfdump var="before sql" abort="false" /> <cfquery name="insertresponses" result="insertresults"> insert studentresponsetable values (102, 1, 39, 1) </cfquery> <cfdump var="after sql" abort="false" /> <cfdump var="insertresults" abort="true" />
based on suggestions above added try/catch , learned 'catch' running duplicated pk on sql table.
sql coldfusion sql-insert cfquery
No comments:
Post a Comment