Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 31, 2007, 6:42 am
rate this thread
I'm trying to create a stored procedure using the following syntax,
but I'm getting an error.
CREATE PROCEDURE `site`.`sp_ValidateInvite_SEL` (invitecode
-- Check that the code exists (deleted/blocked users' invites will be
IF NOT EXISTS (SELECT * FROM `invitations` WHERE `InvitationCode` =
SELECT 'Error' As `Status`, 'Invitation Code is invalid.'
SELECT 'Invited' As `Status`, 'blahblah' As `Details`;
Could someone tell me what the problem could be? Can you use the EXIST
function as a condition (or a parameter within a EXIST function/
I'm using MySQL Administrator which automatically add the delimiter
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum