Shawn, Madderla,
>Don't you need to DECLARE the variable "mvalidate" before you can
use it?
It's declared as OUT mvalidate varchar(10).
PB
-
[EMAIL PROTECTED] wrote:
madderla sreedhar <[EMAIL PROTECTED]> wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following
Madderla,
1. Var assignments need SET, ie SET mvariable = ...
2. Missing semicolon after 'TRUE'
PB
-
madderla sreedhar wrote:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
" := 'TRUE' "
CR
madderla sreedhar <[EMAIL PROTECTED]> wrote on 05/02/2005 03:10:07 AM:
> Can u please execute the following procedure in MySql
> and tell me where I had gone wrong because on my
> system the same code is giving error near line
> " := 'TRUE' "
>
> CREATE PROCEDURE cart_items_validate
> (IN mcus
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
" := 'TRUE' "
CREATE PROCEDURE cart_items_validate
(IN mcustid INT ,IN mprodid varchar(10),
OUT mvalidate varchar(10))
BEGIN
DECLARE rowexists
