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 - 2000-12-21 : 20:23:10
|
TooL writes "Hi Guru. Why doesn't my ASP Looping routine that calls a stored procedure with an ordinary select statement work with datatype Text ?
System specs:
NT 4
Service Pack 5
SQL 7.0
SP Code:
CREATE PROCEDURE sp_nyheter
AS
SET NOCOUNT ON
SELECT * FROM NYHETER WHERE NyhetsID <> '0' ORDER BY Datum DESC, Tid DESC
SET NOCOUNT OFF
Nothing special with that one works perfectly in MS-SQL enviroment such as query analyzer but doesn't work in ASP, hangs when it comes to an datatype text
ASP Code:
RS.Open "sp_bo", conn, 1, 1
Do until RS.EOF
Response.write RS("bla") & "
"
Response.write RS("bla2") & "
"
Response.write RS("bla3") & "
"
Loop
Asp Code end...
This is a shorthand version of course, the very strange thing is that everything works when I'm using an ordinary SQL statement and calling that one instead of the stored procedure...
help me pls...
/TooL" |
|
|
|
|
|
Stored Procedure Problem through ASP