by the way are the same jay patton that writes stuff for webmonkey.com ???
-----Original Message-----
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 17:53
To: CF-Talk
Subject: !!!Statement Question.!!!
This list has been good to me so far so i thought i would ask another
question.
Could anyone help me with this? ive been going over and over it for a while
now and cant seem to get it figured out. what i have is a ResultsManager and
in that i have a ContestantID that is pulled from the ContestantManager.
this was working fine untill my client said that there may be times where
contestants tie in certain places so i changed the ContestantID in the
resultsmanager to nvarchar as the data type so that it could take input
like... 6,161 (contestantid 6 and contestantid 161) now on the output i had
to change the statement to the following but we get an error: (included at
bottom) what i would like to know is am i going about this the proper way or
do i need to redo my statement? ANY and ALL Help will be MUCH MUCH
apreciated. (please reply to on list and CC: to me directly as well, it
seems sometimes that i dont get my list mail as often as i should. but i
would like for others to maybe learn from this as well:)
<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>
ERROR:
Error Diagnostic Information
An error occurred while evaluating the expression:
#ResultsManager.ContestantID#
Error near line 9, column 169.
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
