例子:
function
GetAuditorInfoBySeqNo(filenostr,strSeqNo)
Dim auditorInfo( 3 )
sqltext = " select auditor from fileaudit where FileNO=' " & filenostr & " ' and seqNo=' " & strSeqNo & " '"
set rs_auditor = conn. Execute (sqltext)
if not rs_auditor.eof then
employeeid = rs_auditor( " auditor " )
sqltext = " select * from employee where id= " & employeeid
set rs_em = conn. Execute (sqltext)
auditorInfo( 1 ) = rs_em( " ID " )
auditorInfo( 2 ) = rs_em( " en_Name " )
auditorInfo( 3 ) = rs_em( " mail " )
end if
GetAuditorInfoBySeqNo = auditorInfo
end function
Dim auditorInfo( 3 )
sqltext = " select auditor from fileaudit where FileNO=' " & filenostr & " ' and seqNo=' " & strSeqNo & " '"
set rs_auditor = conn. Execute (sqltext)
if not rs_auditor.eof then
employeeid = rs_auditor( " auditor " )
sqltext = " select * from employee where id= " & employeeid
set rs_em = conn. Execute (sqltext)
auditorInfo( 1 ) = rs_em( " ID " )
auditorInfo( 2 ) = rs_em( " en_Name " )
auditorInfo( 3 ) = rs_em( " mail " )
end if
GetAuditorInfoBySeqNo = auditorInfo
end function
AuditorInfo
=
GetAuditorInfoBySeqNo(file_No,
2
)
Response.write AuditorInfo( 1 )
Response.write AuditorInfo( 1 )