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

[Michelle Wilant]

I second your query choice.  We've found that the interchange formatted query (the fi=foo, etc) hinders our catalogs.  We are now working to
strip those queries out of interchange and replace them with direct, specific sql queries and using table joins, etc wherever necessary.

After we do that then we want to copy our work into the foundation template that comes with interchange so every catalog we make from here
on out will automaticly have those explicit sql queries --- Does anyone want to give me the answer to which templates I need to replace in
order to get the makecat script to copy them into any newly created catalog? :)  I'm assuming its interchangeroot/foundation directory, but
haven't taken the time to try it.  A confirmation of this would be appreciated.  :)  Thanks.

"joachim.richter" wrote:

> 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
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users