Forums

ASP

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???????

Reply to this topic