Okay I figured it was going to be a query based solution. Turns out there is a
table in SQL Server that lists all chars in ASCII so I can sort based on that
table's numeric values and then return two columns to output. Pretty RAD.
here's the t-sql to generate it.
-----------------------------------
set nocount on
declare @integers table ([Number] INT)
declare @i int
declare @char varchar(255)
set @i = 1
while @i < 128
begin
insert into @integers values (@i)
set @i = @i + 1
end
declare char_test cursor for
select [Number] from @integers
open char_test
fetch next from char_test into @char
while @@fetch_status = 0
begin
print 'char #' + @char + ' = ' + char(@char)
fetch next from char_test into @char
end
close char_test
deallocate char_test
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327263
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
