Roger
|
| Posted: 07/16/2001, 12:24 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0084_01C10E6F.C4E3B2A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have managed to create a SQL to COUNT total records in a table.
select count(*) as total from registration
How to I do one for only found records?
Can anyone give me some pointers?
--=20
Rgds
Roger Tng
------=_NextPart_000_0084_01C10E6F.C4E3B2A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2>I have managed to create a SQL to COUNT total =
records in=20
a table.</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2>select count(*) as total from=20
registration</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>How to I do one for only found records?</FONT></DIV>
<DIV><FONT size=3D2>Can anyone give me some pointers?</FONT></DIV>
<DIV><BR><FONT size=3D2>-- <BR><BR>Rgds<BR>Roger=20
Tng<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0084_01C10E6F.C4E3B2A0--
|
|
|
 |
Walker P.
|
| Posted: 07/16/2001, 4:47 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0210_01C10E27.82385D90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Refer to the shoppingcart page (Total Form) of the bookstore example. It =
has a custom SQL statement with an agregate function. The concept is the =
same with the count function.
Walker P.
CC Support
------=_NextPart_000_0210_01C10E27.82385D90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Refer to the shoppingcart page (Total =
Form) of=20
the bookstore example. It has a custom SQL statement with an agregate =
function.=20
The concept is the same with the count function.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Walker P.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>CC Support</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0210_01C10E27.82385D90--
|
|
|
|
Paul Groenendaal
|
| Posted: 07/17/2001, 1:41 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0015_01C10EAC.CE453390
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
what does Count SQL means in the same form?>
"Walker P." <walkerp@codecharge.com> wrote in message =
news:9ivudu$c8g$1@news.codecharge.com...
Refer to the shoppingcart page (Total Form) of the bookstore example. =
It has a custom SQL statement with an agregate function. The concept is =
the same with the count function.
Walker P.
CC Support
------=_NextPart_000_0015_01C10EAC.CE453390
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2512.1" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>what does Count SQL means in the same=20
form?></FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Walker P." <<A=20
href=3D"mailto:walkerp@codecharge.com">walkerp@codecharge.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:9ivudu$c8g$1@news.codecharge.com">news:9ivudu$c8g$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Refer to the shoppingcart page (Total =
Form) of the bookstore example. It has a custom SQL statement =
with an=20
agregate function. The concept is the same with the count=20
function.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Walker P.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>CC Support</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0015_01C10EAC.CE453390--
|
|
|
|
