ASP操作sqlserver数据库，执行没有报错，但是数据没有变化，跪问！！！！！在线等
用asp操作数据库，执行后，没有报错，但是数据库中的数据没有变化。
我用了两种操作方式，都不行
sqlserver表结构：
CREATE TABLE [dbo].[walk_in_id] (
[attend_id] [nchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[status] [nchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[reg_type] [nchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL )

ASP中的操作代码

第一种方式：
strQtemp1 = "update walk_in_id set status= 'Y ' where attend_id= ' " & Trim(strAttendID) & " ' "
g_SQLConn.execute strQtemp1

第二种方式：
Set cmdCID = Server.CreateObject( "ADODB.Command ")
cmdCID.CommandText = "spi_NewAtt "
cmdCID.CommandType = adCmdStoredProc
cmdCID.ActiveConnection = g_SQLConn
cmdCID.Parameters.Append cmdCID.CreateParameter ( "@Firstname ", adVarWChar, adParamInput, 100, Trim(strFirstName))
cmdCID.Parameters.Append cmdCID.CreateParameter ( "@Lastname ", adVarWChar, adParamInput, 100, Trim(strLastName))
cmdCID.Parameters.Append cmdCID.CreateParameter ( "@Company ", adVarWChar, adParamInput, 100, Trim(strOrganization))
cmdCID.Parameters.Append cmdCID.CreateParameter ( "@AttID ", adVarWChar, adParamInput, 20, Trim(strAttendID))
cmdCID.Execute()
Set cmdCID = Nothing

存储过程的内容如下：
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[spi_NewAtt] ') and OBJECTPROPERTY(id, N 'IsProcedure ') = 1)
drop procedure [dbo].[spi_NewAtt]
GO

CREATE PROCEDURE dbo.spi_NewAtt
@FirstNameNVARCHAR(100),
@LastNameNVARCHAR(100),
@CompanyNVARCHAR(100),
@AttID NVARCHAR(10)
AS

update walk_in_id set status = 'Y ' where attend_id = @AttID

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


多谢各位大虾！！！！！！什么问题呢？？？？

[解决办法]
直接在查询分析器中写:
select ... from ... where attend_id = 某个值.
看是否有这条记录.

然后再写:
update walk_in_id set status = 'Y ' where attend_id = 某个值
看是否改写.


[解决办法]
路过，帮你顶！