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 - 2002-07-10 : 08:53:52
|
| Christian writes "Here it goes:strSql = "exec sp_name '" & firstVar & "' ,""" & secVar & """"rs.Open strSql,conn,adOpenKeyset , adLockReadOnly, adCmdTextfirstVar and secVar are my ASP variables which I'm expecting to have a String value.But if i got more than 128 characters for secVar variable, i got an error in rs.Open line which says:"...is too long. Maximum length is 128. "how can I possibly avoid this kind of error? Thanks in advance :)" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-10 : 10:08:07
|
| see www.nigelrivett.comCall stored procedures from ASPDon't know if it will solve your problem but it will give you something that is easier to maintain.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Executing Stored Procs in ASP