mysql> select Preferences.i_preference_desc, Preference_Desc.name, Preference_Desc.value as range_value, Preferences.value as value, Preference_Desc.def_value from Preferences, Preference_Desc WHERE Preferences.i_preference_desc=Preference_Desc.i_preference_desc and i_account=894;
+-------------------+------------------+------------------------------------+-----------------------+-----------+
| i_preference_desc | name             | range_value                        | value                 | def_value |
+-------------------+------------------+------------------------------------+-----------------------+-----------+
|                 0 | mode             | voicemail, auto_attendant          | voicemail             | voicemail |
|                 1 | password         |                                    | 777                   |           |
|                 2 | password_ask     | yes, no                            | no                    | no        |
|                 3 | prompt_levels    | standard, extended, rapid          | standard              | standard  |
|                 4 | announce_dt      | yes, no                            | no                    | no        |
|                 5 | auto_play        | yes, no                            | no                    | no        |
|                 6 | greetings        | standard, extended, personal, name | personal              | standard  |
|                 7 | fax_file         | multi_png, multi_tiff, pdf, tiff   | pdf                   | pdf       |
|                 8 | iso_639_1        | RefB=Languages                     | en                    | en        |
|                 9 | ext_email        |                                    | robscovell@notonyournelly.com |           |
|                10 | ext_email_action | none, forward, notify, copy        | forward               | none      |
+-------------------+------------------+------------------------------------+-----------------------+-----------+
11 rows in set (0.00 sec)


##</code><code>##

$sql="select Preferences.i_preference_desc, Preference_Desc.name, Preference_Desc.value as range_value, Preferences.value as value, Preference_Desc.def_value from Preferences, Preference_Desc WHERE Preferences.i_preference_desc=Preference_Desc.i_preference_desc and i_account=?";	
my $sth2 = $dbh2->prepare($sql);
$sth2->execute($account);
my $preferences = {};

while (my $row = $sth2->fetchrow_hashref) {
	$preferences->{$row->{name}} = { value => $row->{value}, range_value => $row->{range_value}, def_value => $row->{def_value} };
	warn $row->{value};
}
$sth2->finish();


##</code><code>##

no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.
no at /home/beechams/new_gui/cu_accounts/voicemail_options.html line 94.