do as much as you can on the server first, and then do your stuff in cf.... after all you're connecting to it, powerful features it has, use them you will ----- Original Message ----- From: "Rich Wild" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 3:30 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question
> stored procedures = good. > > > -----Original Message----- > > From: Robertson-Ravo, Neil (REC) > > [mailto:[EMAIL PROTECTED]] > > Sent: 10 October 2002 15:42 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Alphabetical dumbass question > > > > > > yes, SP....use them for everything, even the shittiest SQL query..... > > > > -----Original Message----- > > From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] > > Sent: 10 October 2002 15:39 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] Alphabetical dumbass question > > > > > > > > > Use an SP. > > > > Stored procedure my arse! > > > > > > SELECT DISTINCT LEFT(Surname,1) AS MyAlpha > > FROM User > > ORDER BY LEFT(Surname,1) > > > > Taz > > > > -- > > ** 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
