ARI Soft - Query does not run

Featured Demos

e-mail: info@ari-soft.com

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.

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

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

Query does not run

(1 viewing) (1) Guest

Page: 1

TOPIC: Query does not run

Forum Tools

#55992

Query does not run 8 Years, 6 Months ago	Karma: 0
Ari data table 1.15.2 in Joomla 3.4.4 does not run the following query: SET @numero=0; SELECT @numero:=@numero+1 AS `POS`, `OFENSIVA`.* FROM `OFENSIVA` This consultation allows the results to number (Number the registration) of a SELECT in MYSQL but not running on ARI DATA TABLE, I appreciate your feedback as indicated.

egimen25

The administrator has disabled public write access.

#55994

Re:Query does not run 8 Years, 6 Months ago Karma: 747

Hello,

Use the following query:

Code:



SELECT @numero:=@numero+1 AS `POS`, O.* 

FROM `OFENSIVA` O,(SELECT @numero:=0) T

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#55996

Re:Query does not run 8 Years, 6 Months ago	Karma: 0
Okay, it worked perfect. Thanks for the prompt response. Regards,

egimen25

The administrator has disabled public write access.

#56001

Re:Query does not run 8 Years, 6 Months ago	Karma: 0
Friends, that arrangement requires consultation provided for you so there is no duplication of registration. Annex screenshot. The last line of the query add to rank fields based on the AVE (averague) and VB (times at bat) I appreciate your help if possible.