character count in access db field
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:
<% response.Write rsprodinfo("LongDescription") %>
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.
how do i do that?
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
Set myRst = Nothing
Set myConn = Nothing
ive never had a problem pulling more than 255 characters through sql.
Maybe the column the OP thinks is a "memo" field, isn't really a "memo" field at all.
The query didnt work
Access shows in table design that the fileld is memo type.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)