C
Chumley Walrus
This may be a service pack issue, but uncertain as administrators are
on vacation, but I have an insert script thats insert button works on
one server, but not on another:
Here is the subroutine, followed by the onclick tag for the button:
Sub doInsert(Source as Object, E as EventArgs)
Dim MySQL as string = "Insert into Articles (articleheader,
articledate, articletext, sid) values (@articleheader, @articledate,
@articletext, @sid)"
Dim myConn As SqlConnection = New
SqlConnection("SERVER=xx.xx.xx.xx;UID=xx;PWD=xxxxxxxx;DATABASE=myDbase;")
Dim Cmd as New SQLCommand(MySQL, MyConn)
cmd.Parameters.Add(New SQLParameter("@articleheader",
frmarticleheader.text))
cmd.Parameters.Add(New SQLParameter("@articledate",
frmarticledate.text))
cmd.Parameters.Add(New SQLParameter("@articletext",
frmarticletext.text))
cmd.Parameters.Add(New SQLParameter("@sid", frmsid.text))
MyConn.Open()
cmd.ExecuteNonQuery
label1.visible="true"
BindData()
MyConn.Close()
label1.text = "Your data has been received!"
End Sub
''onclick button
<asp:button id="button1" Text="Insert" onclick="doInsert"
class="inputBox-or" runat="server" />
....this is part of an admin script that also includes an edit module,
and the edit module works as we are able to change articles on both
servers. I'm pretty sure that both servers are running .net framework
1.1
thanks for any help
chumley
on vacation, but I have an insert script thats insert button works on
one server, but not on another:
Here is the subroutine, followed by the onclick tag for the button:
Sub doInsert(Source as Object, E as EventArgs)
Dim MySQL as string = "Insert into Articles (articleheader,
articledate, articletext, sid) values (@articleheader, @articledate,
@articletext, @sid)"
Dim myConn As SqlConnection = New
SqlConnection("SERVER=xx.xx.xx.xx;UID=xx;PWD=xxxxxxxx;DATABASE=myDbase;")
Dim Cmd as New SQLCommand(MySQL, MyConn)
cmd.Parameters.Add(New SQLParameter("@articleheader",
frmarticleheader.text))
cmd.Parameters.Add(New SQLParameter("@articledate",
frmarticledate.text))
cmd.Parameters.Add(New SQLParameter("@articletext",
frmarticletext.text))
cmd.Parameters.Add(New SQLParameter("@sid", frmsid.text))
MyConn.Open()
cmd.ExecuteNonQuery
label1.visible="true"
BindData()
MyConn.Close()
label1.text = "Your data has been received!"
End Sub
''onclick button
<asp:button id="button1" Text="Insert" onclick="doInsert"
class="inputBox-or" runat="server" />
....this is part of an admin script that also includes an edit module,
and the edit module works as we are able to change articles on both
servers. I'm pretty sure that both servers are running .net framework
1.1
thanks for any help
chumley