[摘要]&900,这时当你执行以下的查询语句时,肯定会报错: SQL = "SELECT * FROM SecurityLevel WHERE UID='" &...
&900,这时当你执行以下的查询语句时,肯定会报错:
SQL = "SELECT * FROM SecurityLevel WHERE UID='" & UserID & "'"
SQL = SQL & " AND PWD='" & Password & "'"
因为你的SQL将会是这样:
SELECT * FROM SecurityLevel WHERE UID='1'test' AND PWD='A
关键词:处理ASP执行DB查询中的特殊字符问题