Welcome, Guest
Please Login or Register.    Lost Password?

Have a grid based on an SQL statement
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Have a grid based on an SQL statement
#346
Have a grid based on an SQL statement 1 Year, 11 Months ago Karma: 0
Hello,

I would like to find out if it is feasible to have the possibility to create a grid based on an sql statement? That would really be handy, as I need to display information which is in more than one table.

Adelheid
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
apaternoster
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Gender: Female Birthday: 02/25
Last Edit: 2010/03/07 06:28 By viljem.
Reply Quote
 
#347
Re:Have a grid based on an SQL statement 1 Year, 11 Months ago Karma: 1
Hi,

In admin section not entirely, just part in WHERE section. It is supposed to be as much as possible user friendly also to those who don't know anything about SQL.

But if you create SQL view in e.g. phpMyAdmin for Mysql, or Oracle or MS-SQL tools, you can display SQL view with TableJX. This means that you can present any data, almost whatever you can do with SQL. With this ability are possibilities almost endless.

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
Last Edit: 2010/03/07 06:03 By viljem.
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: tomaz
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting