|
-
Total Entire LinePrice Column
Here is my code. I tried looking though the examples. Could not get it to work. What is the exact line of code needed to display a total of the LinePrice column.
<% response.buffer=true %>
<!--ASP-db-->
<HTML>
<HEAD><title>Test Page</title></HEAD>
<%
Set MyDb = Server.CreateObject("Asp.DB"
MyDb.dbUnit = 123
MyDb.dbDSN = "SQL"
MyDb.dbStartup = "filter"
MydB.dbSQL="SELECT XrefOrderNum,LinePrice FROM dbo.Promis_Data"
MyDb.dbColor = "4,auto,white"
MyDb.dbGridtabletag = "border=1 cellspacing=2 cellpadding=1"
MyDb.dbMode = "Grid"
MyDb.dbOptions = "HeaderFontTag=Size=3,CellFontTag=Face=Aria l Size=2"
MyDb.dbGridInc= "10"
MyDb.dbImageDir= "images/"
Mydb.dbNavigationItem= "top, bottom, next, prev, filter, download"
Mydb.dbNavigationIcon= "std"
MyDb.ASPdb
RECS = MyDb.dbRecordCount
%>
<% if RECS < 1 then %>
<BR><FONT SIZE=5 COLOR=BLACK><B>
Sorry, no records were found!<BR>
Please click on the "Back" button and try again.<BR></B></FONT>
<% end if %>
</BODY>
</HTML>
-
Total Entire LinePrice Column (reply)
I do column totals all the time. there is a good exmaple of this at:
http://www.mmstools.com/EP/V2_agg1.asp
Hope that helps you :-)
Donna
------------
Kenny at 4/11/01 9:58:43 PM
Here is my code. I tried looking though the examples. Could not get it to work. What is the exact line of code needed to display a total of the LinePrice column.
<% response.buffer=true %>
<!--ASP-db-->
<HTML>
<HEAD><title>Test Page</title></HEAD>
<%
Set MyDb = Server.CreateObject("Asp.DB"
MyDb.dbUnit = 123
MyDb.dbDSN = "SQL"
MyDb.dbStartup = "filter"
MydB.dbSQL="SELECT XrefOrderNum,LinePrice FROM dbo.Promis_Data"
MyDb.dbColor = "4,auto,white"
MyDb.dbGridtabletag = "border=1 cellspacing=2 cellpadding=1"
MyDb.dbMode = "Grid"
MyDb.dbOptions = "HeaderFontTag=Size=3,CellFontTag=Face=Aria l Size=2"
MyDb.dbGridInc= "10"
MyDb.dbImageDir= "images/"
Mydb.dbNavigationItem= "top, bottom, next, prev, filter, download"
Mydb.dbNavigationIcon= "std"
MyDb.ASPdb
RECS = MyDb.dbRecordCount
%>
<% if RECS < 1 then %>
<BR><FONT SIZE=5 COLOR=BLACK><B>
Sorry, no records were found!<BR>
Please click on the "Back" button and try again.<BR></B></FONT>
<% end if %>
</BODY>
</HTML>
-
Total Entire LinePrice Column (reply)
Hey Kenny,
I have a radical idea. I know it goes against the dot com concept, but you know-nothings are going down the tubes anyway.
LEARN YOUR JOB BEFORE YOU CHARGE SOMEBODY TO DO IT!!
------------
Kenny at 4/11/01 9:58:43 PM
Here is my code. I tried looking though the examples. Could not get it to work. What is the exact line of code needed to display a total of the LinePrice column.
<% response.buffer=true %>
<!--ASP-db-->
<HTML>
<HEAD><title>Test Page</title></HEAD>
<%
Set MyDb = Server.CreateObject("Asp.DB"
MyDb.dbUnit = 123
MyDb.dbDSN = "SQL"
MyDb.dbStartup = "filter"
MydB.dbSQL="SELECT XrefOrderNum,LinePrice FROM dbo.Promis_Data"
MyDb.dbColor = "4,auto,white"
MyDb.dbGridtabletag = "border=1 cellspacing=2 cellpadding=1"
MyDb.dbMode = "Grid"
MyDb.dbOptions = "HeaderFontTag=Size=3,CellFontTag=Face=Aria l Size=2"
MyDb.dbGridInc= "10"
MyDb.dbImageDir= "images/"
Mydb.dbNavigationItem= "top, bottom, next, prev, filter, download"
Mydb.dbNavigationIcon= "std"
MyDb.ASPdb
RECS = MyDb.dbRecordCount
%>
<% if RECS < 1 then %>
<BR><FONT SIZE=5 COLOR=BLACK><B>
Sorry, no records were found!<BR>
Please click on the "Back" button and try again.<BR></B></FONT>
<% end if %>
</BODY>
</HTML>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote