On Sat, 2005-12-10 at 19:59 -0800, Kevin Brown wrote:
[snip]
> h = g_list_join((GList *)headers,"'),upper('");
> g_string_printf(q,"SELECT physmessage_id,headername,headervalue "
> "FROM %sheadervalue v "
> "JOIN %sheadername n ON v.headername_id=n.id "
> "WHERE physmessage_id IN (%s) "
> "AND upper(headername) %s IN (upper('%s'))",
> DBPFX, DBPFX, r->str, not?"NOT":"", h->str);
[snip]Should we also add / change the indexes to uppercase? Aaron
