|
hzarabet -> Very close. Needs a tweak! (5/28/2002 19:51:02)
|
Here is my script:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "DRIVER={SQL Server};SERVER=xx.xx.xx.xxx;DATABASE=xxxxxx;UID=xxxxx;PWD=xxxxx"
fp_sQry="UPDATE SHL_DeLuxe SET SHL_DeLuxe.State1 = 'Test10000' WHERE SHL_DeLuxe.Username = 'test'"
Set RS = Conn.Execute(fp_sQry)
fp_sQry="UPDATE SHL_DeLuxe SET SHL_DeLuxe.State2 = 'Test2000' WHERE SHL_DeLuxe.Username = 'test'"
Set RS = Conn.Execute(fp_sQry)
fp_sQry="UPDATE SHL_DeLuxe SET SHL_DeLuxe.State3 = 'Test3000' WHERE SHL_DeLuxe.Username = 'test'"
Set RS = Conn.Execute(fp_sQry)
fp_sQry="UPDATE SHL_DeLuxe SET SHL_DeLuxe.State4 = 'Test4000' WHERE SHL_DeLuxe.Username = 'test'"
Set RS = Conn.Execute(fp_sQry)
fp_sQry="UPDATE SHL_DeLuxe SET SHL_DeLuxe.State5 = 'Test5000' WHERE SHL_DeLuxe.Username = 'test'"
Set RS = Conn.Execute(fp_sQry)
set rs=nothingConn.Close
%>
And here is my error message:
Microsoft VBScript runtime error '800a01a8'
Object required: 'nothingConn'
/updatetext.asp, line 14
The script is working and making the update so I am close.
Thanks all!
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
|
|
|
|
