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
oRS1.movef
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 rea
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 ar
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 .
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
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 tab
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 files
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 o
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)
);
Righ
On Sun, Sep 16, 2001 at 02:11:20PM -0700, Jim Dickenson wrote:
> Does anyone have an opinion about the following? Are people using decimal
> type fields? Is it important for the database to allow only allowed data?
I use decimal datatype fields all the time for my monetary amounts. I've
always t
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.
- Origi
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: sur
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_r
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
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
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 va
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 fan
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 DA
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
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
Subje
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, s
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, fiel
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
configure MySQL with it.
>Fix:
It can probably be hacked to make it work, but should not need to.
>Submitter-Id:
>Originator:Chris Johnson
>Organization:
>MySQL support: none
>Synopsis: MySQL 3.23.31 configure fails with Berkeley DB
>Severity: serious
24 matches
Mail list logo
