why do you need to know how many records there are under A in order to output them in 2 columns? what's your output code look like?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Giles Roadnight" <giles.roadnight@goldcockerelbo To: <[EMAIL PROTECTED]> oks.co.uk> cc: Subject: [ cf-dev ] Counting titles that do not start with letter 11/21/02 04:16 PM using SQL Please respond to dev I am looping through a query of titles and I want to output the results per letter in two columns so under A there would be two columns of titles starting with A. To do this I need the count of records beginning with A which I have done like this: <cfquery name="qry_getCurrentLettercount" dbtype="query"> select count(gameid) as lettercount from qry_getgames where name like '#request.currentLetter#%' </cfquery> How though do I get the count of titles that do not start with a letter? I could do it like this: <cfquery name="qry_getCurrentLettercount" dbtype="query"> select count(gameid) as lettercount from qry_getgames where name not like 'A%' and name not like 'B%' ect... </cfquery> But I don't want to have to write that out 52 times (upper and lowercase) Also is there a way to make SQL non case sensitive so the first query will count upper and lower case? Thanks Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
