Showing only 1 record

Archived from the Xataface Users forum.

almatesic — Wed Jan 21, 2009 10:59 am

I have an orders table. The tab shows up fine. It is telling me the correct number of found records in the table, which is 12. I also have the limit of shown records set to 100. However out of all the records it is only showing me 1 record. “Now showing 1 of 12

My other table, which is named users is showing correctly. I have 133 records found, broken up to two pages because i am only displaying 100 records per page.

I have nothing out of the ordinary in my fields.ini and conf.ini file. What can be causing this?

Thanks for the help,

almatesic — Wed Jan 21, 2009 1:44 pm

I narrowed down the problem of why only one record is showing versus them all showing. When my primary key is set to be an integer and autoincrement when a new record is inserted then it decides only to show the last record inserted?

Why does this happen?

shannah — Wed Jan 21, 2009 2:11 pm

After inserting a new record, it changes the query to show only the record that was just inserted.. You should see this reflected in the result controller (found 1 of xxx records).

You can show all again by clicking “show all”.

-Steve