Topic awaiting preservation: Need Help With ASP Search Engine (Page 1 of 1)

This is hard for me to explain even though I'm sure it is a very simple thing to do.

I 'd like to be able to display a portion of the contents of a database field on an ASP webpage. I can generate the code to display the field, but have not found a way to limit the number of characters or amount of data that is displayed. (ie. Search engine results . . .) Not worried about highlighting words or anything like that.

I'm relatively new to ASP and Access/SQL databases so I'm learning as I go. Any help would be appreciated.

And it was, thanks anyways.

Left(string, 400)

Ramasax

Ramasax: Glad we could help

___________________
Emps

FAQs: Emperor

You'll want to check if the field is longer than 400 before you truncate it, especially if you're adding something like '...' to it. Otherwise, you'll end up with some data that's less than 400 that still has the '...' on it.

Hope that makes sense.

Makes perfect sense. I actually cut that down to 150 characters, and I am pulling from the entire text of all the pages, so it won't be a problem as far as I can see. I could always add an if statement to be sure I suppose.

Thanks,

Ramasax