c# - '/' 应用程序中的服务器错误。在 c#.net 中

Question

我在 C#.Net 中传递 MYSQL 查询，但总是遇到同样的错误。

我的查询是

    topCustomers.DataSource = GetData("SELECT l.Username , Sum( ad.Amt ) AS Amount ,ad.UserDate FROM adm_advt_answer ad" +
                              "JOIN adm_advt_question adq ON ad.Q_ID = adq.nID" +
                              " INNERJOIN login l ON adq.Buserid = l.Buserid WHERE adq.Buserid = '" + username + "' AND adq.Active='Y' AND date( ad.UserDate ) = '2014-02-20'" +
                              " GROUP BY UserId");
    topCustomers.DataBind();

请纠正我的语法。

我的错误是

您的 SQL 语法有误；查看与您的 MySQL 服务器版本对应的手册，了解在“adm_advt_question adq ON ad.Q_ID = adq.nID INNERJOIN login l ON adq.Buserid = l.”附近使用的正确语法。在第 1 行

Answer 1

尝试使用 INNER JOIN 而不是 INNERJOIN。

topCustomers.DataSource = GetData("SELECT l.Username , Sum( ad.Amt ) AS Amount
,ad.UserDate FROM adm_advt_answer ad " +//Notice the space at ending
"JOIN adm_advt_question adq ON ad.Q_ID = adq.nID" +
" INNER JOIN login l ON adq.Buserid = l.Buserid WHERE adq.Buserid = '" + username + "' AND   
adq.Active='Y' AND date( ad.UserDate ) = '2014-02-20'" +
" GROUP BY UserId");

你应该考虑使用PreparedStatements来避免sql注入(inject)。(对于参数username)