Dear list,
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT
Chris Kavanagh wrote:
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT
[snip]
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone very
kindly gave me and I only have a vague idea of what the first line's doing!
Can anyone see the problem here?
SELECT DATEDIFF(leadtime_type,
Thanks very much for the replies, guys. My version is 4.1.7-max.
The error message I get is:
--
Error Executing Database Query.
Syntax error or access violation: 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
I think datediff only takes two arguments and you have three listed.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Chris Kavanagh
Sent: Monday, January 31, 2005 5:33 PM
To: mysql@lists.mysql.com
Subject: Re: SQL syntax error: help a noob
On 31 Jan 2005, at 11:39 pm, Tom Crimmins wrote:
I think datediff only takes two arguments and you have three listed.
Nailed it! Thanks, Tom.
Best regards,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
