I know I have heard this somewhere before, but can
someone give me a hint ?
I made a simple servlet that just does an insert into a
mysql database from an HTML form. It takes about 10
fields, looks up the unique vals & inserts the data if
it is valid.
One error I forgot to check for is if people put 's in
their data... the sql statements obviously wont like
that... and I can fix that by looking for 's & making
them '''s
The ugly thing was that after someone made the servlet
blow chunks at the error (it responded with a sql
exception) then every other person that tried to use the
posting servlet had their data corrupted... as if the
servlet was remembering their data & using it instead of
the new data.
Any suggestions or obvious things to look at ?
Andrew Dingfelder
Computing As You Like It
108 Blanchard St., Raleigh NC 27603
[EMAIL PROTECTED]
Phone (919) 828-9824
___________________________________________________________________________
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
