V
visualbasicide
I have two lists, one above the other, and they are BOTH populated
using vbscript and sql queries.
what I want to happen is when they select something in the top list
(departments) it refreshes the selections available in the bottom list
(individuals)
so in this case, if they select "IT"
then the bottom list will update itself to show only:
"me"
"follower1"
"follower2"
etc.
or if they select "Famous"
the bottom list will update itself to:
"Elvis"
"Dweezle"
"Parry Hotter"
I dont know how to programmatically check which option was selected.
if I can check that out, then I will be able to pull just the names out
of the database that I want.
or maybe set some value in the database for everyone in that
department.
but still that would depend on detecting what is currently selected.
can someone help me out?
heres a bit of the code:
VB:
--------------------------------------------------------------------------------
Sub GetDropDownValues1(dropdownname,tablename,columnname)
'Get the values for the ticketnumber from the database
Set objConn=Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.ConnectionString = connectionStr
objConn.Open
'Added: Replace function to avoid basic sql injection
strSQL = "SELECT * FROM " & Replace(tablename, "'", "''") & "'" & "
WHERE " & columnname & " = '" & dropdownvalue & "'"
Set objRS = objConn.Execute(strSQL)
Response.Write "<select name=" & dropdownname & ">"
Do While Not objRS.EOF
If objRS("technicianname") <> "myboss" Then
Response.Write "<option value=" & objRS("" & columnname & "id"
& "") & ">" & objRS("" & columnname & "name" & "") & "</option>"
End If
objRS.MoveNext
Loop
Response.Write "</select>"
objRS.Close
objConn.Close 'Added: Close before freeing resources
Set objRS = Nothing
Set objConn = Nothing
End Sub
ok, maybe to make this a little easier, I need a way to write in an
onclick event to call a function where I can check to see what the
selected value of that option is.
my thinking is that if I can check what <option selected> is, so I can
say, ok, this is IT, so on the next dropdown (before its actually
created) I can filter out anyone that isnt in that department.
my 2nd problem is how to actually update the page, again, my guess is
to just refresh the page when they select a department, and have it
check the selected value, and then display the names in the 2nd box
accordingly.
I heard also something about a session variable? I think this is what I
use to determine what department is currently logged on. but if there
is something similar I can use, to keep a variable in when i refresh
the page, that would be perfect.
if im not correct on this line of reasoning, please do help as I only
understand about half of what im doing and I make the rest up as I go
along, so while it works, its a painfully slow process.
using vbscript and sql queries.
what I want to happen is when they select something in the top list
(departments) it refreshes the selections available in the bottom list
(individuals)
so in this case, if they select "IT"
then the bottom list will update itself to show only:
"me"
"follower1"
"follower2"
etc.
or if they select "Famous"
the bottom list will update itself to:
"Elvis"
"Dweezle"
"Parry Hotter"
I dont know how to programmatically check which option was selected.
if I can check that out, then I will be able to pull just the names out
of the database that I want.
or maybe set some value in the database for everyone in that
department.
but still that would depend on detecting what is currently selected.
can someone help me out?
heres a bit of the code:
VB:
--------------------------------------------------------------------------------
Sub GetDropDownValues1(dropdownname,tablename,columnname)
'Get the values for the ticketnumber from the database
Set objConn=Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.ConnectionString = connectionStr
objConn.Open
'Added: Replace function to avoid basic sql injection
strSQL = "SELECT * FROM " & Replace(tablename, "'", "''") & "'" & "
WHERE " & columnname & " = '" & dropdownvalue & "'"
Set objRS = objConn.Execute(strSQL)
Response.Write "<select name=" & dropdownname & ">"
Do While Not objRS.EOF
If objRS("technicianname") <> "myboss" Then
Response.Write "<option value=" & objRS("" & columnname & "id"
& "") & ">" & objRS("" & columnname & "name" & "") & "</option>"
End If
objRS.MoveNext
Loop
Response.Write "</select>"
objRS.Close
objConn.Close 'Added: Close before freeing resources
Set objRS = Nothing
Set objConn = Nothing
End Sub
ok, maybe to make this a little easier, I need a way to write in an
onclick event to call a function where I can check to see what the
selected value of that option is.
my thinking is that if I can check what <option selected> is, so I can
say, ok, this is IT, so on the next dropdown (before its actually
created) I can filter out anyone that isnt in that department.
my 2nd problem is how to actually update the page, again, my guess is
to just refresh the page when they select a department, and have it
check the selected value, and then display the names in the 2nd box
accordingly.
I heard also something about a session variable? I think this is what I
use to determine what department is currently logged on. but if there
is something similar I can use, to keep a variable in when i refresh
the page, that would be perfect.
if im not correct on this line of reasoning, please do help as I only
understand about half of what im doing and I make the rest up as I go
along, so while it works, its a painfully slow process.