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?

Numbering Rows
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Numbering Rows
#58335
Numbering Rows 8 Years, 2 Months ago Karma: 0
I have a data table that uses a query to return data from the database. I want to be able to number the rows returned, to give them a ranking.

Here is the query:

SELECT Score, Name, Position, CurrentAge
From database.table
Where Team = "A"

The scores are ordered correctly, but the results look like:

25, John, C, 18
36, Joe, LF, 19
etc

I'd like to show as

1, 25, John, C, 18
2, 36, Joe, LF, 19
etc.

Any advice would be greatly appreciated.
The administrator has disabled public write access.
 
#58338
Re:Numbering Rows 8 Years, 2 Months ago Karma: 760
Hello,

It is possible to use this solution.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58349
Re:Numbering Rows 8 Years, 2 Months ago Karma: 0
The code results in an error 15:

"unknown expr_type in expression subtree[0] user_variable"

Any other advice?
The administrator has disabled public write access.
 
#58355
Re:Numbering Rows 8 Years, 2 Months ago Karma: 760
What query do you use?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58374
Re:Numbering Rows 8 Years, 2 Months ago Karma: 0
I've tried several of those examples. Anything with user-defined variables throws that same error.
The administrator has disabled public write access.
 
#58378
Re:Numbering Rows 8 Years, 2 Months ago Karma: 760
Update "ARI Smart Content" to v. 2.2.30 and try again. It should help.

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