[ cf-dev ] a-z

2003-09-29 Thread Paul_Swingewood
So . I got this far before lunch beer cfif not isdefined(attributes.search_string) cfset attributes.search_string = a /cfif cfquery name=select_az datasource=WebUserDSN SELECT EstablishmentName FROM School_Details WHERE LEFT(#EstablishmentName#,1) =

Re: [ cf-dev ] a-z

2003-09-29 Thread duncan . cumming
: 29/09/2003 13:22 Subject: [ cf-dev ] a-z Please respond to dev

Re: [ cf-dev ] a-z

2003-09-29 Thread Paul_Swingewood
Hmmm. did that and still doesn't work. Should have looked at error message though Invalid column name 'a' - er I think thats a little wrong then . I just wanted to look in school_details and find all records starting with a Regards - Paul

Re: [ cf-dev ] a-z

2003-09-29 Thread duncan . cumming
: 29/09/2003 13:28 Subject: Re: [ cf-dev ] a-z Please respond to dev

Re: [ cf-dev ] a-z

2003-09-29 Thread Paul_Swingewood
Yep just saw it as your email came through. Many thanks works ok now . Just the next previous all paging thing to do Regards - Paul * The information contained within this e-mail (and

RE: [ cf-dev ] a-z

2003-09-29 Thread Robertson-Ravo, Neil (RX)
for equality. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 September 2003 13:34 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] a-z should perhaps be cfquery name=select_az datasource=WebUserDSN SELECT EstablishmentName FROM School_Details

RE: [ cf-dev ] a-z

2003-09-29 Thread Paul_Swingewood
Actually is says go to the column named EstablishmentName and return all records starting with 'a'. I think. Well it works anyway Regards - Paul * The information contained within this

Re: [ cf-dev ] a-z

2003-09-29 Thread Damian Watson
Paul, did that work? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 1:34 PM Subject: Re: [ cf-dev ] a-z should perhaps be cfquery name=select_az datasource=WebUserDSN SELECT EstablishmentName FROM School_Details

[ cf-dev ] A-Z listing

2002-10-28 Thread Robertson-Ravo, Neil (REC)
Anyone got a link for a decent A-Z listing Tag? I need to implement one fairly quickish and I was hoping there are a few tags out there! Neil -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [ cf-dev ] A-Z listing

2002-10-28 Thread Matt Horn
Order by ? At 15:04 28/10/2002 +, you wrote: Anyone got a link for a decent A-Z listing Tag? I need to implement one fairly quickish and I was hoping there are a few tags out there! Neil -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail:

Re: [ cf-dev ] A-Z listing

2002-10-28 Thread duncan . cumming
PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: [ cf-dev ] A-Z listing

RE: [ cf-dev ] A-Z listing

2002-10-28 Thread Adrian Lynch
cfoutput cfloop from=65 to=90 index=i #Chr(i)# br /cfloop /cfoutput Is this any good? Ade -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: 28 October 2002 15:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] A-Z listing