NextPVR Forums
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Developers v
« Previous 1 … 35 36 37 38 39 … 93 Next »
What's wrong with this SQL query?

 
  • 0 Vote(s) - 0 Average
What's wrong with this SQL query?
bgowland
Offline

Posting Freak

Posts: 4,535
Threads: 376
Joined: Dec 2004
#1
2008-02-03, 07:47 PM
Code:
SELECT oid, RECORDING_SCHEDULE.capture_source_oid, status FROM RECORDING_SCHEDULE WHERE status=0 AND capture_source_oid IN (SELECT capture_source_oid FROM BDA_RECORDING_SOURCE)
It only returns records for the first BDA capture_source_oid (I have 3). I orginally had a query with an INNER JOIN on the BDA_RECORDING_SOURCE table and it behaved exactly the same. I need all pending recordings for all my BDA devices but not my analogue devices. For the life of me I can't see what's missing.

Cheers,
Brian
psycik
Offline

Posting Freak

Posts: 5,206
Threads: 422
Joined: Sep 2005
#2
2008-02-03, 07:58 PM
Did you try right join or left join in your previous query? They may help

Failing that you may want to do it the hard way (query the bda_recording_source, then run queries for each recording source).
bgowland
Offline

Posting Freak

Posts: 4,535
Threads: 376
Joined: Dec 2004
#3
2008-02-03, 08:30 PM (This post was last modified: 2008-02-03, 11:37 PM by bgowland.)
Thanks - it's OK, I found the problem. I looked in a mirror and saw a half-wit staring back at me.

The only pending recordings I have on my BDA tuners are all, urrrm, scheduled for one tuner. :o :o

Both queries are doing exactly what they're supposed to.

Don't go away folks - next week I'm going to invent a glass drum. Big Grin

Cheers,
Brian
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Need help with some real-world SQL query results bgowland 17 4,030 2013-02-01, 02:12 PM
Last Post: mvallevand
  SQLite vs Access query differences fla 6 4,483 2007-02-05, 09:07 PM
Last Post: psycik
  SQLite GUI-based admin & query building? Braklet 3 1,443 2006-10-30, 02:45 PM
Last Post: Braklet
  Recordings made via the Web Admin interface are at the wrong resolution! mmatheny 9 2,007 2006-08-04, 06:34 PM
Last Post: HtV
  Query live preview mode fla 3 1,723 2006-07-12, 12:18 AM
Last Post: fla
  can u see whats wrong with this code? reven 2 1,597 2004-12-06, 04:44 AM
Last Post: sub
  What is wrong with this? NLS 0 1,249 2004-11-10, 06:08 PM
Last Post: NLS

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode