MX Query Builder Forum :: KTCol Param1 Error

I am going through the tutorial "Order Management" and I am using QUB to build the tutorial query. When I try to save the recordset going by the instructions i get the error message: KTColParam1 is an invalid variable name; it does not appear in the SQL. How do I fix this?

Thanks in advance

Hello,

Does this happen when you try to create the recordset as shown in the section named "Create page to display current order", because in that section I do not see any parameters named like that.

Regards,
Razvan RACASANU

 Hi Razvan,
It happens after I complete topic 10 under the tutorials:
Order management Intranet > Create page to display current order > 10 .
When i look at the example I do not have what you have from the select
statement either.

Eddie

Hello,

Please make sure that you have followed all the steps presented in the tutorial in the specified order. Sometimes it helps doing them again, on a new recordset. Also, please attach a screenshot with the Qub window opened showing the relations between the tables, and the SQL query that has been generated.

Regards,
Razvan RACASANU

I've notice that sometime when returning to dreamweaver from qub, that any variable names are missing the type, ie numeric.  Make sure that the variable is assigned a type.

Jim