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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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?

Sort columns
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Sort columns
#11347
Sort columns 13 Years, 9 Months ago Karma: 0
Hello,
Its possible to change the order of the columns?
I can't find the way.

Thanks
The administrator has disabled public write access.
 
#11350
Re:Sort columns 13 Years, 9 Months ago Karma: 760
Hello,

If you load data from SQL database, you can place fields in necessary order in "SELECT" SQL query. For example if you want to show column in order "col2", "col3", "col1" from "table1", use the next SQL query:

Code:


SELECT
  col2,
  col3,
  col1
FROM
  table1



If you use CSV file, just place columns in necessary order in CSV file.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1