Re: [mv] products.txt and SQL

[Mike Heins <mikeh@minivend.com>]

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

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Unix version of an Outlook-style virus:
It works on the honor system. Please forward this message to everyone
you know, and delete a bunch of your files at random.
-
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