Re: SELECTS not working in SP's?

[Mike Kruckenberg]

The problem may be the conflict between your IN parameter "name" and the WHERE clause of your query, "name = parent." Since you are defining the name as a local variable in the SP, when you use "name = parent" it is using parameters for both of them, thus if you call the SP:

CALL add_attribute('john','my dad','charlie');

Your cursor definition will be:

SELECT left_position, right_position FROM attribute WHERE 'John' = 'Charlie';

This will always return no records;

If you have a "name" column in your table, you might try changing the IN parameter to a different variable to keep the SP clear on what you're trying to accomplish.