Applet can not find com.mysql.jdbc.Driver

2002-11-21 Thread Matthew Scarrow
anyone have any ideas. Matthew Scarrow ComIT Solutions Inc. www.comit.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Fw: Mysql Encryption

2002-11-18 Thread Matthew Scarrow
Mysql 4.01 beta has support for ssl connections. I have it compiled and running with the openssl support and it's working good. Have a look at the documentation at http://www.mysql.com/doc/en/Secure_connections.html I think this would be the best way to encrypt your data. Matthew Scarrow ComIT

Openssl and MySQL 4.0.3-Beta

2002-09-03 Thread Matthew Scarrow
freezes it seems. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. If not how can I compile this so it works right. Thanks for any help. Matthew Scarrow ComIT Solutions Inc. [EMAIL PROTECTED

Trying to get openssl working with MySQL 4.0.3-beta

2002-09-02 Thread Matthew Scarrow
freezes it seems. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. If not how can I compile this so it works right. Thanks for any help. Matthew Scarrow ComIT Solutions Inc. [EMAIL PROTECTED

RE: Network access?

2002-07-24 Thread Matthew Scarrow
or ODBC or any other types of connections that have been developed for mysql (See download section for developed connection drivers). Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Steve Dickey [mailto:[EMAIL PROTECTED

RE: Host IP is not allowed to connect this MySQL server

2002-07-18 Thread Matthew Scarrow
%_for_all_or_example_192.% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; that's it. For further fine tunning on privilages please visit www.mysql.com and go to there documentation section. There you will find all you need to know about creating users. Matthew Scarrow ComIT Solutions Inc

Re: still not a simple sql-question ! ...

2002-07-17 Thread Matthew Scarrow
Add the sSession field and put in the not wanteds and wanteds you will see that the 3 rows your query returns is the first ones in the list per iUser that are the not wanteds. The query somehow needs to select the second ones. This is where the problem comes in. -- Original Message

RE: Beginner's question

2002-07-16 Thread Matthew Scarrow
see a big difference in response then it has something to do with the middle man. I can't think of anything else that will help you. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Kyle and Beth Kelly [mailto:[EMAIL

RE: Beginner's question

2002-07-16 Thread Matthew Scarrow
To return the first 500 chars of a field us the substring(str, pos, len) function: example Select substring(field, 0, 500) as First500 from my_table where something=something else; Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original

RE: Use MySQL and Visual Basic 6.0

2002-07-15 Thread Matthew Scarrow
I've built a whole program with vb6 and mysql database back end. Never had any problems. I used the mysql odbc for windows to access the database. What are you using? Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From

RE: Beginner's question

2002-07-14 Thread Matthew Scarrow
? I query on text fields that hold html code all the time and use c++ cgi. It takes less then a second to return my query. So probably going to need more info. Thanks. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Kyle

RE: redirect output to a file?

2002-07-14 Thread Matthew Scarrow
this command: mysql -h somehostname -u username -p query results enter the password for the user then edit the results file which it created and there you go. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Brandon McCombs

Re: C++ API

2002-07-11 Thread Matthew Scarrow
Most likely this will solve your problem. This comes right from the mysql website documentation. It is for the C API but I'm sure the same concepts go for C++ as well. If this doesn't work provide more info on the program you are using for coding and the errors you are getting. Thanks.

Re: Cant start server after reboot - Please Help!

2002-07-11 Thread Matthew Scarrow
Here's a small script to use for automaticly starting the mysqld demaon. Cut and Past it into a file and call it mysqld then save it in the /etc/rc.d/init.d directory. Upon reboot you should see that you mysql server is up and running ( use ps -A as root and look for the mysqld pid's). As for

RE: help with MySQL SELECT statement

2002-07-10 Thread Matthew Scarrow
Use SELECT DISTINCT. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Kirk Babb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 9:59 PM To: [EMAIL PROTECTED] Subject: help with MySQL SELECT statement Easy

RE: help with MySQL SELECT statement

2002-07-10 Thread Matthew Scarrow
)-smallestdomain, smallestdomain) as domain from tbl_emails; Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Kirk Babb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:20 PM To: [EMAIL PROTECTED] Subject: Re: help

C API, MySql ver 3.23.49 and Apache ver 1.3.23

2002-02-23 Thread Matthew Scarrow
I've got this problem that now since I updated mysql to ver 3.23.49 and recompiled some of my working cgi scripts Apache is complaining about a server error. Premature end of header scripts. If I use the cgi that I compiled before the upgrade everything is fine. It's the exact same code.