sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='" & taskid & "'"
如果TASK_GROUP_ID为数值型,则可以不用' sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid
sql="select a.*,b.theday as btheday,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='"& taskid &"'"
fengfangfang 你好象没有改吧 我写出来的有错误 错误就是:SQL 命令未正确结束
fengfangfang 你好象没有改吧 我写出来的有错误 错误就是:SQL 命令未正确结束
空格有没有问题 sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='" & taskid & "'"
你的taskid是不是int型的,如果是,则不需要用单引号了sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid
我不知道是不是要把where 语句也改成on语句 空格我看过了 应该没问题的
你可以把你的sql变量Response.write出来,然后贴出来看一下,容易找错误
也不是这个问题 因为我原先只查询一张表的时候用sql="select * from TASK_GROUP REST_TIME_SPAN where TASK_GROUP_ID='"&taskid&"'" 是没有任何错误的
Response.write 写出的语句是: select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=6425
写出来是这样的 刚才把‘去掉了 select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='6425'
你的taskid是数字型的吧,可以不用引号 你用这个试试 sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid
你的sql变量在执行查询操作时,是否又进行了别的赋值 response.write是在执行前显示的吗? 给加个;看看sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid & ";"再用看看,不显示a.* sql="select b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid一点一点调
sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid
sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='" & taskid & "'"
select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=6425
select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP as a inner join REST_TIME_SPAN as b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID='6425'
你用这个试试
sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid
单引号全角半角有没有问题
a.TASK_GROUP_ID=" & taskid 我刚才也试了 还是错误SQL 命令未正确结束
''也没错
response.write是在执行前显示的吗?
给加个;看看sql="select a.*,b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid & ";"再用看看,不显示a.*
sql="select b.START_TIME as START_TIME2,b.END_TIME as END_TIME2 from TASK_GROUP a inner join REST_TIME_SPAN b on a.TASK_GROUP_ID=b.TASK_GROUP_ID where a.TASK_GROUP_ID=" & taskid一点一点调