[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