<!--#include file="conn.asp"-->
<!-- #include file="inc/null.inc" -->

<% dim action,url,i,abc,categoryid,category,id
category=FormatSQL(SafeRequest("category",0))
categoryid=SafeRequest("categoryid",1)
url="http://" & Request.ServerVariables("http_host") & finddir(Request.ServerVariables("url"))
action=FormatSQL(SafeRequest("action",0))
id=SafeRequest("id",1)

select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from tdcatalog",conn,1,3
rs.AddNew
rs("tcatalogname")=trim(request.form("sorts2"))
rs("carorder")=request.form("sortsorder2")
rs("dtypeway")=request.form("categoryid")

rs.Update
rs.Close
set rs=nothing
response.redirect url&"scarclass.asp?id="&categoryid&"&category="&category

case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from tdcatalog where catalogid="&id,conn,1,3
rs("tcatalogname")=trim(request.form("sorts"))
rs("carorder")=int(request.form("sortsorder"))

rs.update
rs.close
set rs=nothing
response.redirect url&"scarclass.asp?id="&categoryid&"&category="&category

case "del"
conn.execute ("delete from tdcatalog where catalogid="&id)

response.redirect url&"scarclass.asp?id="&categoryid&"&category="&category
end select
%>
<%
Function finddir(filepath)
	finddir=""
	for i=1 to len(filepath)
	if left(right(filepath,i),1)="/" or left(right(filepath,i),1)="\" then
	  abc=i
	  exit for
	end if
	next
	if abc <> 1 then
	finddir=left(filepath,len(filepath)-abc+1)
	end if
end Function
%>