Re: Duplicate Insert Crashes Client

2005-11-15 Thread Bruce Martin
the 'CREATE' statement for you table and sample data. Provide information about operating system and MySQL version. Bruce Martin wrote: Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record alre

Duplicate Insert Crashes Client

2005-11-14 Thread Bruce Martin
Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record already there, my client crashes. Is there an error I can trap for this? The DB does insert the new record. Bruce Martin The Martin Solution PO Box 644 Delaware

Re: mysql_init(&m) changes values of variables

2005-11-13 Thread Bruce Martin
Ok I have an update. I fixed my problem by passing a NULL parameter to mysql_init() to do this I did this: MYSQL *m; m=mysql_init(NULL); connection=mysql_real_connect(m,cStrdbServer,cStrdbUser,cStrdbUserPass,c StrdbName,0,NULL,0); On Nov 12, 2005, at 7:44 PM, Bruce Martin wrote: Hello all

mysql_init(&m) changes values of variables

2005-11-12 Thread Bruce Martin
fter I first set it up the length is 23 which is correct. I then call mysql_init(&m), then I check the length again, well the value of the int I set earlier, and it is 0. What's the deal? why would mysql_init() change the value of my int? Bruce Martin The Martin Solution PO Box 644 D

Re: libmysqld as shared library

2005-11-10 Thread Bruce Martin
]: Leaving directory `/home/pgroen/projects/mysql-5.0.15' make: *** [all] Error 2 I'm quite desperate at the moment because our first demo is due next week What am I doing wrong? Regards, Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: Add New User

2005-11-06 Thread Bruce Martin
Ok thank you, I think I have it now. Now to get my Client application working. On Nov 6, 2005, at 1:16 PM, Björn Persson wrote: söndagen den 6 november 2005 18:39 skrev Bruce Martin: However, even though I specified 'test.*' my test user can access the mysql database. That'

Re: Add New User

2005-11-06 Thread Bruce Martin
database? or should it have been 'test' no quotes of course. Is there a way to update the database access without deleting the user and redoing it all? Thanks for the help. On Nov 6, 2005, at 12:23 AM, Michael Stassen wrote: Bruce Martin wrote: When I log in as root using: mysql -u

Add New User

2005-11-04 Thread Bruce Martin
Query OK, 0 rows affected (0.00 sec) Why is this not working? To test it further I try to log in as testUser but it tells me access denied for user [EMAIL PROTECTED] Even if I grant the testUser @ localhost. I can look in the user table and sure enough user [EMAIL PROTECTED] is there. Bru

mysql_library_init()

2005-10-30 Thread Bruce Martin
har **argv, char **groups) Can someone explain what the 3 parameters are and what they need for info? The docs are a bit light on this subject and it says it is synonym for the mysql_server_init() function, but that function is not listed and is not linked to in the on-line docs. Bruce Martin

Permissions for the install

2005-10-30 Thread Bruce Martin
What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670

Trouble running mysql_install_db

2005-10-27 Thread Bruce Martin
of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! I then checked the permissions for the /usr/local/mysql/data/ directory and it shows: drwxr-x--- 13 mysql wheel What am I missing? I installed MySQL using the installer package. Bruce Martin The M

Re: String insertion

2005-10-24 Thread Bruce Martin
treichardt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Compiling a MySQL Client using Apple's xCode

2005-10-20 Thread Bruce Martin
need to include some libs with this client, but which libs and how can I do that in xCode? Thank you, Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs