Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Changing position colums
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Changing position colums
#28367
Changing position colums 12 Years, 1 Month ago Karma: 0
Hi,

I added all my needed columns but when all was finished i saw that the last one has to be the first.
Is there a way to move columns up.

www.adoewa.com/joomla25/index.php/nl/ari-data-tables


The column Prefix must be the first column.


Koen
The administrator has disabled public write access.
Greetz,

Ken
 
#28371
Re:Changing position colums 12 Years, 1 Month ago Karma: 748
Hello,

Do you show data from a database?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#28374
Re:Changing position colums 12 Years, 1 Month ago Karma: 0
Hi,

Yes , it's from an external db.

Koen
The administrator has disabled public write access.
Greetz,

Ken
 
#28375
Re:Changing position colums 12 Years, 1 Month ago Karma: 748
You can change columns position in "SELECT" SQL query. For example if it looks like:

Code:


SELECT
  col1,
  col2,
  col3
...



and want to show col3 before col1, use the next query:

Code:


SELECT
  col3,
  col1,
  col2
...



Regards,
ARI Soft
The administrator has disabled public write access.
 
#28376
Re:Changing position colums 12 Years, 1 Month ago Karma: 0
Thank you, thee service from ARI Soft is exellent...
The administrator has disabled public write access.
Greetz,

Ken
 
Go to topPage: 1