Re: Error in SQL query

[Robin John]

One more question,

In the query below, is there a need to use COMMIT; somewhere.

Thanks

Robin John Wrote:
-------------------------------------------------------
> Hello Peter,
>
> Thank you for pointing in the right direction.
> Took me a while to understand Procedures but was
> definitely worth it. Also I learnt some other
> complexities of a database. Here is the query that
> worked for me:
> DELIMITER $$
> CREATE DEFINER=`root`@`localhost` PROCEDURE
> `AddText`()
> BEGIN
>
>
> DECLARE post_status INT DEFAULT 0;
>
> DECLARE post_counter INT;
>
> DECLARE post_total INT;
>
> DECLARE post_currentId INT;
> SELECT MIN(counter) FROM wp_text INTO
> post_counter;
>
>
> SELECT MAX(counter) FROM wp_text INTO post_total;
> WHILE(post_counter IS NOT NULL AND
> post_counter<=post_total)
> DO
> SELECT Id FROM wp_text WHERE counter =
> post_counter INTO post_currentId;
>
> SELECT Active from teksten WHERE Id =
> post_currentID INTO post_status;
>
> IF post_status = 1 THEN
>
> UPDATE wp_text
> set Active = "publish"
> WHERE counter = post_counter;
>
> ELSE
>
> UPDATE wp_text
> set Active = "pending"
> WHERE counter = post_counter;
>
> END IF;
>
> SET post_counter = post_counter + 1;
>
> END WHILE;
>
> END$$
> DELIMITER ;