62,243
社区成员
发帖
与我相关
我的任务
分享--sql言语的一般问题?
string idn=this.TextBox1.Text;
sql="select id,cardid,name,paw,nickname from reg when id like '%"+idn+"%'";
网页上办错:'when' 附近有语法错误
sql="select id,cardid,name,paw,nickname from reg when id like '%"+idn+"%'";
网页上办错:'when' 附近有语法错误
...全文
请发表友善的回复…
发表回复
batisituta 2003-07-23
- 打赏
- 举报
1.when改为where
2.sql="select id,cardid,name,paw,nickname from reg where id like %"+idn+"%";
2.sql="select id,cardid,name,paw,nickname from reg where id like %"+idn+"%";
szhuk 2003-07-23
- 打赏
- 举报
呵呵，不好意思
sql="select id,cardid,name,paw,nickname from reg where id = "+idn;
sql="select id,cardid,name,paw,nickname from reg where id = "+idn;
szhuk 2003-07-23
- 打赏
- 举报
如果是ID是numeric型最好不要这样做
sql="select id,cardid,name,paw,nickname from reg where id like "+idn;
sql="select id,cardid,name,paw,nickname from reg where id like "+idn;
付长松_华为云MVP 2003-07-23
- 打赏
- 举报
ID is int!!
szhuk 2003-07-23
- 打赏
- 举报
sql="select id,cardid,name,paw,nickname from reg where id like '%"+idn+"%'";
eshusheng 2003-07-23
- 打赏
- 举报
似乎应该是"where"?
Englishgenius 2003-07-23
- 打赏
- 举报
where 不是when
