87,904
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
bzscs 2003-12-27
- 打赏
- 举报
sqlstr = "select * from xt_mkb where supper="+nodeID+" and id in (select id from xt_mkb where userid="+userID+" and js=2)"
sqlstr = sqlstr + "union"
sqlstr = sqlstr + "select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where userid="+userID+" and js=3)"
.........
sqlstr = sqlstr + "union"
sqlstr = sqlstr + "select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where userid="+userID+" and js=3)"
.........
xucb 2003-12-27
- 打赏
- 举报
我是这么写的，但不成功
sqlstr = "select * from xt_mkb where supper="+nodeID+" and id in (select id from xt_mkb where userid="+userID+" and js=2)"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where userid="+userID+" and js=3)"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=4))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=5)))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper* from xt_mkb where userid="+userID+" and js=6))))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=7)))))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=8))))))"
sqlstr = "select * from xt_mkb where supper="+nodeID+" and id in (select id from xt_mkb where userid="+userID+" and js=2)"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where userid="+userID+" and js=3)"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=4))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=5)))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper* from xt_mkb where userid="+userID+" and js=6))))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=7)))))"+
"union"+
"select * from xt_mkb where supper="+nodeID+" and id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where id in (select supper from xt_mkb where userid="+userID+" and js=8))))))"
xdspower 2003-12-27
- 打赏
- 举报
可以用+号来连接啊.
ccton 2003-12-27
- 打赏
- 举报
写成这个样子，没有不成功的：
x="hishguirehwugiherw"
+"..."
+"..."
...
+"...";
每个引号里面的玩意都不能换行。
x="hishguirehwugiherw"
+"..."
+"..."
...
+"...";
每个引号里面的玩意都不能换行。
