aah okie I think I was trying to get too clever. Guess that won't work ...
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert <bboisv...@gmail.com>wrote:
> You'll have to iterate over your two lists of timestamps and build a
> set of ORed conditional pairs:
>
> sql = "select ... from ... where 1 = 0"
> for (i = 0; i < timestamps.length; i++) {
> sql += " or start <=" + timestamps[i] + " and end >= " + timestamps[i]
> }
>
> You'll want to use bind parameters in real life, of course.
>
> cheers,
> barneyb
>
> On Fri, May 8, 2009 at 9:26 AM, Abhishek Pratap <abhishek....@gmail.com>
> wrote:
> > Hi All
> >
> > I am kind of stuck with this query , cant expand my thinking. May this
> is a
> > limitation. Here it is
> >
> > I have a database with many cols two of which are start and end position
> for
> > an event.
> >
> > Now I have a list of event time stamps, I want to find all the info once
> the
> > current event time stamp is >= start time of event and <=end time of
> event.
> >
> > something like this
> >
> > select * from table_name where start <= ( LIST of time stamps) AND end
> >=(
> > list of time stamps).
> >
> > Clearly above query accepts only one item in the list. Is there a way to
> do
> > this for multiple items in the list ??? I can't think of anything at this
> > moment.
> >
> >
> > Thanks,
> > -Abhi
> >
>
>
>
> --
> Barney Boisvert
> bboisv...@gmail.com
> http://www.barneyb.com/
>
