kentico_michal
-
2/7/2012 7:55:29 AM
RE:Insert parameterise query into multiple choice select
Hello,
You can access the NodeID of the current document on the Form tab using the following query macro: {%nodeid%} and use it in the where condition of the SQL query. It is worth noting that if you are creating a new document, the macro {%nodeid%} returns the NodeID of the parent document (document under which you are about to create a new document). Only when the document has been created and you access the Form tab again in order to update the document, the macro {%nodeid%} returns the NodeID of the current document.
Best regards, Michal Legen
|