www.webdeveloper.com
Results 1 to 7 of 7

Thread: character count in access db field

  1. #1
    Join Date
    Dec 2002
    Posts
    213

    character count in access db field

    Hi
    I have an access db, with a memo field. When I response.write this field in an asp page, only 255 characters show up. Is there a way that the whole of this field would show up in the asp page?
    this field is a longdescription of a product and the code I use is:
    Code:
    <% response.Write rsprodinfo("LongDescription") %>
    thanks

  2. #2
    Join Date
    Dec 2004
    Posts
    8,637
    If you are extracting this data from the database using an SQL statement, then perhaps that is the problem. Try using native ADO methods only and see if you get the same result.

  3. #3
    Join Date
    Dec 2002
    Posts
    213
    hi
    how do i do that?
    thanks

  4. #4
    Join Date
    Dec 2004
    Posts
    8,637
    Code:
    Dim myConn, myRst, ln
    Set myConn = Server.CreateObject("ADODB.Connection")
    Set myRst = Server.CreateObject("ADODB.Recordset")
    myConn.Open "...your connection string..."
    myRst.Open "tableName", myConn, 2, 2, 2 ' adOpenDynamic, adLockPessimistic, adCmdTable
    Do While Not myRst.EOF
        ln = Len(myRst.Fields("memo_field_name").Value)
        Response.Write ln & " = " & myRst.Fields("memo_field_name").Value & "<br>" & vbCrLf
        myRst.MoveNext
    Loop
    myRst.Close
    myConn.Close
    Set myRst = Nothing
    Set myConn = Nothing

  5. #5
    Join Date
    Apr 2005
    Location
    kali
    Posts
    308
    ive never had a problem pulling more than 255 characters through sql.

  6. #6
    Join Date
    Dec 2004
    Posts
    8,637
    Maybe the column the OP thinks is a "memo" field, isn't really a "memo" field at all.

  7. #7
    Join Date
    Dec 2002
    Posts
    213
    Hi
    The query didnt work
    Access shows in table design that the fileld is memo type.
    thnx anyway.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles