[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Searching on more than one table
Tobias Henle <t.henle@thiesen.com> writes:
> patrick.bennett@ccgenesis.com wrote:
>
> > I would like to come up with a way to search two
> > tables using one search string. I have the products
> > table and the article table, both of which should
> > be searched from one search box. Is there an
> > easy way to do this?
>
>
> Use SQL!
>
> ** I use SQL for most of my Querys becourse of preformance.
> If you debug the SQL Querys form IC you will see that it oftens siply
> uses a SELECT * FROM bla; what is not very fast ;)
Even with this restrictions, IC searches are pretty fast. But
one can use mv_like_spec with SQL anyway.
>
> ** and I use SQL berourse SQL == phun! ;)
>
Die Deutschen sind nicht nur im Fußball Rumpelfüßler :-)
Yes, SQL is quite nice. We often use SQL queries in embedded Perl
or usertags. That rocks.
Cheers
Racke
--
Racke happily hacks Interchange and maintains Debian packages like Courier.
For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users