Results 1 to 4 of 4
  1. #1
    saran87 is offline Member
    Join Date
    Jul 2009
    Location
    india
    Posts
    9
    Rep Power
    0

    Default how to populate text box value in between sql query

    this is my query..

    query="SELECT Invoiceno, InvoiceDate, TotalAmount FROM tblInvoice WHERE InvoiceDate BETWEEN AND )";
    Thanks In Advance......

  2. #2
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    10

    Default

    By text box do you mean HTML input box or JTextfield?
    Either way read about PreparedStatement to see how to pass parameters to it.

  3. #3
    saran87 is offline Member
    Join Date
    Jul 2009
    Location
    india
    Posts
    9
    Rep Power
    0

    Default

    yes it is a html text box only....

  4. #4
    RamyaSivakanth's Avatar
    RamyaSivakanth is offline Senior Member
    Join Date
    Apr 2009
    Location
    Chennai
    Posts
    877
    Rep Power
    8

    Default

    u tell the requirement clearly.

    for getting inputs from html and do some db operations u should have some serverside code such as jsp/servlet.
    Ramya:cool:

Similar Threads

  1. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 2
    Last Post: 01-06-2014, 11:09 AM
  2. populate jtable from jtextboxes and jcombo
    By purejoker in forum AWT / Swing
    Replies: 4
    Last Post: 12-02-2010, 10:29 AM
  3. Help Pls!! Jcombobox populate with mysql
    By kwink in forum AWT / Swing
    Replies: 1
    Last Post: 03-23-2009, 05:11 AM
  4. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 0
    Last Post: 01-19-2009, 05:30 PM
  5. how to populate data in drop-down box
    By ma-la in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 11-01-2008, 12:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •