quote:Originally posted by method
quote:Originally posted by shankhan
Thank u for u reply. how i can do the same for dirrent value passed to this page. What i mean for each diffrent value passed to this page it runs similer block of code but for diffrent tables. I mean kind of if statments. I be happy if u show me some code. thanks
let me tell u bit details of above queries. execute 2 quries using 2 different record set.
strSQL1 = "SELECT emp_no, e_name from table1"
strSQL2 = "SELECT dept_no, d_name from table2"
set rs_table1 = con.execute(strSQL1)
set rs_table2 = conn.execute(strSQL2)
'now you can display the output of both queries by calling their record set. like
' these r index number of those record sets. u also can call values by using column name
i hope u can find some help from this example.
if rs_table1(emp_no) = 1 then
e_no = "one"
elseif rs_table1(emp_no) = 2 then
e_no = "two"
e_no = "none"
i hope this is the answer of ur question.