[ic] Searching on more than one table

[Tobias Henle]

Stefan Hornburg Racke wrote:

> 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.
> 


Yes but not if you have 2000 entrys in your Product database and make a 
Query for every Information you need like the data-tag dose.

We have two Servers one for the Webshop an another with the Database and 
they ar connected via our Firm-Network so it courses a lotsof trouble if 
you don't think about preformance and data transferes :)

> 
>>** and I use SQL berourse SQL == phun! ;)
>>
>>
> 
> Die Deutschen sind nicht nur im Fußball Rumpelfüßler :-)


ich hasse fussball ;)


> 
> Yes, SQL is quite nice. We often use SQL queries in embedded Perl
> or usertags. That rocks.
> 


dito

_cu_

mit freundlichen Grüßen

-Tobias Henle
                          _   _    _
  __ __ ____ __ ____ __ _| |_| |_ (_)___ ___ ___ _ _    __ ___ _ __
  \ V  V /\ V  V /\ V  V /  _| ' \| / -_|_-</ -_) ' \ _/ _/ _ \ '  \
   \_/\_/  \_/\_/  \_/\_(_)__|_||_|_\___/__/\___|_||_(_)__\___/_|_|_|
--
________E-Mail________________________URL____________________________
	mailto:t.henle@thiesen.com    http://www.thiesen.com
_____________________________________________________________________