Have a problem with using cursors in SQL server enterprise manager

[TaeHo Yoo]

Have a problem with using cursors in SQL server enterprise manager.
My code sql query is followed
---------------------------------------
DECLARE @element_name varchar(100)
DECLARE elements_cursor CURSOR FOR
SELECT element_name
FROM KB_Element_Ref

OPEN elements_cursor
FETCH NEXT FROM elements_cursor INTO @element_name

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @element_name
FETCH NEXT FROM elements_cursor INTO @element_name
END

CLOSE elements_cursor
DEALLOCATE elements_cursor
------------------------------------------------------------
I have more than 100 rows int KB_Element_Ref table.
but when I execute this query, it said only a row has affected and did't
print any element_name.
does any one know what is going on?


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Vaclav Jedlicka]

your code is correct

are you sure the table is not empty?

Vaclav

"TaeHo Yoo" <anonymous@devdex.com> wrote in message
news:uNMxxf6ODHA.3152@TK2MSFTNGP10.phx.gbl...

> Have a problem with using cursors in SQL server enterprise manager.
> My code sql query is followed
> ---------------------------------------
> DECLARE @element_name varchar(100)
> DECLARE elements_cursor CURSOR FOR
> SELECT element_name
> FROM KB_Element_Ref
>
> OPEN elements_cursor
> FETCH NEXT FROM elements_cursor INTO @element_name
>
> WHILE @@FETCH_STATUS = 0
> BEGIN
> PRINT @element_name
> FETCH NEXT FROM elements_cursor INTO @element_name
> END
>
> CLOSE elements_cursor
> DEALLOCATE elements_cursor
> ------------------------------------------------------------
> I have more than 100 rows int KB_Element_Ref table.
> but when I execute this query, it said only a row has affected and did't
> print any element_name.
> does any one know what is going on?
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Rhys Gravell]

Try
<CODE>
DECLARE @element_name varchar(100)
DECLARE elements_cursor CURSOR FOR SELECT element_name FROM
KB_Element_Ref

SELECT COALESCE(element_name,'Null Value') FROM KB_Element_Ref

OPEN elements_cursor
FETCH NEXT FROM elements_cursor INTO @element_name
WHILE @@FETCH_STATUS = 0

BEGIN
PRINT '<<' + @element_name + '>>'
FETCH NEXT FROM elements_cursor INTO @element_name
END

CLOSE elements_cursor
DEALLOCATE elements_cursor
</CODE>

in query analyzer to help check if a zero length string, or null is
being returned.


Rhys Gravell

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!