Using the old server behaviours you can retrieve a new record ID immediately after insertion.

e.g. // retrieves the record ID
$insert_id = mysql_insert_id();

What is the equivalent procedure using the new DMX Server Connect tools?
I can't seem to find any information on this.

thanks
Greg

Hello Greg,
The last inserted ID is available after the insert step in server connect. You can add another step, after the insert step and you will see the identity in its dynamic data picker.

Hi Teodor,

Thanks for that, I created a session var under "globals" then added a "set_session" step immediately after the "insert" step and this is now grabbing the inserted record ID correctly.

I first tried using the "set value" option, but I can't find how to access this value once it's assigned a dynamic data link.

Could you please advise how to use this option?

thanks

Greg

You can assign a dynamic value to the set value step.. just add it after the insert step and you will see the identity.

Hi Teodor,

My question was really how to access the value from the "set value" step .

In Set Value Properties, are the 'Name' and 'Global Name' fields referring to variables that need to be preset elsewhere?

thanks

Greg

Do you want to access it on your page?
Are you using HTML5 Data Binding or DMXzone App Connect to bind your data on the page?

Yes and I'm using App Connect.
This is a learning process as I migrate from server behaviours and understand the new methods.