Results 1 to 4 of 4

Thread: Problem w. magic cell macros and NULL

  1. #1
    Martin Jocic Guest

    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.

  2. #2
    Fk Guest

    Problem w. magic cell macros and NULL (reply)

    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.

  3. #3
    FK Guest

    Problem w. magic cell macros and NULL (reply)

    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.

  4. #4
    Martin Jocic Guest

    Problem w. magic cell macros and NULL (reply)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •