Creating an Order History Page

The training document is asking me to enter a parameter for {WADAorders.OrderID} after following the steps very carefully I am not able to get the property inspector to allow a parameter to be entered.

What happens when you try to add the parameter? Do you get an error?

Please provide more details so we can try to assist.

Originally Said By: Jason Byrnes

  What happens when you try to add the parameter? Do you get an error?

Please provide more details so we can try to assist.  

There is no parameter to add.

You can only create the parameter while selecting the page the link goes to.

in the property inspector, click the folder Icon next to link. Select the page that the link goes top, before clicking the OK button, click the parameter button to create the link parameters.

My Sql statement is returning an error and not letting me add a binding from the WADAorderdetails Recordset

SELECT orders.*, orderdetails.*
FROM FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailOrderID
WHERE orderdetails.DetailOrderID = WADAOrderID AND orders.OrderUserID = paramUserID

see attached for the sql error

You have the word FROM in the query twice:
FROM FROM orders INNER JOIN...

The SQL should be:
SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailOrderID
WHERE orderdetails.DetailOrderID = WADAOrderID AND orders.OrderUserID = paramUserID

That did it, very embarrassing.

Now that i have finished my page returns the error

Unknown column 'WADAOrderID' in 'where clause'

removed WADA in front of orderid and seems fine now however my page is not returning any results although i am logged in and have orders under m userid

Create a new parameter in the recordset:
Name: WADAOrderID
Type: Number
Default Value: -1
Run Time value: $_GET['OrderID']

Script seems to be fine now although when i test no results are returned. Page is published and have orders under a userid but again no results are returned. the published Page displays
"No results for your search"