[mv] MV4beta2 SQL "LIKE" not working

["Chris Müller" <cjmueller@polinet.ch>]

******    message to minivend-users from "Chris Müller" <cjmueller@polinet.ch>     ******

When I replace 
[search-region search="
	st=sql
	sq=select * from protucts where field = 'xyz'
"]
by 
[search-region search="
	st=sql
	sq=select * from protucts where field LIKE 'xyz%'
"]
the mySQL log shows an entry of "select * from products"
whereas the first varoiiant works fine.

The same SQL statement works in [query sql="select * from products where
field LIKE 'xyz%'], however, I cannot figure out who the [more-list]
works in the [query ..] as it was announced in the WHATSNEW. There is no
detail on how to use it. 

The chapter on SQL searches (not text-based) has disappeared from the
documentation and I cannot find how to set up a form-based SQL search
that accesses the SQL db in MV4.
Is there going to be some additional documentation for SQL?

Mike, as I understand from your earlier posting, you are still improving
the SQL environment. Is this one of the issues you are planning to
address, too?



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