Pulling data from a database with response.write. The fields have "<" and
">" signs. How can I get the full field to display. Currently, the fields
are being truncated at the signs.



Rick

response.write Server.HTMLEncode(yourtext)

http://msdn.microsoft.com/en-us/library/ms525347.aspx

Assuming you mean ASP...

Tim

"RICK" <RICK@xxxxxx> wrote in message
news:8CDC5E06-7A67-415D-BAA0-2B1503598AE3@xxxxxx

> Pulling data from a database with response.write. The fields have "<" and
> ">" signs. How can I get the full field to display. Currently, the
> fields
> are being truncated at the signs.
>
> Rick

"RICK" <RICK@xxxxxx> wrote in message
news:8CDC5E06-7A67-415D-BAA0-2B1503598AE3@xxxxxx

> Pulling data from a database with response.write. The fields have "<" and
> ">" signs. How can I get the full field to display. Currently, the
> fields
> are being truncated at the signs.
>
> Rick

In SQL Server if field or table names have special characters I enclose in
square brackets, "[]". Or, you may need to "escape" the characters. The
escape character depends on your DBMS.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--