Standard SQL allows for inserts without specifying field names.
Personally, I think that it is more readable to specify the field names
but it is quite common to not bother doing so.
--
<Douglas Leonard>
<[EMAIL PROTECTED]>
On 19 Jun 2001, Alan E. Derhaag wrote:
> "Christian Heiss" <[EMAIL PROTECTED]> writes:
>
> > [1 <text/plain; iso-8859-1 (quoted-printable)>]
> > Hi,
> >
> > I'm using Apache::AuthDBI to verifying the users on my web site.
> >
> >
> >
> > I can connect to the the protected site, but there is a output in the error log:
> >
> >
>----------------------------------------------------------------------------------------------------------------------------------------
> > >Use of uninitialized value at /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm
>line 450
> > >Use of uninitialized value at /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm
>line 480
> > >Use of uninitialized value at /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm
>line 481
>
> [...]
>
> > then I put it in the database with:
> >
>----------------------------------------------------------------------------------------------------------------------------------------
> > >my $sql = "INSERT INTO <table name> VALUES($userid, $groupid, $pass, ...);
> > of course, before I'm using the quote funktion ($dbh->quote($userid)...)...
>
> What database manager allows SQL without supplying the fields the
> values go into?
>
