Commands out of syn Error
Hello All,
Following is my query.i am using certain functions in it.
It works fine with function "FN_APP_DOCUMENT_GET_YOUTUBE_URL" commented.
When i uncomment this function, it gives error "Commands out of sync; You can't run this command now".
Other functions dont have this issue.
Code for function is given in the end.
SELECT QUERY:
select distinct bf.CLIENT_ID AS ClientID,FN_GET_BUILDING_NAME(bf.BUILDING_ID) AS Building,bf.BUILDING_ID AS BUILDING_ID,bf.BACKGROUND_COLOR AS BackgroundColour,FN_GET_FEATURE_CATEGORY_NAME(bf.FEATURE_CATEGORY_ID) AS FeatureCategory,bf.FEATURE_CATEGORY_ID AS FEATURE_CATEGORY_ID,bf.TITLE AS Title,bf.FEATURE_ID AS FeatureID,
-- bf.BACKIMAGE_DOCUMENT_ID AS BackImageDocID,
FN_GET_SPONSORNAME(bf.SPONSOR_ID) AS Sponsor,bf.SPONSOR_ID AS SPONSOR_ID,
bf.BACKIMAGE_DOCUMENT_ID AS BackImageDocumentID,
cast(concat(_utf8'ThumbNailHandler.ashx?ID=',bf.BACKIMAGE_DOCUMENT_ID) as char charset utf8) AS ImageURL,
FN_GET_SYS_LOOKUP_DESC('PRO_BUILDING_FEATURE.ARITHMETIC_OPERATION',
bf.ARITHMETIC_OPERATION) AS DArithmeticOperation,
FN_GET_SYS_LOOKUP_DESC('PRO_BUILDING_FEATURE.TIME_SERIES',bf.TIME_SERIES)
AS DTimeSeries,
bf.TIME_SERIES AS TIME_SERIES,
bf.SERVICE_ID AS SERVICE_ID,
bf.SERVICE_ID AS Resource,
FN_GET_SERVICENAME(bf.SERVICE_ID) AS NAME,
fn_selectuser(bf.CREATED_BY_USER_ID,bf.CREATED_ON) AS CreatedBy,
fn_selectuser(bf.UPDATED_BY_USER_ID,bf.UPDATED_ON) AS UpdatedBy,
-- FN_APP_DOCUMENT_GET_YOUTUBE_URL(bf.BACKIMAGE_DOCUMENT_ID,bf.CLIENT_ID) AS URL,
bf.DATAPOINT_DEF_ID AS DATAPOINT_DEF_ID,
FN_GET_CDCNAME_FORFEATURE(bf.DATAPOINT_DEF_ID) AS DataPointDefName
from ((pro_building_feature bf left join pro_inmd_meterdatapoint imdp on((imdp.METER_DATAPOINT_ID = bf.DATAPOINT_ID)))) order by bf.TITLE;
************************ FUNCTION CODE BELOW********************
DROP FUNCTION IF EXISTS FN_APP_DOCUMENT_GET_YOUTUBE_URL;
CREATE FUNCTION FN_APP_DOCUMENT_GET_YOUTUBE_URL`(IMAGE_ID BIGINT(20),CLIENTID BIGINT(20)) RETURNS varchar(255) CHARSET utf8
DETERMINISTIC
BEGIN
DECLARE FIELD_VALUE VARCHAR(150);
IF ((IMAGE_ID IS NOT NULL AND IMAGE_ID>0) AND (CLIENTID IS NOT NULL AND CLIENTID>0)) THEN
SELECT URL INTO FIELD_VALUE
FROM app_document
WHERE DOCUMENT_ID = IMAGE_ID AND CLIENT_ID = CLIENTID;
END IF;
RETURN IFNULL(FIELD_VALUE,'');
END;
***********
Any sort of help would be welcome.
Thanks!