Hi,
I am working right now a property sales & Lets generating list. I have got most of the images from my client. Sometimes the property has no Images with it. In list view, I have got Price, Title & Thumbnail picture, So if there is no picture then it comes with cross jpeg sign, I wanted to add a path into my database, which will contain NO Image default picture.
How can I use Access DB and also MX, that if there is no picture then bring the default Image. I have already a query into Access that if there is picture then put 1 or if null then 0, this is for another reason, Should I make it from access or into MX?? I don't know what will be the code for this, and also is it possible to do like that?
Any suggestion and comments will be highly appreciated from senior friends and cauligues.
I hope I made it a bit clear.
Thanks

Mashkur

You could make the default value of the image path field in the database the value of the No Image picture, something like:

PropertyImages/NoImage.gif

Or try something like this:

<%
varImage = rsName.Fields.Item("ImagePath".Value
If varImage <> "" Then
Response.Write("<img src='" & varImage & "'>"
Else
Response.Write("<img src='PropertyImages/NoImage.gif'>"
End If
%>

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/

Hi
Thanks a lot. I will give a try, I hope I have got the concept.
Thank you for your valuable time.


Mashkur

Edited by - mash07 on 03 Mar 2003 01:03:54