On Fri, Jan 15, 2010 at 7:59 PM, Ryan Pusztai <rpusz...@gmail.com> wrote:
> Hi,
> I can not get the model find_all to work correctly when I want to use MySQL
> operators of '!=' and 'NOT REGEXP'. I think it has to do with the pattern in
> the string.gsub() in "build_query".
>
> To fix the '!=' just add '!' to the string.gsub() pattern.
> - string.gsub(condition, "([%w_]+)%s*([%a<>=]+)%s*%?",
> + string.gsub(condition, "([%w_]+)%s*([%a<>!=]+)%s*%?",
>
> Here is the code I use to call model:find_all()
>>
>> self:find_all("notes NOT REGEXP ?", { Autobahn })Use string.gsub(condition, "([%w_]+)%s*([%a%s<>!=]+)%s*%?", In the line you quoted above. It is somewhat a dirty hack, but it will do for now, Lua's pattern matching is very limited. :-) -- Fabio Mascarenhas _______________________________________________ Kepler-Project mailing list Kepler-Project@lists.luaforge.net http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project http://www.keplerproject.org/
