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