Advertisement
Guest User

Stackoverflow Q54866142-2

a guest
Feb 25th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. <cfquery name="saveDtCk" datasource="#testDB#" result="qResult">
  2. INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
  3. VALUES (
  4. 87550861491
  5. , 8755086149
  6. , 1
  7. , 1
  8. , 'Test 1'
  9. , 'T54645'
  10. , {ts '2019-02-25 10:32:52'}
  11. )
  12. </cfquery>
  13. <h3>Test 1: No parameters (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
  14.  
  15. <cfquery name="saveDtCk" datasource="#testDB#">
  16. INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
  17. VALUES (
  18. <cfqueryparam cfsqltype="cf_sql_numeric" value="87550861493">
  19. , 8755086149
  20. , 1
  21. , 1
  22. , 'Test 1'
  23. , 'T54645'
  24. , {ts '2019-02-25 10:32:52'}
  25. )
  26. </cfquery>
  27. <h3>Test 2: Single parameter (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
  28.  
  29. <cfquery name="saveDtCk" datasource="#testDB#">
  30. INSERT INTO formDetails (recid, formid, refid, status, comment, userid,lastupdate)
  31. VALUES (
  32. <cfqueryparam cfsqltype="cf_sql_numeric" value="87550861493">
  33. , <cfqueryparam cfsqltype="cf_sql_numeric" value="8755086149">
  34. , 1
  35. , 1
  36. , 'Test 1'
  37. , 'T54645'
  38. , {ts '2019-02-25 10:32:52'}
  39. )
  40. </cfquery>
  41. <h3>Test 3: Two parameters (<cfoutput>#qResult.recordCount#</cfoutput>)</h3>
  42.  
  43. ... more tests with 3, 4 and 5 parameters
  44.  
  45. Success
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement