Professional Web Applications Themes

Procedure error: 'chceckVote' in 'field list' - MySQL

CREATE PROCEDURE addVoteAll (profil_Id int ( 11 ) , commmen_Id int ( 11 ) , grande_ smallint ( 1 )) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN DECLARE checkVote smallint(2) DEFAULT 0; SET checkVote = (select count(*) from vote where profilId=3 and commentId=3); IF chceckVote=0 then INSERT INTO vote (voteId,profilId,commentId,grande) VALUES (null,profil_Id,commmen_Id, grande_); END IF; commit; END; Unknown column 'chceckVote' in 'field list' whats wrong?...

  1. #1

    Default Procedure error: 'chceckVote' in 'field list'

    CREATE PROCEDURE addVoteAll (profil_Id int ( 11 ) , commmen_Id int
    ( 11 ) ,
    grande_ smallint ( 1 ))
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
    BEGIN
    DECLARE checkVote smallint(2) DEFAULT 0;
    SET checkVote = (select count(*) from vote
    where profilId=3 and
    commentId=3);
    IF chceckVote=0 then
    INSERT INTO vote (voteId,profilId,commentId,grande) VALUES
    (null,profil_Id,commmen_Id, grande_);
    END IF;
    commit;
    END;

    Unknown column 'chceckVote' in 'field list'

    whats wrong?

    lukasz_sabat@o2.pl Guest

  2. #2

    Default Re: Procedure error: 'chceckVote' in 'field list'

    On 23 Apr 2007 01:29:03 -0700, pl wrote:
     


    Change the "where" in your SET statement to "having"
    Lee Guest

  3. #3

    Default Re: Procedure error: 'chceckVote' in 'field list'

    On 23 Apr 2007 01:29:03 -0700, pl wrote:
     
    ______^

    One c too many...
    --
    ( Kees
    )
    c[_] Solution: A more subtle problem. (#15)
    Kees Guest

Similar Threads

  1. date field in update stored procedure
    By lwd in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 28th, 09:26 PM
  2. how do i know the list of procedure of a package
    By @rennes in forum Oracle Server
    Replies: 4
    Last Post: November 18th, 07:51 AM
  3. Replies: 1
    Last Post: July 10th, 01:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139