How to show the grid total or record count based on the data shown in a Grid (taking into account the search parameters)

	Updates

	Documentation

	Support & Training

	Community


		Online Forum

		Newsgroups

How to show the grid total or record count based on the data shown in a Grid (taking into account the search parameters)

Products:
Areas:	ASP

In CodeCharge Studio you can access the WHERE clause associated with a Grid and utilize it to lookup the record count or field total.
To utilize this feature, place a label anywhere on the page, then place the following code in the label's "Before Show" event:

ASP:
  if <form_name>.DataSource.Where = "" then
     [<form_name>.]<label_name>.Value = CCDlookUp("count(*)", "<table_name>", "0=0", DB<connection_name>)
  else
     [<form_name>].<label_name>.Value = CCDlookUp("count(*)", "<table_name>", <form_name>.DataSource.Where, DB<connection_name>)
  end if

PHP:
  global $<form_name>;
  global $DB<connection_name>;
  if ($<form_name>->ds->Where == "")
    [$<form_name>->]<label_name>->SetValue(CCDLookUp("count(*)", "<table_name>", "0=0", $DB<connection_name>));
  else
    [$<form_name>->]<label_name>->SetValue(CCDLookUp("count(*)", "<table_name>", $<form_name>->ds->Where, $DB<connection_name>));

Replace the values between < > with the appropriate form, lable, table and database connection names.
The square brackets around the form name [<form_name>] indicate that this parameter is optional, for example if the label is placed outside of the form.
Instead of the COUNT function, you can also use SUM and other SQL functions.

Viewed 19967 times. Last updated: 11/11/2002 4:32:31 PM