Re: bulding a hash

[philcrow]

Perhaps you might rather have DBI build the hash? Then you could try fetchall_hashref.

Phil

[mnlight]

I thought of using fetchall_hashref but I am not sure how to use the values inputed by the user as the key. The table I am querying has no values like that. Also I only reference one column and I need a way to point to each individual row value. e.g. My option types are displayed as
1 read 2 write 3 copy
I want the user to enter the number value but in the script I need to use the char string.