Returns a NULL field ?

[Chris Leonard]

Hi.

I'm stuck!

I am querying two tables in a DB using the following string

SQLQuery = "SELECT GuestBook.*, GuestPic.PicName FROM GuestBook LEFT JOIN
GuestPic ON GuestBook.id = GuestPic.id "

Sometimes there will not be a value in PicName so the query only returns the
values in the primary (left hand) table. In my script I need to test and see
if there is a value returned for PicName.

How do I do this ? If I check for a string using "" it fails, isEmpty fails
as well. I think it's because the string is NULL but I've no idea. Can
someone point me in the right direction please.

Here is the code I'm using

if isEmpty(rsGuestBook("PicName")) then
Response.Write(" ")
else
Response.Write("<img src='" & rsGuestBook("PicName") & "'>")
end if

TIA

Chris

[William Tasso]

Chris Leonard wrote:

>
> Sometimes there will not be a value in PicName so the query only
> returns the values in the primary (left hand) table. In my script I
> need to test and see if there is a value returned for PicName.
>
> How do I do this ? If I check for a string using "" it fails, isEmpty
> fails as well. I think it's because the string is NULL but I've no
> idea. Can someone point me in the right direction please.
>

isNull is over there ------->

--
William Tasso - [url]http://WilliamTasso.com[/url]

[Chris Leonard]

Doh!!

Thanks, I really should have tried that one!


"William Tasso" <ngx@tbdata.com> wrote in message
news:eE$2XxOZDHA.2572@TK2MSFTNGP09.phx.gbl...

> Chris Leonard wrote:

> >
> > Sometimes there will not be a value in PicName so the query only
> > returns the values in the primary (left hand) table. In my script I
> > need to test and see if there is a value returned for PicName.
> >
> > How do I do this ? If I check for a string using "" it fails, isEmpty
> > fails as well. I think it's because the string is NULL but I've no
> > idea. Can someone point me in the right direction please.
> >

>
> isNull is over there ------->
>
> --
> William Tasso - [url]http://WilliamTasso.com[/url]
>
>