working on now, as it
definately needs updating).
Roger
> -Original Message-
> From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 1:41 PM
> To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Ideas on creating connecti
> -Original Message-
> From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 12:48 PM
> To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Ideas on creating connections
>
>
> I never use DAO.
>
>
My experience is this. I use DAO through MyODBC, and I also use the
libmysql.dll with a custom recordset. Connection times through both options
are extremely fast. Fast enough in my situation that it can basically can be
ignored. There are times when I open several connections to the server at
o
Try
SELECT DISTINCT state_ID FROM financial_master WHERE category_ID = '1'
Roger
> -Original Message-
> From: Comcast [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 2:03 PM
> To: [EMAIL PROTECTED]
> Subject: SELECT only unique records
>
>
> I am sure this is a slam-dunk,
I am having a bit of trouble with the "IN" operator. I am thinking that it
just may be my misunderstanding.
Situation.
I have a table (ZipCounty) that I want to pull vendors from based on
zipcode. So I have a Vendor like field declared as TEXT. To keep the table
up to date, I issuse upd
t_Search.html
Roger
> -Original Message-
> From: Binay Agarwal [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 10, 2003 7:53 PM
> To: Roger Davis; [EMAIL PROTECTED]
> Subject: Re: Quick ones to speed up acces!
>
>
> Thanks Roger for quick response.
>
> Herebel
It's called indexing and your queries should return in under 1 sec unless
you are pulling all your records and all your data. Show us your Queries
and you table structure and I am sure we can help.
Roger
> -Original Message-
> From: Binay Agarwal [mailto:[EMAIL PROTECTED]
> Sent: Sunday,
Hi all,
My slave has been working fine up until now. Here is the error message.
030730 11:32:28 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'SQLServer1-bin.034' at position 77571524
ERROR: 1062 Duplicate entry '120816' for key 1
030730 11:32:28 Slave: er
mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2003 10:02 PM
> To: Roger Davis; [EMAIL PROTECTED]
> Subject: RE: [EMAIL PROTECTED]
>
>
> At 21:17 -0400 7/8/03, Roger Davis wrote:
> >localhost does not mean 127.0.0.1 Localhost is the socket to
> connect to and
>
t: Tuesday, July 08, 2003 9:27 PM
> To: Roger Davis; [EMAIL PROTECTED]
> Subject: Re: [EMAIL PROTECTED]
>
>
> Roger Davis wrote:
>
> > localhost does not mean 127.0.0.1 Localhost is the socket to
> connect to and
> > has is separate from IP addresses.
>
> Does th
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
> -Original Message-
> From: Joel Rees [mailto:[EMAIL PROTECTED]
> Sen
Change you SQL statement as follows.
"SELECT Count(*) as Cnt FROM"
Then use "Cnt" as your "variable" like you would "h_id"
Roger.
> -Original Message-
> From: ed anderson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 5:58 PM
> To: [EMAIL PROTECTED]
> Subject: How can I
?
Or if someone has a better solution I would love to here it.
Roger
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:18 AM
To: Roger Davis; [EMAIL PROTECTED]
Subject: Re: Help with Proper SQL to Limit number of rows
Hi Roger,
> Q
Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something alo
USE hitcounter;
ALTER TABLE info DROP count;
Hope this helps
Roger
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 8:27 PM
To: [EMAIL PROTECTED]
Subject: BEGINNER QUESTION.
I have looked everywhere online, books.
I simply would like to DELETE a F
Try changing this...
category_id NUMERIC NOT NULL AUTO_INCREMENT,
to this...
category_id INT NOT NULL AUTO_INCREMENT,
or MEDIUMINT/BIGINT if you need that much.
The INT type is the only type to accept an auto_increment qualifier.
http://www.mysql.com/doc/en/CREATE_TABLE.html
Hope this help
not really for mhsql list, more for php list but,,,
select your database after connection.
use echo statement to look at you queries.
check your punctuation
Roger
-Original Message-
From: Karl James [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 6:51 PM
To: [EMAIL PROTECTED]
Subje
Maybe the "[EMAIL PROTECTED]" address should be changed to
"[EMAIL PROTECTED]" so people can't pull the Username off the e-mail
address and bypass the filter.
-Original Message-
From: John Klein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject:
Add quotes to you date.
SELECT time_period_id FROM time_periods
WHERE '2003-03-14' BETWEEN time_period_start AND time_period_end;
Worked for me.
Roger
-Original Message-
From: Cory Hicks [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 3:05 PM
To: [EMAIL PROTECTED]
Subject: Findin
Well, believe it or not SUCCESS!! That's right, you were running the mysql
Server.
Now for something you should try. Find the winmysqladmin.exe (Should be in
the same folder. Run that one. It will allow you to run the mysqld as a
service, give you stat's on whats going on, and start and stop t
This may not be the solution you are looking for, but if you are executing
ths query 1000 times, it must be in a program somewhere, so why not execute
it once, pullout the UserID the run the rest on UserID?
Hope this helps.
Roger
-Original Message-
From: Jason West [mailto:[EMAIL PROTECTE
I think this is more of a Programming problem, but to get you started.
In your database add a field call it updated make it char(1) like
ALTER TABLE Hockey ADD Updated char(1) default NULL;
On the first page when you start processing the players put in a programming
line to update all the players
Or
mysql>> flush privileges;
Roger
-Original Message-
From: Ben Balbo [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:08 PM
To: MySQL List
Subject: Re: ERROR 1045: Access denied for user:
Hi Steve,
Really silly question, but you are reloading the tables once you
change the
try thi
FROM lawfac_pub INNER JOIN fac_stud_lunch ON lawfac_pub.hawkid =
fac_stud_lunch_join.instructor_hawkid INNER JOIN fac_stud_lunch_join ON
fac_stud_lunch.instructor_hawkid = fac_stud_lunch_join.instructor_hawkid
-Original Message-
From: Martin Ostlund [mailto:[EMAIL PROTECTED]
Sent:
7;]} Puffy Foam
$message1\n";
The three designs are coming up:
1 0 1 Applique
1 1 0 Puffy Foam
oopsoopsoopsmessage1
This just doesn't make any sense!
-Original
Why don't you verify what the values are in the variables. If the Variables
are not getting set then you would always see the "oops" in your statement.
Try...
echo $applique;
echo $puffyfoam;
Hope this helps
Roger
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
Sent: Friday,
The % wildcard works for granting permission over the network. When you are
working on the localhost, you are using mysql.sock to connect to the server.
Try this (I believe it should work) /bin/mysql -u iz3
ip'iz' -h'youripaddress' This should allow you to connect using the network
and not mysql
Absolutely it is possible (With cavaets).
The cavaets are...
1. Does you web hosting company allow external access to your MySQL
database. I do not know for sure but it looks like they might (telnet works
to port 3306).
2. Is your Mysql user set up to allow external access.
3. If you
>>Most things I've read say to establish a "mysql" user -I take it this
>>is to run the daemon(mysqld?) under?
Correct
>>Is the above user one that will be created in the users table of the
>>mysql db? What mysql privileges does such a user need?
No, this is a unix/linux user that is used to run t
If you are unsure about using the mysql_insert_id, have PHP use a session
variable then do the following,
1. On the insert command, use the session variable as the Name of the class.
2. Retrieve the record with the session variable as the name.
3. Update the record you just retrieve
If I understand right try..
SHOW DATABASES;
The mysql and test database are installed by default.
Hope this helps
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 8:12 PM
To: [EMAIL PROTECTED]
Subject: MySQL Command to "List" existing
Ok, I will try this one again.
I need some help on a select if it is possible. Take for Example the
following data.
--
| RUSH | FileNumber | PTime | PDate |
--
| 1 | 1-1023-001 | 08:00 | 12/04 |
| 1 | 1--001 | 06
I need some help on a select if it is possible. Take for Example the
following data.
--
| RUSH | FileNumber | PTime | PDate |
--
| 1 | 1-1023-001 | 08:00 | 12/04 |
| 1 | 1--001 | 06:00 | 12/04 |
| 0 | 1-1023-0
Redhat 8.0 includes mysql. Although it is not a part of the default
install, you can install it by choosing the option to select which packages
will be installed. Or if you already have redhat 8.0 installed, the mysql
rpms are on the CD's (number 3 I think).
Also, make sure that you update your
Sounds like all is set up properly, but, have you give your mysql USERS
permissions to connect from from the 192.168.1 network?
The Really Insecure way of doing this is...
GRANT ALL PRIVILEGES ON *.* TO mysqlusernamehere@"%" IDENTIFIED BY
'mypasswordhere';
FLUSH PRIVILEGES;
Hope this helps
Rog
erc@;pobox.com]
Sent: Tuesday, October 22, 2002 7:27 PM
To: Roger Davis; [EMAIL PROTECTED]
Subject: RE: Can't Restart Server
> 021022 17:54:13 mysqld started
> 021022 17:54:13 bdb: PANIC: No such file or directory
> 021022 17:54:13 Can't init databases
> 021022 17:54:1
eatly appreciate it.
Thanks
Roger Davis
SQL, MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
Or you could just use the libmySQL.dll and handle everything yourself
through VB.
>>You will however need to download the MyODBC driver if you wish to access
>>MySQL through VB.
>>
>>-Nick
-
Before posting, please check:
h
Redhat (at least 7.3) comes with MySQL. If select the default install for
server, it will NOT install MySQL. You must check the box to Select
individual packages, and check off the MySQL binaries. Of course, you can
always install them After the installation from the CD's but you might have
to
I don't know if you cut and pasted your code, if you did then try this.
$qid = mysql_query("SELECT * FROM 1_nodedata WHERE id = ".$edit_id.";");
$tr = mysql_num_rows ($qid);
echo $tr;
That should give us a count of the rows and it will make sure our query is
returning something.
-Original
40 matches
Mail list logo
