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]