Re: [mv] products.txt and SQL

[John Beima <jbeima@reality.palb.com>]

******    message to minivend-users from John Beima <jbeima@reality.palb.com>     ******

Just a quick question, I have always used "st=sql" as opposed to "st=db", is 
there any mojor difference between the two?

Another place this would be nice, is on the banner database. I am storing all my 
banners in a SQL table, and I have to delete the catalog/tmp/Banner directory to 
force an update. Might there be an easier way?

John Beima


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