Jeffrey A. Stuart
|
Posted: 02/05/2001, 12:03 PM |
|
Ok.. got a weird bug here... Have 2 tables... One is a news provider and the other a story db.
We had entered some stories in with a news provider of BS... later on, someone deleted the
news provider of BS but did NOT delete the stories related to that provider.... So when we go
and have it display a listing of all the stories, those 2 stories did NOT show up on the grid
BUT are still in the DB... We couldn't do a search on the stories via the grid search form but
if I do a mysql query by hand they come up....
--
Jeff (FurBall)
WebOverdrive Newbie Tech Board http://www.topniche.com/tech/
furball@weboverdrive.com
|
|
|
Joachim Uersfeld
|
Posted: 02/05/2001, 12:54 PM |
|
This is a Bug in your Database / Query-Design, not in CodeCharge
Good databasedesign is: The stories must deleted with the provider. Or bind
the stories on deleting the provider on another provider.
In think, you have set with your design in CC a join like:
select * from stories, providers where stories.providerid =
provider.providerID.
The result: No provider, no stories.
You can use your own sql-statement in CC to change it in something like
this: select * from stories, providers where stories.providerid *=
provider.providerID.
Regards, Joachim
Mainz/Germany
"Jeffrey A. Stuart" <jstuart@neo.rr.com> schrieb im Newsbeitrag
news:MPG.14e8d156a0833d3e989687@news.codecharge.com...
> Ok.. got a weird bug here... Have 2 tables... One is a news provider and
the other a story db.
> We had entered some stories in with a news provider of BS... later on,
someone deleted the
> news provider of BS but did NOT delete the stories related to that
provider.... So when we go
> and have it display a listing of all the stories, those 2 stories did NOT
show up on the grid
> BUT are still in the DB... We couldn't do a search on the stories via the
grid search form but
> if I do a mysql query by hand they come up....
>
> --
> Jeff (FurBall)
> WebOverdrive Newbie Tech Board
> http://www.topniche.com/tech/
>furball@weboverdrive.com
|
|
|
Jeffrey A. Stuart
|
Posted: 02/05/2001, 9:14 PM |
|
Well...... let's see..... the short answer is.... in theory... yes... in practice... NO.
Mysql has NO types of requirements for that... It has no referential integrity. QED it has
no problems doing what just happened... Now are you saying that CC does that kind of join? If
so.. OK.. fine... but that would have been nice to have had that documented. ;) I can work
around it. ;)
And no, good database design does not ALWAYS say that referential integrity is required... ;)
In article <95n3u8$o13$1@news.codecharge.com>, uersfeld@pc-team.de says...
> This is a Bug in your Database / Query-Design, not in CodeCharge
>
> Good databasedesign is: The stories must deleted with the provider. Or bind
> the stories on deleting the provider on another provider.
>
> In think, you have set with your design in CC a join like:
> select * from stories, providers where stories.providerid =
> provider.providerID.
> The result: No provider, no stories.
>
> You can use your own sql-statement in CC to change it in something like
> this: select * from stories, providers where stories.providerid *=
> provider.providerID.
>
> Regards, Joachim
> Mainz/Germany
>
>
> "Jeffrey A. Stuart" <jstuart@neo.rr.com> schrieb im Newsbeitrag
>news:MPG.14e8d156a0833d3e989687@news.codecharge.com...
> > Ok.. got a weird bug here... Have 2 tables... One is a news provider and
> the other a story db.
> > We had entered some stories in with a news provider of BS... later on,
> someone deleted the
> > news provider of BS but did NOT delete the stories related to that
> provider.... So when we go
> > and have it display a listing of all the stories, those 2 stories did NOT
> show up on the grid
> > BUT are still in the DB... We couldn't do a search on the stories via the
> grid search form but
> > if I do a mysql query by hand they come up....
> >
> > --
> > Jeff (FurBall)
> > WebOverdrive Newbie Tech Board
> > http://www.topniche.com/tech/
> >furball@weboverdrive.com
>
>
>
--
Jeff (FurBall)
WebOverdrive Newbie Tech Board http://www.topniche.com/tech/
furball@weboverdrive.com
|
|
|
|