Artetics Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Art SQL Table Can't Get it to work (1 viewing) (1) Guest
Art Data
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Art SQL Table Can't Get it to work
#2757
Gorden Mack (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Art SQL Table Can't Get it to work 3 Months, 3 Weeks ago Karma: 0  
You can see my content page here: http://led-pwr.com/powergatellc/index.php?option=com_content&view=article&id=106&Itemid=202

The plugin is enabled but I can not get a table to display for the life of me. Just for testing, I used this syntax:

{artsqltable query="SELECT title,alias from jos_categories" headerNames="title,alias" headers="title,alias" } {/artsqltable}

Once i can get any table to display, I think I'll need help writing the syntax to display a table that pulls from my sql database with the following specifics:

table = jos_j_cat1_series
Filter = where category_id = 3
Display = name, col1_value, col2_value, col3_value, col4_value, col5_value, length, width, height
Sorted by = col1_value
Headers = Series, Watts, Vin, Vout, Type, Case, Length, Width, Height

If you could provide me the syntax for this one type of query, I can figure it out for the dozens of other queries I might need.

Your help is deeply appreciated,

Gorden
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2758
Administrator (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:Art SQL Table Can't Get it to work 3 Months, 3 Weeks ago Karma: 0  
Hello,

Please make sure plugin is enabled in Extensions -> Plugin Manager -> Art Data.
Also could you please check that artdata.php and artdata.xml files exist in JOOMLA_DIR/plugins/content folder (these files should be copied automatically during install but may not be copied if folder has inappropriate permissions).

Regards,
artetics.com team
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2762
Gorden Mack (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:Art SQL Table Can't Get it to work 3 Months, 3 Weeks ago Karma: 0  
My permissions were set to 777, but the files were not there. I manually placed the files and the tables now work.

Now I'll try to figure out the syntax to create the tables I really need. Hopefully you won't see another post from me today.

Thank you.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2763
Administrator (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:Art SQL Table Can't Get it to work 3 Months, 3 Weeks ago Karma: 0  
Good to hear. Anyway please let us know if case of any issues via forum or by email - we are always ready to help.

Regards,
artetics.com team
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Bookmark

VirtueMart Shopping Cart

Your Cart is currently empty.