hmmm yeah -- Taz's query works best thus far... nice an simple related question- can one convert from uppercase to lowercase, 'n vice versa when outputting?
----- Original Message ----- From: "Russ 'Snake' Michaels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 3:50 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question > that would be awful. > > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED]] > Sent: 10 October 2002 15:56 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Alphabetical dumbass question > > > so you're saying... WTFAYS? ;0) -- I guess I could set up a table with 26 > columns a-z and when a user is registered just add 1 to the appropriate > letter -- that would be normanised a bit more > > twould be another method > > ----- Original Message ----- > From: "Colm Brazel" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, October 10, 2002 3:44 PM > Subject: RE: [ cf-dev ] Alphabetical dumbass question > > > > >>Any ideas? > > > > Only guessing, but you could normalise the table a bit and say make 4 > tables > > out of it and use 4 lists one for each table and use cf ISdefined which > > should limit the number of queries you do on each table as well, Sam`s > Teach > > Yourself SQL in 24 Hours, is good for options around this as well and > could > > give you some more ideas. Or you could give each user a queryid in the > user > > table, then use the foreign key of their id to point at their list of > links > > and use one quuery to output their info based on their queryid or somtin > > like that... > > > > regards > > > > Colm > > > > > > Colm Brazel MA > > CB Publications > > > > www.cbweb.net <http://www.cbweb.net> > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -----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] > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/2002 > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/2002 > > > > > > -- > > ** 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]