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]