JDBC - Constructing a query realtime

From: Mohammad S Khan (mskhanis_at_hotmail.com)
Date: 10/31/03 

Date: 31 Oct 2003 04:03:57 -0800

What is the best way of constructing a query realtime . I am thinking
along the lines of a screen with multiple combo boxes and text fields
that provide the user with options to select. After he is is done with
the selection a search query that would effectively span multiple
tables in the database to show the results.

I am having problems with 1) Efficient way of constructing the query ?
2) how to decide which columns to display in the result

i am using mySQL as the db ...any help appreciated .. thanks

Relevant Pages

  • Re: Multiple Many-to-Many relationships
    ... You need to update through forms, not a query. ... display a single record from the Article table. ... needs to be able to accommodate multiple authors, ... (Newspaper, Magazine, Blog, etc.) ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL query help
    ... the multiple where criterion. ... I downloaded a query onto a table for a test ... numeric datatypes in Access do not have precision and scale the way ...
    (microsoft.public.access.queries)
  • RE: Loops
    ... table with multiple columns 5 for each pay period, ... I run my query for the pay period ending on 01/05/07 ... you are updating multiple tables. ...
    (microsoft.public.access.modulesdaovba)
  • Re: issue with runing Select query with condition using code
    ... You can then apply it as the Filter of a form, or the WhereCondition of OpenReport, or build the whole SQL string and apply it to the SQL property of a QueryDef. ... Splitmight be useful for parsing multiple elements in a text box into an array. ... Be sure to use the correct delimiter around the values, i.e. " for strings, # for dates, and no delimiter for numeric values. ... I'm trying to use the DoCmd.open query statement to run a Select query. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Trying to build a database driven website
    ... content blocks in multiple pages and one or more of those links has changed. ... You would have to query all html fragments ... With a files based system I use recursive perl search and replace, ... No database experience? ...
    (comp.lang.php)