一下是我的一段代码,可以正常运行Sub dzzaddarticlep(cid)
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
sqla = "select * From bbsClass"
Set rsa = Server.CreateObject("adodb.recordset")
rsa.open sqla, conn, 1, 1
Do While Not rsa.EOF
Response.Write "<option value='" & rsa("classid") & "'"
If cid <> "" Then
If CLng(cid) = CLng(rsa("classid")) Then
Response.Write " selected"
End If
End If
Response.Write ">" & rsa("classname") & "</option>"
rsa.movenext
Loop
rsa.Close
Set rsa = Nothing
End Sub我怎么把这一段代码写道全局变量呢?否则每一个function都要写这个,太麻烦了!
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr高手帮忙!!
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
sqla = "select * From bbsClass"
Set rsa = Server.CreateObject("adodb.recordset")
rsa.open sqla, conn, 1, 1
Do While Not rsa.EOF
Response.Write "<option value='" & rsa("classid") & "'"
If cid <> "" Then
If CLng(cid) = CLng(rsa("classid")) Then
Response.Write " selected"
End If
End If
Response.Write ">" & rsa("classname") & "</option>"
rsa.movenext
Loop
rsa.Close
Set rsa = Nothing
End Sub我怎么把这一段代码写道全局变量呢?否则每一个function都要写这个,太麻烦了!
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr高手帮忙!!
Option Explicit
Public gconSys As ADODB.Connection
Public Function SystemInitialize() As Boolean
On Error GoTo errhandle
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End Function
Option Explicit
Public gconSys As ADODB.Connection 。。我方在最上边了,可是提示 gconSys As ADODB.Connection 编译错误:用户定义类型未定义。
把conn设成全局变量,适当地方运行 一次 上面几行代码就成了
我晕了,我就是不会设定全局变量啊我编写的是dll,只有类模块
Public Function SystemInitialize() As Boolean
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End Function这段代码放在最前边,可是提示:
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
以前没有错的
这是怎么回事?
以后用到它的地方就<#include file=xx.inc#>
就ok 了
Private Sub Class_Initialize()
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End Sub
这样的代码也不会加,有点吃力Private MyScriptingContext As ScriptingContext
Private Application As Application
Private Request As Request
Private Response As Response
Private Server As Server
Private Session As SessionPublic conn As Object
Private Sub Class_Initialize()
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("/shujuku.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End Sub'======================定义变量开始======================
'======================定义变量结束======================
拜托了大头,帮人帮到底吧,我真的很吃力啊我从来没有弄过dll,一直是弄web程序,这是第一次,只要数据库弄上,就没有问题了。谢谢!!
可不可以qq 啊,这么等太累了。谢谢了啊!
你没有空间上传么?我送你一个啊,100m的空间,可以么?谢谢!!!qq 108828368请指教啊,在线等!谢谢了大头
我的qq 108828368 解决问题送100M 网络空间。谢谢!
Global con As New ADODB.Connection
Global cmn As New ADODB.Command
Global rstRec As New ADODB.Recordset
用request读进相应参数,构造con
http://expert.csdn.net/Expert/topic/2189/2189110.xml?temp=.7792932
'********************************************************************************
'** 函数功能:从ini配置文件中读取指定段名、关键字名的值
'** 调用语法: GetInIKeyValue(SectionName as string,KeyName As String,FileName As String)
'** 参数说明:
'** SectionName :段名
'** KeyName :关键字名
'** FileName :ini文件名包括路径
'** 返 回 值:
'** String :返回关键字值
'** 处理说明:
'** 调用API函数GetPrivateProfileString
'******************************************************************************
Public Function GetInIKeyValue(ByVal SectionName As String, _
ByVal KeyName As String, _
ByVal FileName As String) As String
Dim KeyValue$
Dim strTmp As String
KeyValue$ = String$(512, " ")
GetPrivateProfileString SectionName, KeyName, "", KeyValue$, 512, FileName
strTmp = Trim(KeyValue$)
GetInIKeyValue = Left(strTmp, Len(strTmp) - 1)
End Function'********************************************************************************
'** 函数功能:从ini配置文件中写入指定段名、关键字名及值
'** 调用语法: SetInIKeyValue(SectionName as string,KeyName As String,KeyValue as string ,FileName As String)
'** 参数说明:
'** SectionName :段名
'** KeyName :关键字名
'** KeyValue :关键字值
'** FileName :ini文件名包括路径
'** 返 回 值:
'** 处理说明:
'** 调用API函数WritePrivateProfileString
'******************************************************************************
Public Sub SetInIKeyValue(ByVal SectionName As String, _
ByVal KeyName As String, _
ByVal KeyValue As String, _
ByVal FileName As String)
Dim lng As Long
lng = WritePrivateProfileString(SectionName, KeyName, KeyValue, FileName)
End Sub
另外不会把得到的ini里边的数值设定为全局变量dublue你有qq 么?108828368 随时恭候!谢谢!!
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("test.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End Sub但是调用的时候怎么还是不行?我通过opendb调用的
Public Sub InitDB()
'初始化数据库
'建立数据库连接并打开
strDBName = "dbRecords"
strcnn = "Provider=MSDASQL.1;UID=sa;Data Source=Records;Extended Properties='DSN=dbRecords;DBQ=" & strDBName & ";DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5'"
cnn.Open strcnn, "", ""
'设置记录集
Set rstRec = New ADODB.Recordset
rstRec.CursorType = adOpenKeyset
rstRec.LockType = adLockOptimistic
rstRec.Open "tblRec", cnn, , , adCmdTable
iRecNum = rstRec.RecordCount
End Sub
在你的应用程序中,最开始的地方,比如form_load,module等调用此函数就行了
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("test.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End SubSub test2(cid)
Opendb
sqla = "select * From Class"
Set rsa = Server.CreateObject("adodb.recordset")
rsa.open sqla, conn, 1, 1
Response.Write rsa("classname")
rsa.Close
Set rsa = Nothing
End Sub这样就是无效的而Sub test1(cid)
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("test.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
sqla = "select * From Class"
Set rsa = Server.CreateObject("adodb.recordset")
rsa.open sqla, conn, 1, 1
Response.Write rsa("classname")
rsa.Close
Set rsa = Nothing
End Sub这样运行正常
这样可以在类模块里用一个方法来得到Connection对象呀。
Set MyScriptingContext = PassedScriptingContext
Set Application = MyScriptingContext.Application
Set Request = MyScriptingContext.Request
Set Response = MyScriptingContext.Response
Set Server = MyScriptingContext.Server
Set Session = MyScriptingContext.Session
Set conn = Server.CreateObject("ADODB.CONNECTION")
connstr = "DBQ=" + Server.MapPath("test.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr
End SubPublic Sub OnEndPage()
Set MyScriptingContext = Nothing
Set Application = Nothing
Set Request = Nothing
Set Response = Nothing
Set Server = Nothing
Set Session = Nothing
Set conn = Nothing
End Sub
虽然没有生成ini文件,但是只有如此了。谢谢大家!谢谢参与的人!ini我再想办法。