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?

How to create a dynamic query string
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: How to create a dynamic query string
#36315
Re:How to create a dynamic query string 11 Years, 2 Months ago Karma: 747
Read this post.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#36319
Re:How to create a dynamic query string 11 Years, 2 Months ago Karma: 0
Hi -

Thanks for your reply. The query you provided is not functioning properly

palmsprings-mobile.com/index.php/portfolio/video-portfolio

The table rows load into MyResults without any action by user and no matter what combination of selection criteria, all 350 rows are retrieved.
The administrator has disabled public write access.
 
#36320
Re:How to create a dynamic query string 11 Years, 2 Months ago Karma: 747
Disable server side pagination. It is not possible to use request variables in SQL query when server side pagination is enabled.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#36323
Re:How to create a dynamic query string 11 Years, 2 Months ago Karma: 0
Hi -

Thanks again for your excellent support and assistance.

When the page is accessed (palmsprings-mobile.com/index.php/portfolio/video-portfolio) the MyResults area is prepopulated with "showing 1 to 10 of 350 entries" without any action by user.

Is it possible to have this area empty until user has made selection(s) from list(s) AND/OR pressed SUBMIT button?

FYI N- I had to modify the caption "Price Range" to "Price" as the query didn't function properly with the space between words.
Last Edit: 2013/01/31 23:32 By tmediacom.
The administrator has disabled public write access.
 
#36331
Re:How to create a dynamic query string 11 Years, 2 Months ago Karma: 747
Create a new article which will contain only the search form and will redirect to article with the search form and the module and a user click by "Submit" button.

PS: It is not necessary to change caption, it is enough to change "name" attribute of "SELECT" element.

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