MySQL Forums :: Connector/Arduino :: UPDATE not working


Advanced Search

UPDATE not working
Posted by: Steve Spence ()
Date: May 04, 2014 04:47AM

My query is:

const char UPDATE_DATA[] = "UPDATE spspence_jobqueue.currentstatus SET pinID = pinValue WHERE deviceID = deviceID";

I'm calling it as such:

char pinID[6];

pinID = "pin_4"; // could be other values, pin_5, pin_6, all valid column names

my_conn.cmd_query(UPDATE_DATA);

get error:

Error: 47 = Unknown column 'pinID' in 'field list'.

Options: ReplyQuote


Subject Views Written By Posted
UPDATE not working 1887 Steve Spence 05/04/2014 04:47AM
Re: UPDATE not working 1104 Charles Bell 05/07/2014 08:39AM
Re: UPDATE not working 1083 Steve Spence 05/07/2014 09:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.