error message when calling customer_order_details.php

I have created according to the tutorial a customer_order_history.php page and also a customer_order_details.php page. The first page works really fine, but when I click on an order number to get to the customer_order_details.php page then I only get the following error message:

Unknown column 'WADAOrderID' in 'where clause'

Any idea what went wrong??

for some reason the string WADAOrderID is being used in the where clause.

when creating the where clause create it as:
WHERE <id column> = paramOrderID

Then create a new parameter:
Name: paramOrderID
Type: number
Default Value: -1
Runtime Value: $_GET['WADAOrderID']

if you are still having problems, please send a copy of your pages.

Sorry, but I do not have a clue, what you mean. I sent you the page as attachment

somehow the WADAOrderID parameter got deleted in the recordset.


double click the WADAorderdetails recordset.

In the parameters section, click the plus button to create a new parameter.

Name: WADAOrderID
Type: Number
Default Value: -1
Run Time Value: $_GET['OrderID']

Please apologize my dump question, but where can I find this

WADAorderdetails recordset

server behavior???

Yes, it is in the Server Behaviors panel.

Thank's it is working