Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Aug 2004
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Database Length

    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?

    Thanks
    Attached Thumbnails Attached Thumbnails SQL Database Length-example.gif   SQL Database Length-example2.gif  

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    are you using mysql? If not I can move the thread to the general database area.

    have you checked the value directly in the mysql client? make sure the problem isn't with your GUI you are using.

  • #3
    New Coder
    Join Date
    Aug 2004
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yes SQL, sorry wrong forum. I've also resolved my code issue.

  • #4
    SSJ
    SSJ is offline
    Regular Coder
    Join Date
    Mar 2007
    Posts
    230
    Thanks
    0
    Thanked 4 Times in 4 Posts
    dude9er,
    Will you please post the solution here

  • #5
    New Coder
    Join Date
    Aug 2004
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts
    sure, the problem was in my asp:

    comment = left(Trim(Replace(Request.Form("comment"),"'","''")),40)

    changed to

    comment = left(Trim(Replace(Request.Form("comment"),"'","''")),255)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •