SEO

#1 (**permalink**) 02-28-2008, 09:05 AM

Hi,

I have a problem with a stored procedure:
It goes as follows:

DELIMITER $$

CREATE PROCEDURE `spValidateUser2`(IN _ClassID INT, IN _Username TEXT, IN
_Password TEXT)
BEGIN

DECLARE v_password TEXT;

SET v_password = _Username + _Password;

SELECT UserID FROM users WHERE ClassID = _ClassID AND username = _Username
AND Password2 = MD5(v_password);

END $$

DELIMITER ;

However, when I execute it with a parameter, that should return a UserID, it
never returns anything. If I modify the Select-statement and just execute it
as normal SQL with the same parameters, it works fine. Any ideas?

#2 (**permalink**) 02-28-2008, 09:05 AM

René Vutborg wrote:
> Hi,
>
> I have a problem with a stored procedure:
> It goes as follows:
>
> DELIMITER $$
>
> CREATE PROCEDURE `spValidateUser2`(IN _ClassID INT, IN _Username
> TEXT, IN _Password TEXT)
> BEGIN
>
> DECLARE v_password TEXT;
>
> SET v_password = _Username + _Password;
>
> SELECT UserID FROM users WHERE ClassID = _ClassID AND username =
> _Username AND Password2 = MD5(v_password);
>
> END $$
>
> DELIMITER ;
>
> However, when I execute it with a parameter, that should return a
> UserID, it never returns anything. If I modify the Select-statement
> and just execute it as normal SQL with the same parameters, it works
> fine. Any ideas?

Where are you expecting it to return the UserID to. you don't seem to have
defined an output.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

sp and MD5 ?