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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:11:41
|
paul starmach writes "Hi, form an asp i call a stored procedure that looks like this. SQLStmt3 ="exec campuscontrol..procProcessEmpDescriptionUpdate " & _ "'" & rqTitleID & "', " & _ "'" & process & "', " & _ "'" & session("userlogonid") & "'
rqtitleid is a database which gets picked by user eg. "tempdb"
process is a unique id eg. "1234"
session("userlogonid") the loged on user eg. "paul"
here is my stored procedure
CREATE PROCEDURE procProcessEmpDescriptionUpdate
@ID char(30),
@user char(50),
@processedby char(255)
AS
begin
DECLARE @text char(100)
SELECT @text = " UPDATE " + @id + "..EmpDescription " +
" SET " +
" processby = " + @processedby +
" WHERE userlogonid = " + @user
exec (@text)
end
so it will dynamically choose the database, i can't get this stored procedure to work.. it aways gives me some kind of errors.. eg. not a column name i can't seem to pass the information from the asp page properly always some kind of ' or " problem..
are there any ways to solve this?
that you very much
i'm using windows 2k profession. wiht ms sql server 7.0" |
|
|
|
|
|
asp and dynamic update