leem
Starting Member
United Kingdom
17 Posts |
Posted - February 06 2003 : 06:09:31
|
Last week I was looking for advice for help with cross selling products appearing in my extended description page and being selectable for purchase. I managed to get around this by making some changes to the 'sub procedure crossell' in shopfileio.asp. This acheives the following look:-
|-------------------------------------------------------| | Product Name| | | | Extended Desc| | | | | Picture | | | | | | | Item Code| | | | Price| | | |-------------------------------------------------------| |cross sell 1 |cross sell 2 | cross sell 3|cross sell 4 | | | | | | | | | | | |-------------------------------------------------------| |Order Button |Reset Button |Hyperlinks| | |-------------------------------------------------------|
From this I can now select multiple items from my extended description and place them back into my main page to the cart. I did this by using the existing cross sell procedure. What I would like now is to have an upsell/downsell item appearing as shown below.
|-------------------------------------------------------| | Product Name| |-------------------| | Extended Desc| |UpSell Item | | | Picture | | | | |-------------------| | Item Code| |DownSell Item | | Price| | | |-------------------------------------------------------| |cross sell 1 |cross sell 2 | cross sell 3|cross sell 4 | | | | | | | | | | | |-------------------------------------------------------| |Order Button |Reset Button |Hyperlinks| | |-------------------------------------------------------|
By using a field say pother4 or pother5 I would like to take a value from this field from the existing recordset displayed and run another query creating a second recordset much like the crosssell procedure to create upsell and downsell items. All of which can be shown in the form. Can anybody give me a pointer on how to start this as so far I have only acheived the cross sell results by updating existing procedures. My ASP is okay and I have tried creating procedures but I can't seem to tie the recordsets to one another, can anyone help me please????
leem |
|