📄 commfunc.asp
字号:
<%'建立数据库连接的文件
Public Sub open_data(ByRef cn, ByVal f)
' cn = connection object variable
' f = relative path and name of .mdb file
Dim s
if session("DataAdmi_DSN_Less") = 1 then
s = "driver={Microsoft Access Driver (*.mdb)};"
s = s & "dbq=" & Server.MapPath(f)
if session("DataAdmi_DataUsid") <> "" OR session("DataAdmin_DataPass") <> "" then
s = s & ";"
s = s & "uid=" & session("DataAdmi_DataUsid") & ";"
s = s & "pwd=" & session("DataAdmi_DataPass")
end if
else
s = "DSN=" & f
if session("DataAdmi_DataUsid") <> "" OR session("DataAdmin_DataPass") <> "" then
s = s & "; "
s = s & "UserID=" & session("DataAdmi_DataUsid") & "; "
s = s & "pwd=" & session("DataAdmi_DataPass")
end if
end if
set cn = Server.CreateObject("ADODB.Connection")
' response.write s
cn.Open s
End Sub
Public Function inse_apos(ByVal s)
if s <> "" then
if Instr(s,"'")<>0 then
inse_apos = Replace(s,"'","''")
else
inse_apos = s
end if
end if
End Function
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -