clvbconn.asp

来自「飞天论坛FTBBS PHP版 v4.1.ASP源代码」· ASP 代码 · 共 60 行

<%
dim dsnstr
dim db
db="lh100com.mdb"
dsnstr1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
set dsnstr=server.CreateObject("adodb.connection")
dsnstr.Open dsnstr1
%>


<%
Function htmlCode(content)
	TempContent = content
	TempContent = replace(TempContent,"<","&lt;")
	TempContent = replace(TempContent,">","&gt;")
	TempContent = replace(TempContent,vbcrlf,"<br>")
	TempContent = replace(TempContent,chr(32),"&nbsp;")
	TempContent = replace(TempContent,chr(34),"&quot;")
	TempContent = replace(TempContent,chr(44),"，")
	htmlCode=TempContent
End Function

function code(content)
	TempContent = content
	TempContent = replace(TempContent,chr(34),"&quot;")
	code=TempContent
end function
function sqlstr(dat)
sqlstr=replace(dat,"'","''")
end function

function data1(title)
dim title1
if len(trim(title))>10 then
title1=mid(title,1,10)
title1=title1&"....."
response.Write (title1)
else
response.Write (title)
end if
end function
function datastr(title)
dim title1
if len(trim(title))>8 then
title1=mid(title,1,8)
datastr=title1
else
datastr=title
end if
end function
function datastr1(title)
dim title1
if len(trim(title))>14 then
title1=mid(title,1,14)
datastr1=title1
else
datastr1=title
end if
end function
%>