Ah that looks good, thought there must be a SQL solution, I'll be trying that as soon as I can log into my server (Russ!!!!!!!!!)
cheers everyone --- ----- Original Message ----- From: "Peter Harrison" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 3:32 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question > or perhaps some SQL like: > > SELECT DISTINCT SUBSTR([TBL_USER].[USERNAME], 1, 1) AS FIRSTLETTER > ORDER BY FIRSTLETTER ASC > > (returns letters only where a username starts with that letter - or number > or any character for that matter) > > > > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:[EMAIL PROTECTED]] > Sent: 10 October 2002 15:19 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Alphabetical dumbass question > > > Use an SP. If you perform all the logic within the DB, you should be able > to return only the data required for display by CF/HTML. > > N > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED]] > Sent: 10 October 2002 15:17 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Alphabetical dumbass question > > > Hi, > > I'm making an index of users on a site which one can navigate through A-Z. I > am trying to get each letter from the A_Z list of links to only appear if > there are entries under that letter. I've done this but it's pretty query > intensive and I'm wondering if anyone's got any other ideas. > > Currently I've created a list 'a,b,c,d' etc which I loop into a query which > selects records where like #list#%. I then output the letters if there are > any records from the query. Problem is, this gives me 26 queries which (if > there were a large userbase) would be a nightmare. > > Any ideas? > cheers > d > > ----- Original Message ----- > From: "Giles Roadnight" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, October 10, 2002 2:49 PM > Subject: Re: [ cf-dev ] CFMX, looping through error varaibles > > > > Thanks everyone for the help. Adrian, this looks like the one I am looking > > for. I already use similar loops to the error one I am tying to use to > send > > me session, client and other variables but it will be a lot easier to use > > CFdump. is htis new in MX? > > > > Also I didn't think you could use cfmail in the error page. has this now > > changed? when I first did an error template I put all variables in a form > > and submitted to another page that e-mailed me as I didn't think you could > > use any CF in the error page. > > > > The grey box is a syntax error, it was just a deliberate error I did to > test > > my error template. I didn't know that these were handled differently. > > > > Thanks for all of the help. > > > > Giles > > > > ----- Original Message ----- > > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, October 10, 2002 2:36 PM > > Subject: RE: [ cf-dev ] CFMX, looping through error varaibles > > > > > > This might help you out, but I've just ripped it out of an application > > so you might need to wade through it a little. > > > > > > Put this in your Application.cfm file: > > > > <cferror type="EXCEPTION" exception="ANY" > > template="/errors/exception.cfm" mailto="[EMAIL PROTECTED]"> > > > > > > then put this in /errors/exception.cfm > > > > <cfmail > > to="[EMAIL PROTECTED]" > > from="My web site" > > subject="An e-mail from My web site" > > type="HTML"><html> > > <head> > > <title>An error has occurred</title> > > </head> > > <body> > > > > <p>An error has occurred on My web site</p> > > > > <hr> > > > > <p>Error:</p> > > > > <cfdump var="#Error#"> > > > > <p>Variables:</p> > > > > <cfdump var="#Variables#"> > > > > <p>CGI:</p> > > > > <cfdump var="#CGI#"> > > > > <p>File:</p> > > > > <cfdump var="#File#"> > > > > <p>URL:</p> > > > > <cfdump var="#URL#"> > > > > <p>Form:</p> > > > > <cfdump var="#Form#"> > > > > <p>Cookie:</p> > > > > <cfdump var="#Cookie#"> > > > > <p>Client:</p> > > > > <cfdump var="#Client#"> > > > > <p>Server:</p> > > > > <cfdump var="#Server#"> > > > > <p>Application:</p> > > > > <cfdump var="#Application#"> > > > > <p>Session:</p> > > > > <cfdump var="#Session#"> > > > > <p>Request:</p> > > > > <cfdump var="#Request#"> > > > > </body> > > </html></cfmail> > > > > > > > > <!--- Put your header cfinclude or cfmodule here ---> > > > > <cfoutput> > > <p>Unfortunately an error has occurred on this web site.</p> > > > > <p>The error has now been logged and the web site developers > > notified.</p> > > > > <p>We are sorry for the inconvenience this has caused. If you would like > > to contact the web site technical support team, please send an e-mail to > > <a href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]</a>.</p> > > > > <p>Please <a href="/">return to the web site</a>.</p> > > </cfoutput> > > > > <!--- Put your footer cfinclude or cfmodule here ---> > > > > > > -- > > Aidan Whitehall <[EMAIL PROTECTED]> > > Macromedia ColdFusion Developer > > Fairbanks Environmental +44 (0)1695 51775 > > > > ________________________________________________________________________ > > This e-mail has been scanned for all viruses by Star Internet. The > > service is powered by MessageLabs. For more information on a proactive > > anti-virus service working around the clock, around the globe, visit: > > http://www.star.net.uk > > ________________________________________________________________________ > > > > -- > > ** 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] > > > > > > -- > ** 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] > > > -- > ** 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]
