🚀 go-pugleaf

Here is my clarification.

Consider the following SQL statement:

select * from table1 where name='steven' and age=25

lets say that the user sends back just the name parameter and does not wish
to search using the age parameter... how do I customize the SQL statement to
reflect this?

Essentially I would like to dynamically take one SQL statement and be able
to change it according to the specified parameters sent from a user.  So, I
would like to search using any number of parameters with "and" or "or"
operators in the SQL statement.  How do I set these without having to
hardcode it into the SQL statement within the program?

Thanks!


Steve Kothenbeutel
skothenbeutel@consultant.com


"Steve Kothenbeutel" <skothenbeutel@consultant.com> wrote in message
news:3cffb4e2_2@dnews...
> What happens when I have any number of arguments to pass?  This is my
> problem.  For example... if the user sends 2 arguments back, I want to be
> able to change the SQL... and if the user sends just one argument, then I
> want to be able to change the SQL... see my point?
>
> Thanks for the assitance!
>
> "Clay Shannon" <cshannon@amfam.com> wrote in message
> news:3cff9614$1_1@dnews...
> > Use the Format function, zB:
> >
> > Format('Select %s, %s FROM %s where %s = %s',
> >   [arg1, arg2, arg3, arg4]);
> >
> > "Steve Kothenbeutel" <skothenbeutel@consultant.com> wrote in message
> > news:3cff342f_2@dnews...
> > > Hello,
> > >
> > > I am trying to create dynamic SQL statements that depend on user
input.
> I
> > > am aware of the Parameters property in TADOQuery for example... but I
am
> > > unsure how to use it in the following scenario:
> > >
> > > A user sends a request for information as such:
> > >
> > > select :readfields from table1 where :conditions
> > >
> >
> >
>
>