April 1st, 2002, 05:16 AM
I guess this is a dumb question to ask but am feeling rather dumb today and hope someone can help me out....
I am doing an insert into an oracle database with the info received from another page..
my query reads like this:
SQL2 = "insert into DOC_PRIVILEGES (CODE,doc_code,MADE_BY,COLAB_VERIFY,COLAB_APPROVE,COLAB_VIEW,COLAB_UPDATE) values("+nv.query(DOC_PRIV)+","+tempn1+","+MadeBy[m]+","+Verify[k]+","+Approve[l]+","+View+","+Update[j]+")";
The problem is each of these 5 arrays MADE_BY,COLAB_VERIFY,COLAB_APPROVE,COLAB_VIEW,COLAB_UPDATE
may hv 0 or more values....
so how and where do i execute the query?? as if one loop is zero, the query wont enter into the next loop....
one solution is to validate all the loops but that wud mean immense amt of code...