only show pic if there is a record

[Mo*1]

Ive got an asp website which has a news function. it pulls through info and a
pic ref to a url on the server that in turn puts it onto a page.

My problem is that i only want to show this picture if there is a record in
that news item - at the moment its coming up as a broken picture link. Is there
a way of showing it only if that record in the table is filled in?

ive tried using the only show if... function but the record has info in it
with the details of the news anyway, so it thinks there is info in it when
picref if blank and the rest of the fields are filled in

anyone shed some light on this for me?

[Manuel Socarras]

you can try:

If Not IsNull(picture_field) Then
'Show info
End If

HTH,

manuel

Mo*1 wrote:

> Ive got an asp website which has a news function. it pulls through info and a
> pic ref to a url on the server that in turn puts it onto a page.
>
> My problem is that i only want to show this picture if there is a record in
> that news item - at the moment its coming up as a broken picture link. Is there
> a way of showing it only if that record in the table is filled in?
>
> ive tried using the only show if... function but the record has info in it
> with the details of the news anyway, so it thinks there is info in it when
> picref if blank and the rest of the fields are filled in
>
> anyone shed some light on this for me?
>

[Mo*1]

unfortunatly it didnt work...ive got a hide if record is empty on the field,
but cant figure out how to put in the also hide if that field is empty...ive
put in the code you gave me but is this right? any help appreciated!

<% If Not RS_newsp.EOF Or Not RS_newsp.BOF Then %>
<% If Not IsNull("picref") Then %>
<img src="<%=(RS_newsp.Fields.Item("picref").Value)%>" width="148"
height="156">
<% End If %>
<% End If ' end Not RS_newsp.EOF Or NOT
RS_newsp.BOF %>

[Manuel Socarras]

correct this line:

If Not IsNull(RS_newsp.Fields.Item("picref").Value) Then


Mo*1 wrote:

> unfortunatly it didnt work...ive got a hide if record is empty on the field,
> but cant figure out how to put in the also hide if that field is empty...ive
> put in the code you gave me but is this right? any help appreciated!
>
> <% If Not RS_newsp.EOF Or Not RS_newsp.BOF Then %>
> <% If Not IsNull("picref") Then %>
> <img src="<%=(RS_newsp.Fields.Item("picref").Value)%>" width="148"
> height="156">
> <% End If %>
> <% End If ' end Not RS_newsp.EOF Or NOT
> RS_newsp.BOF %>
>