Συνδεδεμένα Μέλη
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.CompanyName) like "%"ORDER BY CompanyName' at line 15 SQL=SELECT
C.CompanyId as CompanyId, C.CompanyName as CompanyName, C.CompanyAddress as CompanyAddress,C.CompanyZip as CompanyZip,
C.CompanyCity as CompanyCity, C.CompanyPhone as CompanyPhone, C.CompanyFax as CompanyFax, C.CompanyEmail as CompanyEmail,
C.CompanyUrl as CompanyUrl,
C.CompanyLogo as CompanyLogo,
P.CompPropName as CompPropName, P.CompPropValue 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.CompanyName) like "%"ORDER BY CompanyName