CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Bug with grid and PHP

Print topic Send  topic

Author Message
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

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.