nope thats not me
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Javed Mushtaq" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:15 AM
Subject: RE: !!!Statement Question.!!!
> 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
