|
Subject:
|
DataShaping with Aggregate
|
|
Posted By:
|
Jon4Paz
|
Post Date:
|
9/15/2006 1:29:56 PM
|
I am using the following datashaping in my asp page just fine until I try to add the Aggregate COUNT function which generates the error below. I want to get a count of the number of Districts withing each Division.
SQL = "SHAPE {Select DivName from tblDiv ORDER BY DivName ASC} APPEND ({Select DistrictName as DS From tblDistrict ORDER BY DistrictName} As rsDS RELATE DvID TO DvID) As rsDV
, COUNT(DS) AS CDS"
dim rsDS
set rsDS = Server.CreateObject("ADODB.Recordset")
rsDS.Open SQL, cn
Error Type:
MSDataShape (0x80040E14)
Aggregate functions require a chapter column. The column (DS) is not a chapter column or does not exist.
My data connection contains:
Provider=MSDataShape; Data Provider=SQLOLEDB
|
|
