vb.net and mysql training

2004-05-19 Thread Grant Cooper
I am looking for a course in North America that provides mysql and vb.net or c# training or a good text book or dvds. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Finding Empty Records

2004-05-08 Thread Grant Cooper
I am trying to find all my empty records. I am looking for NULLs and Empty strings but is there a simple way to just as this? I thought MySql may have something built in. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

MySQLDriverCS-n-EasyQueryTools-3.0.11

2004-02-19 Thread Grant Cooper
I am desperately looking for some programming examples for building custom gui's. And can't find any online using MySQLDriverCS. I have one built but I need to find better examples. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

SEC_TO_TIME not working?

2003-09-16 Thread Grant Cooper
SELECT DailyLog.TimeOut, DailyLog.TimeIn, SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) - UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog keeps on giving me a result as a date. Not time in years, days, hours, min. For example 9/9/2007 12:51:26 PM - 9/9/2007 12:51:26 PM gives me 12:00 PM. I

listing all people who have the same firstname and lastname

2003-08-29 Thread Grant Cooper
I'm trying to get a query to work by listing all the people in a row with the same last name and first name. key, fname, lname 1 ,John, Smith 4, John, Smith 5, Cody,Edwards 2, Cody, Edwards Don't list anyone that has a unique first name last name. Is this possible? Trying to use the Count comman

array vs. more table cells

2003-08-28 Thread Grant Cooper
I'm building a program calendar describing each Year's courses. I have a field for a semester and it's current courses in one cell separated by a ",". When I go to print this out I create an array out of the cell than do it's sorting. Or Should I just take the time and create a new table and sepa

Is query possible? (Newbie)

2003-08-14 Thread Grant Cooper
I have 2 tables used for an online calendar... first table fields: primary_key , start_date, event_name, event_description second table fields: primary_key, end_date Tables fields are shortened and can't be changed. My second table only contains events that have a end date. I want to create a qu

RE: unique identifier using mysql_connect

2003-07-31 Thread Grant Cooper
PROTECTED]; [EMAIL PROTECTED] Subject: Re: unique identifier using mysql_connect At 12:43 -0700 7/30/03, Grant Cooper wrote: >Can I get a unique identifier using the mysql_connect command by connecting >to the same host, same user but different database during the life time of >one scr

unique identifier using mysql_connect

2003-07-30 Thread Grant Cooper
Can I get a unique identifier using the mysql_connect command by connecting to the same host, same user but different database during the life time of one script? I currently do a $conn_id = mysql_connect ($host_name, $user_name, $password); Then call a, mysql_select_db ($db_name,$conn_id) But I

Configuring Database Server

2003-07-24 Thread Grant Cooper
I was hoping someone could tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD. Is there a toaster than can bring me up to speed. Thanks. -- MySQL General Mailing

updating database query

2003-06-02 Thread Grant Cooper
I'm trying to update an email field. Our company has changed from a .com to a .ca. I wrote a php script to make the changes but I was wondering if I could do this from the command line. Its a text field and I would like to replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out plea

storing a picture in a file or database (newbie)

2003-01-14 Thread Grant Cooper
Is it better to store a picture in mysql field or a link to the file on my server? I want to allow people to use a php script to upload a gif or a pic. Any pro's and con's would be appreciated. - Before posting, please check:

RE: Access to MySQL

2002-12-17 Thread Grant Cooper
There are many tools. Use a gui. mysql front (free), premium soft (my pick but has a 29 day trial). There are also many small window applications to do this. Do a search at one of the famous downloads. +client +mysql +gui -Original Message- From: Charles Mabbott [mailto:[EMAIL PROTECTED]]

Re: replication hell.

2002-12-14 Thread Grant Cooper
Mysql works on port 3306 by default. for example, my mysql server is on 10.10.10.1 so you would use this command to test your mysql server. telnet 10.10.10.1 3306 you will get special garbage or host not allowed if testing a remote server. But at least you know your mysql server is open. You co

Re: Connecting M. Access Forms to insert data into mysql

2002-12-14 Thread Grant Cooper
dly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: "Grant Cooper" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to

Connecting M. Access Forms to insert data into mysql

2002-12-14 Thread Grant Cooper
I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Re: access->mysql

2002-12-14 Thread Grant Cooper
MySQL-Front was super and has a built in utility. Can do it remotely or locally. To bad they stopped supporting it. - Original Message - From: "Sandeep Murphy" <[EMAIL PROTECTED]> To: "Crercio O. Silva" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 200

Building Web Pages

2002-12-10 Thread Grant Cooper
Does anyone know of a package that computer novices can use to build simple web pages. Even if they know nothing of HTML? I'm using mysql and I figure there might be something out there all ready built. This is for a small college that teachers can use to put on there stuff.

RE: mysqlhotcopy

2002-12-10 Thread Grant Cooper
Why is mysqldump grossly inefficient. I thought this was the standard to backing up a mysql database. I use dump / restore to back up my hard drive. Would this be a better option to do a separate dump on the mysql database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

Re: mysql port number

2002-12-09 Thread Grant Cooper
I use freeBSD and like to use "sockstat -4". It tells you the user, the command that is used and the PID, Protocol local address and the foreign address it is connected to. - Original Message - From: "Brian P. Austin" <[EMAIL PROTECTED]> To: "Mike At Spy" <[EMAIL PROTECTED]> Cc: <[EMAIL PR

RE: Aggregating function which returns more than one row

2002-12-05 Thread Grant Cooper
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Felix LUNGU Sent: Thursday, December 05, 2002 12:27 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: Re: Aggregating function which returns more than one row The idea is simple: I want to implement some

mysql breaking through a firewall

2002-12-05 Thread Grant Cooper
I am trying to break through my admins firewall on 1531. But my admin was thinking it needs more than one port like Microsoft MySQL. Are there special requirements for port assignments? If this doesn't work I have to use M. MySQL. :( Thanks in advance. G. Cooper

MYSQL and large fields

2002-12-03 Thread Grant Cooper
We have switched over from Microsoft Access to MySQL because we were unable to store large files. 2-3 pages of written text. But M. Access kept messing with the data. MySQL has Blob types that can store large amounts of Data. So, can MySQL store 2-3 pages of text or would this be a limitation. I h

Re: Data base driven web page idea - need help!

2002-11-27 Thread Grant Cooper
Thanks you very much for all your suggestions. I really appreciate it. Grant Cooper - Original Message - From: "Matthew Baranowski" <[EMAIL PROTECTED]> To: "Grant Cooper" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 9:2

Re: Data base driven web page idea - need help!

2002-11-27 Thread Grant Cooper
have to sleep on it. Thanks for your input. I'm a one man team developing this and I've been sinful. This is the time God's going to punish me if this blows up in my face. hehe. - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Grant Coop

Data base driven web page idea - need help!

2002-11-26 Thread Grant Cooper
I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of th

Re: simple update!!!

2002-09-05 Thread Grant Cooper
sql,query please respond directly, not part of list yet. > > This is crazy, ok. > I am trying to update lot's of tables. Can I do this in one command? > > If so, what is the command. I've tried everything. Nothing works. I can only > update one table at a time. > > I am s buying a book. > >