Hello

One field of my (SQL Server's) table is ntext type. When I call my table 
in an ASP page, all the other fields show up, but the ntext field comes 
blank. When I change this field's data type to nvarchar(3000) it came up 
fine. 

Why is that and the ntext datatype comes blank (null) in my select 
statement??

Thanx 

Nick

I have a feeling that you must specify the ntext column(s) at the end of
your SELECT statement. E.g.

SELECT myVarCharField, myDateTimeField, myNTextField
FROM myTable

If this isn't the problem, then i'm not sure what the problem is.  Perhaps
post your code?

HTH,
Col

-----Original Message-----
From: Nikos Drandakis [mailto:ektorjr@h...]
Sent: 23 October 2002 21:37
To: ASP Databases
Subject: [asp_databases] I cannot see my ntext field in me select....


Hello

One field of my (SQL Server's) table is ntext type. When I call my table 
in an ASP page, all the other fields show up, but the ntext field comes 
blank. When I change this field's data type to nvarchar(3000) it came up 
fine. 

Why is that and the ntext datatype comes blank (null) in my select 
statement??

Thanx 

Nick


*******

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.  If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system.  If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.