Cart
[Home] [By Thread] [By Date] [Recent Entries]
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
___________________
|
