Documentation Details :: Problem on discussion board tutorial

I've done the discussion board tutorial and have one problem. (using PHP_ADODB) version.

On page http://www.interaktonline.com/Documentation/MXKollection/#075000_tutorialdiscussionboard.htm

it states "The id_init_msg field was initially removed from the insert transaction, when you applied the Insert Record Form Wizard. It must have the same value as the ID of the newly inserted message. However, the primary key of the new message is not available until the message has been actually inserted. Therefore, you will have to create a custom trigger that retrieves the ID of the message that has just been inserted, then updates the message by adding the same value for the id_init_msg field."

It then gives code examples to use in your custom trigger. the one for PHP_ADODB is:

$pkval = $tNG->getColumnValue('id_msg');
$query_update_initmsgid = "UPDATE message_msg SET id_init_msg = ".$pkval." WHERE id_msg = ".$pkval;
$result_update = $tNG->connection->execute($query_update_initmsgid);

However, this doesn't work for me. Messages are inserted in the database, but the id_init_msg field is NOT updated. Please HELP!!!

 

Hello Michael,

Please attach in a new reply to this post with the page you have trouble with, and the database you are using.

Regards,
Florin CARLIG

Sorry, my mistake. Turns out that I misspleed a filed name when setting up the database. Once I fixed that, all is well.