关于存储过程嵌套以及递归的问题?(PHP调用,高手请进,在线等)
存储过程ManualIndexReorderAll在查询分析器运行是正确的,可以正确的排列顺序。而在PHP中调用以后,只会部分排序,很多纪录的行被赋了初值0,而没有正确的排序。我怀疑是PHP调用存储过程,可能某些变量没有被调用。以下为PHP调用,应该没有问题的。
<?php
require("serverinfo.php");
$connect=mssql_connect($SERVERNAME,$LOGINUSER,$LOGINPSWORD);
mssql_select_db($DATABASE,$connect);
//排序
$sqlSort="EXEC ManualIndexReorderAll";
$rstSort = mssql_query($sqlSort) or die("无法执行SQL:$sqlSort");
?>
以下为存储过程ManualIndexReorderAll,嵌套ManualIndexReorder,有些乱。
CREATE PROCEDURE ManualIndexReorderAll AS
DECLARE @ID INT,@ret INT,@Row INT,@Col INT,@ParentID INT
UPDATE ManualIndex SET ManualIndexRow=0
SET @Row = 0
SET @Col = 0
WHILE EXISTS (SELECT * FROM ManualIndex WHERE ManualIndexParentID=ManualIndexID AND ManualIndexRow=0)
BEGIN
SELECT TOP 1 @ID=ManualIndexID FROM ManualIndex
WHERE ManualIndexParentID=ManualIndexID AND ManualIndexRow=0
ORDER BY ManualIndexID
SELECT @Row = @Row+1
UPDATE ManualIndex SET ManualIndexRow = @Row, ManualIndexCol = @Col WHERE ManualIndexID = @ID
IF EXISTS (SELECT* FROM ManualIndex WHERE ManualIndexParentID=@ID AND ManualIndexRow=0)
BEGIN
SET @Col = @Col+1
EXEC @ret = ManualIndexReorder @ID,@Row,@Col
SET @Col = @Col-1
SELECT @Row = @ret
END
END
RETURN @Row
GO
以下为ManualIndexReorder,其中自己调用自己。
CREATE PROCEDURE ManualIndexReorder @ParentID int, @Row int, @Col int AS
DECLARE @ID AS INT,@ret AS INT
IF @ParentID = -1
UPDATE ManualIndex SET ManualIndexRow=0
WHILE EXISTS (SELECT * FROM ManualIndex WHERE ManualIndexParentID = @ParentID AND ManualIndexRow=0)
BEGIN
SELECT TOP 1 @ID=ManualIndexID FROM ManualIndex
WHERE ManualIndexParentID=@ParentID AND ManualIndexRow=0
ORDER BY ManualIndexParentID,ManualIndexID
SELECT @ID AS 'ID',@ParentID AS 'ParentID',@Row AS 'Row',@Col AS 'Col'
SELECT @Row = @Row+1
UPDATE ManualIndex SET ManualIndexRow = @Row, ManualIndexCol = @Col WHERE ManualIndexID = @ID
IF @ID=@ParentID
SELECT @Col = 0
SELECT @ret = @Col+1
IF EXISTS (SELECT* FROM ManualIndex WHERE ManualIndexParentID=@ID AND ManualIndexRow=0)
BEGIN
SET @Col = @Col+1
EXEC @ret = ManualIndexReorder @ID,@Row,@Col
SET @Col = @Col-1
SELECT @Row = @ret
END
END
RETURN @Row
GO
以下是正确显示结果。分不够可以再加。多谢大侠们!!
ManualIndexID ManualIndexParentID ManualIndexRow ManualIndexCol
1 1 1 0
2 1 2 1
3 1 3 1
4 3 4 2
5 5 5 0
帮忙找写法的错误,或者提供另外的思路。多谢了。急。
<?php
require("serverinfo.php");
$connect=mssql_connect($SERVERNAME,$LOGINUSER,$LOGINPSWORD);
mssql_select_db($DATABASE,$connect);
//排序
$sqlSort="EXEC ManualIndexReorderAll";
$rstSort = mssql_query($sqlSort) or die("无法执行SQL:$sqlSort");
?>
以下为存储过程ManualIndexReorderAll,嵌套ManualIndexReorder,有些乱。
CREATE PROCEDURE ManualIndexReorderAll AS
DECLARE @ID INT,@ret INT,@Row INT,@Col INT,@ParentID INT
UPDATE ManualIndex SET ManualIndexRow=0
SET @Row = 0
SET @Col = 0
WHILE EXISTS (SELECT * FROM ManualIndex WHERE ManualIndexParentID=ManualIndexID AND ManualIndexRow=0)
BEGIN
SELECT TOP 1 @ID=ManualIndexID FROM ManualIndex
WHERE ManualIndexParentID=ManualIndexID AND ManualIndexRow=0
ORDER BY ManualIndexID
SELECT @Row = @Row+1
UPDATE ManualIndex SET ManualIndexRow = @Row, ManualIndexCol = @Col WHERE ManualIndexID = @ID
IF EXISTS (SELECT* FROM ManualIndex WHERE ManualIndexParentID=@ID AND ManualIndexRow=0)
BEGIN
SET @Col = @Col+1
EXEC @ret = ManualIndexReorder @ID,@Row,@Col
SET @Col = @Col-1
SELECT @Row = @ret
END
END
RETURN @Row
GO
以下为ManualIndexReorder,其中自己调用自己。
CREATE PROCEDURE ManualIndexReorder @ParentID int, @Row int, @Col int AS
DECLARE @ID AS INT,@ret AS INT
IF @ParentID = -1
UPDATE ManualIndex SET ManualIndexRow=0
WHILE EXISTS (SELECT * FROM ManualIndex WHERE ManualIndexParentID = @ParentID AND ManualIndexRow=0)
BEGIN
SELECT TOP 1 @ID=ManualIndexID FROM ManualIndex
WHERE ManualIndexParentID=@ParentID AND ManualIndexRow=0
ORDER BY ManualIndexParentID,ManualIndexID
SELECT @ID AS 'ID',@ParentID AS 'ParentID',@Row AS 'Row',@Col AS 'Col'
SELECT @Row = @Row+1
UPDATE ManualIndex SET ManualIndexRow = @Row, ManualIndexCol = @Col WHERE ManualIndexID = @ID
IF @ID=@ParentID
SELECT @Col = 0
SELECT @ret = @Col+1
IF EXISTS (SELECT* FROM ManualIndex WHERE ManualIndexParentID=@ID AND ManualIndexRow=0)
BEGIN
SET @Col = @Col+1
EXEC @ret = ManualIndexReorder @ID,@Row,@Col
SET @Col = @Col-1
SELECT @Row = @ret
END
END
RETURN @Row
GO
以下是正确显示结果。分不够可以再加。多谢大侠们!!
ManualIndexID ManualIndexParentID ManualIndexRow ManualIndexCol
1 1 1 0
2 1 2 1
3 1 3 1
4 3 4 2
5 5 5 0
帮忙找写法的错误,或者提供另外的思路。多谢了。急。
...全文
相关推荐
PHP中的函数嵌套层数限制分析
PHP本身的函数嵌套是没有限制的,如果说有限制,也是内存的限制。这是因为PHP的函数嵌套是以栈的形式实现的。对于每个函数都会分配一段内存来存储函数局部的内容。
PHP递归的三种常用方式
递归:函数自己调用自己的一种编程方法,类似于循环,所以递归调用的函数中必须有终止条件,否则就会成为死循环 无限级:其实并不是真正的无限级,只是层级不确定,所以我们称之为无限级 因为常用递归实现无限级分类,所以我们习惯说无限级的时候带上分类。 递归的三种常用技法: 静态变量、全局变量、引用 一 静态变量方式 function loop(){ static $i = 0; echo $i.' '; $i++; if($i<10){ loop(); } } loop();//输出 0 1 2 3 4 5 6 7 8 9 二 全局变量方式 $i = 0; function
php代码-PHP函数的嵌套
php代码-PHP函数的嵌套
php实现在线考试系统【附源码】
主要介绍了php在线考试系统附源码下载,文中通过实例代码给大家介绍了开发思路,需要的朋友可以参考下
php代码-PHP递归调用
php代码-PHP递归调用


基础编程
