'Assume objconn is declared

dim objRSPD
set objRSPD = server.createobject("ADODB.Recordset")
objRSPD.open "select * from Projectdetails",objConn

dim objRSWT
set objRSWT = server.createobject("ADODB.Recordset")
objRSWT.open "select * from worktype where wtid = " & objRSPD("wtid"),objConn

<table border="1">
<% do while not objRSPD.EOF %>
<tr align="center">
<% Response.write "<td>" & objRSPD("ProjID") & "</td>" %>
<% Response.write "<td>" & objRSWT("wtname") & "</td>" %>
</tr>
<% objRSPD.MoveNext
    objRSWT.close

    objRSWT.open "select * from worktype where wtid = " & objRSPD("wtid"),objConn
'''''This gives error. "Exception occurred"

    loop
%>

Hi,

I think the problem is with the following code:

dim objRSWT
set objRSWT = server.createobject("ADODB.Recordset")
objRSWT.open "select * from worktype where wtid = " & objRSPD("wtid"),objConn

Here, u are not getting values in objRSPD recordset, which is used above.
You need to check for EOF and then execute the above statement.




Om Prakash

Hi,

I have checked values of objRSPD, and that shows the value. Even I am getting values when I showed them in following statement:-
--------
<% Response.write "<td>" & objRSPD("ProjID") & "</td>" %>
--------
The only problem I think is with same recordset opeing again, which I don't know how to achieve.
Please let me know if you have can solve this out.

Hi,

 Try adding the objRSPD.MoveNext statement after opening and closing objRSWT recordset.

something like:

do while not objRSPD.EOF %>
<tr align="center">
<% Response.write "<td>" & objRSPD("ProjID") & "</td>" %>
<% Response.write "<td>" & objRSWT("wtname") & "</td>" %>
</tr>
<% objRSWT.open "select * from worktype where wtid = " & objRSPD("wtid"),objConn
    objRSWT.close
  objRSPD.MoveNext
    loop



Om Prakash

Well, If I move MoveNext stat after openning objRSWT, it will not update the value of ojbRSPD("wtid") which is given in open state of objRSWT and hence it is useless.
-------------
Let me brief you.

objRSPD contains one ID which keeps on changing(as we fire movenext) and hence we will get different values in objRSWT.

Please let me know if you have any idea about it.

Hi Rupen,

In the last iteration of your do loop, objRPSD is going to be at .EOF and you are trying to get a value from it when opening objRSWT. Can't you open objRSWT at the beginning of your loop rather than outside it and at the end, e.g.

That should be fine now. Is that resolved?

_________________________
- Vijay G
Strive for Perfection

Hi Crhis,

Ya it is working as you mention.

Thank You so much!!!!