Re: newbie: Stored proc silently fails

[7 reeds]

Peter Brawley Wrote:
-------------------------------------------------------
> > I have seen that stored procs may not include
> transactions
>
> You saw that where?

"The trigger cannot use statements that explicitly or implicitly begin or end a transaction such as START TRANSACTION, COMMIT, or ROLLBACK."

http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html


>
> > ...SET s.end_id = @id ...
>
> What sets the user variable @id?

@id comes in through the "CALL"ing trigger. It is the "NEW.id" of the INSERT.