Here is the code. I'm trying to input the information using windows
scripting host in a .vbs file. If that makes a difference I'm not sure.
strSql = "Select * From tblproapp_cat where esnum = '" & strES & "'
AND revnm = '" & strRevision & "'"
set objConn = CreateObject("ADODB.Connection")
set rsItem = CreateObject("ADODB.Recordset")
objConn.Open(strconn)
rsItem.Open strSql, objConn, adOpenKeyset, adLockOptimistic,
adCmdText
esnum = rsItem("esnum")
msgbox(totcount & " " & esnum & " " & err.number & " " &
err.description)
rsItem("cstname") = strCust ' Customer Name inputed by user
rsItem.Update
msgbox(totcount & " " & esnum & " " & err.number & " " &
err.description)
rsItem.Close
Set rsItem = Nothing
-----Original Message-----
From: darren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 9:11 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: Inputting Info to database
On Thursday, August 29, 2002 at 14:58, Hoenig, Robert wrote:
HR> I've opened the connection and still get the same error.
can you post the code you are trying to run?? might be a bit quicker than
throwing lots of suggestions at you! ;>
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: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ • 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]
