Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.

Recent Events
  • 25/11/2021 Black Friday Promotion

    BIG SALE, 35% discount for all our extensions. Use BF21 coupon code. Hurry up the discount is valid till 1 December.

  • 30/04/2021 Important information

    We transferred to another hosting so if you are experiencing any problem let us know. We will fix it as soon as possible.

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?

Passing parameters to SQL
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Passing parameters to SQL
Passing parameters to SQL 9 Months ago Karma: 0

Is there a worked example of passing parameters to a SQL query? I want to display only the first few columns on the first page and then when the user clicks on a link, it opens a new page with just the individual record showing (with all the other fields).

What I really need to know is the format for the SQL in the sub page and the link on the main page (and how it is set up).

The administrator has disabled public write access.
Re:Passing parameters to SQL 8 Months, 4 Weeks ago Karma: 739

If you want to use request parameters in SQL query, it will look like:


 id, title

Just replace VAR_NAME with variable name. For example if want to pass ID via article_id variable, it will look like:


 id, title
WHERE id = {$REQUEST:article_id}

ARI Soft
The administrator has disabled public write access.
Go to topPage: 1