我用select和where 读取数据库指定的记录，但出错，也试过用where 不同条件，请问各位我应如何做才能解决？

[tod_lee]

我用select和where 读取数据库指定的记录，但出错，请问各位我应如何做才能解决？
以下是我的原代码：
Set con = Server.CreateObject("ADODB.Connection")
set rst = Server.CreateObject("ADODB.Recordset")
ks = Server.Mappath("\fpdb\scooter_part.mdb") & ";"
con.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & ks
sql = "SELECT * FROM scooter_part where e_part_name = "Starter Claw (Pawl)""
rst.Open sql,con,1,1
错误报告：
Microsoft VBScript compilation error '800a0401'

Expected end of statement

/get_retail_price.asp, line 16

sql = "SELECT * FROM scooter_part where e_part_name = "starter claw (pawl)""
-------------------------------------------------------^

[zysoft17]

Set con = Server.CreateObject("ADODB.Connection")
set rst = Server.CreateObject("ADODB.Recordset")

ks = Server.Mappath("\fpdb\scooter_part.mdb") & ";"
'1.把这句改成:ks = Server.Mappath("fpdb\scooter_part.mdb") & ";" 试试

con.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & ks

sql = "SELECT * FROM scooter_part where e_part_name = "Starter Claw (Pawl)""
'2.把上句改成: sql ="SELECT * FROM scooter_part where e_part_name = 'Starter Claw (Pawl)'" 试试,还有我不明白Starter Claw (Pawl)是什么意思?

rst.Open sql,con,1,1

[zysoft17]

啊我明白了!是要查询的内容!对吧?

[belldandy11]

sql = "SELECT * FROM scooter_part where e_part_name = "Starter Claw (Pawl)""
改成: sql ="SELECT * FROM scooter_part where e_part_name = "&Starter Claw(Pawl)&""

[猪头堂主]

sql = "SELECT * FROM scooter_part where e_part_name = "Starter Claw (Pawl)""中的"Starter Claw (Pawl)"是获取TEXT的数据吗？是的话要request一下

[tod_lee]

我也试过改为sql ="SELECT * FROM scooter_part where e_part_name = "&Starter Claw(Pawl)&""但还是出错，我是想把e_part_name为“Starter Claw(Pawl)”的记录的有关数据取出来，我还试过改为sql ="SELECT * FROM scooter_part where e_part_name = "％Starter Claw(Pawl)％""也不成。看书都看了十回了，也找不到解决方法，请问还有好的建议吗？

[tod_lee]

Starter Claw (Pawl)是一个零件的名称。

[jspadmin]

应该是括号导致出错，试试sql ="SELECT * FROM scooter_part where e_part_name ='Starter Claw(Pawl)'"
----------------------------------------------------------------------------------
欢迎光临我的小站（提供免费博客申请）：http://www.pifoo.com

[hudson]

Set con = Server.CreateObject("ADODB.Connection")
set rst = Server.CreateObject("ADODB.Recordset")
ks = Server.Mappath("../database/henkoudb2.mdb") & ";"
con.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & ks
sql = "SELECT * FROM USER_INFO where USRNAME = 'Starter Claw(Pawl)'"
rst.Open sql,con,1,1
我测试过没问题啊，你是不是SQL拼错了。
在SQLSERVER中能运行吗你的SQL文

[tod_lee]

我是以前没搞过SQL，也没安装SQLSERVER，只是直接发文件到WEB上试。