| 
                                                                        
                                                                         
                                                                            
                                                                                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
                                                                         
                                                                        
                                                                            
                                                                         
                                                                        
                                                                         
                                                                        
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                        
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                        
                                                                         
                                                                     |