Hi,
Can you advise me if your Multi Column Combo extension is the one I need to do this:
I'm building a shopping site, in the product edit (or new product) screen the administrator will be able to select which colours a product is available in by selecting Multiple selections from a list box (the contents of this list come from a database table of all available colours). I would like their choices to be saved into the database in a single field (i.e. 4,7,8 - where the number is the ID of the colour).
On the front end of the website customers will only see the colours selected as available for each product (I've done this bit by using SQL WHERE.. IN command).
This product edit (or new) screen will be using your ASP Upload and Resize extension to store the data in the database.
If I try just using a standard Dreamweaver Multiple Select List it generates an error when it writes to the database - also when you return to the edit screen it does not display which colours were previously highlighted.
Will your extension be suitable for this scenario - I don't actually need multiple columns just the ability to select multiple options and store them in the database then retrieve them when you edit that product.
The database is Access and the site is coded in ASP (VB Script).
Thanks. |
|
|