Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfquery name="saveDtCk" datasource="#testDB#" result="qResult">
- INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
- VALUES (
- 87550861491
- , 8755086149
- , 1
- , 1
- , 'Test 1'
- , 'T54645'
- , {ts '2019-02-25 10:32:52'}
- )
- </cfquery>
- <h3>Test 1: No parameters (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
- <cfquery name="saveDtCk" datasource="#testDB#">
- INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
- VALUES (
- <cfqueryparam cfsqltype="cf_sql_numeric" value="87550861493">
- , 8755086149
- , 1
- , 1
- , 'Test 1'
- , 'T54645'
- , {ts '2019-02-25 10:32:52'}
- )
- </cfquery>
- <h3>Test 2: Single parameter (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
- <cfquery name="saveDtCk" datasource="#testDB#">
- INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
- VALUES (
- <cfqueryparam cfsqltype="cf_sql_numeric" value="87550861493">
- , <cfqueryparam cfsqltype="cf_sql_numeric" value="8755086149">
- , 1
- , 1
- , 'Test 1'
- , 'T54645'
- , {ts '2019-02-25 10:32:52'}
- )
- </cfquery>
- <h3>Test 3: Two parameters (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
- ... more tests with 3, 4 and 5 parameters
- Success
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement