[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Minivend <-> MySql problems
On Thu, 15 Jul 1999, adfranse wrote:
> I finally got Minivend working with a MySql Products table. I still have a few questions though.
>
> 1. Is it possible to only use the Mysql database without the products.asc file.
Yes. Make sure that you set NoImport products
You also need to leave the products.asc in the Database directive as
a placeholder.
> 2. I want to be able to search on parts of a field eg when a user types 'ABC' I want Minivend to find 'ABC' but also 'GSFABC' and 'FEYHABCFSE'.
Use LIKE instead of = in your SELECT,
select * from products where description like '%[mv_searchspec]%';
Using two % wild cards can be really slow though.
> 3 Are there any templates for using Minivend with MySql ?
Coming in the new documentation project.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
