请教一下这句SQL语句怎么写

[xiangzhang1983]

有以下一段ASP代码
<%
dim con, rs
dim sql
dim id1
id1=Request.QueryString("id")
set con = Server.CreateObject("ADODB.Connection")
con.Open "Driver={SQL Server};Server=(local);UID=sa;PWD=;"&_
"Database=fzgl" '打开数据库连接
set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorType=adOpenStatic
sql="select Top'"&id1&"' * from fqpzdj order by id desc"
rs.open sql,con
%>
意思是查找前N条记录,N是个变量,即'"&id1&"',说我这句SQL语句有错误,应该怎么改啊?谢谢!

[hztgcl1986]

[Quote=引用 1 楼 myvicy 的回复:]
sql="select Top "&id1&" * from fqpzdj order by id desc"
数字两边不要带'
[/Quote]

顶

[ycmuma]

<%
dim con, rs
dim sql
dim id1
id1 = Request.QueryString("id")
set con = Server.CreateObject("ADODB.Connection")
con.Open "Driver={SQL Server};Server=(local);UID=sa;PWD=;"&_
"Database=fzgl" '打开数据库连接
set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
sql= "select Top" & id1 & " * from fqpzdj order by id desc"
rs.open sql,con,1,1
...
%>

[Love_birds]

晕，跑过，以为是什么复杂Sql，进来想看看。呵呵。

没想到……（当我路过！）

[snlixing]

可以结帖了

鉴定完毕。。。。

[xiangzhang1983]

改成以下两个
sql="select Top " & id1 & " * from fqpzdj order by id desc"
sql="select Top "&id1&" * from fqpzdj order by id desc"
还是出现
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '*' 附近有语法错误。

[myvicy]

<%
dim con, rs
dim sql
dim id1
id1=Request.QueryString("id")
set con = Server.CreateObject("ADODB.Connection")
con.Open "Driver={SQL Server};Server=(local);UID=sa;PWD=;"&_
"Database=fzgl" '打开数据库连接
set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorType=adOpenStatic
sql="select Top "&id1&" * from fqpzdj order by id desc"
response.write sql
response.end '输出sql看看，把这个sql拷贝到数据库里去测试，正确后可以把这两句去掉
rs.open sql,con
%>

[孟子E章]

If IsNumeric(id1 ) = false Then
 id1 = 10
Else
id1  = CLng(id1)
End If
sql="select Top " & CStr(id1) & " * from fqpzdj order by id desc" 

[一把编程的菜刀]

[Quote=引用 12 楼 xiangzhang1983 的回复:]

改成以下两个
sql="select Top " & id1 & " * from fqpzdj order by id desc"
sql="select Top "&id1&" * from fqpzdj order by id desc"
还是出现
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '*' 附近有语法错误。
[/Quote]

如果你ID1没有值肯定要出错

[myvicy]

sql="select Top "&id1&" * from fqpzdj order by id desc"
数字两边不要带'

[hookee]

<% 
dim con, rs 
dim sql 
dim id1 
id1 = Request.QueryString("id") 
set con = Server.CreateObject("ADODB.Connection") 
con.Open "Driver={SQL Server};Server=(local);UID=sa;PWD=;"&_ 
              "Database=fzgl" '打开数据库连接 
set rs = Server.CreateObject("ADODB.Recordset") 
rs.CursorLocation = 3
sql= "select Top" & id1 & " * from fqpzdj order by id desc" 
rs.open sql,con,1,1
...
%> 

[cnchart]

sql="select Top'"&id1&"' * from fqpzdj order by id desc"


要加单引号吗？

去掉它，换成空格

[一把编程的菜刀]

id1
你必须有值

比如你
在1.asp里有一代码：

<a href=2.asp?num=50>看看</a>

2.asp里的SQL语句应该是
sql="select Top "&request("num")&" * from fqpzdj order by id desc"
不能使用单引号
你的使用了单引号

[hookee]

上面的少了个空格

<% 
dim con, rs 
dim sql 
dim id1 
id1 = Request.QueryString("id") 
set con = Server.CreateObject("ADODB.Connection") 
con.Open "Driver={SQL Server};Server=(local);UID=sa;PWD=;"&_ 
              "Database=fzgl" '打开数据库连接 
set rs = Server.CreateObject("ADODB.Recordset") 
rs.CursorLocation = 3
sql= "select Top " & id1 & " * from fqpzdj order by id desc" 
rs.open sql,con,1,1
...
%>

[cnchart]

只能是

select top 3 from table

而不能是

select top '3' from table

[chinastorm]

用conn.execute（sql）这种方法

[xiangzhang1983]

net_lover 的答案是正确的,不愧是专家,爱死net_lover 了

[一把编程的菜刀]

他只是把你的为空的情况过滤了

[一把编程的菜刀]

只能说你粗心大意
又不是难题

[MissStar]

...基础了点..