7. Re: [NF] MySQL IFNULL() Question (Ken Dibble)
Yeah. The idea is to have People in the system only once, since the same
person can be an Artist (designated as such for a Performance, like when
you go to see Bonnie Raitt--she's got a Band too, but it's not The Bonnie
Raitt Band, it's just
Do any of these help? http://www.databaseanswers.org/data_models/
There's certainly a lot of food for thought there. Thanks very much!
Ken
www.stic-cil.org
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/713 - Release
Similar to the directory problem, sometimes you need to convert a type
of data into a more abstract element.
Well, that's what I thought I was doing with my compound key of arttype and
artid. They behave as though there is a coordinates table, except that
table doesn't really exist.
It returns actual values for artist that my
query returned as null. Can you tell me why that is?
The WHERE clause for each of the two selects filters out only those
records that match either Person or Band so you're not getting any
extra records with NULLs.
Right. But (he said sheepishly)
On 3/6/07, Ken Dibble [EMAIL PROTECTED] wrote:
Right. But (he said sheepishly) my tables had actual data in them that
should have been returned in the artist field for some performances;
instead my query returned nulls in some cases.
No need to be sheepish. This stuff is hard. I suspect you
At 03:57 PM 3/6/07, you wrote:
On 3/6/07, Ken Dibble [EMAIL PROTECTED] wrote:
I suspect you have a subtle data design problem, one iirc Tamar once
presented as parents of unrelated siblings - your Perfs table has an id
that you are
joining both to a PK in the Person table and a PK in the
Yeah. The idea is to have People in the system only once, since the same
person can be an Artist (designated as such for a Performance, like when
you go to see Bonnie Raitt--she's got a Band too, but it's not The Bonnie
snip
This sounds like a great problem for a database design class.
On 3/4/07, Ken Dibble [EMAIL PROTECTED] wrote:
I'm trying to substitute an empty string when a derived field returns None
(null).
Any suggestions would be appreciated. Thanks.
You might not like my suggestion ;). If I understand what you're
doing, you're trying to assemble a list of records
I'm trying to substitute an empty string when a derived field returns None
(null).
Any suggestions would be appreciated. Thanks.
You might not like my suggestion ;). If I understand what you're
doing, you're trying to assemble a list of records and the performer
from the Songs and Perfs
Actually, I like it a lot. It returns actual values for artist that my
query returned as null. Can you tell me why that is? (I know it's not the
field truncating thing; I modified my original query with a PADL() and
still got those nulls.)
I meant, PADR().
--
No virus found in this outgoing
I'm trying to substitute an empty string when a derived field returns None
(null).
In VFP 9 I can do it like this:
artfield = '(SELECT ICASE(musPerfs.arttype == P, ' ;
+ 'ALLTRIM(musPeople.firstname) +
+ ALLTRIM(musPeople.lastname), ' ;
+ 'musPerfs.arttype == B, '
11 matches
Mail list logo