Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sql statement

 
shumani edzani
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All..

I have been struggling with this code for 3 hours now,can you please help.this code is hard coded and i need to unhard code it,so here is the code please help.

select staticdata.descr as deptname,appraisal.state as appraisalPhase,appraisal.lastupdated,appraisal.scoreunitid
from appraisal
left JOIN hruser on hruser.userid = appraisal.appraisee
LEFT JOIN staticdata on staticdata.id = hruser.deptname
where appraisal.lastupdated > "1999/01/01"
AND appraisal.lastupdated < "2009/01/01"
and appraisal.state in ("SUBMITTED", "CREATED_INCOMPLETE", "UPDATED_UNCONFIRMED", "COMPLETE_UNCONFIRMED"
, "DEV_PLAN_SET")
AND staticdata.id in ("1179991863437762177185","123539977081431915490412353998213101873543512353999380021949703600")
group by hruser.deptname

Thank you.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "un-hardcode" it? What are you trying to do with this query?
 
denis sorn
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I presume he wants to be able to change parameters dynamically...

If this is what you want Shumani you can do it with PreparedStatement.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic