• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Adding parameter on select statement

 
Caleb Jhay
Greenhorn
Posts: 18
Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys I just want to ask how can i put my parameter to my quere please see the code below





Best Regards,
 
anirudh jagithyala
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can also try the concept of prepared statement



i am not clear with the question, might be this would help....
 
Caleb Jhay
Greenhorn
Posts: 18
Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
anirudh jagithyala wrote:you can also try the concept of prepared statement



i am not clear with the question, might be this would help....


Thank you for your quick reply but im getting error with the parenthesis. Kinda new with this stuff

Regards
 
anirudh jagithyala
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hey Caleb,
where are you getting the errors.... Isit for your code or the code which i gave
Did you try the code with prepared statement..

please ellaborate
 
Caleb Jhay
Greenhorn
Posts: 18
Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
anirudh jagithyala wrote:hey Caleb,
where are you getting the errors.... Isit for your code or the code which i gave
Did you try the code with prepared statement..

please ellaborate


I tried your code but the problem is java is asking me to put another parenthesis at the end of the PreparedStatement (see the bold parenthesis below.) Java is telling me that i need to put another one of that at the end



Thanks again
 
Caleb Jhay
Greenhorn
Posts: 18
Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey buddy thank you for your help I got the idea and it is working ok now.
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Caleb Jhay wrote:
anirudh jagithyala wrote:hey Caleb,
where are you getting the errors.... Isit for your code or the code which i gave
Did you try the code with prepared statement..

please ellaborate


I tried your code but the problem is java is asking me to put another parenthesis at the end of the PreparedStatement (see the bold parenthesis below.) Java is telling me that i need to put another one of that at the end



Thanks again


Don't wrap quotes around a parameter:

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic