YEP ThankYou, YEP ThankYou
Have a nice day William
>Capital letters vs. lower case.
>
>Your 'hardcode' example used a lowercase letter, while your examples here
>have an uppercase letter.
>
>If changing the uppercase in the variable to a lowercase 'does' result in
>the expected solutions, then I would suggest changing the 'case' of both
>sides of the equality.
>
><cfquery name="data" dbtype="query">
> select * from session.usersData
> <cfif isDefined('url.alpha')>
> where LOWER(username) LIKE '#Lcase(url.alpha)#%'
> </cfif>
> order by #sortKey# #sortOrder#
></cfquery>
>
>--
>William E. Seiter
>
>Have you ever read a book that changed your life?
>Go to: www.winninginthemargins.com
>Enter passkey: goldengrove
>
>Web Developer / ColdFusion Programmer
>http://William.Seiter.com
><cfdump var = "#data.recordcount#"> returns zero records.
>The query has not been simplified.
>I have tried various values for url.alpha: "A,B,C,D ..."
>
>
>
>
>
>>When you dump the recordcount (<cfdump var="#date.recordcount#">
>>
>>Does it say '0' or does it say the variable is undefined?
>>
>>Also, is this the exact query that is in your code or is it 'simplified'
>for
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3370
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
