XMagic & Nulls Pro | Enterprise | Gold

The following examples illustrate how to handle Nulls in Xtended Magic Cell. The examples show the combination of Null cell values in combination with dbBlankText.

Example

<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="1;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="2;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,,(#1#|EQ||BGCOLOR=yellow|My Null Text)"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="3;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,,(#1#|EQ||BGCOLOR=yellow)"
X.ASPDB
%>
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="4;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,BGCOLOR=yellow"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="5;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbBlankText="My Blank Text"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="6;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,,(#1#|EQ||BGCOLOR=yellow|My Null Text)"
X.dbBlankText="My Blank Text"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="7;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,BGCOLOR=yellow"
X.dbBlankText="My Blank Text"
X.ASPDB
%>  
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="8;NWIND;;grid;4;;;ACCESS;5"
X.dbSQL="Select Title,Region FROM employees"
X.dbMagicCell="1,BGCOLOR=yellow"
X.dbBlankText="My Blank Text"
X.ASPDB
%>