Text Data Type

[atimo]

What aren't I doing right with the SQL text data type in my code?

In some pages that I am developing, there are recordsets with 2 or more fields with text data type.

Sometimes it seems that these fields do not appear when I use <%= rsTable("text_field") %>, and sometimes it seems that it is causing other fields not to show when I use the same <%= rsTable("other_field") %>

Is there any special treatment for SQL text datatype in ASP ?

[riis]

Are you sure those fields aren't empty?
There isn't something like an SQL Text data type in ASP, they're just plain strings.

Check for Len(rs("text_field")) = 0 to see whether a field is empty.

[atimo]

Yes, I am sure they are NOT empty.

As I said, sometimes they work fine, and sometimes they don't work.

The text fields in SQL are problematic ! I have a hard time with them.