[ic] European Date Search - accomplished that is 99%

[joachim.richter]

Thanks for the help guys,

after changing the date format to YYYY-MM-DD in the field "date"
I get an correct list output. (YES!!)

But somehow the output process is VERY slow, although we are using an MYSQL database !
Any ideas on how I can change the link to be faster ?

After reading the manual - I even got more confused with the [query sql] tag....

Does anybody have a very simple sql link and a simple results page we can build upon ?

By the way a couple of times I have seen that people were using "st=sql" instead of "st=db"
does that make a difference ?

<a href="[area href=scan
        search=|

                fi=products
                st=sql
                sp=new50

                co=1

                sf=date
                se=N
                op=ne
                nu=0
                su=1

                sf=date
                se=2001-09-01
                op=>
                nu=0
                su=1

                sf=date
                se=2001-12-31
                op=<
                nu=0
                su=1

                ml=50
                tf=date
                to=r
        |
]">test</a>



thanx JoE
US Video Center Medien GmbH
Heimsheimer Str 22
70499 Stuttgart

Tel 0711 880252 0
Fax 0711 880252 22
Email joachim.richter@usvideocenter.de