Hello!
I create a cursors in MSSQL Server (see below). How can I read the data from it?
(the cursor make a select for every "FETCH NEXT ....")
$start_cursor = "
DECLARE @codcard varchar(8)
DECLARE co_cursor CURSOR FOR
select codcard from dbo.op_terminal_test where dbo.op_terminal_test.codop='G700'
OPEN co_cursor
FETCH NEXT FROM co_cursor INTO @codcard
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT TOP 1 CONVERT(CHAR(11), dbo.op_terminal_test.data_op, 113) AS [Data operatiei], CONVERT(CHAR(5), dbo.op_terminal_test.ora, 108)
AS ora_plec_pauza, CONVERT(CHAR(5), op_terminal_test1.ora, 108) AS ora_venit_pauza, DATEDIFF([day], dbo.op_terminal_test.data_op,
op_terminal_test1.data_op) AS zile_co, dbo.nomen_angajati.nume, dbo.nomen_angajati.prenume, dbo.nomen_depart.nume_departam,
dbo.op_terminal_test.data_op AS data_plec_co, op_terminal_test1.data_op AS data_ven_co
FROM dbo.op_terminal_test INNER JOIN
dbo.op_terminal_test op_terminal_test1 ON dbo.op_terminal_test.codcard = op_terminal_test1.codcard AND
dbo.op_terminal_test.codcard = @codcard AND dbo.op_terminal_test.codop = 'G700' AND op_terminal_test1.codop = 'A100' AND
op_terminal_test1.data_op > dbo.op_terminal_test.data_op INNER JOIN
dbo.nomen_angajati ON dbo.op_terminal_test.codcard = dbo.nomen_angajati.codcard1 INNER JOIN
dbo.nomen_depart ON dbo.nomen_angajati.cod_depart = dbo.nomen_depart.cod_departam
ORDER BY data_ven_co
FETCH NEXT FROM co_cursor INTO @codcard
END
CLOSE co_cursor
DEALLOCATE co_cursor
";
$get_cursor = mssql_query($start_cursor, $conn) ;
I use for get data the function "mssql_fetch_assoc($get_cursor)"...but in browser I see the output only for first select, the other select isn't there!
Have anyone any idea?
Thanks!
