home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2002 April
/
Chip_2002-04_cd1.bin
/
chplus
/
asp
/
dil3_ASP2.txt
< prev
next >
Wrap
Text File
|
1999-04-10
|
952b
|
45 lines
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual InterDev 1.0">
<META HTTP-EQUIV="Content-Type" content="text/html; charset=windows-1250">
<TITLE>P°ehled zam∞stnanc∙ firmy</TITLE>
</HEAD>
<BODY>
<H3>P°ehled zam∞stnanc∙ firmy podle v∞ku (vzestupn∞)</H3>
<TABLE BORDER=1 CELLPADDING=5 CELLSPACING=0>
<%
' *** otev°e spojenφ do databßze ***
Set DC = Server.CreateObject("ADODB.Connection")
DC.Open Session("firma_ConnectionString")
' *** definice databßzovΘho dotazu ***
SQL = "select * from ZAMESTNANCI order by VEK"
' *** provede dotaz ***
Set Q = DC.Execute(SQL)
Do While Not Q.EOF
%>
<TR>
<TD><% = Q("ID") %></TD>
<TD><% = Q("JMENO") %></TD>
<TD><% = Q("PRIJMENI") %></TD>
<TD><% = Q("POHLAVI") %></TD>
<TD><% = Q("VEK") %></TD>
</TR>
<%
Q.MoveNext
Loop
Set Q = Nothing
' *** uzav°e spojenφ do databßze ***
DC.Close
Set DC = Nothing
%>
</TABLE>
<BR>
Konec v²pisu.
</BODY>
</HTML>