read large db fields

[stvchezgm123]

I have a simple task that I need to work out. the field in my db (comments) needs to be limited, then a conditional read more gets set in place.

here's what I have so far:

' this is the field, limited to 200 characters
<%= Left(rs("comments"),200) %>

<%

if len(rs("comments")) > 200 then
response.Write("read more...")
end if %>

when I do a response.write of the above, i get a value of zero, so I'm doing something wrong.

 

[Chopstik]

What are you reponse.write(ing) that gives you a value of zero? The len(rs("comments")) variable?

If so, are you sure that you are returning a value from your database? I would check on that just to be sure and then go from there.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill