[dev] Diff for horde/lib/Prefs/sql.php

[Joel Vandal]

Hi,

Compare the result and tell me if it's normal .. but I don't think...

Original :
SELECT pref_name, pref_value
FROM horde_prefs
WHERE pref_uid='user@domain'
AND ( pref_name = 'sortby')
AND pref_scope='horde'
OR pref_scope='gollem'

Output from SQL command SELECT * FROM horde_prefs WHERE
pref_uid='jvandal@infoteck.qc.ca' AND ( pref_name = 'sortby') AND
pref_scope='horde' OR pref_scope='gollem' ..

pref_uid                            pref_scope            pref_name
pref_value
sly@slyastro.com              gollem                   show_detail     0
Dwell@lantin.net               gollem                   sortdir
0
Dwell@lantin.net               gollem                   sortby             0
jvandal@infoteck.qc.ca     gollem                   sortby             3


New :
SELECT pref_name, pref_value
FROM horde_prefs
WHERE pref_uid='user@domain'
AND ( pref_name = 'sortby' )
AND (pref_scope='horde' OR pref_scope='gollem')

Output from SQL command SELECT * FROM horde_prefs WHERE
pref_uid='jvandal@infoteck.qc.ca' AND ( pref_name = 'sortby') AND
(pref_scope='horde' OR pref_scope='gollem') ..

pref_uid                            pref_scope            pref_name
pref_value
jvandal@infoteck.qc.ca     gollem                   sortby              3

--
Joel Vandal