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

[Michelle Wilant]

Actually, also on the note of sql queries:  Why was it that explicit queries were not used in the first place?  The general user base not having
a high amount of sql knowledge?  Some other reasons?  Just curious.

Michelle Wilant wrote:

> 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