[mythtv] Feature Request: Search function for programs

Robert Kulagowski mythtv-dev@snowman.net
Wed, 13 Nov 2002 09:03:29 -0600


 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I like the grid, but finding a program is sometimes difficult.

I've gone to mysql, and the following syntax would allow for program
searches:

mysql> use mythconverg;
mysql> select * from program where title like "a %" group by title;

Which gives me all the programs (31 rows, and took 0.09 seconds) that
start with "a" and have a space.  "%" is the SQL wildcard.

Similarly, "%daily show%" will send back "The Daily Show with Jon
Stewart".

Now, all someone (not me:  don't know enough c++ / qt yet) needs to
do is take this SQL syntax, replace the hardcoded information with a
variable, and put the results in a listbox for further processing.

You're welcome! :)

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPdJpwfc1NpCTlP0JEQKlzwCgl717q+a1yv4db9pzyCDsvNx3ArIAoJAO
4y1cKjw2kVWb7j5Zkm8TjaLi
=9Oma
-----END PGP SIGNATURE-----