kumarsivarajan / rmh-roomreservation-maker

Automatically exported from code.google.com/p/rmh-roomreservation-maker
0 stars 0 forks source link

creating a new family profile fails when there is no secondary phone number #127

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.login as social worker
2. Choose Family Profile
3.Choose Create Family Profile
4. Enter information but leave secondary phone number blank

The record should be inserted with a NULL secondary phone number.Instead, 
several errors are displayed. There is a SQL error - misformatted query around 
the secondary phone number. Since nothing is retrieved in the subsequent call 
to retrieve the new family profile, an error message is displayed to the user. 

Fixes 1. fix the SQL
      2. Add a check to the code that retrieves the family profile, handling the case that nothing is returned. Always do this as a general practice.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by bkmackellar on 12 Dec 2012 at 2:31