Re: [mv] products.txt and SQL

[Stefan Hornburg <racke@linuxia.de>]

******    message to minivend-users from Stefan Hornburg <racke@linuxia.de>     ******

Mike Heins <mikeh@minivend.com> writes:

> ******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******
> 
> Quoting Chris Jesseman (chris@sitemajic.net):
> > 
> > Hi everyone,
> > 
> > Can I implement a SQL products table and remove products.txt?
> > 
> > I'm all of the sudden noticing that my minimate updates the mySQL 
> > databases (ie. products, pricing) fine but not the corresponding *.txt 
> > files. Until this week, minimate updated both of them in tandem. It looks 
> > like minimate uses the sql database and the front end is using the *.txt 
> > files. What can I do to force the front end (ie searches, query's. etc) 
> > to use the sql database?
> > 
> 
> Typically, the .txt file stops getting auto-updated when it reaches
> a certain size. All you have to do is export it.
> 
> To use the SQL database for searches, just include st=db in the
> scan (or mv_searchtype=db in a form). 
> 
> I will look at adding a setting (to Interchange, at least) that allows
> you to specify the default search type. There are a few ramifications
> to this, but I think it is doable.

A related question. It is possible to make NoImport automagicallly come
in place for all SQL database with sth like NoImportSQL ?
That would be quite handy.

Ciao
        Racke

-- 
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Junior Officer of the MiniVend/Interchange Bug Patrol <--- 
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list