Changes to search

[PeterJ]

This is what we are using, and we are trying to avoid allowing search returning huge numbers of rows

Just throwing this thought in the ring...

If limiting number of results why not allow any old stupid search criteria but then limit what is returned to screen and post a message saying...

"This search generated more than 500 results, please refine your search criteria"

Or whatever number or message you see fit. Then all this work isn't needed?
Just an idea.

Hi, it's an idea, but I would prefer not to restrict results. With the current system I think that we have the most flexible search system we possibly can, but I'm always happy to listen and make changes if the majority of users want something. Search is very complicated due to the non-UK characters.

The only limitation is three alphanumeric characters in search which I don't believe will cause any issues 99.9% of the time, but as mentioned I'm open to suggestions such as the request for 3D which has been implemented.

[Fahnn]

This probably isn't anything anything that anyone else wants (and if so, please just ignore me), but is it possible to search for games that have an entry in the "Comments" field? Some of the comments have some great information (e.g. Bandersnatch, Sqij!, etc.) and I'd love to be able to find more of that sort of thing.

Thanks for the suggestion. I could do you a CSV or Excel export of all the games with comments, and include the comments. Would that help?

Talk about service! That would be amazing! But please don't go to any trouble on my behalf, I was really just wondering whether all the fields were searchable. I'd figured out how to search the main ones, but had wondered if the search might extend beyond those.

[PeterJ]

No problem [mention]Fahnn[/mention]. I will do over the weekend.

[PeterJ]

This probably isn't anything anything that anyone else wants (and if so, please just ignore me), but is it possible to search for games that have an entry in the "Comments" field?

Hi [mention]Fahnn[/mention]

Here is a CSV file with a list of all titles in ZXDB and the comments included.

http://s000.tinyupload.com/index.php?fi ... 2747063454

Peter

[Fahnn]

Hi @Fahnn

Here is a CSV file with a list of all titles in ZXDB and the comments included.

http://s000.tinyupload.com/index.php?fi ... 2747063454

Peter

Peter, this is absolutely fantastic. It's exactly what I was looking for! I'm really looking forward to having a good browse through all the data but can already see that there's some fascinating bits and pieces in there. Many thanks!