wlie Posted March 17, 2019 Report Share Posted March 17, 2019 I have a report that shows me all the people born between 1400 and 1500. The report works well, but when I try to click on the individual's ID the report shows error code 404. SELECT tng_people.personID, firstname, lastname,birthdate,birthplace,deathdate,deathplace FROM (tng_people ) WHERE (LPAD(SUBSTRING_INDEX(birthdate, ' ', -1),4,'0') >= "1400" AND LPAD(SUBSTRING_INDEX(birthdate, ' ', -1),4,'0') < "1500") ORDER BY firstname,lastname, birthdate I'm definitely not an expert in SQL, so what have I done wrong. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.