asp牵涉到sql函数newid()的写入方法

[复制链接]

森林的眼泪

电梯直达

1^#

发表于 2009-11-29 00:46:14 | 只看该作者回帖奖励

|倒序浏览 |阅读模式

<% set rs=Server.CreateObject("adodb.recordset")
sql = "select * from [order] where orderNO='"&request("orderNO")&"'"
rs.Open sql,conn,1,1
if rs.eof then

conn.execute ("INSERT INTO [order] (orderNO,customername,sourceType,customerTele,installaddress,customerFaxn,webflag,OrderGuid) VALUES ('"& Request("orderNO") &"','" & Request("customername") & "','"& Request("sourceType") &"','"& Request("customerTele") &"','" & Request("installaddress") & "','"& Request("customerFax") &"',1," & newid() & ")" )
response.write "添加成功"
else
response.write("记录已存在！")
end if

%>

收藏0