[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-----