I am currently doing a project, part of which involves reading peoples information into a Database, the table in question being member_table which includes a 'Date of Birth' field. I have no problem doing this as all the information I want to assign to this table including DOB is happening.
My problems arise when I interrogate the database. I am outputting my query to a jTable. The DOB field (which is a date field) is not being picked up and in fact the next column which is an address field occupies the DOB column. In other words the heading DOB appears but all the information moves one column to the left with the last column remaining empty, all because the DOB field is not being read from the database.
The SQL query is:
query = "SELECT * from Member_Table WHERE Member_Table.FirstName = 'jTextFieldFirstName.getText()' AND (Member_Table.Surname = 'jTextFieldSurname.getText()');
Anyone any ideas.