Variable Runtime value disappears

[pabirds]

Dreamweaver CS4, PHP

When I create a recordset, and set the variable "colname" runtime value to $_GET['OrderID'] and click OK, it appears to save it. But when I click OK to save the recordset, a red ! appears next to it. If I open the recordset to check it, the runtime value has disappeared.

I have created many recordsets from this database, and they all are working except this one. Also, sometimes, after saving the recordset, and then testing the web page, when I return to check the recordset, a new variable "TotalRows" has appeared! I delete that variable, re-enter the runtime value for colname and save it, and the red ! reappears and I'm back to square one.

The recordset is defined as follows:

SELECT *
FROM orders, orderdetails
WHERE orders.OrderID = colname and orderdetails.DetailOrderID = orders.OrderID

The page on which it is used has a top section where data from one record from the orders table is displayed and a repeat region where multiple records from the orderdetails table are displayed.

What the heck is going on? How can I fix this?

[bregent]

I would guess that since both tables have an OrderID and so DW is confused about which to use. Rather than using * to specify columns, list them explicitly and use only one OrderID.