I have an recordset that contains information for a retractable screen door. All the variables for the door are contained in the recordset. So the recordset has information for the style, color, height, width, etc. The recordset also has the information for the primary product, which in this case is the retractable screen door. The way the page is set up is that the client wants the primary product to have additional products that are associated with the main product on the same page. So you would have the door, you would select the options for the door, and then you could select additional products that are associated with that door like, a hinge, or screen, etc.
Here is where it gets complicated: for those other products associated with the main product, they are also complex products in that they have options you can select. So for the hinge, for example, you can select a grey hinge or black hinge, and it can be 2 inches or four inches.
All this information is dumped into a table that collects the main product id, the labels for all of the options, the values for all of the options and some other stuff.
I have a recordset that has values like the name of the product options and their value. It also has the product number of the product that it is attached to. I need to loop through the recordset so that I can create one string that has the name of the main product AND the product options AND the value for the product options. So it should look something like this:
I've already done this by creating a recordset and then looping through it and adding this after the while:
thelabel = thelabel & ([url removed, login to view]("thetest").Value) & "-"
this gave be a label that looks like this:
So, I'm half way there! The problem is that I need to loop through that recordset- or create another or something, so that I can look through and get ALL the values for EACH string. Make sense? So the original recorset has all the values and labels for each of the additional products. It's all in one recordset. So I need to loop through first and create the string for EACH product and then get that same string for each additional product. I hope that makes sense. It should look like this:
This should be real easy for a ASP and SQL guru. I'm just stuck and need to move on.
7 freelancers are bidding on average $86 for this job
serious bid. eleven years experienced asp developer. your project could be done in few [url removed, login to view] to start whenever you want. thanks
Hi, I can give you the solution as I have already worked in a similar kind of product selection using ASP.... Please let me know if you want to proceed. Thanks!