帮我看一下这段sql语句 - .NET技术 / ASP.NET

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
  sqlSel = sqlSel + "from image as img,album as alb where img.albumID=alb.albumID and img.albumID=" + Request["id"];
到底错在那里呢？

---

form 前面留个空格

---

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
  sqlSel = sqlSel + "from image as img,album as alb where img.albumID=alb.albumID and img.albumID=" + Request["id"];
Request["id"]是什么啊
是Request.QueryString["id"]吗

---

SQL code:

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc ";
sqlSel = sqlSel + " from image as img,album as alb where img.albumID=alb.albumID and img.albumID='" + Request["id"] + "'";


如果albumID是int型的，那后面的单引号就不要加，按你原来的样子就行，
但是前面我加的空格你一定要仔细看好啦！！

---

引用

form 前面留个空格

赞

---

引用

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
sqlSel = sqlSel + "from image as img,album as alb where img.alb