Sunday 15 January 2012

sql - Execution halts at CFQuery -



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