% dim sotof, sohvtof, sosyb, soiyb, sohviyb, sohvsyb sohviyb=0 sohvsyb=0 Set cn=Server.CreateObject("ADODB.Connection") cn.open sDSN,"","" 'Tof strSQLtof="Select * from Training" set RcTof=Server.CreateObject("ADODB.Recordset") RcTof.open strSQLtof,cn,1,1 sotof=RcTof.RecordCount RcTof.Close set RcTof=nothing 'Number of Facilitator Tof strSQLtofhv="Select * from Facilitator" set RcTofhv=Server.CreateObject("ADODB.Recordset") RcTofhv.open strSQLtofhv,cn,1,1 sohvtof=RcTofhv.RecordCount RcTofhv.Close set RcTofhv=nothing 'SYB strSQLsyb="Select * from SYB" set RcSYB=Server.CreateObject("ADODB.Recordset") RcSYB.open strSQLsyb,cn,1,1 sosyb=RcSYB.RecordCount Do until(RcSYB.EOF) if (RcSYB("female")<>"") then sohvsyb=sohvsyb+RcSYB("female") end if if (RcSYB("male")<>"") then sohvsyb=sohvsyb+RcSYB("male") end if RcSYB.MoveNext loop RcSYB.Close set RcSYB=nothing 'IYB strSQLiyb="Select * from IYB" set RcIYB=Server.CreateObject("ADODB.Recordset") RcIYB.open strSQLiyb,cn,1,1 soiyb=RcIYB.RecordCount do until (RcIYB.EOF) if (RcIYB("males")<>"") then sohviyb=sohviyb+RcIYB("males") end if if (RcIYB("females")<>"") then sohviyb=sohviyb+RcIYB("females") end if RcIYB.MoveNext Loop RcIYB.Close set RcIYB=nothing cn.Close set cn=nothing %>
|
||||||||||||
|
|
|||||||||||
© Tổ chức Lao động Quốc tế Lời thông cáo | Phản hồi |
||||||||||||