Help with an ASP Page

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.

Beceriler: ASP, SQL

Daha fazlasını gör: sql recordset product options, where is guru, value options, up string, the string problem, string problem, page problem, options guru, number guru, need sql help, m string, information guru, help guru, guru help, get it guru, create on page for products, creating a page, sql guru, problem with name, move sql, make loop, labels for product, help name, get sql help, four page

İşveren Hakkında:
( 0 değerlendirme ) Los Angeles, United States

Proje NO: #704430

Bu iş için 7 freelancer ortalamada $86 teklif veriyor


have a glance at PM. Regards,

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(174 Değerlendirme)

Hello, I can do it for you. Please check my PMB. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(53 Değerlendirme)

See PMB for silly question that I hope clarifies your discussion.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)

serious bid. eleven years experienced asp developer. your project could be done in few [login to view URL] to start whenever you want. thanks

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

This is a pretty straight forward operation depending on the type of data-source your using should only take 10-30 minutes to get it resolved. I'm currently the head of IT for a national construction company and I work Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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!

in %bids___i_period_sub_35% gün içinde65%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Been working with classic ASP and SQL for years, should be easy to do.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)