ERROR:
Error Diagnostic Information
An error occurred while evaluating the expression:
#ResultsManager.ContestantID#
Error near line 9, column 169.
This is telling you that it can't find the variable, not that it's the wrong
type...
Just on a side point;
> <cfquery name="GetTotalPts" datasource="#datasource#"
> dbtype="ODBC" username="#username#" password="#password#">
> SELECT ResultsManager.ContestantID, ContestantManager.FirstName,
> ContestantManager.LastName, ContestantManager.City,
> ContestantManager.State, SUM (ResultsManager.AdjPoints) as TOTALPTS
> FROM ResultsManager INNER JOIN ContestantManager ON
> ResultsManager.ContestantID =
> ListGetAt(ContestantManager.ContestantID, <<<<
> "ListFind(ContestantManager.ContestantID, <<<<
> "#ResultsManager.ContestantID#")") <<<<
> WHERE ContestantManager.Gender = '2' AND ResultsManager.NotAllAround = '0'
> GROUP BY ResultsManager.ContestantID,
> ContestantManager.FirstName, ContestantManager.LastName,
> ContestantManager.City, ContestantManager.State
> ORDER BY SUM (AdjPoints) DESC
> </cfquery>
The lines I've hilighted seem to be missing #s - unless your database has
the function ListGetAt and ListFind...
Also, that'll return a number - you can't join tables like that - they need
to be joined by fields
If I was you, I'd get rid of the denormalised data and normalise it -
instead of making a comma separate list, make a lookup table...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
