Forums
This topic is locked
Use Stored Procedure in Command to Instert data
Posted 04 Nov 2002 14:08:28
1
has voted
04 Nov 2002 14:08:28 Perry Olsen posted:
Sorry if this becomes a mess but here we go....I have a stored procedure that States.
"INSERT INTO dbo.NFFLPlayerNew
Select *
From dbo.NFFLPlayers"
I have two dynamic list/menus that display the record sets of the tables that I want to affect. I have a button in the middle of it all.
When I start this in the web page it shows both lists correctly but when I press the button it move the entire record set from NFFLPlayers to NFFLPlayerNew. I want it to move only one record that is selected in the recordset and not the entire recordset.
Can any one help???????