Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paul13
Starting Member
17 Posts |
 Posted - 2001-06-05 : 06:32:43
|
i'm running SQL server 6.5 on NT 4.0when i try to run a stored procudure that updates one of my tables from my asp pages it has no effect. the stored procedure runs fine from inside of the query manager.the stored procedure runs fine in the enterprise manager query manager, but won't update the table from an asp page. the stored procedure:@startdate and @enddate are passed in as parameters quote:
select @QStr1 = 'update table1 set col1 = 0 where col1 = null and date between ''' + @startdate + ''' and ''' + '''@enddate ''''execute(@QStr1)select @QStr2 = 'update table1 set col2 = 0 where col2 = null and date between ''' + @startdate + ''' and ''' + '''@enddate ''''execute(@QStr2)select @QStr3 = 'update table1 set col3 = 0 where col3 = null and date between ''' + @startdate + ''' and ''' + '''@enddate ''''execute(@QStr3)
other stored procedures are run fine from the same asp pages, this is the only procedure that has the problem.i have checked all of the permissions, and they seem to be in order for anyone to run the procedure, and anyone to update the table.Edited by - paul13 on 06/05/2001 06:33:38 |
|
|
|
|
|
an updating stored procedure won't run on asp page