Summen af to rækker i SQL
Jeg skal have lagt summen af henholdsvis LISTEPRIS & DR_pris sammen som vist her. What to do?!?<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/kundedbsql.asp" -->
<%
Dim DR_pris
Dim DR_pris_numRows
Set DR_pris = Server.CreateObject("ADODB.Recordset")
DR_pris.ActiveConnection = MM_kundedbsql_STRING
DR_pris.Source = "SELECT LISTEPRIS, DR_pris FROM dbo.kundedb2"
DR_pris.CursorType = 0
DR_pris.CursorLocation = 2
DR_pris.LockType = 1
DR_pris.Open()
DR_pris_numRows = 0
%>
<html>
<head>
<title>KundeDatabase</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
LISTEPRIS HER
DR_pris HER
</td>
</tr>
</table>
<a href="java script:history.go(-1)">Tilbage</a> | <a href="default.asp">Forsiden</a>
</body>
</html>
<%
DR_pris.Close()
Set DR_pris = Nothing
%>
