getRow / array question (need help to expand my brain)

[josephweiss]

Here's my quandry

my bundles table

ID bottleTotal price
==========================
1 1 10.00
2 6 8.00
3 12 7.50



I want to create a quick and easy select list that looks like this...

<SELECT name="qtyANDprice" class="default">

<option value="1,10.00">1</option>
<option value="2,10.00">2</option>
<option value="3,10.00">3</option>
<option value="4,10.00">4</option>
<option value="5,10.00">5</option>
<option value="6,10.00">6</option>
<option value="7,8.00">7</option>
<option value="8,8.00">8</option>
<option value="9,8.00">9</option>
<option value="10,8.00">10</option>
<option value="11,8.00">11</option>
<option value="12,7.50">12</option>

</SELECT>

I am foggy as how to make this mappen. I think that I am looking up
the getRow/recordset to arry concept, but that is as far as I am.

I'm looking for a learning insight here... Thanks!

 

[Bob Barrows [MVP]]

Here's my quandry

my bundles table

ID bottleTotal price
==========================
1 1 10.00
2 6 8.00
3 12 7.50

Check out this article:
http://www.aspfaq.com/show.asp?id=2467

 

[Dave Anderson]

I want to create a quick and easy select list that looks like this...
<option value="1,10.00">1</option>
<option value="2,10.00">2</option>
<option value="3,10.00">3</option>
<option value="4,10.00">4</option>
<option value="5,10.00">5</option>
<option value="6,10.00">6</option>
<option value="7,8.00">7</option>
<option value="8,8.00">8</option>
<option value="9,8.00">9</option>
<option value="10,8.00">10</option>
<option value="11,8.00">11</option>
<option value="12,7.50">12</option> ...

Please tell me you are not depending on client-side code to set your prices,
and that this is for display purposes only.



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[joe...]

uhhh...

I have three different prices based upon qty.

1 to 5 = 10.00
6 to 11 = 8.00
12 + = 7.50

I just want to match those prices to qty on this drop down. I am
passing those values (price and qty) to another page.

i am selecting a recordset based upon a particular value, and my
bundles table then returns 3 recordsets

qty 1 price 10.00
qty 6 price 8.00
qty 12 price 7.50

I can't figure out how to seperate the prices into something and then
write them back into the drop list based upon the value of the qty.

Hope that makes sense.

Thanks