Kapalı

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:

Retractable_Screen_Door-Color:Black-Height:120-Width:60-Style:Single

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:

Retractable_Screen_Door-Color:Black-Height:120-Width:60-Style:Single

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:

Retractable_Screen_Door-Color:Black-Height:120-Width:60-Style:Single

Door_Hinge-Size:Small-Color:Grey

Bottom_Rail-Height:120-Width:240-Color:Black

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ün: sql recordset product options, value options, up string, string problem, page problem, options guru, number guru, need sql help, m string, information guru, help guru, guru help, create page products, creating page, sql guru, problem name, move sql, make loop, labels product, get sql help, four page, creating sql, recordset, screen page, select page

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

Proje NO: #704430

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

shmai

have a glance at PM. Regards,

in 2 gün içinde200$ USD
(174 Değerlendirme)
6.9
guoxinliu917

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

1 gün içinde 150$ USD
(53 Değerlendirme)
6.5
softwarehandyman

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

1 gün içinde 50$ USD
(13 Değerlendirme)
3.9
ssanri

serious bid. eleven years experienced asp developer. your project could be done in few hours.free to start whenever you want. thanks

in 0 gün içinde50$ USD
(8 Değerlendirme)
3.7
realityfusion

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 fazlası

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0
mapssoft

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 0 gün içinde65$ USD
(0 Değerlendirme)
0.0
kristainholt

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

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0