On Wednesday, August 28, 2002 at 19:47, Hoenig, Robert wrote:
HR> What do you mean by
HR> 1. Make sure u r opening the strconn connection object.
HR> I have the Open statement, is that what you are referring to?
HR> rsItem.Open strSql, strconn, adOpenKeyset, adLockPessimistic, adCmdTable
make sure you are explicitly creating your connection object. strconn
looks more like a variable that holds the connection string.
you should have something that looks like (this isn't tested, but it should
work - note the change to the parameters on the recordset opening):
strConn = "data source=northwind; etc..."
strSQL = "SELECT Col1, Col2 FROM .... "
set objConn = Server.CreateObject("ADODB.Connection")
set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open(strConn)
objRs.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdText
objRs("Col1") = "fred"
objRs.Update
objRs.Requery
Response.Write "col1 = " & objRS("Col1")
objRS.Close
objConn.Close
set objRS = nothing
set objConn = nothing
hth,
darren
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
