07-24-2023, 10:06 AM
So i am working on a project where i get list of ID's and i have to execute 10 different queries for each id. Now the catch is that, we have a code written to manage it for one ID.
its like:
DBConnect accDB1,sql1,A
DBConnect accDB1,sql2,B
DBConnect accDB1,sql3,C
DBConnect accDB1,sql4,D
DBConnect accDB1,sql5,E
Now for N number of Id's I need some thing like
for(i=0;i<N;i++)
{
DBConnect accDB1,sql1,A //A0 for i=0, A1 for i=1....
DBConnect accDB1,sql2,B
DBConnect accDB1,sql3,C
DBConnect accDB1,sql4,D
DBConnect accDB1,sql5,E
}
Since first we are executing all queries for all ID's and then displaying every thing, i cant display it in loop.
What would be approach to solve this problem.
its like:
DBConnect accDB1,sql1,A
DBConnect accDB1,sql2,B
DBConnect accDB1,sql3,C
DBConnect accDB1,sql4,D
DBConnect accDB1,sql5,E
Now for N number of Id's I need some thing like
for(i=0;i<N;i++)
{
DBConnect accDB1,sql1,A //A0 for i=0, A1 for i=1....
DBConnect accDB1,sql2,B
DBConnect accDB1,sql3,C
DBConnect accDB1,sql4,D
DBConnect accDB1,sql5,E
}
Since first we are executing all queries for all ID's and then displaying every thing, i cant display it in loop.
What would be approach to solve this problem.