View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Aug 26, 2007 3:19 pm 
Offline
Joined: Fri Nov 04, 2005 7:11 am
Posts: 61
I have set up the following powersearch to get live nascar races:

program.title = ('Nascar Racing')
AND program.subtitle REGEXP '(Nextel Cup)'
AND program.first > 0
AND program.previouslyshown = 0
AND program.category = ('Sports Event')

The only problem with this expression is that we pick up Practice, Final Practice and Qualifying in addition to the race. How do I modify the expression to exclude events that contain the word 'Practice' or 'Qualifying'

_________________
BE: R8.4, HVR2250, MCE media center remote, GigaByte GA-EP43-UD3L, 2gb ram

FE: Linhes 8.4, Mythbuntu, Linux Mint DE


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 26, 2007 4:24 pm 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
How about adding this to the end of your search criteria:

Code:
AND program.description NOT ('Qualifying')
AND program.description NOT ('Practice')


I'm unsure if 'NOT' is the correct syntax (maybe '!=' instead?) but I'm sure someone more versed can chime in an correct that if it's wrong. That should give you a push in the right direction.

_________________
Mike
My Hardware Profile


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 26, 2007 5:19 pm 
Offline
Joined: Fri Nov 04, 2005 7:11 am
Posts: 61
Thanks, that helped me narrow my guessing. I'm not sure if this is the correct way but... here's what I came up with that seems to work:

program.title = ('Nascar Racing')
AND program.subtitle REGEXP '(Nextel Cup)'
AND program.first > 0
AND program.previouslyshown = 0
AND program.category = ('Sports event')
AND program.subtitle NOT LIKE '%Practice'
AND program.subtitle NOT LIKE '%Qualifying'

_________________
BE: R8.4, HVR2250, MCE media center remote, GigaByte GA-EP43-UD3L, 2gb ram

FE: Linhes 8.4, Mythbuntu, Linux Mint DE


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu