1,105,229 Community Members

mysql error : Unknown column in 'field list'

nova37
Deleted Member
 
0
 

am doing project in c++ using mysql api

i have update query like that

q2<<"UPDATE `dorder` set `ddown_status`= 1 WHERE `Machine ID`= "<<"'"<<xbx4.mid<<"'";

but when i execute it , its says Unknown column 'ddown_status' in 'field list'

but ddown_status coloumn already exisits in dorder table ,
so any idea whats wrong with update query
thanks

Member Avatar
radhakrishna.p
Posting Whiz in Training
281 posts since Nov 2012
Reputation Points: 29 [?]
Q&As Helped to Solve: 64 [?]
Skill Endorsements: 11 [?]
 
0
 

hai darkc99

please check whether these two columns ddown_status , Machine ID are existed in your database table dorder or not

if not matched replace with exact column names

check it once and let me know the status

Member Avatar
RvSon
Junior Poster in Training
72 posts since Aug 2010
Reputation Points: -3 [?]
Q&As Helped to Solve: 8 [?]
Skill Endorsements: 0 [?]
 
0
 

HI,
Check for Upper/Lower letters and
also Check that you are getting value in Where statement too.

nova37
Deleted Member
 
0
 

ya machine id coloumn also exists and ddown_status too

you can see my another query with machine id works fine
q<<"SELECT * FROM dorder WHERE Machine ID = "<<"'"<<xbx4.mid<<"'";

Member Avatar
radhakrishna.p
Posting Whiz in Training
281 posts since Nov 2012
Reputation Points: 29 [?]
Q&As Helped to Solve: 64 [?]
Skill Endorsements: 11 [?]
 
0
 

hai darkc99,

can you post the table structure and code once here?

so that we will try to help you out in this regard

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article