dim sql as string dim orderby as string sql="select * from guestbook" sql=guestbook & " order by 故障发生时间 desc"
sql="select * from guestbook" sql=guestbook & " order by 故障发生时间 desc" ok!~
sql字符串连接是没有问题的 str2 前面要有个空格,不然 guestbook和order就加成一个了,所以sql语句出错。 现有字符串1="select * from guestbook" 字符串2=" order by 故障发生时间 desc" 想让字符串3="select * from guestbook order by 故障发生时间 desc" 你在试试
sql字符串连接是没有问题的 str2 前面要有个空格,不然 guestbook和order就加成一个了,所以sql语句出错。 现有字符串1="select * from guestbook" 字符串2=" order by 故障发生时间 desc" 想让字符串3="select * from guestbook order by 故障发生时间 desc" 你在试试=================================== 我也认为这样
str2 ="order by 故障发生时间 desc"
str3=str1 +str2
str2 ="order by 故障发生时间 desc";
str3=str1 + str2 ;
System.Data.OleDb.OleDbException: FROM 子句语法错误。源错误:
行 109: ada=new oledbdataadapter(sql,con)
行 110: ds=new dataset()
行 111: ada.fill(ds,"guestbook")
行 112: rp.datasource=ds.tables("guestbook")
行 113: rp.databind()
在page_load中response.write(str3)
dim orderby as string
sql="select * from guestbook"
sql=guestbook & " order by 故障发生时间 desc"
sql=guestbook & " order by 故障发生时间 desc"
ok!~
str2 前面要有个空格,不然 guestbook和order就加成一个了,所以sql语句出错。
现有字符串1="select * from guestbook"
字符串2=" order by 故障发生时间 desc"
想让字符串3="select * from guestbook order by 故障发生时间 desc"
你在试试
str2 前面要有个空格,不然 guestbook和order就加成一个了,所以sql语句出错。
现有字符串1="select * from guestbook"
字符串2=" order by 故障发生时间 desc"
想让字符串3="select * from guestbook order by 故障发生时间 desc"
你在试试===================================
我也认为这样