On Wed, Nov 27, 2002 at 02:51:08PM -0500, Ronald J Kimball wrote:
> > 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. It
> 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)
Goot catch. This is almost certainly what's happening.
> What error do you get if you execute the above query in MySQL?
> (Oracle says: ORA-00984: column not allowed here)
ERROR 1054: Unknown column 'nine' in 'field list'
Thanks,
Tony
