ads.SelectCommand = "SELECT * FROM [defaultpage] WHERE ca_id =" + Request.QueryString["ca_id"] + " ORDER BY [album_date] DESC";
这是sql2005语句的order by语句,但是会显示关键字“order”附近有语法错误。请问各位大神这是怎么回事,我看是没有问题,求大神指点!分不多,全给了!
这是sql2005语句的order by语句,但是会显示关键字“order”附近有语法错误。请问各位大神这是怎么回事,我看是没有问题,求大神指点!分不多,全给了!
ads.SelectCommand = "SELECT * FROM [defaultpage] WHERE ca_id ='" + Request.QueryString["ca_id"] + "' ORDER BY [album_date] DESC";
ads.SelectCommand = "SELECT * FROM [defaultpage] WHERE ca_id =@anchao ORDER BY [album_date] DESC";
ads.Parameters.AddWithValue("anchao",Request.QueryString["ca_id"]);请这样测试一下,应该不会再有什么问题!!