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 Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.