Artetics Forum
Welcome, Guest
Please Login or Register.    Lost Password?
How do I get a SQL filter or search working? (1 viewing) (1) Guest
Art Data
Go to bottom Post Reply Favoured: 0
TOPIC: How do I get a SQL filter or search working?
#2570
Steve Hill (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
How do I get a SQL filter or search working? 4 Months, 2 Weeks ago Karma: 0  
I think this is a fairly simple thing I'm trying to do. I want to list out the data in a SQL Table and then allow the user to search/filter that data to narrow the results. It seems to be a combination of the features Art SQL and Art Data Table. Is this possible? If so, how do I accomplish this?

Thanks!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2571
Administrator (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:How do I get a SQL filter or search working? 4 Months, 2 Weeks ago Karma: 0  
This should be possible with Art Data Table:

{artdatatable}
{artsqltable query="YOUR_QUERY_HERE"}{/artsqltable}
{/artdatatable}

or Art Table Sorter:

{arttablesorter filter="true"}
{artsqltable query="YOUR_QUERY_HERE"}{/artsqltable}
{/arttablesorter}

Regards,
artetics.com team
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2572
Steve Hill (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:How do I get a SQL filter or search working? 4 Months, 2 Weeks ago Karma: 0  
Hmmm...that's what I thought, but when I tried that I see the artdatatable tags around my data.

Here's my article code.

{artdatatable}{artsqltable query="SELECT * from utilities order by membercode" headerNames="Member Code, Company Name, Phone Number" headers="membercode,company,phone"}{/artsqltable}{/artdatatable}

The data is displayed correctly, but the artdatable tags seem to have no effect.

this is the page: http://dev.korterra.com/gsoc/index.php/submit-exc-ticket/utilities-served.html

Thanks for the quick response.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2577
Administrator (Visitor)
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Birthdate:
Re:How do I get a SQL filter or search working? 4 Months, 2 Weeks ago Karma: 0  
Most probable this is because too many rows, which Art Data Table plugin cannot parse - do you have access to PHP settings on your server to increase the value of pcre.backtrack_limit setting?

If not we can to adjust the extension so it tries to set this setting to greater value.

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.