Rider lookup field at front page CQ

Number of posts: 61 Registration date: 2009-03-07

Suggestion from several people:

A lookup field somewhere on the CQ frontpage where the visitor can directly type a rider name.

Note Leon: might be a possibility, but it's only one extra mouse click to click on Search Riders button.

Number of posts: 23 Registration date: 2009-08-16

In my Firefox browser I created a "search engine" for CQ, which allows me to type a rider name first without even having visited CQ prior to the search. Maybe that's only a solution for the heavy users. Very Happy

Number of posts: 61 Registration date: 2009-03-07

dijk wrote:

In my Firefox browser I created a "search engine" for CQ, which allows me to type a rider name first without even having visited CQ prior to the search. Maybe that's only a solution for the heavy users. Very Happy

Hi Dike,

Maybe - as a servide for these heavy users - you can describe here how to create such a search engine?

Number of posts: 23 Registration date: 2009-08-16

Leon wrote:

dijk wrote:

In my Firefox browser I created a "search engine" for CQ, which allows me to type a rider name first without even having visited CQ prior to the search. Maybe that's only a solution for the heavy users. Very Happy

Hi Dike,

Maybe - as a servide for these heavy users - you can describe here how to create such a search engine?

You can download my version from
http://www.xs4all.nl/~dijk71/cyclingquotient.xml and save it in the searchplugins directory of Mozilla Firefox. At my computer it is: C:\Program Files\Mozilla Firefox\searchplugins. Close Firefox and open it again and it will be available.

It might even be easier if CQ added

Code:

to their homepage, where /cq.xml must point to a location of the XML file like mine. The search engine will be automatically available via the search engine box via "Add CQ".

FilipCQ wrote:

Done!

Number of posts: 2 Registration date: 2009-08-16

By the way, when you are using the "Search Riders" function, typing the full name of the rider is useless. I usually only write the name or the surname because of it.

For example: If you type "Lance Armstrong" you get no result. But if you type "Armstrong Lance", "Lance", "Armstrong" you can find him. I guess a lot of people will most likely write Lance Armstrong if they are looking for him.

It's just a little detail but I guess this is what this forum was created for Very Happy

It you are going "for perfection", you could even include a "Did you mean" feature like google. But I guess that's a very difficult feature to code.

Number of posts: 23 Registration date: 2009-08-16

Klasbak wrote:

By the way, when you are using the "Search Riders" function, typing the full name of the rider is useless. I usually only write the name or the surname because of it.

For example: If you type "Lance Armstrong" you get no result. But if you type "Armstrong Lance", "Lance", "Armstrong" you can find him. I guess a lot of people will most likely write Lance Armstrong if they are looking for him.

Technically, it seems that you have to split the input string on white space and concatenate the search by an "AND". In Lance's case it will become

Code:

WHERE Name LIKE '%Lance%' AND Name Like '%ARMSTRONG%'.

Subject: Zoekfunctie Fri Sep 18, 2009 10:44 am

De zoekfunctie zou best wat specifieker mogen zijn, vind ik.

Bijvoorbeeld: wanneer ik een renner zoek met 'man' in zijn naam, dan krijg ik 'too many results, refine your search'.
Het gebruik van jokertekens zou al een heel pak verbeteren.
Nu krijg ik in het vorige voorbeeld zowel MANZANO RUANO Jesus Maria (begin van de naam), als GERDEMANN Linus (midden in de naam), als DAMAN Gunther Wink

(eind van de naam), als QUINZIATO Manuel (voornaam), enz. Wie weet duiken zelfs renners van de ploeg Palmans of inwoners van de Cayman Islands op in deze zoekopdracht.
Met jokertekens zou het mogelijk moeten zijn om te specifiëren of de zoekstring zich vooraan, achteraan of middenin de naam bevindt. Tevens zou het handig zijn om alleen te kunnen zoeken op familienaam (of voornaam).
De opmerking geldt voor alle zoekopdrachten (bijv. wedstrijden)

Subject: Re: Rider lookup field at front page CQ Thu Jan 21, 2010 7:57 pm

Klasbak wrote:

By the way, when you are using the "Search Riders" function, typing the full name of the rider is useless. I usually only write the name or the surname because of it.

For example: If you type "Lance Armstrong" you get no result. But if you type "Armstrong Lance", "Lance", "Armstrong" you can find him. I guess a lot of people will most likely write Lance Armstrong if they are looking for him.

It's just a little detail but I guess this is what this forum was created for Very Happy

It hasn't been mentioned here yet, but Mark solved this about a month ago. You can now search for "Lance Armstrong" and get AMRSTRONG Lance as a result. * can be used as a wildcard.