还是再问下我这个sql语句为什么得不到结果呢
Dim InsertTag,InsertSqlStr
InsertTag = DateToStr(Now(), "YmdHIS ")&Generator(5)
InsertSqlStr = "INSERT INTO User (Name,Pass,AddDate,InsertTag) VALUES ( ' "&Name& " ', ' "&Pass& " ', ' "&Now()& " ', ' "&InsertTag& " '); "
InsertSqlStr = InsertSqlStr& "select ID AS UserID,InsertTag from User where InsertTag= ' "&InsertTag& " ' "
Conn.ExeCute(InsertSqlStr)
Response.Write(UserID)
==========================================
意思就是插入数据后立即得到这个自动编号id，数据插入是成功了，为什么读不出id呢
[解决办法]
Dim InsertTag,InsertSqlStr
InsertTag = DateToStr(Now(), "YmdHIS ")&Generator(5)
InsertSqlStr = "INSERT INTO User (Name,Pass,AddDate,InsertTag) VALUES ( ' "&Name& " ', ' "&Pass& " ', ' "&Now()& " ', ' "&InsertTag& " '); "
InsertSqlStr = InsertSqlStr& "select ID AS UserID,InsertTag from User where InsertTag= ' "&InsertTag& " ' "
set rs=Conn.ExeCute(InsertSqlStr)
Response.Write(rs( "UserID "))
[解决办法]
报错了还是什么都不显示?
user是系统保留字段,应该写成[user]
