Remove the ORDER BY clause. There's nothing to order, since you're only going to get ONE row (with MaximumTIP and MinimumTIP). With the ORDER BY clause containing TipTitle, the query needs a GROUP BY clause to give it something to order by...
> trying to do a little funky SQL to get the minimum and maximum > ID's with respect to a sort order on a table but I'm getting an access > error, cam anybody see what is wrong with my sql here... > > <CFQUERY DATASOURCE="#CFG.DS#" CONNECTSTRING="#CFG.CONNECTSTRING#" > DBTYPE="#CFG.DBTYPE#" NAME="Q_Tips"> > SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP > FROM TIPS > WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink# > ORDER BY TipTitle ASC > </CFQUERY> > > > > Error Diagnostic Information > ODBC Error Code = S1000 (General error) > [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query th at > does not include the specified expression 'TipTitle' as part of an > aggregate function. > SQL = "SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP FRO M > TIPS WHERE TipTipCategoryLink = 1 ORDER BY TipTitle ASC" > Data Source = "" > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (20:2) to (20:104) in the template > file > D:\JOBS\WEB-FUSION\WEBSHOPCODEBASE\_MIRROREDFILES\BFD5C5FB051709B72C9FF32 1B62A465C\PLUGIN_SHOWSTUFF\QRY_SHOWTIP.CFM. > Date/Time: 02/22/02 16:02:18 > Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) > Remote Address: 10.10.10.105 > Query String: > FuseAction=showTip&TipID=7&CFID=6778&CFTOKEN=31983074&ForceUpdate =1 > > > > > James Sleeman > Innovative Media Ltd > Phone: (03) 377 6262 > http://www.websolutions.co.nz/ > > CAUTION: The information contained in this email message is confidential > and may be legally privileged. If the reader of this message is not the > intended recipient you are notified that any use, dissemination, > distribution or reproduction of this message is prohibited. If you have > received this message in error please notify the sender immediately and > destroy the original message and any attachments. > > Views expressed in this communication may not be those of Innovative Medi a Ltd. > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
