RE: Invalid syntax with STD() function when more than one field is used in select query

2006-07-21 Thread William Bronsema 
Oops, the version numbers were 4.1.18-nt and 4.1.19-standard.  I have tried
it now on the latest 4.1.20 version and still have the same problem.

Does anyone have any ideas?  Is this a bug?

Cheers,
Bill



 -Original Message-
 From: William Bronsema
 Sent: Thursday, July 20, 2006 10:18 AM
 To: mysql@lists.mysql.com
 Subject: Invalid syntax with STD() function when more than one field is
 used in select query
 
 Hello,
 
 I am encountering a strange issue when using the STD function.  On my
 local development machine (MYSQL version 4.18-nt) I can run the following
 basic SELECT query with no problems:
 
 SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP
 BY UKEY
 
 When I test this query on my hosted production machine (MYSQL version
 4.19-standard) that query results in an invalid syntax error:
 
 #1064 - You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near
 '( `LAPSETIME` ) , UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
 UKEY
 LIM' at line 1
 
 The query will work if I remove the UKEY field in the select:
 
 SELECT STD(`LAPSETIME`) FROM 4b3f91f64a19529a84dff4982c8a6bc5
 
 Any ideas?
 
 Cheers,
 Bill



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Invalid syntax with STD() function when more than one field is used in select query

2006-07-20 Thread William Bronsema 
Hello,

I am encountering a strange issue when using the STD function.  On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:

SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY

When I test this query on my hosted production machine (MYSQL version
4.19-standard) that query results in an invalid syntax error:

#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(
`LAPSETIME` ) , UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY UKEY
LIM' at line 1

The query will work if I remove the UKEY field in the select:

SELECT STD(`LAPSETIME`) FROM 4b3f91f64a19529a84dff4982c8a6bc5

Any ideas?

Cheers,
Bill



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]