7 Aug
2006
7 Aug
'06
10:57 p.m.
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users