Re: [SQL] SQL update function faililed in Webmin Interface

Kathiravan Velusamy wrote:
> I created database called "test" and created table name called "one"
> for that DB, which contains filed name "Name" with varchar(10) as a
> type and allows Null values.

The issue here is that you have created a column "Name" with quotes,
which means it is case-sensitive.

> "SQL update "one" set Name = 'Second1' where oid = 25349 failed :
> column "name" of relation "one" does not exist".

You are then trying to access it without quotes which means it gets
folded to lower-case "name" (look carefully at the error message).

If you quote the name when you create it, ALWAYS quote it. If you never
quote names then you won't have any problems.

It might be that the webmin module quoted the column-name for you
without your knowledge. You'll need to consult your webmin documentation
for details.

--
Richard Huxton
Archonet Ltd