stockton Posted March 11, 2009 Share Posted March 11, 2009 Please tell me what "ERROR 1305 (42000): FUNCTION dotproject.EFT does not exist" produced by the following means & how I fix it. mysql> SELECT LEFT(project_name,50) AS 'Project', -> /*== Decode Project Status == */ -> CASE project_status -> WHEN 1 THEN LEFT('Incoming/Approval',20) -> WHEN 2 THEN LEFT ('Planning',20) -> WHEN 3 THEN LEFT('In Progress',20) -> WHEN 4 THEN LEFT('QC/UAT',20) -> WHEN 5 THEN LEFT('Complete',20) -> WHEN 6 THEN LEFT('On Hold',20) -> WHEN 7 THEN EFT('Archived',20) -> END AS 'Status' -> from projects; ERROR 1305 (42000): FUNCTION dotproject.EFT does not exist Link to comment https://forums.phpfreaks.com/topic/148917-solved-error-1305-42000-function-dotprojecteft-does-not-exist/ Share on other sites More sharing options...
aschk Posted March 11, 2009 Share Posted March 11, 2009 Typo.... See "WHEN 7 THEN EFT('Archived',20)" Can you spot the error? Link to comment https://forums.phpfreaks.com/topic/148917-solved-error-1305-42000-function-dotprojecteft-does-not-exist/#findComment-781996 Share on other sites More sharing options...
stockton Posted March 11, 2009 Author Share Posted March 11, 2009 I should have seen that. I am sorry to have wasted your time. Link to comment https://forums.phpfreaks.com/topic/148917-solved-error-1305-42000-function-dotprojecteft-does-not-exist/#findComment-782087 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.