Re: [mv] May i miss something ?

[Dan Busarow <dan@dpcsys.com>]

On Thu, 11 Nov 1999, Fabien SIERRAS wrote:
> I have done read all FAQ, mailing list archive & docs, but i have
> still don't understand the database system.
> 
> In fact i have my product base under MySQL server so i put the line :
> 
> 
> #Database            products    products.asc   TAB
> 
> Database            products products.asc  dbi:mysql:cinemaffiche:localhost:3306
> Database            products DELIMITER    TAB

Specifying a TAB delimiter for an sql table may cause problems.  It
certainly is not correct and you should remove this line.

> Database            products LongReadLen  128

I'd get rid of this one too.

> And of course my Database login & Pass
> 
> There's no error in the error log or at starting, but when i make a
> search, i alway have empty results if i don't precise the searchtype
> as DB (of course the products.asc is empty) and when i use :
> 
> 
> <A HREF="/cgi-bin/cinemaffiches/scan/st=db/sf=ALPHA/se=A/ml=5/sp=result2
> .html">
> or
> 
> <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="db">

Here you're telling it to use the flat file, VALUE should be "sql"

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