December 30th, 2012, 12:22 AM
How can I do this?
Ok I am helping a friend with a website for a local ski shop to sell online. I have done dynamic sites before and have managed to figure things out most of the time by searching....but I am really butting my head against the wall. Here is what I need to do.(I am using .ASP and Access DB)
On the admin side he will be able to input new inventory such as skis. Every brand has different lengths, If I create a multi-choice crop menu and insert that into the DB it gives me the following in one field in the DB...160 cm, 161 cm, 162 cm, 163 cm
Ok so how do I display that on the front end so it will allow them to select from an individual lengths that are available? I can only get it to return 160 cm, 161 cm, 162 cm, 163 cm when I query the DB.
Check this link to see what I am talking about on a front side. It lists the sizes that are available and allows it to be passed on
Elan Amphibio Waveflex 78 Ti Skis with ELX 11.0 Fusion Bindings 2013
thanks for the help..
December 31st, 2012, 01:52 PM
Any one? Or am I just not making clear what I am trying to accomplish?
January 1st, 2013, 07:00 PM
You aren't clear.
You are putting in 160 cm and getting out 160 cm. What's the problem?
Or do you mean you are inserting
160, 161, 162, 163
as a single entry, which would be the wrong way to do it?
Brinkster- free development account. Not affiliated, but I sure like free. Brinkster.com
January 2nd, 2013, 09:43 AM
If I understand correctly, you are saying that not all skis come in all lengths and therefore you don't want to display all lengths for all skis?
I have a similar script which has sizes for clothes, and not all clothes are available in all sizes. So, I have the sizes in one table, and the clothes in another, then I have a table that contains a link between the two
so, I select my clothes product, which then does a look up to see which sizes are available for that product and display them
Choose Size :
strSQL2 = "Select ProductSize from ProductSizes PS where SizeID in (select SizeID from SizeMap where ProductID =" & rs("Record_ID") & ") order by PS.SizeID "
do while not rs2.eof
January 3rd, 2013, 09:04 AM
publish you table structure It seems like it is SQL issue
if you found this post is useful click Give Rep button (bottom side on this reply ) and agree