Test for null or blank syntax magic cell-tornado

[barryhund]

I am trying to test for blank or null and can't seem to get the syntax right.
Help Please.

"fi=4|macro=(#4#|IB||<font color=red>NONE ORDERED</font>~#4#|NB||#4#) "

BTW; I can't wait to try the calendar!

[Frank]

* goto manual
* dbBlankText
* Run the example
* Following is the source code
* Calendar Report is coming as soon as we fininh arguing how to implement it with the Database. My idea is no database, let the user draw from their database and furnish the date, text and URL.

FK

-------------------------------------

<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim BlankNull As New Tornado.Z()
response.write("<Center><H3>ASPdb.Net - Nulls and Blanks</H3></Center>")
response.write("<TABLE BORDER=5><TR><TD>")
With BlankNull
.dbSkin = 2
.dbUnit= 1
.dbDSN="Nwind"
.dbSQL="Select Title,Region FROM employees"
.dbTextHolder = "Title=#1"
.dbNavigationitem="None"
.ASPDBNet
response.write("</TD><TD>")

.dbUnit=2
.dbDSN="Nwind"
.dbSQL="Select Title,Region FROM employees"
.dbGridMagicCell="fi=1| macro=(#1#|IB||class=CC1|My Null Text)"
.dbTextHolder = "Title=#2"
.ASPDBNet
response.write("</TD><TD>")

.dbUnit=3
.dbDSN="Nwind"
.dbSQL="Select Title,Region FROM employees"
.dbGridMagicCell="fi=1| Mac=(#1#|IB||class=cc1)"
.dbTextHolder = "Title=#3"
.ASPDBNet
response.write("</TD></TR><TR><TD>")

.dbUnit=4
.dbDSN="Nwind"
.dbSQL="Select Title,Region FROM employees"
.dbGridMagicCell="fi=1| tag=class=cc2"
.dbTextHolder = "Title=#4"
.ASPDBNet
response.write("</TD><TD>")
.dbUnit=5
.dbDSN="Nwind"
.dbSQL="Select Title,Region FROM employees"
.dbBlankText="My Blank Text"
.dbTextHolder = "Title=#5"
.ASPDBNet
response.write("</TD><TD>")

.dbUnit=6
.dbDSN=Application("Nwind")
.dbSQL="Select Title,Region FROM employees"
.dbGridMagicCell="fi=1| mac=(#1#|EQ|My Blank Text|class=cc1|My Null Text)"
.dbBlankText="My Blank Text"
.dbTextHolder = "Title=#6"
.ASPDBNet
response.write("</TD></TR><TR><TD>")

.dbUnit=7
.dbDSN=Application("Nwind")
.dbSQL="Select Title,Region FROM employees"
.dbGridMagicCell="fi=1| tag=class=cc1"
.dbBlankText="My Blank Text"
.dbTextHolder = "Title=#7"
.ASPDBNet
response.write("</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TABLE>")
End With
End Sub
</Script>

[barryhund]

My vote is let me supply the data. Just tell me how to display it in the calender. Making a new table or DB is a small price to pay for such a gift!

[Frank]

OK.. 1 - 0 for me !!!

I think when I hook up with DB then it becomes an application and not a tool. Nothing wrong with that but to extract 3 fields from a DB is really nothing. Displaying with the passing parameter of the 'selected date' is also a snap with Tornado.

FK

[barryhund]

Exactly us users supply the DB tornado makes us look good. You could comprimise and add a table to the northwind test db that you ship with the dll, anyone wanting a ready to use calendar could just use a premade example.

Besides serious gold users will want to connect to sql2000 any way. So making it an application would just get in the way!

[Frank]

let me know if you want to test this module.

Fank

[barryhund]

I would very much like to test it.
Also did you see my post on .dbsupressmsg? setting it to true or false has no effect. For some reason. I can make custom messages though. And I have dbinvisible set to true?

[Frank]

dbsuppressmsg bug has been fixed.. but cannot send due to the mail server problem. Can only read email here in this China location. Will send as soon as it clears up.