[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] How to send input from a form page to a SQL query page?
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?