This is a multi-part message in MIME format.
------=_NextPart_000_002F_01BFC40C.895D2DA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Miriam:
If it's numerical, you can do:
<cfquery name=3D"myquery" datasource=3D"yourdsn">
select sum(myfield) as sum_myfield
</cfquery>
and that will add them up for you.
Or, if you simply need the total items selected, you can use=20
#myquery.recordcount#.=20
Didn't know which ya needed. : )
Is there a way in CF that you can add the summ of all the results in a
certain query?
Thanks,
---miriam
-------------------------------------------------------------------------=
-----
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body=3Dsts/cf_talk =
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
----------
------=_NextPart_000_002F_01BFC40C.895D2DA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>Miriam:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2>If it's numerical, you can =
do:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2><cfquery name=3D"myquery"=20
datasource=3D"yourdsn"></FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>select sum(myfield) as =
sum_myfield</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></cfquery></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2>and that will add them up for =
you.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Or, if you simply need the total =
items selected,=20
you can use </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>#myquery.recordcount#. </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Didn't know which ya needed. : =
)</FONT></DIV>
<DIV> </DIV>
<DIV>Is there a way in CF that you can add the summ of all the results =
in=20
a<BR>certain=20
query?<BR><BR>Thanks,<BR><BR>---miriam<BR><BR>---------------------------=
---------------------------------------------------<BR>Archives:=20
<A=20
href=3D"http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/=
cf-talk</A><BR>To=20
Unsubscribe visit <A=20
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body=3Ds=
ts/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body=
=3Dsts/cf_talk</A>=20
or send a message to <A=20
href=3D"mailto:[EMAIL PROTECTED]">cf-talk-request@houseof=
fusion.com</A>=20
with 'unsubscribe' in the body.<BR>----------<BR></DIV></BODY></HTML>
------=_NextPart_000_002F_01BFC40C.895D2DA0--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
