[thelist] Learning SQL

Michiel Trimpe info at juvex.com
Wed, 5 Jan 2000 22:46:20 +0100


You say it, _as long as_ . That's exactly the problem. In data critical
applications these kind of errors can be desastrous and well , we don't want
that to be even remotely possible, do we ?

----- Original Message -----
From: Oliver Lineham <oliver@lineham.co.nz>
To: <thelist@lists.evolt.org>
Sent: Wednesday, January 05, 2000 10:36 PM
Subject: Re: [thelist] Learning SQL


> At 22:24 4/01/00 +0100, you wrote:
>
> >If you define these critters in the Database Structure you can prevent
this
> >kind of "error" from occuring. In other words assigning an incorrect ID
will
> >return a simple error.
> >mSQL & MySQL do _not_ support this, Oracle _does_ and I don't _know_
about
> >MS SQL and other SQL servers.
>
> But surely this isn't a problem?  As long as whatever interface you are
> providing to the database is properly written (eg. CGI, PHP, text menu ..)
> it won't cause a problem.
>
> Ol.
>
> ___________________________________________________
>       oliver.lineham   http://vox.vibe.co.nz/
>                  mind over pixel
>
> _______________________________________________________
> unsubscribe+options: http://lists.evolt.org/mailman/listinfo/thelist
> tip harvester: http://lists.evolt.org/harvest/
> email archive: http://lists.evolt.org/archive/
> http://evolt.org/  Workers of the Web, evolt !
>