我是这么写的,但不成功
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))))))"
解决方案 »
- 能否让while循环按照规定的时间一次一次的循环啊!@!!!!!!
- 求一验证正浮点数的正则表达式
- JS注册信息的问题,我不要原码,我想知到该怎么解决我想知道的问题,谢谢了!
- 新手的一个问题急求大家帮忙,重分请教啊~在线等!
- 关于滚动条跟随滚动的问题
- 50分求救~~~div中写marquee
- 请问下我写的一段JS,为什么有时候能执行,有时候不行?
- 为什么在asp中不能执行下列代码
- 不甘心:A窗口打开B窗口,B窗口提交到A窗口时,同时关闭B窗口,如何实现?
- 有何办法可以让<Table><td>标签中的数据(数据中有空格)不自动折行。
- java在获取网页标题有问题!请高手指教,在线等!
- 急:怎样判断输入文本域的数据是2003/02/03这样的日期格式?
.........
x="hishguirehwugiherw"
+"..."
+"..."... +"...";每个引号里面的玩意都不能换行。