[Fez-developers] minor sql syntax error in Browse by Author (ID)

[Lynette R. <el...@cs...>]

FYI...

=20

A minor sql syntax error occurs when Browse by Author ID is selected and
there are no records in Fez.  The error occurs because the where =
statement
does not list any ids.

=20

WHERE value when Fez has records...

=20

            WHERE  r2.rmf_xsdmf_id in
(3327,3328,3329,3330,3331,3332,3595,3825,3951,4134,4150,4200,4208,6029,60=
37,6
225
,6233,6346,6354,6463,6471,6588,6596,6699,6707,6818,6826,6931,6939,7044,70=
52,7
221
,7229,7337,7345,7384,7392,7625,7633,7912,7920,7995,8002,8115,8122,8537,85=
45,8
852 ,8860,8979,8987,9108,9116,9227,9235,9357,9365)

=20

=20

WHERE value when Fez does not have records...

=20

            WHERE  r2.rmf_xsdmf_id in ()

=20

=20

This is generated in class.collection.php  Collection::listByAuthor().

=20

Lynette

=20