As an update to this, I have discovered that if you
enter information from the servlet then the servlet
will not let you enter duplicate records but if you
have entered a record via the mySQL machine the
servlet does not recognise this and allows you to
enter a duplicate!! The database seems to treat
records entered via a local source and records entered
via the web as different types of data!
Is this a known problem?
Cheers
Jon
--- Jonathan Howells <khiffy@stripped> wrote:
> I am running a mysql database and querying it via a
> website running Java Servlets. I made the username
> field the primary key as this must be unique and
> tested it on the mysql machine - this does not let
> you
> enter a duplicate username.
>
> However, if I run the same insert statement in my
> servlet, it enters the information into the database
> even though it has a duplicate username!
>
> Can anyone explain this for me?
> Thanks
> Jon
>
>
____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
>
> --
>
---------------------------------------------------------------------
> Please check
>
"http://www.mysql.com/Manual_chapter/manual_toc.html"
> before
> posting. To request this thread, e-mail
> mysql-thread32722@stripped
>
> To unsubscribe, send a message to:
>
>
<mysql-unsubscribe-khiffy=yahoo.co.uk@stripped>
>
>
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
