S
Samuel
Guest
I am running winxp pro, IIS, latest MySQL version & latest Dadabik beta.
I have two tables:
MAIN:
MAINID (primary) auto incremented
promo (int) Linked to 2nd table
code (varchar)
cems (bigint)
date (date)
PROMO:
ID (primary) auto incremented
promo (varchar)
The table linking works perfectly,
I have tried to set up checking duplicates on one field only, the CEMS field which is patron account number.
When ever I set it to check for duplicates it comes up with a duplicate record found every time. Even when I take a test card and search for the test card number, and delete all of the test card results.
My goal is to have it check the CEMS field only and find duplicates on a per day (24hour basis) one card number per day allowed..
Another issue I am having is with timezones, we are in washington state, pacific time zone. but our business day runs from 7:00am - 7:00am, I have found if i change the system time on the MySQL box to the Japan Timezone this works, the problem comes when trying to update our intranet website, with the differing timezones..
I have tried unsuccessfully to change the time zone in the [mysqld] & [mysqld_safe] sections of the startup INI file. When I try to force MYsql into the japan time zone the server fails to start and an error message pops up failed to start unexpectedly, etc..
Thanks,
Samuel
I have two tables:
MAIN:
MAINID (primary) auto incremented
promo (int) Linked to 2nd table
code (varchar)
cems (bigint)
date (date)
PROMO:
ID (primary) auto incremented
promo (varchar)
The table linking works perfectly,
I have tried to set up checking duplicates on one field only, the CEMS field which is patron account number.
When ever I set it to check for duplicates it comes up with a duplicate record found every time. Even when I take a test card and search for the test card number, and delete all of the test card results.
My goal is to have it check the CEMS field only and find duplicates on a per day (24hour basis) one card number per day allowed..
Another issue I am having is with timezones, we are in washington state, pacific time zone. but our business day runs from 7:00am - 7:00am, I have found if i change the system time on the MySQL box to the Japan Timezone this works, the problem comes when trying to update our intranet website, with the differing timezones..
I have tried unsuccessfully to change the time zone in the [mysqld] & [mysqld_safe] sections of the startup INI file. When I try to force MYsql into the japan time zone the server fails to start and an error message pops up failed to start unexpectedly, etc..
Thanks,
Samuel