Alt Text problem

[vam1]

Greetings,

I have a photo gallery of about 4000 pics and am trying to get it to display an alt text for each image. I have tried the two following methods and get the same result with both, they only display the first 4 characters of the field.

My captions at like "2000 Ford Ranger Pickup" and the alt text only shows the year.

First piece of code I wrote:

response.write "<td width='410' align='center'><br><IMG SRC=/images/" & rsObj("Folder") & "/" & rsObj("FileName") & "   alt=" & rsObj("Caption") & "><br><br><b>" & rsObj("Caption") & "</b><br>"

Second was someone else's idea.

response.write "<td width='410' align='center'><br><IMG SRC=/images/" & rsObj("Folder") & "/" & rsObj("FileName") & "   alt=" & Server.HTMLEncode(rsObj("Caption")) & "><br><br><b>" & rsObj("Caption") & "</b><br>"

both give me the same result, anyone have any ideas?

Thanks

Doug

[DrBunchman]

Hi Doug,

Welcome to Bytes.com! I hope you find the site useful. Please could you remember to wrap your code blocks with CODE tags as it makes your posts much easier to read. Please also don't post links to external websites in the technical forums. You should take a moment to read the Posting Guidelines.

What happens if you hard code the words in like this:

 alt="2000 Ford Ranger Pickup"

Does that display correctly? (obviously it's the same for all images but we're just testing here).

If so then the string being returned from the database must be getting truncated somehow - are there any string delimiters in rsObj("Caption") (e.g. ' or ") which might be cutting it short?

Dr B

[jhardman]

Doug,

also, what does

response.write server.htmlencode(rsObj("Caption"))

produce in code? My best guess is it isn't valid HTML - validating (validator.w3.org) is always a good idea if the code doesn't look how you expect.

Yes, there are other ways to write it. The following makes more sense to me if you need to write more than a little in the response.write:

%>
<td width="410" align="center"><br><img src="/images/<%=rsObj("folder") & "/" & rsObj("FileName")%>" alt="<%=server.htmlEncode(rsObj("Caption"))%>">
<br><br><b><%= rsObj("Caption")%></b><br>
<%

Let me know if this helps.

Jared