character count in access db field

[tasneem]

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:

<% response.Write rsprodinfo("LongDescription") %>

thanks

[phpnovice]

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.

[tasneem]

hi
how do i do that?
thanks

[phpnovice]

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

[wmif]

ive never had a problem pulling more than 255 characters through sql.

[phpnovice]

Maybe the column the OP thinks is a "memo" field, isn't really a "memo" field at all.

[tasneem]

Hi
The query didnt work
Access shows in table design that the fileld is memo type.
thnx anyway.