from:"Eternal Designs, Inc"

New To MySQL Connector J

2003-11-29 Thread Eternal Designs, Inc

you. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail)

Re: Newbie Table question

2003-08-31 Thread Eternal Designs, Inc

B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Can't connect to local MySQL question

2003-08-10 Thread Eternal Designs, Inc

tools do, too. Use pure bash or xterm. Better yet, install mysql as a service to have it started at boot time. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail)

Re: Nested SELECT statements problem

2003-08-02 Thread Eternal Designs, Inc

) ON aut.IDAuteur = ecr.IDAuteur WHERE book.IDLivre IN (SELECT book.IDLivre FROM livre book, livreEcritPar ecr, auteur aut WHERE aut.Prenom like '%$firstName%' AND aut.Nom like '%$name%' AND ecr.IDAuteur = aut.IDAuteur AND book.IDLivre = ecr.IDLivre); -- Peter K. Aganyo Eternal Designs Inc., +1(617)344

Re: Root

2003-08-02 Thread Eternal Designs, Inc

MySql after uninstalling it and rebooted the server but no luck so far... Thanks for the hand Fabrice Try re-installing (even w/o uninstalling) using the --force option. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail) -- MySQL General Mailing List For list archives

Re: Select problem

2003-07-29 Thread Eternal Designs, Inc

table ordering by smiles_id, then by lpcval. The second uses Group By to pick the first. The reason is that the specification says that in a single statement GROUP BY must precede the ORDER BY. To beat that we have to use 2 statements. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax

Re: passwords DBI/DBD

2003-07-19 Thread Eternal Designs, Inc

the password nor reset it. The compilation of DBD worked fine; after which I created MySQL users and set passwords. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Deleting a database....

2003-07-18 Thread Eternal Designs, Inc

.. Thank you all in advance... Ola Hi Ola: To delete a database use the DROP DATABASE command at the command prompt as follows: drop database dbasenow [That's, of course assuming your database is named dbasenow] -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail

Re: errors with source file

2003-07-15 Thread Eternal Designs, Inc

copy and paste onto your browser's address line. It should start downloading. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT TOP

2003-07-14 Thread Eternal Designs, Inc

Sure Woody and Phil are right; just take out TOP 20 and put LIMIT 20 at the end of your SQL. If you care for the docs, the page is at http://www.mysql.com/doc/en/SELECT.html Peter Eternal Designs Phil Bitis wrote: Yeah, put LIMIT 20 on the end. - Original Message - From: Jim McAtee