Så:
http://www.hybenvang.dk/SpecialeLogbog/66666.aspHer er koden:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Anvendelse</title>
</head>
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="dbconnect.asp" -->
<%
soeg = Request.QueryString("soeg")
If soeg = "" Then
soegestreng = "'%'"
Else
soegestreng = "'%" & soeg & "%'"
End If
Set list = Server.CreateObject ("ADODB.Recordset")
list.Open "SELECT [08Pilot].Pilot, [24KalibreringsKomponent].KalibreringskomponentPris AS Pris FROM 24KalibreringsKomponent INNER JOIN (08Pilot INNER JOIN (00Apparat INNER JOIN 26Log ON [00Apparat].ID_Apparat = [26Log].ID_Apparat) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot) ON [24KalibreringsKomponent].ID_Kalibreringskomponent = [26Log].ID_Kalibreringskomponent UNION ALL SELECT [08Pilot].Pilot, [12Forsyningsmedie].ForsyningsmediePris FROM 12Forsyningsmedie INNER JOIN (08Pilot INNER JOIN (00Apparat INNER JOIN 26Log ON [00Apparat].ID_Apparat = [26Log].ID_Apparat) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot) ON [12Forsyningsmedie].ID_Forsyningsmedie = [26Log].ID_Forsyningsmedie UNION ALL SELECT [08Pilot].Pilot, [15Reservedel].ReservedelPris FROM 08Pilot INNER JOIN ((04Model INNER JOIN 00Apparat ON [04Model].ID_Model = [00Apparat].ID_Model) INNER JOIN 15Reservedel ON [04Model].ID_Model = [15Reservedel].ID_Model) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot WHERE ((([08Pilot].Pilot) LIKE " & soegestreng & " )) ", Conn
Set sum = Server.CreateObject ("ADODB.Recordset")
sum.Open "SELECT 'Ialt:' AS pilot, SUM(pris) as samletpris FROM (SELECT [08Pilot].Pilot, [24KalibreringsKomponent].KalibreringskomponentPris AS Pris FROM 24KalibreringsKomponent INNER JOIN (08Pilot INNER JOIN (00Apparat INNER JOIN 26Log ON [00Apparat].ID_Apparat = [26Log].ID_Apparat) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot) ON [24KalibreringsKomponent].ID_Kalibreringskomponent = [26Log].ID_Kalibreringskomponent UNION ALL SELECT [08Pilot].Pilot, [12Forsyningsmedie].ForsyningsmediePris FROM 12Forsyningsmedie INNER JOIN (08Pilot INNER JOIN (00Apparat INNER JOIN 26Log ON [00Apparat].ID_Apparat = [26Log].ID_Apparat) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot) ON [12Forsyningsmedie].ID_Forsyningsmedie = [26Log].ID_Forsyningsmedie UNION ALL SELECT [08Pilot].Pilot, [15Reservedel].ReservedelPris FROM 08Pilot INNER JOIN ((04Model INNER JOIN 00Apparat ON [04Model].ID_Model = [00Apparat].ID_Model) INNER JOIN 15Reservedel ON [04Model].ID_Model = [15Reservedel].ID_Model) ON [08Pilot].ID_Pilot = [00Apparat].ID_Pilot WHERE ((([08Pilot].Pilot) LIKE " & soegestreng & " ))) as temp", Conn
samletpris = sum.fields("samletpris")
%>
<html>
<head>
<title>Anvendelse</title>
</head>
<body bgcolor="#FFFFCC">
<tr><td bgcolor="#999999">
<div align="center"> </div>
<div align="center"> </div>
<div align="center"><b><font face="Times New Roman" size="5">Søgning</font></b></div>
</td></tr>
<tr><td bgcolor="#CCCCCC">
<form method="GET" action="66666.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
<p align="left">
<font face="Times New Roman">- hvad har det kostet sammenlagt pr. pilot, at lave
analyser ?</font></p>
<p>
<b><font face="Times New Roman"><br>
Pilot:</font></b><br>
<font face="Arial" size="2">
<!--webbot bot="Validation" s-display-name=" " s-data-type="String" b-allow-letters="TRUE" s-allow-other-chars="? &" --><input type="text" name="soeg" value="<% = soeg%>" size="20">
<input type="submit" name="Submit" value="Søg"></font></td>
</p>
</form>
<table style="border-left-color: #000000; border-top-color: #000000" cellspacing="0" bordercolorlight="#000000" bordercolordark="#000000" border="1" cellpadding="0">
<tr>
<th width="1300" valign="top" colspan="2" bgcolor="#CCFFCC">
<p align="left">
<b>Søgeordet <font color="#CC0000"><% = soeg%></font> giver <font color="#CC0000">
</b></th>
</tr>
<tr>
<td valign="top" bgcolor="#C0C0C0" align="center"><b><font size="2">Pilot</font></b></td>
<td valign="top" bgcolor="#C0C0C0" align="center"><b><font size="2">SamletPris</font></b></td>
</tr>
<tr>
<td valign="top" bgcolor="#C0C0C0" align="center"><font size="2"></b> </td>
<td valign="top" bgcolor="#C0C0C0" align="center"><font size="2"><font color="#CC0000"><% = samletpris%></font> kr.</td>
</tr>
<%
While NOT list.EOF
%>
<td valign="top"><font size="2"><% = list.Fields("Pilot")%> </font></td>
<td valign="top"><font size="2"><% = list.Fields("Pris")%> </font></td>
</tr>
<%
list.MoveNext
Wend
%>
<tr>
<th width="1300" valign="top" colspan="2" bgcolor="#CCFFCC">
<p align="right">
</th>
</tr>
</table>
</form>
</font>
<p align="center"> </p>
</b>
</body>
</html>
<%
list.close
set list = nothing
%>