Hi there can anyone help with the problem here.

I have a recordset in an asp page in Dreamweaver and a Show Region called "Show if Recordset is not empty"

When doing a search in a database, if a particular column called "Description" has nothing in it, i would like for the word "DETAIL" to not appear in the results page. This word always appears if there is something in the "Description" column or not.

in the recordset that I have created just for this function I have set the Column to "Selected" and selected the "Description" column. Under that in the "Filter" tab I have selected the "Description" column and then selected "=", "Session Variable", entered the word Description where it allows you to and I have not selected any sort function.

Either way no matter how I set this I either get the word "DETAIL" on every search I do, even though some of the search results do and dont have anything in the detail page and when i play with the settings i get nothing on all of them.

Can anyone help?

Hi Malcolm,

Can you post your code and a quick sample row of a table record.

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]