Hi All, I have an access DB for fooling about on. I'm trying to enter a text Longer
then 255 characters into a 'memo' field. I'm using a PreparedStatement and my code
looks something like this:
ps = conn.prepareStatement("INSERT INTO table (First, Last, eMail,comment) VALUES(?,
?, ?, ?)");
ps.setString(1, request.getParameter("First"));
ps.setString(2, request.getParameter("Last"));
ps.setString(3, request.getParameter("eMail"));
ps.setString(4, request.getParameter("comment"));
It works fine if the 'comments' value is less the or equal to 255 Characters, it
crahses with an error telling me that the String is to long. The question is how do I
enter Strings longer then 255 chars into a DB using JDBC?
Tahnks in advance,
Chris
--
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
