> Alan McDonald wrote:
> > Lester
> > Somehow this code
> > $users_table = (isset($db_prefix) ? $db_prefix : '') . 'users';
> >
> > $sql = "SELECT * FROM $users_table WHERE user_id = '1'";
> >
> > // Check if we already have an Admin user.
> > $result = $this->mDbConnection->Execute($sql);
> > if ($result)
> > {
> > // If the record exists, we update it.
> > $row = $result->FetchRow();
> > $this->mAdminUsername = $row['user_name'];
> > $this->mAdminPassword = $row['user_pass'];
> > }
> >
> > results in an error: undefined index $row[user_name'];
> >
> > it works fine under MySQL
> > any ideas?
>
> firebird driver should be returning lower case field and table
> names. There is
> a switch for it but I forget where.
> I did try to convince people that upper case would be more
> logical but it fell
> on deaf ears :(
>
> --
> Lester Caine - G8HFL

wish I knew where it was supposed to be getting converted.
Alan