• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Adding parameter on select statement

 
Greenhorn
Posts: 19
Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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,
 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 19
Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 19
Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 19
Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey buddy thank you for your help I got the idea and it is working ok now.
 
Bartender
Posts: 2658
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:

 
CAUTION! Do not touch the blades on your neck propeller while they are active. Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic