Re: C API Prepared Statement Parameter not bind

[Joseph Dimech]

It may be due to an incorrect setting of the type to your parameter buffer_type. Even though your result bind is working for the the same assigned type when you tested it without using the param binding. May be worth checking out. You sould confirm that the parmeter "id" stored in your "subset" table is truely a int or long and not a short, etc... Use the "SHOW COUMNS FROM tablename;" command in the "mysql" utility to confirm the field type for field "id" for that table. I can't tell anything about the structure of your table. It is always a good Idea to include the out put from the "SHOW CREATE TABLE table_name" command with your questions. The more info the better. Hope this helps.

Joe