Welcome, Guest
Please Login or Register.    Lost Password?
Tools JX
Table JX
Installation

Grid not showing
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Grid not showing
#541
Grid not showing 1 Year, 8 Months ago Karma: 0
Hi,

I have a issue similar to a previous post where it will not display grids. It counts the records and I can filter it so its just not displaying.

Thanks
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jens
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#543
Re:Grid not showing 1 Year, 8 Months ago Karma: 1
Hi,

what type of DB you have? (MySQL, MySQLi, Oracle, MS-SQL, MS-SQL2000)

Can you send me table structure with some inserts, i will check it in debug mode.

customers@toolsjx.com

Best regards,
Viljem
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
viljem
Admin
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#544
Re:Grid not showing 1 Year, 8 Months ago Karma: 0
Hi

You have mail

Thanks
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jens
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#545
Re:Grid not showing 1 Year, 8 Months ago Karma: 0
Many thanks now working
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jens
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#579
Re:Grid not showing 1 Year, 8 Months ago Karma: 0
can you explain what you did to fix it?
I'm having the same problem -- the grid indicates there are records and when I filter/search, the number of records reflects the search criteria, but nothing is showing up in the grid results.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
lcdservices
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#580
Re:Grid not showing 1 Year, 8 Months ago Karma: 0
Hello,

Usually the problem is in field names of a table if they contain characters like '-', ' ', '+', '/'... (e.g. 'e-mail', 'my field').

The solution is to create a view like

CREATE VIEW MY_TABLE_VIEW AS
SELECT
`e-mail` AS email
`my field` AS myfield
FROM MY_TABLE

and then display this view with TableJX

Regards,
Bostjan
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
Bostjan
Senior Boarder
Posts: 46
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Tools JX
Table JX
Installation
Moderators: tomaz
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting