View Screen - Hide Null fields

Just a basic idea - you can use Before Display event of View page:

http://xlinesoft.com/asprunnerpro/docs/before_display.htm
First of all construct and execute SQL Query that retrieves the current record. Then hide certain field blocks if corresponding field is null.
Here is the sample code. Make sure you use correct field and table names.

I've added the follow to the view_before event but am still seeing the blank fields, is this correct.. or have i missed something.
I've created a test database with a table called AllDatabases, it contains ID, Field1 and Field2
The code i've entered is
sql = "select * from AllDatabases where ID=" & Request.QueryString("editid1")

set rstmp = CustomQuery(sql)
xt.assign "ID_fieldblock",IsNull(rstmp("ID"))

xt.assign "Field1_fieldblock",IsNull(rstmp("Field1"))

xt.assign "Field2_fieldblock",IsNull(rstmp("Field2"))
rstmp.close : set rstmp = nothing

Hi,
your code looks correct. It's hard to tell you what's wrong without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

Oops, i'd put the code in view before process, rather than view before display. I've now go the code in the right place, but instead of hiding the null fields it shows null fields and hides the fields with content which is the opposite of what i need to do.

Hi,
please see my changes below:

Jane, many thanks