2 Replies - 1306 Views - Last Post: 20 February 2007 - 04:22 AM Rate Topic: -----

#1 eXceed69  Icon User is offline

  • "Super Sentai Knight Of DawN"
  • member icon

Reputation: 7
  • View blog
  • Posts: 688
  • Joined: 12-November 06

WebPage Issue: SQL Database Length

Posted 19 February 2007 - 11:00 PM

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).

Attached Image

Attached Image

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


Is This A Good Question/Topic? 0
  • +

Replies To: WebPage Issue: SQL Database Length

#2 gregoryH  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 60
  • View blog
  • Posts: 656
  • Joined: 04-October 06

Re: WebPage Issue: SQL Database Length

Posted 20 February 2007 - 01:15 AM

View PosteXceed69, 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

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.
Was This Post Helpful? 0
  • +
  • -

#3 Trogdor  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 15
  • View blog
  • Posts: 627
  • Joined: 06-October 06

Re: WebPage Issue: SQL Database Length

Posted 20 February 2007 - 04:22 AM

If it is a mssqlserver database you can try the TEXT fieldtype, it should give plenty of space.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1