DataGrid Tab Appears but no records in the grid

A place for users and developers of the Xataface to discuss and receive support.

DataGrid Tab Appears but no records in the grid

Postby lhat » Thu Nov 04, 2010 11:12 am

Hi, All.

I've downloaded and installed the datagrid module, added the required modules line in my conf.ini, and even have added the datagrid:view, etc. lines to my permissions.ini. This results in the Grid tab appearing in my application, and when I click on it, I get the DataGrid layout well enough; but there are no records listed, even though my test application has 50 some records. The records show up normally in list view--here's what it looks like:
broken_grid.png
broken_grid.png (20.62 KiB) Viewed 1291 times

As you can see, the frame and headers appear, including the notation of how many records, pagination, and showing xx results per page; the next row also looks normal (add row; toggle full screen; export csv); and then the table's column/field heads which are all toggle-able. The export button even works, providing me a download of the records. But no records are listed.

I thought this must be a permissions issue, but I've logged in as admin and that role has the full array of datagrid perms in place, all set to work.

I'm stumped and would welcome any pointers/suggestions!
lhat
 
Posts: 40
Joined: Thu Aug 06, 2009 3:31 pm

Re: DataGrid Tab Appears but no records in the grid

Postby shannah » Thu Nov 04, 2010 11:24 am

check your error log and see if it reports anything.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: DataGrid Tab/No Records--SOLVED; Nxt questions

Postby lhat » Thu Nov 04, 2010 3:56 pm

Thanks, Steve--

Further experimentation has resolved the issue: my first field and primary key was of type INT, and several of the others in the table were INT variants; I changed these all to varchar types and the records became visible once more. Thanks!
lhat
 
Posts: 40
Joined: Thu Aug 06, 2009 3:31 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 11 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved