approach to concat SQL string?

Hi, I need a very basic SQL SELECT with 1 up to 7 fields (f1-f7) to be selected, like (reduced form): SELECT * FROM myTable WHERE f1=s1 AND f2=s2 AND f3=s3 ... AND f7=s7 The user can use only one field or any combination of up to 7 fields for selecting. >From coding point of view the easie

Re: approach to concat SQL string?

--- On Thu, 12/2/10, Tiemo Hollmann TB wrote: > Hi, > > I need a very basic SQL SELECT with 1 up to 7 fields > (f1-f7) to be selected, > like (reduced form): > > SELECT * FROM myTable WHERE > > f1=s1 > > AND f2=s2 > > AND f3=s3 > > ... > > AND f7=s7 > > The user can use only one field or a

AW: approach to concat SQL string?

Hi Jan, thanks for sharing your expertise! Tiemo > > You may want to take a look at the TicketExampleApplication that I used > for my RunRevLive'09 presentations: > > > It contains a helper library for constructing SQL queries from > parameters passed i