Member Avatar for 2eXtreme

Hey guys,

say im doing a query like:

select * from info where date = '21-APR-08'

but i want to do it for a number of different dates, how can i create an array to hold teh dates, and then for each date in the array, execute the query?

like say my array holds '21-APR-08, 28-APR-08, 05-MAY-08'

can i do a query like select * from info where date = <array value x>

where array value x is the array index, which increments upon each execution of the query? so it'd be the equivalent of doing:

select * from info where date = '21-APR-08'
select * from info where date = '28-APR-08'
select * from info where date = '05-MAY-08'

Thanks for any help

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

try to use this

select * from info where date in (date1,date2,date3,.................)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.