On 6/8/06, George <[EMAIL PROTECTED]> wrote:
Hi,I try to use datediff() function in SQl select statement but got an error:
Error Executing Database Query.
Query Of Queries syntax error.
Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but encountered '(' instead, A select statement should have a 'FROM' construct.The error occurred in E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuadmin.cfc: line 227
Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 9
Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 1
Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuadmin.cfc: line 227
Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 9
Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 1 225 : SELECT abs(datediff(dd,date_submitted,date_com)) AS SubTotalNum
226 : FROM qAllRequestedJobsWithAllFields
227 : WHERE (date_submitted BETWEEN #convertedStartDate# AND #convertedEndDate#) AND (date_com is not null) 228 : </CFQUERY> 229 : </CFCASE>Could anyone please help?Thanks,George
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---