[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

xsql - accessing parameters in sqlfunction

• To: xml-dev@l...
• Subject: xsql - accessing parameters in sqlfunction
• From: mst@k...
• Date: Thu, 8 Jan 2004 17:10:38 +0100

                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
  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@k...
tlf.: 3347 4743
___________________

• Prev by Date: Re: Re: Cookies at XML Europe 2004 -- Call for Participation
• Next by Date: RE: Why is xml:base a URI *reference*?
• Previous by thread: Googlearchy
• Next by thread: RE: anyone know of good places to get opengis data?
• Index(es):
  • Date
  • Thread