dropdown selection populates a table row

bucephalushtml · May 14, 2003

I have been trying for days to do the following:

User selects an option from a dropdown (populated by SQL db). That selection would in turn display a table row with data properties accosicated with the dorpdown selection. Then we need to allow the user to select another option from the dropdown and have those properties added to the table in another row after the first selection, and on and on. This all needs to happen on the same page.

I have about a dozen pages with different coding attempts. So I'm not sure if I have any code to post that would help. I'm pretty sure any code I posted would be more confusing than helpful.

Any sort of ideas would help, basic concepts, code snippets, anything I'm up against a brick wall.

Thanks!!

Bob C. I/T Department WYSAC

http://www.uwyo.edu/wysac

BDC2 · May 15, 2003

Can you give an example of what your drop down menu looks like?

Do you want a user to select from a drop down which inserts a new record into your database?

BDC.

mwolf00 · May 15, 2003

This code should help you. You need to create the javascript arrays in you asp code...

oldField = ""
arrayStr = ""
tempStr = ""
do while not rs.eof
if rs("mainField&quot

<> oldField then
if len(tempStr) > 0 then
arrayStr = mid(tempStr,1) & &quot

" 'peel off first comma and close parenthesis
end if
selectStr = selectStr & ",'" & rs("mainField&quot

& "'"
oldField = rs("mainField&quot

tempStr = vbcrlf & oldField & "Arr = new Array("
end if
tempStr = tempStr & ",'" & rs("detailField&quot

& "'"
rs.movenext
loop
if len(selectStr) > 0 then
selectStr = mid(selectStr, 1) 'peel off first comma
end if
if len(tempStr) > 0 then
arrayStr = mid(tempStr,1) & &quot

" 'peel off first comma and close parenthesis
end if

so your resulting HTML will look like this...
<script>
//selectArr = new Array(<%=selectStr%>) gives you the next line
selectArr = new Array("Breakfast","Lunch","Dinner&quot

//response.write (arrayStr) will give the following lines
BreakfastArr = new Array ("Ham and Eggs","Pancakes","Waffles","Cereal And Toast&quot

LunchArr = new Array ("BLT","Peanut Butter and Jelly","Grilled Cheese","Soup and Salad&quot

DinnerArr = new Array ("Pizza","Tacos","Hamburgers","Fried Chicken","Grilled Salmon","Lasagna&quot

function setSelect(){
for (x=0; x<selectArr.length; x++){
if (! document.myForm.mySelect.options[x + 1]){
document.myForm.mySelect.options[x + 1] = new Option()
}
document.myForm.mySelect.options[x + 1].value = selectArr[x]
document.myForm.mySelect.options[x + 1].text = selectArr[x]
}
}

function showVals(){
selectVal = document.myForm.mySelect.options[document.myForm.mySelect.selectedIndex].value
valueArr = eval(selectVal + "Arr&quot

tableNode = document.getElementById("displayTable&quot

newRow = document.createElement("tr&quot

for (x=0; x<valueArr.length; x++){
newTD = document.createElement("td&quot

newTD.innerHTML = valueArr[x]
newRow.appendChild(newTD)
}
tableNode.firstChild.appendChild(newRow)
}

</script>
<body onLoad="setSelect()">
<form name="myForm">
<select name="mySelect" onChange="showVals()"><option></select>
<br>
<table id="displayTable" border=1>
</table>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

bucephalushtml · May 15, 2003

BDC,

Dropdown code:
<select name="test_group">
<% While Not rsTestGroupGet.EOF %>
<option value="<%=rsTestGroupGet.Fields("test_group_id&quot

%>"<%If Request.Form("test_group&quot

= rsTestGroupGet.Fields("test_group_id&quot

Then Response.Write("selected&quot

%>><%=rsTestGroupGet.Fields("test_group_abbr&quot

%></option>
<% rsTestGroupGet.MoveNext
Wend%></select>

Table code:
<tr><td><%=Response.Write(rsSamples_TestGroupI.Fields("test_group_id&quot

)%></td></tr>
<tr><td><%=Response.Write(rsSamples_TestGroupI.Fields("test_group_abbr&quot

)%></td></tr>
<tr><td><%=Response.Write(rsSamples_TestGroupI.Fields("test_group_name&quot

)%></td></tr>
<tr><td><%=Response.Write(rsSamples_TestGroupI.Fields("lab_section_name&quot

)%></td></tr>
<tr><td><%=Response.Write(rsSamples_TestGroupI.Fields("sort_order&quot

)%></td></tr>

Now I don't know if this code will help in any way but you asked for some

dropdown:
test 1
test 2
test 3

Table:
Test# Test Name Test Group Sort#

User selects "test 1" and clicks "add" button. Test 1's attribuites are displayed in the table

test 1 (selected)

Test# Test Name Test Group Sort#
1 first test first group 1

Then user can select another test...

test 2 (selected)

Test# Test Name Test Group Sort#
1 first test first group 1
2 Second test second group 2

and on and on.

Now the dropdown is populated by the database and the attributes for the table are also called from the database.

At the end of it all the Selected tests are sent to a table in the database in the order finally listed in the table. It's just that simple right...

Thanks.

Bob C. I/T Department WYSAC

http://www.uwyo.edu/wysac

BDC2 · May 15, 2003

Sounds like you just need to remember what has been selected and in what order. How about writing the number of the option selected to a text file and appending the file with subsequent option numbers. So you will end up with a text file containing:

3
1
5

or delimited

3,1,5,

...for example.

You can use this to populate your table with every new selection and also to write to a new table in your database at the end.

You will need to use the filesystemobject for this. Read about it here:

http://www.4guysfromrolla.com/webtech/faq/FileSystemObject/faq1.shtml

Hope this helps,

BDC.

mwolf00 · May 15, 2003

The code I wrote does not need you to call the server again to populate table rows. All data is sent to the HTML page and used (as needed) by the javascript code. Did the code I wrote above work for you?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

bucephalushtml · May 16, 2003

mwolf00

I can see how the code can work, I'm struggling with getting all my info in. (might come with time), My big question would be how does the selections made get written to the database?

Bob C. I/T Department WYSAC

http://www.uwyo.edu/wysac

mwolf00 · May 19, 2003

To write the data to a database, you would have to store the selections and have the user submit them. I like the fact that each selection doesn't force a server call, but you may decide that having each selection entered into the db is more important than fewer server calls...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

dropdown selection populates a table row

bucephalushtml

Vendor

BDC2

Programmer

mwolf00

Programmer

bucephalushtml

Vendor

BDC2

Programmer

mwolf00

Programmer

bucephalushtml

Vendor

mwolf00

Programmer

Similar threads

Part and Inventory Search

Sponsor