IF NOT NULL, THEN WHAT?

[Erik]

I'm making a reference list for my company. We have photos from most of
our reference projects, but not all.

When I create a recordset to present our reference list, pulling data
from our mySQL projects database, I want to print a text instead of just
showing an empty picture frame.

SELECT *
FROM projects
IF projectPhotoURL IS NULL
THEN PRINT 'Sorry, no photo'
END IF
WHERE customerID=colname

Yes I know, this is not valid SQL syntax. I was hoping someone could
catch my point better this way, and guide me to something that works :)


Help greatly appreciated

Erik

[Joe Makowiec]

On 12 Apr 2005 in macromedia.dreamweaver.appdev, Erik wrote:

> I'm making a reference list for my company. We have photos from most
> of our reference projects, but not all.
>
> When I create a recordset to present our reference list, pulling
> data from our mySQL projects database, I want to print a text
> instead of just showing an empty picture frame.
>
> SELECT *
> FROM projects
> IF projectPhotoURL IS NULL
> THEN PRINT 'Sorry, no photo'
> END IF
> WHERE customerID=colname
>
> Yes I know, this is not valid SQL syntax. I was hoping someone could
> catch my point better this way, and guide me to something that works

Do it in PHP, not SQL. Your image code would look something like:

<img src="<?php echo $row_Recordset1['filename']; ?>" alt="picture">

You want something like:

if (strlen($row_Recordset1['filename']) > 0) {
// Regular image from database
echo "<img src=\"$row_Recordset1['filename']\" alt=\"picture\">";
} else {
// Blank image
echo '<img name="" src="sorry.gif" alt="Sorry, no picture">';
}

Should work, not tested.

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]

[RobGT]

You need to use some scripting on the web page instead.
Use your recordset as normal and before your image location in the code, add
a little script.

In ASP VBScript:

<%
varPhoto = rsRecordsetName.Fields.Item("projectPhoto").Value
If varPhoto = "" Or IsNull(varPhoto) Then
Response.Write("No Photo")
Else
%>

<img src="../path/to/media/<%=varPhoto%>">

<%
End If
%>

Something like that - coffe has just arrived :)
HTH
Cheers,
Rob
[url]http://robgt.com[/url]

[Erik]

RobGT skrev:

> You need to use some scripting on the web page instead.

OK, get it. Will try later, sorry for late response.

This group has some fine heads attached to it, thank you for being at
rescue point! :)

Erik the Viking