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
    8

    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
    835
    Rep Power
    6

    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, 10:09 AM
  2. populate jtable from jtextboxes and jcombo
    By purejoker in forum AWT / Swing
    Replies: 4
    Last Post: 12-02-2010, 09:29 AM
  3. Help Pls!! Jcombobox populate with mysql
    By kwink in forum AWT / Swing
    Replies: 1
    Last Post: 03-23-2009, 04:11 AM
  4. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 0
    Last Post: 01-19-2009, 04: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, 11:24 AM

Posting Permissions

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