[Clipart] Bug. strange searching

Roan Horning roan at horning.us
Wed Jun 9 06:01:26 PDT 2010


On 6/9/2010 3:43 AM, chovynz wrote:
>
> Does search count _ as "and other letters in between"?

In SQL the main wildcards are the percent sign, %, to match any number 
of characters, and the underscore, _, to match any character. (See 
http://www.w3schools.com/SQL/sql_wildcards.asp for more on SQL wildcards).

It appears that when using the search box with this resulting url: 
http://www.openclipart.org/search/?query=b_w that the underscore is escaped.
But when going through the tags url: 
http://www.openclipart.org/tags/b_w?page=4, the underscore is not escaped.

This should be a relatively easy fix, and since the underscore is used 
to represent a space character in tags, this has potential to cause more 
weird returns for other tags (although probably not very often).

My 2 pence worth.

Roan



More information about the clipart mailing list