Hello all,

I have a tricky question that I just can't seem to figure out.

I have a list with two columns in it. str_thumb and reviews. its basicaly a list of reviews with a photo, and sometimes I don't have a photo, so the default value of a review without a photo is "none.jpg"

I would like to loop through the list and when a record with a value of "none.jpg" is pulled, it would hide it that image or lack of an image :-)

here is the code i'm tring to execute but it throws an error.

thanks for your help.

Wayne

<ASP:Repeater runat="server" DataSource='<%# RS.DefaultView %>'>
    <ItemTemplate>
<%
DIM strIMAGE
strIMAGE= RS.FieldValue("str_thumb", Container)
IF strIMAGE <>"NONE.jpg" then %>

<%# RS.FieldValue("str_thumb", Container) %>
<% end if %>



    </ItemTemplate>
</ASP:Repeater>

------------

the error

Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30451: Name 'Container' is not declared.

Source Error:

Line 26: DIM strIMAGE
Line 27:
Line 28: strIMAGE= RS.FieldValue("str_thumb", Container)
Line 29: IF strIMAGE <>"NONE.jpg" then %>
Line 30:


Source File: C:\Inetpub\wwwroot\sfsurvey2\dotnet\rsVB.aspx Line: 28

I was able to do it by hand codeing, but would love to do it in visualstudio with some of the user controls.

<%@ Page Language="VB" Debug="true" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ OutputCache Duration="300" VaryByParam="*" %>
<%

Dim conSFMAN As SqlConnection
Dim cmdSelectRatings As SqlCommand
Dim dtrRatings As SqlDataReader
conSFMAN = New SqlConnection( "Server=DELL\SQLEXPRESS;uid=t;pwd=t;database=sfman " )
conSFMAN.Open()
cmdSelectRatings = New SqlCommand( "SELECT top 10 * FROM dbo.VIEW_ratings", conSFMAN )

dtrRatings = cmdSelectRatings.ExecuteReader()

While dtrRatings.Read() %>



    <% IF dtrRatings( "str_thumb" )<>"none.jpg" then%>
    <img src="../ad_images/<%=dtrRatings( "str_thumb" ) %>">
    <%else%>
    <b><h1>NO IMAGE to Display</h1></b>
    <% end if %>

<%=dtrRatings( "txt_description" ) %>
<%
End While

dtrRatings.Close()
conSFMAN.Close()

I would actuall do this in SQL:

SELECT
   ISNULL(imagepath, './director/noimage.jpg') as imagepath
From
   Table

This way there is no need to loop at all, your datasource will already have the correct path to the image or, in this case, the lack thereof an image.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Hi Dparsons,

Thanks for your reply.

In reading your reply I have noticed that my original statement was not clear.

The records that have a value of “none.jpg” also have data that I need to display, so filtering based on if they have an image or not is not a solution. I’ll always need to display the text associating the record, but some recods have images and some don’t. Either way I need to show all records and some of those records have images, which I’ll need to display.

thanks for your consideration.

waynelambright:
In your topic it was not clear that you wanted to print the review whether the review had a image or not, however my suggestion would be to give "none.jpg" some "none image", as a place holder or filler and continue to loop thru "read a record/row, write a record/row".

This is just a suggestion.

Thats fine, all the ISNULL fuction will do is that if there is no image path for the image it will display a default iamge (or whatever it is you need to display); you cna still grab the other fields from the row and display the corrosponding data just with a default image.

Had my statement been something like:

SELECT [columns] FROM [table] WHERE image is null (or where there is an image link) image is not null

then that would be a filter, the isnull in my previous example has nothing to do with filtering your results.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature