person_search_view should discard non integer lunaids

LabNeuroCogDevel / LNCDschedule

calendar and research schedule/visit DB interface

0 stars 1 forks source link

person_search_view should discard non integer lunaids #48

Open WillForan opened 2 years ago

WillForan commented 2 years ago

maybe also make sure addId doesn't add text to lunaid

lncddb_test=# select * from enroll where id like 'test5';
 eid | pid | etype  |  id   | edate 
-----+-----+--------+-------+-------
   7 |   2 | LunaID | test5 |

select * from person_search_view;

ERROR: invalid input syntax for type integer: "test5"