No valid database connection 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 'AND UPPER(C.CompanyNam_EN) like "%"ORDER BY CompanyName' at line 15 SQL=SELECT C.CompanyId as CompanyId, C.CompanyNam_EN as CompanyName, C.CompanyAddre_EN as CompanyAddress,C.CompanyZip as CompanyZip, C.CompanyCit_EN as CompanyCity, C.CompanyPhone as CompanyPhone, C.CompanyFax as CompanyFax, C.CompanyEmail as CompanyEmail, C.CompanyUrl as CompanyUrl, C.CompanyLogo_EN as CompanyLogo, P.CompPropName_EN as CompPropName, P.CompPropValue_EN as CompPropValue, C.CompTypeID as CompTypeID FROM Companies C,CompanyProperties P WHERE P.CompanyId = C.CompanyId AND P.CompPropOrderBy = (SELECT min(I.CompPropOrderBy) FROM CompanyProperties I WHERE I.CompanyId=P.CompanyId) AND C.CompanyActive = 1 AND C.CompTypeID = AND UPPER(C.CompanyNam_EN) like "%"ORDER BY CompanyName