[ic] How to send input from a form page to a SQL query page?

[interchange-users@interchange.redhat.com]

Thanks to the help on the group I have managed to create an advanced search
form that searches an arbitary (alternate) MySQL products table and that
returns a product lists beautifully.

My problem now is creating an order link or order button.

I have added to catalog.cfg

ProductFiles   products newarbitaryproductfile

and restarted Interchange but for some reason none of my 'Buy now' buttons
or links find the product or add tit to the cart. (Empty cart is displayed)

Error log:  Attempt to order missing product code

Why would it be that interchange can't find the sku's in the new products
file?

(My advanced [query] searches on the SQL database are working beautifully.
Will post the form and the results file after I get ordering happening)

Have tried

[order [sql-code]]Order this item</a> which produces:
http://www.store.com/cgi-bin/masson/ord/basket?mv_session_id=pUDxQMQq&mv_pc=
3&mv_action=refresh&mv_order_item=99117

but this doesn't find the product.

The tag will find a product sku in the default products.txt but not in the
arbitary product file.

What else other than

ProductFiles   products newarbitaryproductfile

do I need to add so that  IC 4.83 can recognise a product in an alternate
products file?