Dreamweaver - MS Access Database

Author

MS Access Database

RICHARD ABRAHAM

2004-08-13, 7:18 pm

Hi,
I'm pulling into an ASP page a field from an Access 2000 table. For some
records this field is blank. In the ASP page I want to show an icon for just
the records that contain data. Where the record is blank I do not want to
display anything. I can use an if... else statement, e.g.

<% if (AllProjects.Fields.Item("ProjectWeb").Value) = "null" then %>

but the "null" does not identify the blank records. Does anyone know what I
can use in this statement to indentify blank records?

Cheers,
Rich.

Murray *TMM*

2004-08-13, 7:19 pm

Crafty, Jules....

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:cfctlm$1vi$1@forums.macromedia.com...
> Try
>
> <% if (AllProjects.Fields.Item("ProjectWeb").Value) & "" = "" then %>
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>