[eXceed69]

I've created an SQL DB which includes a COMMENT column, I then connect to the DB and show the results of that column on my webpage using <%=oRs.Fields("comment")%>, however the COMMENT info is not fully showing and gets cut off (see example.gif), in fact the SQL DB is not saving the entire comment entry (see example2.gif).





Can someone please help me out with this, why is this happening?

This post has been edited by eXceed69: 19 February 2007 - 11:16 PM

[gregoryH]

eXceed69, on 19 Feb, 2007 - 11:00 PM, said:

I've created an SQL DB which includes a COMMENT column, I then connect to the DB and show the results of that column on my webpage using <%=oRs.Fields("comment")%>, however the COMMENT info is not fully showing and gets cut off (see example.gif), in fact the SQL DB is not saving the entire comment entry (see example2.gif).

attachment

attachment

Can someone please help me out with this, why is this happening?

HI eXceed..

I am not sure if I am barking up the right tree, but either:

• the web form
  
• the SQL statement

is truncating the text.

Check this by trying a regular select statement and see if the field is truncated. Some newer SQL DB haev implemented a type of BLOB statement to pick up large text and binary data.

[Trogdor]

If it is a mssqlserver database you can try the TEXT fieldtype, it should give plenty of space.