vad kan felet vara??
Fick felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Unknown column 'tu.userID' in 'on clause'
Kod:
SELECT
tu.userID, tu.userName, tu.userInvitedBy, tu.userPicture, tu.userAddressCity, tue.userEducationSchool, tue.userEducationSchoolAlignment, tuw.userWorkEmployer, tuw.userWorkPosition
FROM
tableUser tu,
tableUserEducation tue,
tableUserWork tuw
INNER JOIN
tableUserEducation tue2 ON tu.userID = tue2.userEducationToID
INNER JOIN
tableUserWork tuw2 ON tu.userID = tuw2.userWorkToID
WHERE
tu.userName LIKE '%" & functionInjection(Request.Querystring("searchField")) & "%' AND
tu.userAddressCity LIKE '%" & functionInjection(Request.Querystring("usercity")) & "%' AND
tu.userAddressCountry LIKE '%" & functionInjection(Request.Querystring("usercountry")) & "%' AND
tu.userWebsite LIKE '%" & functionInjection(Request.Querystring("userWebsite")) & "%' AND
tue.userEducationSchool LIKE '%" & functionInjection(Request.Querystring("userEducationSchool")) & "%' AND
tue.userEducationSchoolAlignment LIKE '%" & functionInjection(Request.Querystring("userEducationSchoolAlignment")) & "%' AND
tuw.userWorkEmployer LIKE '%" & functionInjection(Request.Querystring("userWorkEmployer")) & "%' AND
tuw.userWorkPosition LIKE '%" & functionInjection(Request.Querystring("userWorkPosition")) & "%' " & stringSQL & " AND
tu.userAccept = 1
GROUP BY
tu.userID
ORDER BY
tu.userName ASC,
tu.userOnline ASC,
tu.userLoginDate DESC