jamo

ColdFusion QueryNew NULL Test

Apr 10th, 2013
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <h1>Using QueryNew & QuerySetCell creates "empty string" instead of NULL for non-defined values.</h1>
  2. <p>Adobe ColdFusion 9 set default values to "empty string" instead of NULL.</p>
  3.  
  4. <CFSET Temp = QueryNew("ID,Name,DateStart","Integer,Varchar,Date")>
  5. <CFSET QueryAddRow(Temp)>
  6. <CFSET QuerySetCell(Temp, "ID", 1)>
  7.  
  8. <CFOUTPUT>
  9. <b>IsNull(Temp.Name)</b> #IsNull(Temp.Name)# should be "Yes", right?<br>
  10. <b>IsNull(Temp.DateStart)</b> #IsNull(Temp.DateStart)# should be "Yes", right?
  11. </CFOUTPUT>
Advertisement
Add Comment
Please, Sign In to add comment