nicht angemeldet
Sodale,
hier die 2 Dateien die ich geschrieben hab, der DOCTYPOE ist hier
schon rausgenommen:
Die HTML-Datei:
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=ISO-8859-1" />
<title>
Personen suchen
</title>
<script type="text/vbscript">
<!-- #include file="connectDB.asp" -->
</script>
<link rel="stylesheet" type="text/css" href="../style/global.css" />
</head>
<body>
<%
'*********************
'* Suchen
'*********************
Dim searchItemString
Dim sqlString
searchItemString = Request.Form("searchPerson")
sqlString = "SELECT AnredeID, TitelID, Vorname, Nachname, MitarbeiterID " _
& "FROM tab_base_Mitarbeiter " _
& "WHERE ((Nachname LIKE '%" & searchItemString & "%')" _
& " OR (Vorname LIKE '%" & searchItemString & "%'));"
sqlString = "SELECT tab_base_Mitarbeiter.Mitarbeiter_ID, tab_base_Mitarbeiter.Einstellung, tab_base_Person.* " _
& "FROM tab_base_Mitarbeiter INNER JOIN tab_base_Person ON tab_base_Mitarbeiter.Person_ID = tab_base_Person.Person_ID " _
& "WHERE tab_base_Person.Nachname_FirmenName LIKE '%" & searchItemString & "%' " _
& " OR tab_base_Person.Vorname_Firmenzusatz LIKE '%" & searchItemString & "%';"
conn.Open connString
'SQL-Select ausführen und Ergebnis in Recordset speichern
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sqlString, conn, 3, 3
'Recordset auslesen
%>
<h1>
Suchergebnisse zu "<%=searchItemString%>"
</h1>
<hr />
<%
Do While Not rs.EOF
%>
<div class="divPanel">
<div class="LabelRow">
<div>
Anrede, Titel:
</div>
<div>
Vorname:
</div>
<div>
Nachname:
</div>
</div>
<div class="ResultRowSmall">
<div class="ResultSmallInline">
<%=rs.Fields("Anrede_ID").Value%>
</div>
<div class="ResultSmallInline">
<%=rs.Fields("Titel_ID").Value%>
</div>
<div class="ResultMedium">
<%=rs.Fields("Vorname_Firmenzusatz").Value%>
</div>
<div class="ResultMedium">
<%=rs.Fields("Nachname_Firmenname").Value%>
</div>
</div>
<div class="LabelRow">
<div>
</div>
<div>
</div>
<div>
Geburtstag:
</div>
</div>
<div class="ResultRowSmall">
<div>
</div>
<div>
</div>
<div class="ResultSmall">
<%=rs.Fields("Geburtstag").Value%>
</div>
</div>
</div>
<%
rs.MoveNext
Loop
'Ressourcen freigeben
rs.close
conn.close
%>
</body>
</html>
und die zugehörige CSS-Datei, nur relevante Teile
/*
*********************************
* Datenanzeigestyle *
* Verwendet für folgende Seiten *
* - 01-A-00.asp *
* - 01-B-00.asp *
*********************************
*/
.divPanel
{
font-family: arial;
font-size: 10pt;
width: 55em;
background-color: #E0E0E0;
border: 0;
border-top-width: 0.2em;
border-color: #FF0000;
border-style: solid;
margin: 0.5em;
margin-bottom: 1em;
padding: 0.3em;
}
.divPanelSmall
{
font-family: arial;
font-size: 10pt;
width: 47em;
background-color: #E0E0E0;
border: 0;
border-top-width: 0.2em;
border-color: #FF0000;
border-style: solid;
margin: 0.5em;
margin-bottom: 1em;
padding: 0.3em;
}
.divPanel h4
{
font-family: arial;
font-size: 12pt;
font-weight: bold;
margin: 0;
}
.divPanelSmall h4, .divPanelSmall form
{
font-family: arial;
font-size: 12pt;
font-weight: bold;
margin: 0;
}
.LabelRow
{
font-family: arial;
font-size: 10pt;
font-weight: bold;
display: inline;
width: 10em;
margin: 0;
padding: 0;
}
.LabelRow div
{
font-family: arial;
font-size: 10pt;
width: 12em;
height: 1.9em;
margin: 0.05em;
padding: 0;
font-weight: bold;
border-width: 0.1em;
border-style: solid;
border-color: #E0E0E0;
}
.ResultRow
{
font-family: arial;
font-size: 10pt;
display: inline;
width: 21em;
margin: 0;
padding: 0;
}
.ResultRowSmall
{
font-family: arial;
font-size: 10pt;
display: inline;
width: 15em;
margin: 0;
padding: 0;
}
.Result
{
font-family: arial;
font-size: 10pt;
display: inline;
width: 17.55em;
height: 1.9em;
margin: 0.05em;
padding: 0;
padding-left: 0.3em;
background-color: #EFEFEF;
border-width: 0.1em;
border-color: #808080;
border-style: solid;
}
.ResultMedium
{
font-family: arial;
font-size: 10pt;
display: inline;
width: 11.4em;
height: 1.9em;
margin: 0.05em;
padding: 0;
padding-left: 0.3em;
background-color: #EFEFEF;
border-width: 0.1em;
border-color: #808080;
border-style: solid;
}
.ResultSmall
{
font-family: arial;
font-size: 10pt;
width: 5.6em;
height: 1.9em;
margin: 0.05em;
padding: 0;
padding-left: 0.3em;
background-color: #EFEFEF;
border: 0.1em;
border-color: #808080;
border-style: solid;
}
.ResultSmallInline
{
font-family: arial;
font-size: 10pt;
width: 5.6em;
height: 1.9em;
display: inline;
margin: 0.05em;
padding: 0;
padding-left: 0.3em;
background-color: #EFEFEF;
border: 0.1em;
border-color: #808080;
border-style: solid;
}
.Result input, .ResultInline input, .ResultMedium input, .ResultSmall input, .ResultSmallInline input,
{
font-family: arial;
font-size: 10pt;
display: inline;
margin: 0;
padding: 0;
background-color: #EFEFEF;
border-width: 0;
border-color: #EFEFEF;
border-style: solid;
}
.ButtonRight
{
font-family: arial;
font-size: 10pt;
float: right;
width: 4em;
height: 1.9em;
margin: 0;
padding: 0;
border-width: 0;
border-style: solid;
border-color: #EFEFEF;
}
.ButtonRightSmall
{
font-family: arial;
font-size: 10pt;
float: right;
width: 2em;
height: 1.9em;
margin: 0;
padding: 0;
border-width: 0;
border-style: solid;
border-color: #EFEFEF;
}
mfg Benny