AC数据库操作问题，那位大大帮我看看

下面是原代码，能写入2级分类，把他改成写入三级分类怎么写？惊云数据库，试了一天了，搞不盯它，那位帮我改下，先谢谢了
set rs2=server.createobject("adodb.recordset")
sql2="select * from downtype where tname='"&Nclass&"|"&NNclass&"|'"
rs2.open sql2,conn,1,3
if rs2.eof or rs2.bof then
rs2.close
call addtype()
classid=rs2("ID")
rs2.close
else
classid=rs2("ID")
end if

set rs2=nothing
‘-------------------------------------------------------------------------------------------------------
sub addtype()
sql2="select * from downtype where tname='"&Nclass&"|'"
rs2.open sql2,conn,1,3
if rs2.eof or rs2.bof then
rs2.addnew
rs2("tname")=""&Nclass&"|"
rs2("tj")=1
rs2.update
rs2("ts")=rs2("ID")&","
rs2.update
tempnum=rs2("ID")
rs2.addnew
rs2("tname")=""&Nclass&"|"&NNclass&"|"
rs2("tj")=2
rs2.update
rs2("ts")=tempnum&","&rs2("ID")&","
rs2("tn")=tempnum
rs2.update
else
tempnum=rs2("ID")
rs2.addnew
rs2("tname")=""&Nclass&"|"&NNclass&"|"
rs2("tn")=tempnum
rs2("tj")=2
rs2("zm")=""&ABC&""
rs2.update
rs2("ts")=tempnum&","&rs2("ID")&","
rs2.update
end if
end sub

 

是这种格式
现在
NClass|NNClass|NNNClass 可以写入，
现在的问题是不会自动写入分类ID 老是漏掉中间的一个， 比如我们应该是1,3,5这样的，它只写入1,5

 

rs2("ts")=tempnum&","&rs2("ID")&","

这个就是写入的ID