Merry Xmas Rick

in java
String memoString = request.getParameter("memoField");
Connection conn = DriverManager.getConnection("jdbc:odbc:Customer",null,null);
PreparedStatement stmt = conn.prepareStatement(sqlFieldDescription);
stmt.setString(1,memoString);
stmt.executeUpdate();

using mySql, there are no problems on varchar or SqlServer on Text field
only in VFP memo field where memoString is longer than 255 chars

>>Hi anyone,
>>why is it that i cannot save a long string into a VFP memo field ( being truncated ) from html textarea ( equiv to editbox control ) using javaserverpages or JSP ?
>
>What are you doing exactly to save the value?
>
>One thing to understand is that if you use literal strings you will have to adhere to VFP's 255 character string limit. If you use ODBC/OleDb you need to make sure you use named parameters for longer values.
>
>+++ Rick ---