|
| |
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
 |
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
|
|
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
|
RE: Very close. Needs a tweak! - 5/28/2002 23:50:11
( :
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
