I'm using Coldfusion8/MySQL5 (still newbie) and am looking for some tips on the following:
On my Coldfusion.cfc I'm calling a cfquery/stored procedure to insert a new records into the database.
This is my simple storedprocedure:
CREATE DEFINER=`root`@`127.0.0.1` PROCEDURE `proc_insert_user`(IN `user_iln` VARCHAR(13))
LANGUAGE SQL
DETERMINISTIC
MODIFIES SQL DATA
SQL SECURITY INVOKER
COMMENT ''
BEGIN
INSERT INTO teilnehmer (iln)
VALUES(user_iln);
END
The problem is, this inserts a new record, BUT I can't see it...
If I query the database for records, they all get returned, but the records never show up in my HeidiSQL window. I assume this must be somewhat related to my MySQL session (root@127.0.0.1) and the stored procedure (`root`@`127.0.0.1`), but even with both of them being the same, Heidi just does not show the records, that are currently in the table.
Can someone give me a pointer on what settings to tweak in order to see what gets inserted?
Thanks for help!