Can anyone tell me how to hide an empty field in a record set but show it when it has a value?? ie i have a database where some records have a second image stored and some do not, but i want to be able to repeat a region of 6 items, but auto hide any given item when it is an empty field in the database,
I know it is a simple snippet but i cant find it??
Can anyone help??

Many Thanks

Add this where you want the second image to appear inside the recordset:

<% Dim str2ndImage
str2ndImage = yourRecordsetname.fields.item("your2ndimagefieldname".value
%>
<% If str2ndImage <> "" Then %>

Here is where you put the code for the dynamic image (same as you have for the first one)

<% End If %>

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting