Hey all,
I'm having problems ! , my app was running fine until this morning.
I receive following error :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error
/clientenrollment.asp, line 67
the line 67 for that file is
You should be able to just use something like this:
Select uid, username From tablename Where '$externalstringvar' like query;
That's PHP syntax. You'll have to use whatever makes sense for your
scripting or programming language in place of the $externalstringvar
variable. The single-quotes
I'd have to guess that MySQL is interpreting the set clause this way:
Set events_ID = ( 512 AND ( term = 'changed' ))
That is, a logical AND, so a zero result makes sense. Still, it seems a bit
odd.
- Original Message -
From: Salada, Duncan [EMAIL PROTECTED]
For one of two reasons
A test SQL script which duplicates this problem is available via anonymous
FTP at the following location:
Hostname: ftp.visi.com
Directory: /users/chris
Filename: test.sql
Run the script like this to see the error:
mysql -t temp test.sql
The second select statement returns only 2 of the
Q1: I am not sure what you mean by executing queries through files. Do you
mean being able to run a query from a script like this?
#!/bin/sh
mysql -t -p password -u usename databasename EOF
Select * From mytable;
EOF
Q2: There are mailing list archives available at http://lists.mysql.com .
David,
I don't know the answers to your biggest problem, but do know the answer to
your last question: Yes, it seems perfectly normal to nail one CPU and take
2 minutes to show tables with 80,000 tables. Somewhere on your system is a
directory that has 240,000 files (80,000 tables times 3
This should be pretty close to what you need, if I understand your
situation:
Select * From mytable
Where
(querydate1 tabledatelow And querydate1 tabledatehigh)
And
(querydate2 tabledatelow And querydate2 tabledatehigh);
I'm assuming you know which of the two dates in the table
One only needs to specify the column names if and only if there are not
values, in the correct order, for all of the columns in the table.
That is:
Create Table foo (
aid intnot nullprimary key,
last varchar(30),
firstvarchar(30),
emailvarchar(60)
);
It appears (without verifying it myself), these are the approximate
meanings:
IdThe process or thread ID of this particular job or process in the
database
UserUsername of this job or process or connection
HostFrom which host is the User connected
dbWhat is the default database or
Paradox should allow you to export your data in some sort of flat file
format, such as comma separated values (CSV). If so, you can use the MySQL
mysqlimport program or the MySQL load data infile 'filename' into
table... statement to load the flat files into your MySQL database.
- Original
If you want a count for a specific team:
Select count(*) From table Where team = 'support';
If you want the counts for all the teams:
Select team, count(*) From table Group By team;
- Original Message -
From: Jamie Burns [EMAIL PROTECTED]
I have a table (ref, name, team, seminar_ref)
Woops! Nevermind. I didn't notice your data was denormalized.
- Original Message -
From: Chris Johnson [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 14, 2001 10:33 PM
Subject: Re: surely an easy quick one
If you want a count
The directory /usr/local/src/mysql-3.23.42-source-bin/var/ does not exist on
your system. You probably do not really want your database files stored in
such a cryptic directory name. You probably need to use the --basedir
or --datadir parameters to mysqld to tell it where your databases really
What version of FreeBSD do you have installed? Was it upgraded from an
earlier version? If so, was the ports collection upgraded as well?
This sounds like you have incompatible versions of the system and the ports
collection installed.
- Original Message -
From: Siva Namburi [EMAIL
That error message is coming from PHP, not from MySQL.
PHP generates that error message when, for some reason, the number of fields
returned by a MySQL query was greater than zero, but the return from
mysql_store_result() or mysql_use_result() was zero or NULL.
The PHP code which checks those
The remote hosts you mention are not allowed to access the database. This
is a permissions problem, in particular the value of hosts in one of the
permissions tables. It sounds like they only allow connections from the
localhost or their own network.
..chris
- Original Message -
From:
I think you will you have to do it in 2 steps using a temporary table. This
is one of MySQL's biggest weak points.
..chris
- Original Message -
From: Mattias Jiderhamn [EMAIL PROTECTED]
I have a table
CREATE TABLE currency_rate (
currency_id VARCHAR(3),
currency_date DATE,
I've used all three, Access, Oracle and MySQL. I have the least expertise
with Access.
My impressions are:
* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL. It does not handle large amounts of
data well. Access is really a very
I use MySQL a number of different ways: the C API, from PHP, from the
command line, and often from shell scripts run by other users or from
crontab entries. The latter two uses present a couple of problems that
could be fixed easily through some minor changes to the code for the mysql
program
Looking at this post and your previous one, you could just create a new
table with the same definition as the old table except to make the field you
want with the numbered field be an int auto_increment datatype.
Then do the following SQL:
Insert Into newtable
Select field1, field2, NULL,
Do it this way:
Create Table copy ( sessionid int not null auto_increment,
username varchar(20 not null,
start int not null,
stop int not null,
ipaddress varchar(15),
Primary Key (sessionid),
Index altkey (username, start, stop)
);
Insert Into copy
Select NULL, username, start,
Do you want to delete all records which have duplicates, or do you want to
delete all the duplicates but leaving one copy of each duplicated record
behind?
- Original Message -
From: Rory O'Connor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 4:50 PM
Subject:
It can probably be hacked to make it work, but should not need to.
Submitter-Id: submitter ID
Originator:Chris Johnson
Organization:
MySQL support: none
Synopsis: MySQL 3.23.31 configure fails with Berkeley DB
Severity: serious
Priority: high
Category: mysql
Class:
23 matches
Mail list logo