database if statement with conditions

fran7

Hi, I wonder if anyone can advise.
One database field is never empty as I have a text editor that inputs   even if I dont actually put any text. I need to check with an if statement if the field has either   and " " & vbCrLf
and if so write, no data availabel and if not write the field text.

I have this but it doesnt seem to do the trick

Expand|Select|Wrap|Line Numbers

 <%

If Trim(PDFavQuote) = "" OR Trim(PDFavQuote) = "<P>&nbsp;</P>" OR (strPDFavQuote) = "<br>" OR (strPDFavQuote) = "<br>" & vbCrLf Then 

%> 

nothing available

<%

Else

%> 
 
<br><h2>statement</h2><%=rs("PDFavQuote")%>

<%

End If

%>

Any help would be great.
Thanks
Richard

fran7

Hi, just to say I worked it out and this does the trick.

Expand|Select|Wrap|Line Numbers

 <% If Trim(rs("PDFavQuote")) = "" OR Trim(rs("PDFavQuote")) = "<P>&nbsp;</P>" OR Trim(rs("PDFavQuote")) = "<br>" OR Trim(rs("PDFavQuote")) = "<br>" & vbCrLf Then 

%> 

There is currently no statement

<%

Else

%> 

<%=rs("PDFavQuote")%>

<%

End If

%>

Thanks
Richard

database if statement with conditions

re: database if statement with conditions

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about