Re: OTP-Dynamically building an SQL Query from ActionForm inputs

2003-07-21 Thread Curtney Jacobs
Thanks David. I understand. _CJ On Sunday 20 July 2003 01:03 pm, David Graham wrote: > --- Curtney Jacobs <[EMAIL PROTECTED]> wrote: > > Greetings David. > > > > I understood everything up to the point where I have to read in a > > properties > > file. If it is not to much of a problem., can you

Re: OTP-Dynamically building an SQL Query from ActionForm inputs

2003-07-20 Thread David Graham
--- Curtney Jacobs <[EMAIL PROTECTED]> wrote: > Greetings David. > > I understood everything up to the point where I have to read in a > properties > file. If it is not to much of a problem., can you please elaborate from > that > point downwards. Regardless of whether or not you store SQL in a

Re: OTP-Dynamically building an SQL Query from ActionForm inputs

2003-07-19 Thread Curtney Jacobs
Greetings David. I understood everything up to the point where I have to read in a properties file. If it is not to much of a problem., can you please elaborate from that point downwards. I thought that once I have the criteria I would just build the SQL query. However, your approach appears t

Re: OTP-Dynamically building an SQL Query from ActionForm inputs

2003-07-19 Thread David Graham
Name all of your search fields using this pattern: criteria(name). For example, Now use a Map backed form attribute called criteria in your form bean with a method like this: public void setCriteria(Map criteria) { this.criteria=criteria; } When the form is submitted you'll now have each c

OTP-Dynamically building an SQL Query from ActionForm inputs

2003-07-18 Thread Curtney Jacobs
Hi everyone, I know this is of the topic but I am hoping that someone has came accross this and wouldn't mine shareing with me how they eloquently solve this problem. I have an ActionForm (and corresponding Action class) that takes input from the user and does a search depending on the inputed