Getting Error: Column does not exist

Question

When adding rows to a table I am getting Error: column does not exist and I am not sure why. I know the table does and it is fairly straight forward. Here is what I have to add and here is what the table looks like. Any help would be great and let me know if you have any questions. Thanks!

Whatever value I have in emailField it is giving me the error that emailfield column does not exist

final String addemployee = "insert into employee values ('" + name_field.getText() + "', '" + usersSuper.getText() + "', '" + true + "' , md5('" +    passwordField.getText() + "') , "  + emailField.getText() + ");";

Here is the table

CREATE TABLE employee
(
  name text NOT NULL,
  manageremail text,
  isadmin boolean NOT NULL,
  userpassword text NOT NULL,
  email text NOT NULL,
  CONSTRAINT "user_Email" PRIMARY KEY (email)
)

you've missed quotes around emailField.getText()? it should be '" + emailField.getText() + "' — roman
– roman, Commented Sep 24, 2013 at 14:36
Not sure how I missed that one but thanks for your help Roman! — Alex Miles
– Alex Miles, Commented Sep 24, 2013 at 14:45
i hope you are only storing salted hashes and not real passwords. — Woot4Moo
– Woot4Moo, Commented Sep 24, 2013 at 14:46

BAD_SEED · Accepted Answer · 2013-09-24 14:43:42Z

1

Try

final String addemployee = "insert into employee values ('" + name_field.getText() + "', '" + usersSuper.getText() + "', '" + true + "' , md5('" + passwordField.getText() + "') , '" + emailField.getText() + "');";

answered Sep 24, 2013 at 14:43

BAD_SEED

5,10611 gold badges62 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

roman · Accepted Answer · 2013-09-24 16:38:01Z

0

You've missed quotes around emailField.getText()? it should be '" + emailField.getText() + "'

answered Sep 24, 2013 at 16:38

roman

118k30 gold badges205 silver badges209 bronze badges

Collectives™ on Stack Overflow

Getting Error: Column does not exist

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related