Doesn't necessarily follow: with ascii "a" is 97, whereas "H" is 72, so
you'd expect

<cfoutput>#("a" GT "H")#</cfoutput> --> Yes

Whereas it actually gives no, as lexically a is before (less than) H.

-----Original Message-----
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] 
Sent: 06 April 2004 10:35
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] String values and GTE etc

is that not what one would expect to see though with comparing ASCII values?

is this not how a DB would sort text information in alphabetical order?

_______________________________________________________
Regards, 
                Richard Lovelock, 
                Senior Application Analyst.

Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London 
SW8 2HG 
Tel:     0870 906 7482
 
_______________________________________________________


-----Original Message-----
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: 06 April 2004 10:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] String values and GTE etc



> I think you're getting what's called a "lexical comparison" 

Looks like you're right:

<cfoutput>#"aaa" GTE "aab"#</cfoutput> <!--- no  --->
<cfoutput>#"aaa" GTE "aaa"#</cfoutput> <!--- yes --->
<cfoutput>#"aab" GTE "aaa"#</cfoutput> <!--- yes --->

Another example of CF being "clever"...  Ho hum.

Tim.

--
-------------------------------------------------------
<CF_CodingContest mode="judging" newentries="false">
Maze Solver - http://tech.badpen.com/cfcontest/
-------------------------------------------------------
RAWNET LTD - Internet, New Media and ebusiness Gurus.
WE'VE MOVED - for our new address, please visit our
website at http://www.rawnet.com/ or call us any time
on 0800 294 24 24.
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
------------------------------------------------------- 

-- 
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
 
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
      *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
           *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]


=======================================================

This message contains information that may be privileged or 
confidential and is the property of the Cap Gemini Ernst & Young 
Group. It is intended only for the person to whom it is addressed. If you
 are not the intended recipient, you are not authorised to read, print, 
retain, copy, disseminate, distribute, or use this message or any part 
thereof. If you receive this message in error, please notify the sender 
immediately and delete all copies of this message.

=======================================================


-- 
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
 
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
      *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
           *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]





-- 
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
 
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
      *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
           *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]

Reply via email to