2. ASPRunnerPro General questions
  3. [SOLVED]   E_Fail Status In Sql Querry
This topic is locked
[SOLVED]

  E_Fail Status In Sql Querry

 		1/3/2013 9:19:17 AM
ASPRunnerPro General questions
M
 mitzi author

Hello, i just encountered this isue: it worked before.

The issue is in the ASPrunner application not in the webserver
I have this query:
SELECT

ID,

EmployeeName,

Address,

DateField,

TimeField,

EndTime,

DATEDIFF("n", [TimeField], [EndTime])/60 AS TotalHrs,

EmployeeRate,

[EmployeeRate]*(DATEDIFF("n", [TimeField], [EndTime])/60) AS Earnings,

OwnerID,

EmployeeTel

FROM WorkedHrs
when i click Results to check if my query is working9as it did just yesterday)

I get this error:
Unspecified error:

Data provider returned an E_FAIL status.
M
 		mitzi author 1/3/2013

http://sqlfiddle.com/
I used this to find the solution:
Schema Creation Failed: 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 '[TimeField], [EndTime])/60 AS TotalHrs, EmployeeRate, [EmployeeRate]*(DATEDIFF("' at line 8:
I had an empty field for EndTime, and that's why the applicatiopn was returning the error.