On Wed, Nov 27, 2002 at 07:00:31PM +0000, Tony Bowden wrote:
> On Wed, Nov 27, 2002 at 08:28:40AM -0800, Michael A Chase wrote:
> > On Wed, 27 Nov 2002 13:12:24 +0000 Tony Bowden <[EMAIL PROTECTED]> wrote:
> > > And there's still the matter of the highly misleading error message:
> > > DBD::mysql::st execute failed: Unknown column 'nine' in 'field list'
> > > The error of course being nothing to do with a column 'nine', as that's
> > > the value being passed to it...
> > You'll need to take that up with the mysql people. Everything after
> > 'failed: ' is coming from mysql.
>
> But what's the query being sent to MySQL? Why does it think that the
> value is the column?
I don't know how MySQL handles placeholders, so this is just a guess. Ut
may simply be interpolating the string 'nine' into the query string, in the
same way it interpolated the number 9, that is, without qotes:
INSERT INTO user (username, password)
VALUES ('bar', nine)
in which case, since nine is unquoted, it looks like a column name.
What error do you get if you execute the above query in MySQL?
(Oracle says: ORA-00984: column not allowed here)
Ronald
