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

Δεν υπάρχουν Μέλη που εκπληρούν το Κριτήριο που δώσατε

Χρησιμοποιούμε cookies για να βελτιώσουμε την ιστοσελίδα μας και την εμπειρία σας όταν την χρησιμοποιείτε. / We use cookies to improve our website and your experience when using it.
Για να ενημερωθείτε για την πολιτική μας για τα cookies διαβάστε εδώ privacy policy / To find out more about the cookies we use and how to delete them, see our privacy policy.

Αποδέχομαι τη χρήση cookies από αυτή την ιστοσελίδα / I accept cookies from this site.
EU Cookie Directive plugin by