dbAnywhere from Symantec Corps. > Warm Regards, > > Ajit Kumar Dash > Microland Software Services > email : [EMAIL PROTECTED] > : [EMAIL PROTECTED] > Tel No : +91-80-5521451 > +91-80-5525011 > +91-80-5525018 > +91-80-5538958 > Fax No :+91-80-5538415 > url : www.microland.net > www.microlandsw.com > > > ---------- > From: Hee Meng[SMTP:[EMAIL PROTECTED]] > Reply To: A mailing list for discussion about Sun Microsystem's Java > Servlet API Technology. > Sent: Friday, May 07, 1999 10:07 AM > To: [EMAIL PROTECTED] > Subject: Re: �ظ�: SQLException > > Hi, > > Are u using JDBC-ODBC bridge as your db driver? > Any other driver available to try with? > > Regards > > qian jianhua wrote: > > Thank you for your time.But I am not trying to put a too long > string in a Text field. And I haven't find the solution yet. If you have, > please let me know.Thanks a lot. Qian1999.5.7 > > -----Original Message----- > ������: Balogh Andras < [EMAIL PROTECTED]> > �ռ���: [EMAIL PROTECTED] < > [EMAIL PROTECTED]> > ����: 1999��5��6�� 22:21 > ����: Re: SQLException > I think your error means that you try to put in a Text > field more than it is possible ( 8152 chars).I think or the pwd_question > or the pwd_answer is too long. I am not sure about this :))) p.s. Sorry if > i misunderstood your problem Best wishes, Andras > > -----Original Message----- > From: qian jianhua < [EMAIL PROTECTED]> > To: [EMAIL PROTECTED] < > [EMAIL PROTECTED]> > Date: Thursday, May 06, 1999 4:04 PM > Subject: SQLException > Sorry, my following code throws some SQLException > that I can't understand. I wonder who can help me.Thank you. The codes > are:String query1= "update customer set > customer_passwd='"+passwd+"',customer_comm='" > > +comm_method+"',customer_pwq=?,customer_pwa=? where customer_num=" > +num; > PreparedStatement > stmt1=con.prepareStatement(query1); > stmt1.setString(1,pwd_question); > stmt1.setString(2,pwd_answer); > int n1=stmt1.executeUpdate(); The > SQLExceptions are:SQLException:22001 [Microsoft][ODBC SQL Server > Driver][SQL Server]String or binary data would be truncated. 8152 > SQLException:01000 [Microsoft][ODBC SQL Server Driver][SQL Server]The > statement has been terminated. 3621 Qian.1999.5.5 > > ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
