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.
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.
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"
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.