>>I get a JDBC,... error.
Print out the parameters and see exactly which parameter is causing
the error.
eg. INSERT INTO XYZ (ABC, DEF) VALUES ("Jack", );
if abc is text field and def is numeric field, the above result in an
error, since it will try to insert ) into the text field. If the
input value of a field is null, assign a blank(text field) or a
zero(numeric field) to it.
>>What should I do to increase this limit?
If you are using MSAccess, change the type to a Memo field and you
will not have the 256 character restriction.
Hope this helps.
J
---Oguz Baktir <[EMAIL PROTECTED]> wrote:
>
> Have a nice day!
>
> I have 2 problems. I thin some of you may have already faced with
these, if
> so I need your help. Here they are:
>
> I have a form from which I want to send text data to a database via a
> servlet. The problem is: When there is single quote or double quote
> somewhere in the to-be-input text, I get a JDBC,... error. I
understand that
> JDBC confuses with these quotes? How can I overcome this problem?
>
>
> Second, as using MsAccess I observed that I could a max of 256
characters
> into a text type field? What should I do to increase this limit? Is
there
> another way to store text data in a database? Which type should I use?
>
> Have a nice work,
> I am looking for the answers of these questions, and some others
also...
> My senior project deadline is May 10. I need urgent help. Thanks for
> everything.
> Regards,
> Oguz
>
>
___________________________________________________________________________
> 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
>
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
___________________________________________________________________________
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
