Morning :)
1. You sure can, e.g:
CREATE PROCEDURE `user_authenticate`(IN sUserName VARCHAR(25), IN sPassword
CHAR(32), OUT sUserCookie CHAR(32))
BEGIN
DECLARE iUserID INT;
DECLARE iLogID INT;
SELECT MD5(CONCAT(UserID,NOW())) INTO sUserCookie FROM users WHERE UserName
= sUserName AND Password
Sorry, I spoke too soon.
I just made a test case of a proc calling a proc, which works,
so I must have a different problem.
- Still would like to know if a function will ever be able to issue a
SELECT tho.
Cheers
Mike
-Original Message-
From: Michael Pheasant [mailto:[EMAIL