By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,949 Members | 1,554 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,949 IT Pros & Developers. It's quick & easy.

Double entry

P: n/a
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.
Jul 19 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #2

P: n/a
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #3

P: n/a
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #4

P: n/a
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #5

P: n/a
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #6

P: n/a
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.

Jul 19 '05 #7

P: n/a
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.


Jul 19 '05 #8

P: n/a
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.


Jul 19 '05 #9

P: n/a
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.

Users can enter name and date
So users can enter their names only on one date.

Please help.

Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.


Jul 19 '05 #10

P: n/a
because a primary key can be made up of more than one field..

"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au...
Francesco in the previous post mentioned a primary key on the name *AND* the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.



Jul 19 '05 #11

P: n/a
because a primary key can be made up of more than one field..

"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au...
Francesco in the previous post mentioned a primary key on the name *AND* the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.



Jul 19 '05 #12

P: n/a
because a primary key can be made up of more than one field..

"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au...
Francesco in the previous post mentioned a primary key on the name *AND* the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl...
Sorry that won't work.
Because every member should be able to confirm that they are present on a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.

"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch...
birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,

you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.



Jul 19 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.