[Devel] Re: [Users] The lcr module has incorrect syntax for the
current mysql release
brandon at dacrib.net
Mon Aug 7 21:57:32 CEST 2006
Yes. I agree. Must be.
On Aug 5, 2006, at 3:45 PM, Juha Heinanen wrote:
> Brandon Price writes:
>> q_len = snprintf(query, MAX_QUERY_SIZE, "SELECT %.*s.%.*s, %.*s.%.*s,
>> %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s FROM %.*s, %.*s WHERE %.*s
>> LIKE %.*s.%.*s AND '%.*s' LIKE CONCAT(%.*s.%.*s, '%%') AND %.*s.%.*s
>> = %.*s.%.*s ORDER BY CHAR_LENGTH(%.*s.%.*s), %.*s.%.*s DESC, RAND()",
>> and it works. Notice I removed the ''s after WHERE.
> if there is a problem, it must be in mysql client library, not lcr
> module. on the other hand, i don't understand why you didn't need to
> remove the quotes also from arround AND '%.*s' LIKE.
> -- juha
> Users mailing list
> Users at openser.org
More information about the Devel