Είσοδος Όνομα Χρήστη Κωδικός
English (United Kingdom)Greek
Κεντρική Σελίδα Μέλη Τακτικά Μέλη
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

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