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) =
:
29/09/2003 13:22 Subject: [ cf-dev ] a-z
Please respond to dev
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
:
29/09/2003 13:28 Subject: Re: [ cf-dev ] a-z
Please respond to dev
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
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
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
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
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:
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:
PROTECTED]To:
'[EMAIL PROTECTED]' [EMAIL PROTECTED]
dexpo.com cc:
Subject: [ cf-dev ] A-Z
listing
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
12 matches
Mail list logo