on 8/29/03 2:21 PM, Jerry Johnson at [EMAIL PROTECTED] wrote: > You're in luck. > > Someone else has already assembled the letters in a nice, convenient order for > you. > > You can use the ASCII table to get the alphabet. > > If you just want the letters A-Z, you can grab the ascii characters between 65 > and 90 > > You can then use the chr() built in function to turn a number (like 65) into > an ASCII letter (like "A") > > For example: > > <cfloop index="i" from="65" to="90" step="1"> > <cfset letter=chr(i)> > <cfoutput>#letter#</cfoutput> > </cfloop> > > HTH > Jerry Johnson
Okay, I've got almost ALL the parts in place. But there's ONE LAST part that I'm having trouble with. It's the expression to check for the existance of an entry. Of course the easiest way would be to just pass the first letter of each letter in the alphabet, and on the following page simply check recordcount to see if there are any entries corresponding to that letter. That seems like the wussy way out. I'd rather have it be clean, so what I'd LIKE to do is somehow loop over that list, and compare each row of the query object for the existance of an entry, but darnit, it's just plain escaping me how to do this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
