如何提示重复的记录?
我向parcels这个表插入数据,共有packingslipid,parcelstatusid,enterdate,userid四个
字段,其中packingslipid 是主键,这个字段不能插入相同的值,
如果是相同的值,就给予警告,该怎么做呢?
代码是这样的:
<%
set sConn=server.CreateObject("adodb.connection")
sConn.Open "Driver={Microsoft Excel Driver (*.xls)};DBQ="&server.mappath("./a/b.xls")
set oConn=server.CreateObject("adodb.connection")
oConn.Open "Driver={sql server};server=mlirdtry;database=rdtry;uid=zhang fang;pwd=zf"
set sRs=server.CreateObject("adodb.recordset")
sRs.Open "select * from [b$]",sConn,2,2
set oRs=server.CreateObject("adodb.recordset")
oRs.Open "select * from parcels",oConn,3,3
j=1
Do While Not sRs.Eof
oRs.AddNew
oRs(0)=j
for i=0 to sRs.Fields.Count-1
oRs(i)=Trim(sRs(i))
Next
oRs.Update
sRs.MoveNext
j=j+1
Loop
sRs.Close
oRs.Close
oConn.Close
sConn.Close
Set oRs=nothing
Set oConn=nothing
%>
该加一句什么样的代码呢?