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?

Problem query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Problem query
#3684
Problem query 14 Years, 8 Months ago Karma: 0
Is there a limit of complexity for a query using SQL ARI TABLE?
For a simple query I have a result but for a complex query, nothing appears

regards
The administrator has disabled public write access.
 
#3685
Re:Problem query 14 Years, 8 Months ago Karma: 760
Could you provide your SQL query? Did you try to run your query in a SQL manager, is it work without problems?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#3686
Re:Problem query 14 Years, 8 Months ago Karma: 0
I try to run this request in a SQL manager and it works.
I attach a .txt file to see my query.

I put this query in this structure:
{arisqltable}
{ariconnectionstring dbHost="localhost" dbName="joomla" dbUser="user" dbPass="pass" dbType="mysqli" persistent="false"}
{arisqltablequery}
my_query
{/arisqltablequery}
{/arisqltable}

I test the ariconnectionstring parameters with a simple query and it works.

See you tomorrow.

Regards
File Attachment:
File Name: requete.txt
File Size: 1688
The administrator has disabled public write access.
 
#3688
Re:Problem query 14 Years, 8 Months ago Karma: 760
Could you also provide SQL dump of tables that are used in your query? It requires that we can reproduce this issue on our test server.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#3689
Re:Problem query 14 Years, 8 Months ago Karma: 0
I attach a file to this message with sql tables but no corresponding data. I can not. I hope that's enough.

I think I put all the tables corresponding to my query

regards
File Attachment:
File Name: sql_dump_without_data.txt
File Size: 5579
Last Edit: 2010/04/08 07:56 By yannick33.
The administrator has disabled public write access.
 
#3690
Re:Problem query 14 Years, 8 Months ago Karma: 760
Check your mail, please.

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