xsql - accessing parameters in sqlfunction

[mst@kb.dk]

  Hi                                                                                                               
                                                                                                                   
  I'm a newbee when it comes to xsql/xml...                                                                        
                                                                                                                   
  I'm having problem getting access to parameters passed from a webpage. I'm proberbly just misunderstanding       
  something.                                                                                                       
                                                                                                                   
  Here's what's done: The user selects a year which is then passed to the xsql, and I need to select all           
  diaryentries from the year given (see code below). My problem is that the '?' is not accepted as the value of    
  the selectYear parameter. How do I get hold of that value so that I can use it in the to_date function?          
                                                                                                                   
  This is the code I have                                                                                          
                                                                                                                   
  <xsql:query                                                                                                      
  rowset-element=""                                                                                                
  row-element="monthelement"                                                                                       
  tag-case="lower"                                                                                                 
  bind-params="selectYear selectYear"                                                                              
  >                                                                                                                
                                                                                                                   
  select unique to_char(diarydate, 'Month') as month, to_char(diarydate, 'MM') as mm                               
  from diaryentry                                                                                                  
  where                                                                                                            
  diarydate between                                                                                                
  to_date(?||'-01-01','YYYY-MM-DD')                                                                                
  and                                                                                                              
  to_date(?|| '-12-31','YYYY-MM-DD')                                                                               
  order by mm;                                                                                                     
                                                                                                                   
  Thank you VERY much!                                                                                             
                                                                                                                   
                                                                                                                   
                                                                                                                   




___________________

Web-udvikler
Det Kongelige Bibliotek
Maiken Søltoft
mst@kb.dk
tlf.: 3347 4743
___________________