-
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.
-
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("AspDB.EP"
X.dbUnit=1
X.dbMode="grid"
X.dbDSN="NWIND"
X.dbSQL="Select * FROM employees"
'....open one of following to see effect
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)"
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow )"
'X.dbMagicCell="9,BGCOLOR=yellow"
'....open following in combination with the above to see effect
'X.dbBlankText="My Blank Text"
X.aspdbEP
%>
I'll check out the bgcolor=xxx for form mode
FK
------------
Martin Jocic at 7/21/99 5:44:17 PM
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.
-
Problem w. magic cell macros and NULL (reply)
Do the following to get the same magic effect in form ->
X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow|Null Text)"
X.dbFormMagicCell="9,,(#9#|EQ||BGCOLOR=yellow| NullText)"
EP has separate grid and form controlled Magiccells.
Fk
------------
Martin Jocic at 7/21/99 5:44:17 PM
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.
-
Problem w. magic cell macros and NULL (reply)
I tried your example:
'....open one of following to see effect
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)"
Result: Only background color works, NO null text displayed
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow )"
Result: Background color NOT changed
'X.dbMagicCell="9,BGCOLOR=yellow"
Result: Background color always yellow
'....open following in combination with the above to see effect
'X.dbBlankText="My Blank Text"
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("AspDB.EP"
X.dbUnit=1
X.dbMode="grid"
X.dbDSN="NWIND"
X.dbSQL="Select * FROM employees"
'....open one of following to see effect
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow |My Null Text)"
'X.dbMagicCell="9,,(#9#|EQ||BGCOLOR=yellow )"
'X.dbMagicCell="9,BGCOLOR=yellow"
'....open following in combination with the above to see effect
'X.dbBlankText="My Blank Text"
X.aspdbEP
%>
I'll check out the bgcolor=xxx for form mode
FK
------------
Martin Jocic at 7/21/99 5:44:17 PM
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|