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]
