Reply to topic  [ 5 posts ] 
musicnizer & booknizer problem 
Author Message
Extra

Joined: Fri Jan 21, 2011 1:50 am
Posts: 24
Post musicnizer & booknizer problem
both show movie when you try to do sql.

In both I was just starting to do sql stuff with it, and I had to do select * from movies in both musicnizer & booknizer.


Sun Jun 10, 2012 11:54 am
Profile
Developer
User avatar

Joined: Wed Jan 23, 2008 11:37 am
Posts: 2498
Post Re: musicnizer & booknizer problem
It's not a problem, just the internal mechanics of the database.

_________________
ImageImage


Mon Jun 11, 2012 8:47 am
Profile
Extra

Joined: Fri Jan 21, 2011 1:50 am
Posts: 24
Post Re: musicnizer & booknizer problem
figured as much, just fyi

RElize its not a problem... Though i thought it was funny that a book database would reference movie.
I figured you would fix that in a future version anyway.


Tue Jun 12, 2012 11:38 am
Profile
Extra

Joined: Fri Jan 21, 2011 1:50 am
Posts: 24
Post Re: musicnizer & booknizer problem
Vlad wrote:
It's not a problem, just the internal mechanics of the database.



Not really a problem... I use the product as intended for most of what I need it for.

But if I want to do sql to find which movies have Sean Connery ... it doesnt seem doable.
Because there seems no linkage to join them to gether in order to give that answer via sql.
Via the actual program of course.

Per what I figure, intention... Im ok with it...just asking.


Wed Jul 04, 2012 3:36 pm
Profile
Developer
User avatar

Joined: Wed Jan 23, 2008 11:37 am
Posts: 2498
Post Re: musicnizer & booknizer problem
Tulsaboyw wrote:
But if I want to do sql to find which movies have Sean Connery ... it doesnt seem doable.
Because there seems no linkage to join them to gether in order to give that answer via sql.
Via the actual program of course.

This is how the database structure works :). Information about movies and persons is, naturally, stored in different tables, so it is not possible to make a straightforward request. You need to use various JOIN, WHERE, ON operators :roll:

_________________
ImageImage


Mon Jul 09, 2012 3:47 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 5 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


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

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.