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

joachim.richter interchange-users@interchange.redhat.com
Thu Nov 29 16:33:00 2001


Hi list sorry to bother you all but I do believe i have the solution :

instead of :

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

                fi=products
                st=sql
                sp=sql_test

                co=1

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

all of the before

I can use this (at neckbreaking speed) :

[set test_sql]2001-10-01[/set]

[scratch test_sql]<br><br>

[query list=1 st=db ml=500 sql=|
    select * from products
         where xeingdatum > "[scratch test_sql]"
         and xeingdatum < '2001-12-31'
        |
        ] [sql-increment] [sql-code] [sql-field title] [sql-field category] <font color=FF0000>[sql-field xeingdatum]</font><br>[/query]


thanx Guys


JoE



US Video Center Medien GmbH
Heimsheimer Str 22
70499 Stuttgart

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