Can't pass string to MySQL stored procedure using adodb

Question

I'm using adodb5 to call this stored procedure but MySQL doesn't understand $sealID is a string.

$db = NewADOConnection('mysql://'.DB_USER.':'.DB_PASS.'@'.DB_SERVER.'/'.DB_NAME);
$sql = "CALL GetSeal($userID, $sealID, @result)";
$r = $db->Execute($sql);

When I run this php from shell.

TestGetSealProc.php 3155011 ZZZZNLJSAYGZECWY

MySQL reports:

Unknown column 'ZZZZNLJSAYGZECWY' in 'field list'

ZZZZNLJSAYGZECWY must be understood as a string but a column. How to fix it?

Update: first part of my stored proc.

    CREATE DEFINER=`root`@`localhost` PROCEDURE `GetSeal`(IN userID INT, IN sealID char(16), OUT result INT)
    BEGIN

        DECLARE imageCnt INT;
        DECLARE pointCnt INT;
        DECLARE puriCode varchar(256);
        DECLARE newImgID INT;
....

        DECLARE c_data CURSOR FOR
            SELECT TELEPHONE_NUMBER, IMG_FILENAME, SELECTION_FLG, PHOTOGRAPH_DATE, SEND_DATE
            FROM re_photograph_imgs
            WHERE SEAL_NUMBER = sealID
            AND IMG_FILENAME IS NOT NULL
            AND IMG_FILENAME != "";

......................

Marc B · Accepted Answer · 2011-12-09 14:09:12Z

1

Don't forget quotes. Without them, a bare string will be interpreted as a field name:

$sql = "CALL GetSeal($userID, '$sealID', @result)";
                              ^       ^

answered Dec 9, 2011 at 14:09

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can't pass string to MySQL stored procedure using adodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related