Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: "Gordon" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by error
Try this
SELECT c.account_id,
a.name,a.company,
Hi.
call this function, phpinfo(); in a *.php file.
That should return alot of usesfull info.
Make sure the mysql extension is being loaded.
If so check the value of the following php config var:
; Default socket name for local MySQL connects. If empty,
; uses the built-in ; MySQL defaults.
Try this
SELECT c.account_id,
a.name,a.company,
SUM(c.agent_product_time) AS mins
FROM account a
LEFT JOIN calls c
ON c.account_id = a.id
WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY)
AND c.agent_id = 9
GROUP BY a.account_id
HAVING SUM(c.agent_pr
> > I'm fairly new to all this and duing everything step by step...
> >
> > I made my first (test) php site - and it works... then, i have this
> > script
> > where i'm supposed to find out if MySQL and PHP talk with each
> > other. and
> > there i get the answer
> > "Error 2002: Can't connect to l
What does your script look like? Code?
Ed
On May 13, 2006, at 5:46 PM, Steve wrote:
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this
script
where i'm supposed to find out if MySQL and PHP talk with each
oth
I've got a backup that is scheduled by MySQL Administrator, which appears to be
happening without a problem. However, I just tried to restore that backup on
my machine, and the data doesn't appear to be restoring properly. The original
database was on our web server, where the backup occurs ea
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 16, 2006 3:08 PM
Subject: Re: Converting varchar field into primary key
> Jonathan Mangin wrote:
>
> >>>I'm creating a new MySQL database from an existing Fil
Jonathan Mangin wrote:
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zer
> > > I'm creating a new MySQL database from an existing Filemaker db.
> > >
> > > My problem is that some of the existing 'numbers' in one column (it
> > > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > > 001234. I need to maintain these numbers 'as is' - complete with
> > I'm creating a new MySQL database from an existing Filemaker db.
> >
> > My problem is that some of the existing 'numbers' in one column (it
> > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > 001234. I need to maintain these numbers 'as is' - complete with
> > zeros
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
>How would this query be constructed with the HAVING clause,
>not real fimilar with t
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this script
where i'm supposed to find out if MySQL and PHP talk with each other. and
there i get the answer
"Error 2002: Can't connect to local MySQL server through sock
Mike,
>How would this query be constructed with the HAVING clause,
>not real fimilar with this type of clause.
SELECT
a.id,
a.name,
a.company,
SUM(c.agent_product_time) AS mins
FROM account a
LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY)
AND c.
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this erro
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 1:56 PM
Subject: Re: Baffled by error
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, Ma
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following
query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE
c.calldate >= DATE_SUB(NOW(),INTERVAL 14
corrected it and still the same error.
Mike
- Original Message -
From: "Chris Sansom" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -0500 16/5/06, Mike Blezien wrote:
trying to f
Tried that, still same error. If I remove the 'AND
SUM(c.agent_product_time) >= '500'
then it works, but I need this in the query.
Mike
- Original Message -
From: "Ing. Edwin Cruz" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Tuesday, May 16, 200
Is because in your select you have c.accound_id and in your group by clause
you have a.accound_id
Try this:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.ag
At 12:29 -0500 16/5/06, Mike Blezien wrote:
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS
mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE
c.calldate >= DATE_SUB(NOW(),INTERVAL 14
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, May 16, 2006 1:29 PM
Subject: Baffled by error
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following
query:
SELECT c.account_id,a.name,a.company,SUM
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.agent_id =
On Tuesday 16 May 2006 02:16 am, Philippe Poelvoorde wrote:
> Hi,
>
> I need to upgrade a server from Solaris 8 to Solaris 10. There is one
> MySQL server running on it, (the binary
> mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need
> to upgrade MySQL as well ? (to
> mysql-stan
Hi,
If you are installing in windows only thing you run the setup.exe ,after
the installation
is completed it will prompt for you a default user password that is root
(password).
and also to create anonymous user.
Jim wrote:
Hi All,
Does anybody have some advise on automating the insta
> I'm creating a new MySQL database from an existing Filemaker db.
>
> My problem is that some of the existing 'numbers' in one column (it
> was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> 001234. I need to maintain these numbers 'as is' - complete with
> zeros. I've tried
Hello,
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried al
Hi,
Just yesterday I have finished doing something very similar
( Apache+PHP+MySQL+Database+PHP-Application ) installer
for a demo site. The setup installs the Apache service, the MySQL
service and database and start the services. On unistall it removes
the services, leaving all clean. The idea is
Hi,
I need to upgrade a server from Solaris 8 to Solaris 10. There is one
MySQL server running on it, (the binary
mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need
to upgrade MySQL as well ? (to
mysql-standard-4.1.x-sun-solaris2.10-sparc ?)
--
MySQL General Mailing List
For l
Ooh. I can from cmd-line not set any variable not listed there.
That explains it all.
Yes, I will put the command in the script-file instead then.
Thanks alot.
/Mattias
sheeri kritzer wrote:
I don't know what version you're running, but a
mysql -?
will show you the variables you can set. It'
29 matches
Mail list logo