Problem w. magic cell macros and NULL

I'm trying out the new dbMagicCell macro stuff. It doesn't seem to work with fields containing null values. No matter what I do (even using EL directly) is anything shown in these fields. Also which operator should I use to test for NULL values? And another thing, the bgcolor=xxx option works only in grid mode, not in form mode.

I am working against a Access database with Asp-dB EP.

When EP sees a Null it converts to a blank. Earlier versions ahs some problem in mixing dbBlankText and the Xtended Magic cell. If you have problems then get the latest one.

<%
Set X=Server.CreateObject(&#34;AspDB.EP&#34;)
X.dbUnit=1
X.dbMode=&#34;grid&#34;
X.dbDSN=&#34;NWIND&#34;
X.dbSQL=&#34;Select * FROM employees&#34;

&#39;....open one of following to see effect
&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)&#34;
&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow )&#34;
&#39;X.dbMagicCell=&#34;9,BGCOLOR=yellow&#34;

&#39;....open following in combination with the above to see effect
&#39;X.dbBlankText=&#34;My Blank Text&#34;

X.aspdbEP
%>

I&#39;ll check out the bgcolor=xxx for form mode

FK


------------
Martin Jocic at 7/21/99 5:44:17 PM

I&#39;m trying out the new dbMagicCell macro stuff. It doesn&#39;t seem to work with fields containing null values. No matter what I do (even using EL directly) is anything shown in these fields. Also which operator should I use to test for NULL values? And another thing, the bgcolor=xxx option works only in grid mode, not in form mode.

I am working against a Access database with Asp-dB EP.

Do the following to get the same magic effect in form ->

X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow|Null Text)&#34;
X.dbFormMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow| NullText)&#34;

EP has separate grid and form controlled Magiccells.


Fk



------------
Martin Jocic at 7/21/99 5:44:17 PM

I&#39;m trying out the new dbMagicCell macro stuff. It doesn&#39;t seem to work with fields containing null values. No matter what I do (even using EL directly) is anything shown in these fields. Also which operator should I use to test for NULL values? And another thing, the bgcolor=xxx option works only in grid mode, not in form mode.

I am working against a Access database with Asp-dB EP.

I tried your example:

&#39;....open one of following to see effect
&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)&#34;
Result: Only background color works, NO null text displayed

&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow )&#34;
Result: Background color NOT changed

&#39;X.dbMagicCell=&#34;9,BGCOLOR=yellow&#34;
Result: Background color always yellow

&#39;....open following in combination with the above to see effect
&#39;X.dbBlankText=&#34;My Blank Text&#34;
Did not enable this

I have version 2.1901 Do I need to upgrade?

Martin Jocic

------------
Fk at 7/21/99 11:40:48 PM

When EP sees a Null it converts to a blank. Earlier versions ahs some problem in mixing dbBlankText and the Xtended Magic cell. If you have problems then get the latest one.

<%
Set X=Server.CreateObject(&#34;AspDB.EP&#34;)
X.dbUnit=1
X.dbMode=&#34;grid&#34;
X.dbDSN=&#34;NWIND&#34;
X.dbSQL=&#34;Select * FROM employees&#34;

&#39;....open one of following to see effect
&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)&#34;
&#39;X.dbMagicCell=&#34;9,,(#9#|EQ||BGCOLOR=yellow )&#34;
&#39;X.dbMagicCell=&#34;9,BGCOLOR=yellow&#34;

&#39;....open following in combination with the above to see effect
&#39;X.dbBlankText=&#34;My Blank Text&#34;

X.aspdbEP
%>

I&#39;ll check out the bgcolor=xxx for form mode

FK


------------
Martin Jocic at 7/21/99 5:44:17 PM

I&#39;m trying out the new dbMagicCell macro stuff. It doesn&#39;t seem to work with fields containing null values. No matter what I do (even using EL directly) is anything shown in these fields. Also which operator should I use to test for NULL values? And another thing, the bgcolor=xxx option works only in grid mode, not in form mode.

I am working against a Access database with Asp-dB EP.