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

Pre-purchase question
(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: Pre-purchase question
#615
Pre-purchase question 1 Year, 7 Months ago Karma: 0
I have two tables in my joomla database with data that I wish to present in a joomla article. One table has 3 text fields i need (and an id field in common with the other table), and another table has one data field that I need.

Firstly, can I link 2 tables in Table JX?

Secondly, the data field in the second table is in comma delimited form. I need each data element in the comma delimited field separated into its own column. Is that possible?

Thanks in advance.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
4ZFood
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#619
Re:Pre-purchase question 1 Year, 7 Months ago Karma: 1
Hi,

Firstly, can I link 2 tables in Table JX?
Not yet.

Secondly, the data field in the second table is in comma delimited form. I need each data element in the comma delimited field separated into its own column. Is that possible?

This is possible with SQL. You can create View and display view with Table JX. If you need help, send us mail with details.

Example:
Code:
CREATE VIEW Something AS
SELECT substring_index(field,', ', 2), substring_index(field,', ', -2)
FROM Table



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
 
Go to top
Post Reply
Post New Topic
Page: 1
Tools JX
Table JX
Suggestions
Moderators: tomaz
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting