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?

column transform
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: column transform
#51105
column transform 10 Years, 2 Months ago Karma: 0
i've a select with some numeric value (0,1,2) and need to show a string to user:

0=unpaid
1=pending
2=paid

Can i do this with ARI Data Tables?

Thanks for help
The administrator has disabled public write access.
 
#51106
Re:column transform 10 Years, 2 Months ago Karma: 760
Hello,

You can use CASE operator in "SELECT" SQL query for this purpose.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#51115
Re:column transform 10 Years, 2 Months ago Karma: 0
very good !
thanks
Mauro
The administrator has disabled public write access.
 
Go to topPage: 1