Solved

Linked list in combobox(pulldown menu)

Posted on 2002-07-16
11
332 Views
Last Modified: 2008-03-04
Got this problem with a double linked list.
I wonder if anyone has seen, got a "simple" example.

I've added a values from one table, looks like this.(has 2 columns)into a selectbox
ID|Musclegroup
0|Legs
1|Biceps
and so on...
This far I'am ok but how do I select the appropriate musclegroups into the next selectbox, choosing the right exercises.

Then I want to add all the ID values
into the next selectbox.
From the next table, it looks like this
ID|Exercise|Musclegroup|MusclegroupID
0|Legpress|Legs|0
1|Barbell curl|Biceps|1
3|Legcurl|Legs|0

Any info or help would be greatly appretiated.
Jon
jrh@telia.com

P.S
This is the loop for adding the musclegroups

     <tr>
          <td width="5" nowrap>&nbsp;</td>          
          <td nowrap align="left">Muskelgrupp</td>
         <td nowrap colspan="2">
               <select name="cboMuscleGroup" size="1" onChange="LaddaInMuscleGroup()">
               <%Do While Not rstGroup.EOF%>
                    <option value="<%=rstGroup("ID")%>"selected="">
                    <%=rstGroup("MuscleGroup")%>

                    </option>
     
               <%
                    rstGroup.MoveNext
                    loop
                    rstGroup.close
                    set rstGroup = nothing    
               %>
               </select>
               <input type="text" name="txtMuscleGroup" value="" size="20">
               <input type="text" name="txtMuscleGroupID" value="" size="5">

         </td>
          <td nowrap colspan="6">&nbsp;</td>
     </tr>
0
Comment
Question by:binhex
  • 6
  • 4
11 Comments
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 7157036
Here is a simple example that is completely client-side. However, I generate the array portion of this script server side by iterating through tables and using response.write to construct the arrays:

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
<SCRIPT LANGUAGE=javascript>
<!--

// Populate an array with all of the models from the different
// manufactures in the order that the manufacturers appear in the
// drop-down list. In this example, I'll use Ford and Toyota
// of course, you'll want to generate these via server-side vbscript

models = new Array(3)
models [0] = new Array(1)
models [1]= new Array(3)
models [2] = new Array(4)

//Empty (0)
models [0][0] = " "

//Ford  (3)
models [1] [0] = "Tempo"
models [1] [1] = "Tauras"
models [1] [2] = "Windstar"

//Toyota   (2)
models [2][0] = "Tercel"
models [2][1] = "Corolla"
models [2][2] = "Camry"
models [2][3] = "Avalon"


//============================================

//Next, we create a function to fill the second drop down from
//the array based on the item selected in the first drop down.

function FillList()
{
var num=document.formname.manufacturer.selectedIndex
var boxlength = 0

document.formname.models.selectedIndex = 0
for ( ctr=0;ctr<models[num].length;ctr++)
 {
 boxlength++;
 document.formname.models.options[ctr] = new Option(models[num] [ctr], models[num][ctr]);
 }

document.formname.models.length = boxlength;
document.formname.models.focus() ;

}


//-->
</SCRIPT>
</HEAD>
<BODY>
<FORM action="" method=post id=form1 name=formname>
<SELECT id=select1 name=manufacturer onChange="JavaScript:FillList()">
<OPTION value=""></OPTION>
<OPTION value=Ford >Ford</OPTION>
<OPTION value=Toyota>Toyota</OPTION>

</SELECT>

<p>
<SELECT id=select2 name=models>
<OPTION></OPTION>
</SELECT>

</FORM>
</BODY>
</HTML>


Fritz the Blank
0
 

Author Comment

by:binhex
ID: 7157090
Thanks fritz_the_blank for your quick answer

But the database records are dynamic, so I add new musclegroups and then need to add exercises according to the musclegroup

Thats why I got MusclegroupID in the second table (called tblExercise), the first is called tblMusclegroup

tblMusclegroup
ID|Musclegroup

tblExercise
ID|Exercise|Musclegroup|MusclegroupID
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 7157122
I understand that the tables are dynamic, so I generate the arrays from the tables. Here is an example:

<%
dim ojbConnectionJavaScript, objRSJavaScript

if not IsObject("ojbConnectionJavaScript") then
     set ojbConnectionJavaScript=Server.CreateObject("ADODB.Connection")
     strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;"_
                    + " Data Source= " & strDataPath & ";"_
                    + " Mode=Share Deny None;User Id=admin;PASSWORD=;"

     ojbConnectionJavaScript.ConnectionTimeout = 15
     ojbConnectionJavaScript.CommandTimeout =  10
     if ojbConnectionJavaScript.state = 0 then
          ojbConnectionJavaScript.Open strConnectString
     end if
end if

if not isObject("objRSJavaScript") then
     set objRSJavaScript=Server.CreateObject("ADODB.RecordSet")
end if
if objRSJavaScript.state <> 0 then
     objRSJavaScript.close
end if

Response.Write("<SCRIPT LANGUAGE=javascript>" & vbcrlf & "<!--" & vbcrlf)
dim strJavaSQL, numRecordCount, i

strJavaSQL = "select numRecordID, strDescription, strState from lu_FineRegion order by strState, strDescription"
objRSJavaScript.Open strJavaSQL,ojbConnectionJavaScript,adOpenKeyset,adLockOptimistic
numRecordCount = objRSJavaScript.RecordCount
Response.write("arrFine = new Array(" & numRecordCount*3 & ")" & vbcrlf)
for i =0 to numRecordCount - 1
     Response.Write("arrFine[" & i & ".1] = '" & objRSJavaScript("strState") & "'" & vbcrlf)
     Response.Write("arrFine[" & i & ".2] = '" & objRSJavaScript("numRecordID") & "'"  & vbcrlf)
     Response.Write("arrFine[" & i & ".3] = '" & objRSJavaScript("strDescription") & "'"  & vbcrlf)
     objRSJavaScript.movenext
next
objRSJavaScript.close

strJavaSQL = "select numRecordID, strDescription, strState from lu_CoarseRegion order by strState, strDescription"
objRSJavaScript.Open strJavaSQL,ojbConnectionJavaScript,adOpenKeyset,adLockOptimistic
numRecordCount = objRSJavaScript.RecordCount
Response.write("arrCoarse = new Array(" & numRecordCount*3 & ")" & vbcrlf)
for i =0 to numRecordCount - 1
     Response.Write("arrCoarse[" & i & ".1] = '" & objRSJavaScript("strState") & "'" & vbcrlf)
     Response.Write("arrCoarse[" & i & ".2] = '" & objRSJavaScript("numRecordID") & "'"  & vbcrlf)
     Response.Write("arrCoarse[" & i & ".3] = '" & objRSJavaScript("strDescription") & "'"  & vbcrlf)
     objRSJavaScript.movenext
next

if IsObject("objRSJavaScript") then
     if objRSJavaScript.state <> 0 then
          objRSJavaScript.close
     end if
     set objRSJavaScript = Nothing
end if
if IsObject("ojbConnectionJavaScript") then
     if ojbConnectionJavaScript.state <> 0 then
           ojbConnectionJavaScript.close
     end if
     set ojbConnectionJavaScript = Nothing
end if

Response.Write("//-->" & vbcrlf & "</SCRIPT>")
%>

Fritz the Blank
0
 

Author Comment

by:binhex
ID: 7157192
Hi again fritz_the_blank

It looks to complicated, I need it more clarified.
Bumping up the points a bit

Jon
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 7157235
A question before the clarification: does the javascript part of it make sense? If so, then the remaining problem is the creation of the arrays becuase the values in the tables are dynamic. If you like, I can explain how I use the above code to generate the arrays if that is the issue.

Fritz the Blank
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:binhex
ID: 7157265
I'am not any good at javascript, I've been programming VB with databases a lot.


0
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 400 total points
ID: 7157327
Here is an example where one drop down menu has a list of states while the second
has a list of companies for each state. Choosing a different state will generate
different companies in the second drop down menu. Both the states and the companies
come from tables in the database

<%
'start to generate the javascript dynamically:

Response.Write("<SCRIPT LANGUAGE=javascript>" & vbcrlf & "<!--" & vbcrlf)
dim strJavaSQL, numRecordCount, i

'Get a list of companies ordered by state and then by name from the database
strJavaSQL = "select numRecordID, strCompanyName, strState from tblCompanies order by strState, strCompanyName"
'open your recordset
objRSJavaScript.Open strJavaSQL,ojbConnectionJavaScript,adOpenKeyset,adLockOptimistic
'This portion will generate the array of companies by state. If you were to view the source of
'the page, it would look like this:

'arrCompanies = new Array(210)
'arrCompanies[0.1] = 'DC'
'arrCompanies[0.2] = '63'
'arrCompanies[0.3] = 'Donohoe'
'arrCompanies[1.1] = 'FL'
'arrCompanies[1.2] = '41'
'arrCompanies[1.3] = 'Kraft Const Co'
'arrCompanies[2.1] = 'FL'
'arrCompanies[2.2] = '43'
'arrCompanies[2.3] = 'Suffolk Const Co'
'arrCompanies[3.1] = 'MA'
'arrCompanies[3.2] = '40'
'arrCompanies[3.3] = 'Erland Const Co'
'arrCompanies[4.1] = 'MA'
'arrCompanies[4.2] = '42'
'arrCompanies[4.3] = 'Erland Const Co'
'arrCompanies[5.1] = 'MA'
'arrCompanies[5.2] = '1'
'arrCompanies[5.3] = 'Suffolk Const Co'
'
'and so forth. The idea here is that you are building your array dynamcially by iterating
'through your tables

numRecordCount = objRSJavaScript.RecordCount
Response.write("arrCompanies = new Array(" & numRecordCount*3 & ")" & vbcrlf)
for i =0 to numRecordCount - 1
      Response.Write("arrCompanies[" & i & ".1] = '" & objRSJavaScript("strState") & "'" & vbcrlf)
      Response.Write("arrCompanies[" & i & ".2] = '" & objRSJavaScript("numRecordID") & "'"  & vbcrlf)
      Response.Write("arrCompanies[" & i & ".3] = '" & objRSJavaScript("strCompanyName") & "'"  & vbcrlf)
      objRSJavaScript.movenext
next
'clear up your recordset and finish off the code.
objRSJavaScript.close
Response.Write("//-->" & vbcrlf & "</SCRIPT>")
%>
<SCRIPT LANGUAGE=javascript>
<!--
function initPage()
{
      getImages();
}
function fillList(strState)
{
      //depending on the parameter passed to this function, it will generate
      //a list of companies for the given state
      
      var iLength, ctr
      //clear out any old values in the list
      iLength=document.form1.numCompanies.length;
      document.form1.numCompanies.selectedIndex = 0;
      for(i=iLength;i>0;i--){
            document.form1.numCompanies.options[i] = null;
      }
      document.form1.numCompanies.length = 0      
      
      //generate the values of the second select based on the values of the first
      var boxlength = 0
      var numIndex = 0
      var numItems = arrCompanies.length/3
      document.form1.numCompanies.selectedIndex = 0
      for (ctr=0;ctr<numItems;ctr++){
            sState = eval("arrCompanies[" + ctr + ".1]")
            if(sState==strState){
                  boxlength++;
                  numIndex++;
                  strValue = eval("arrCompanies[" + ctr + ".2]")
                  strDispay =  eval("arrCompanies[" + ctr + ".3]")
                  document.form1.numCompanies.options[numIndex] = new Option(strDispay,strValue);
            }
       }

      document.form1.numCompanies.length = boxlength + 1;
      document.form1.numCompanies.focus() ;
}
//-->
</SCRIPT>

This is what the source for the whole page looks like when things are done:

<style>
h1,h2,h3,h4,h5,h6 {
      font-family:sans-serif;
      color:#003366;}

body {
      font: 6pt Arial, Helvettica;
      font-weight: bold;
      color:#003366;}
      
a:visited{color:blue}
</style>




<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
<script language="JavaScript" src="JavaScript/main.js"></script>
<SCRIPT LANGUAGE=javascript>
<!--
arrCompanies = new Array(210)
arrCompanies[0.1] = 'DC'
arrCompanies[0.2] = '63'
arrCompanies[0.3] = 'Donohoe'
arrCompanies[1.1] = 'FL'
arrCompanies[1.2] = '41'
arrCompanies[1.3] = 'Kraft Const Co'
arrCompanies[2.1] = 'FL'
arrCompanies[2.2] = '43'
arrCompanies[2.3] = 'Suffolk Const Co'
arrCompanies[3.1] = 'MA'
arrCompanies[3.2] = '40'
arrCompanies[3.3] = 'Erland Const Co'
arrCompanies[4.1] = 'MA'
arrCompanies[4.2] = '42'
arrCompanies[4.3] = 'Erland Const Co'
arrCompanies[5.1] = 'MA'
arrCompanies[5.2] = '1'
arrCompanies[5.3] = 'Suffolk Const Co'
arrCompanies[6.1] = 'MA'
arrCompanies[6.2] = '3'
arrCompanies[6.3] = 'Suffolk Const Co'
arrCompanies[7.1] = 'MA'
arrCompanies[7.2] = '4'
arrCompanies[7.3] = 'Suffolk Const Co'
arrCompanies[8.1] = 'MA'
arrCompanies[8.2] = '2'
arrCompanies[8.3] = 'Suffolk Const Co SPD'
arrCompanies[9.1] = 'MI'
arrCompanies[9.2] = '7'
arrCompanies[9.3] = 'Alberici'
arrCompanies[10.1] = 'MI'
arrCompanies[10.2] = '6'
arrCompanies[10.3] = 'Alberici'
arrCompanies[11.1] = 'MI'
arrCompanies[11.2] = '5'
arrCompanies[11.3] = 'Alberici'
arrCompanies[12.1] = 'MI'
arrCompanies[12.2] = '22'
arrCompanies[12.3] = 'Aristeo'
arrCompanies[13.1] = 'MI'
arrCompanies[13.2] = '20'
arrCompanies[13.3] = 'Aristeo'
arrCompanies[14.1] = 'MI'
arrCompanies[14.2] = '21'
arrCompanies[14.3] = 'Aristeo'
arrCompanies[15.1] = 'MI'
arrCompanies[15.2] = '25'
arrCompanies[15.3] = 'Barton Malow'
arrCompanies[16.1] = 'MI'
arrCompanies[16.2] = '24'
arrCompanies[16.3] = 'Barton Malow'
arrCompanies[17.1] = 'MI'
arrCompanies[17.2] = '23'
arrCompanies[17.3] = 'Barton Malow'
arrCompanies[18.1] = 'MI'
arrCompanies[18.2] = '26'
arrCompanies[18.3] = 'Campbell-Manix'
arrCompanies[19.1] = 'MI'
arrCompanies[19.2] = '27'
arrCompanies[19.3] = 'Campbell-Manix'
arrCompanies[20.1] = 'MI'
arrCompanies[20.2] = '18'
arrCompanies[20.3] = 'Christman'
arrCompanies[21.1] = 'MI'
arrCompanies[21.2] = '17'
arrCompanies[21.3] = 'Christman'
arrCompanies[22.1] = 'MI'
arrCompanies[22.2] = '9'
arrCompanies[22.3] = 'Clark'
arrCompanies[23.1] = 'MI'
arrCompanies[23.2] = '12'
arrCompanies[23.3] = 'CSM Group'
arrCompanies[24.1] = 'MI'
arrCompanies[24.2] = '13'
arrCompanies[24.3] = 'D&D Building'
arrCompanies[25.1] = 'MI'
arrCompanies[25.2] = '28'
arrCompanies[25.3] = 'DeMaria Building'
arrCompanies[26.1] = 'MI'
arrCompanies[26.2] = '29'
arrCompanies[26.3] = 'Ellis Don'
arrCompanies[27.1] = 'MI'
arrCompanies[27.2] = '14'
arrCompanies[27.3] = 'Elzinga & Volkers'
arrCompanies[28.1] = 'MI'
arrCompanies[28.2] = '31'
arrCompanies[28.3] = 'Etkin-Skanska'
arrCompanies[29.1] = 'MI'
arrCompanies[29.2] = '30'
arrCompanies[29.3] = 'Etkin-Skanska'
arrCompanies[30.1] = 'MI'
arrCompanies[30.2] = '15'
arrCompanies[30.3] = 'Etkin-Skanska'
arrCompanies[31.1] = 'MI'
arrCompanies[31.2] = '32'
arrCompanies[31.3] = 'Etkin-Skanska'
arrCompanies[32.1] = 'MI'
arrCompanies[32.2] = '16'
arrCompanies[32.3] = 'Etkin-Skanska'
arrCompanies[33.1] = 'MI'
arrCompanies[33.2] = '33'
arrCompanies[33.3] = 'Etkin-Skanska'
arrCompanies[34.1] = 'MI'
arrCompanies[34.2] = '39'
arrCompanies[34.3] = 'Granger'
arrCompanies[35.1] = 'MI'
arrCompanies[35.2] = '19'
arrCompanies[35.3] = 'Granger'
arrCompanies[36.1] = 'MI'
arrCompanies[36.2] = '34'
arrCompanies[36.3] = 'J.M. Olson'
arrCompanies[37.1] = 'MI'
arrCompanies[37.2] = '35'
arrCompanies[37.3] = 'Pumford Construction'
arrCompanies[38.1] = 'MI'
arrCompanies[38.2] = '11'
arrCompanies[38.3] = 'Rockford Construction'
arrCompanies[39.1] = 'MI'
arrCompanies[39.2] = '10'
arrCompanies[39.3] = 'Skillman'
arrCompanies[40.1] = 'MI'
arrCompanies[40.2] = '8'
arrCompanies[40.3] = 'Triangle'
arrCompanies[41.1] = 'MI'
arrCompanies[41.2] = '37'
arrCompanies[41.3] = 'Walbridge'
arrCompanies[42.1] = 'MI'
arrCompanies[42.2] = '38'
arrCompanies[42.3] = 'Walbridge'
arrCompanies[43.1] = 'MI'
arrCompanies[43.2] = '36'
arrCompanies[43.3] = 'Walsh Group'
arrCompanies[44.1] = 'VA'
arrCompanies[44.2] = '67'
arrCompanies[44.3] = 'Archer Western'
arrCompanies[45.1] = 'VA'
arrCompanies[45.2] = '44'
arrCompanies[45.3] = 'Beers Skanska'
arrCompanies[46.1] = 'VA'
arrCompanies[46.2] = '68'
arrCompanies[46.3] = 'Bovis Lend Lease'
arrCompanies[47.1] = 'VA'
arrCompanies[47.2] = '70'
arrCompanies[47.3] = 'Branch & Associates, Inc.'
arrCompanies[48.1] = 'VA'
arrCompanies[48.2] = '69'
arrCompanies[48.3] = 'Branch & Associates, Inc.'
arrCompanies[49.1] = 'VA'
arrCompanies[49.2] = '61'
arrCompanies[49.3] = 'Centennial'
arrCompanies[50.1] = 'VA'
arrCompanies[50.2] = '65'
arrCompanies[50.3] = 'Centex'
arrCompanies[51.1] = 'VA'
arrCompanies[51.2] = '53'
arrCompanies[51.3] = 'Charles E. Smith'
arrCompanies[52.1] = 'VA'
arrCompanies[52.2] = '46'
arrCompanies[52.3] = 'Clancy & Theys Const Co'
arrCompanies[53.1] = 'VA'
arrCompanies[53.2] = '47'
arrCompanies[53.3] = 'Dick Corporation'
arrCompanies[54.1] = 'VA'
arrCompanies[54.2] = '64'
arrCompanies[54.3] = 'DPR'
arrCompanies[55.1] = 'VA'
arrCompanies[55.2] = '52'
arrCompanies[55.3] = 'E.E. Reed'
arrCompanies[56.1] = 'VA'
arrCompanies[56.2] = '57'
arrCompanies[56.3] = 'Falls Church Const Co'
arrCompanies[57.1] = 'VA'
arrCompanies[57.2] = '48'
arrCompanies[57.3] = 'Hansel Phelps Const Co.'
arrCompanies[58.1] = 'VA'
arrCompanies[58.2] = '66'
arrCompanies[58.3] = 'Hitt Contracting'
arrCompanies[59.1] = 'VA'
arrCompanies[59.2] = '49'
arrCompanies[59.3] = 'Hourigan'
arrCompanies[60.1] = 'VA'
arrCompanies[60.2] = '50'
arrCompanies[60.3] = 'Jacobs Facilities'
arrCompanies[61.1] = 'VA'
arrCompanies[61.2] = '56'
arrCompanies[61.3] = 'Kfoury'
arrCompanies[62.1] = 'VA'
arrCompanies[62.2] = '62'
arrCompanies[62.3] = 'Manhattan'
arrCompanies[63.1] = 'VA'
arrCompanies[63.2] = '51'
arrCompanies[63.3] = 'Rector Construction'
arrCompanies[64.1] = 'VA'
arrCompanies[64.2] = '60'
arrCompanies[64.3] = 'S.R. Smoot'
arrCompanies[65.1] = 'VA'
arrCompanies[65.2] = '58'
arrCompanies[65.3] = 'Scott-Long'
arrCompanies[66.1] = 'VA'
arrCompanies[66.2] = '45'
arrCompanies[66.3] = 'Shockey Bros.'
arrCompanies[67.1] = 'VA'
arrCompanies[67.2] = '59'
arrCompanies[67.3] = 'Turner Construction'
arrCompanies[68.1] = 'VA'
arrCompanies[68.2] = '55'
arrCompanies[68.3] = 'Whiting-Turner'
arrCompanies[69.1] = 'VA'
arrCompanies[69.2] = '54'
arrCompanies[69.3] = 'Whiting-Turner'
//-->
</SCRIPT>
<SCRIPT LANGUAGE=javascript>
<!--
function initPage()
{
      getImages();
}
function fillList(strState)
{
      var iLength, ctr
      
      iLength=document.form1.numCompanies.length;
      document.form1.numCompanies.selectedIndex = 0;
      for(i=iLength;i>0;i--){
            document.form1.numCompanies.options[i] = null;
      }
      document.form1.numCompanies.length = 0      
      
      var boxlength = 0
      var numIndex = 0
      var numItems = arrCompanies.length/3
      document.form1.numCompanies.selectedIndex = 0
      for (ctr=0;ctr<numItems;ctr++){
            sState = eval("arrCompanies[" + ctr + ".1]")
            if(sState==strState){
                  boxlength++;
                  numIndex++;
                  strValue = eval("arrCompanies[" + ctr + ".2]")
                  strDispay =  eval("arrCompanies[" + ctr + ".3]")
                  document.form1.numCompanies.options[numIndex] = new Option(strDispay,strValue);
            }
       }

      document.form1.numCompanies.length = boxlength + 1;
      document.form1.numCompanies.focus() ;
}
//-->
</SCRIPT>
</HEAD>
<BODY onLoad="JavaScript:initPage()">
<font size=3>

</font>

<Table width=650 Border=0 cellpadding=0 cellspacing=3>
     <tr>
           <td colspan = 2 align = left><img src ="Graphics/header.gif"></td>
     </tr>
     <TR>
           <TD width=160 valign=top bgcolor="#003366">
                 <p>&nbsp;</p>
                 
            &nbsp;&nbsp;<a href ='Main.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Main','','Graphics/Main_on.gif',1)"><img name='Main' border='0' src='Graphics/Main_off.gif'><p></a>

            &nbsp;&nbsp;<a href ='Companies.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Companies','','Graphics/Companies_on.gif',1)"><img name='Companies' border='0' src='Graphics/Companies_off.gif'><p></a>

            &nbsp;&nbsp;<a href ='Mailings.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Mailings','','Graphics/Mailings_on.gif',1)"><img name='Mailings' border='0' src='Graphics/Mailings_off.gif'><p></a>

            &nbsp;&nbsp;<a href ='Reports.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Reports','','Graphics/Reports_on.gif',1)"><img name='Reports' border='0' src='Graphics/Reports_off.gif'><p></a>

            &nbsp;&nbsp;<a href ='Utilities.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Utilities','','Graphics/Utilities_on.gif',1)"><img name='Utilities' border='0' src='Graphics/Utilities_off.gif'><p></a>

            &nbsp;&nbsp;<a href ='Logout.asp' onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Logout','','Graphics/Logout_on.gif',1)"><img name='Logout' border='0' src='Graphics/Logout_off.gif'><p></a>

           </td>
           <td width=480 bgcolor="#E3E3E7">
                  <table>
                        <FORM action="ReportsDisplay.asp" method=POST id=form1 name=form1 onSubmit = "return validateReports()">
                       <tr>
                             <td colspan=2 align=center><font  face=Arial size=3>&nbsp;&nbsp;<b>Report Parameters</b></font></td>
                       </tr>
                       <tr>
                             <td colspan=2 align=Left><hr><font  face=Arial size=2>Required Parameters</font><hr></td>
                       </tr>
                      <TR>
                            <TD align = right>Start Date</TD>
                            <TD><INPUT type=text size=25 name=datStart value=''></TD>
                      </TR>
                      <TR>
                            <TD align = right>End Date</TD>
                            <TD><INPUT type=text size=25 name=datEnd value=''></TD>
                      </TR>
                      <TR>
                            <TD align = right>Sort Order</TD>
                            <TD><Select Name = 'numSortOrder'>
                              <Option Value = ''></Option>
                              <Option Value ='1'>Resume, Company, Date, Associate</Option>
                              <Option Value ='2'>Company, Resume, Date, Associate</Option>
                              <Option Value ='3'>Date, Associate, Resume, Company</Option>
                        </Select></TD>
                      </TR>
                       <tr>
                             <td colspan=2 align=Left><hr><font  face=Arial size=2>Optional Parameters</font><hr></td>
                       </tr>
                      <TR>
                            <TD align = right>Associate</TD>
                            <TD><Select Name = 'numAssociate'>
                              <Option Value = ''></Option>
                              <Option Value ='3'>Anderson, Jeff</Option>
                              <Option Value ='2'>Enes, Jr., Michael</Option>
                              <Option Value ='1'>Enes, Sr., Michael</Option>
                              <Option Value ='6'>Gambale, Kathy</Option>
                              <Option Value ='5'>Hixon, Chad</Option>
                              <Option Value ='4'>Zelazik, Peter</Option>
                        </Select></TD>
                      </TR>
                      <TR>
                            <TD align = right>State</TD>
                            <TD><Select Name = 'strState' onChange='javascript:fillList(this.value)'>
                              <Option Value = ''></Option>
                              <Option Value ='AL'>Alabama</Option>
                              <Option Value ='AK'>Alaska</Option>
                              <Option Value ='AB'>Alberta</Option>
                              <Option Value ='AS'>American Samoa</Option>
                              <Option Value ='AZ'>Arizona</Option>
                              <Option Value ='AR'>Arkansas</Option>
                              <Option Value ='BC'>British Columbia</Option>
                              <Option Value ='CA'>California</Option>
                              <Option Value ='CN'>Canada</Option>
                              <Option Value ='CZ'>Canal Zone</Option>
                              <Option Value ='CO'>Colorado</Option>
                              <Option Value ='CT'>Connecticut</Option>
                              <Option Value ='DE'>Delaware</Option>
                              <Option Value ='DC'>District of Columbia</Option>
                              <Option Value ='FL'>Florida</Option>
                              <Option Value ='GA'>Georgia</Option>
                              <Option Value ='GU'>Guam</Option>
                              <Option Value ='HI'>Hawaii</Option>
                              <Option Value ='ID'>Idaho</Option>
                              <Option Value ='IL'>Illinois</Option>
                              <Option Value ='IN'>Indiana</Option>
                              <Option Value ='IA'>Iowa</Option>
                              <Option Value ='KS'>Kansas</Option>
                              <Option Value ='KY'>Kentucky</Option>
                              <Option Value ='LB'>Labrador</Option>
                              <Option Value ='LA'>Louisiana</Option>
                              <Option Value ='ME'>Maine</Option>
                              <Option Value ='MB'>Manitoba</Option>
                              <Option Value ='MD'>Maryland</Option>
                              <Option Value ='MA'>Massachusetts</Option>
                              <Option Value ='MI'>Michigan</Option>
                              <Option Value ='MN'>Minnesota</Option>
                              <Option Value ='MS'>Mississippi</Option>
                              <Option Value ='MO'>Missouri</Option>
                              <Option Value ='MT'>Montana</Option>
                              <Option Value ='NE'>Nebraska</Option>
                              <Option Value ='NV'>Nevada</Option>
                              <Option Value ='NB'>New Brunswick</Option>
                              <Option Value ='NH'>New Hampshire</Option>
                              <Option Value ='NJ'>New Jersey</Option>
                              <Option Value ='NM'>New Mexico</Option>
                              <Option Value ='NY'>New York</Option>
                              <Option Value ='NF'>Newfoundland</Option>
                              <Option Value ='NC'>North Carolina</Option>
                              <Option Value ='ND'>North Dakota</Option>
                              <Option Value ='NT'>Northwest Territories</Option>
                              <Option Value ='NS'>Nova Scotia</Option>
                              <Option Value ='OH'>Ohio</Option>
                              <Option Value ='OK'>Oklahoma</Option>
                              <Option Value ='ON'>Ontario</Option>
                              <Option Value ='OR'>Oregon</Option>
                              <Option Value ='PI'>Pacific Islands</Option>
                              <Option Value ='PA'>Pennsylvania</Option>
                              <Option Value ='PE'>Prince Edward Island</Option>
                              <Option Value ='PQ'>Province of Quebec</Option>
                              <Option Value ='PR'>Puerto Rico</Option>
                              <Option Value ='RI'>Rhode Island</Option>
                              <Option Value ='SK'>Saskatchewan</Option>
                              <Option Value ='SC'>South Carolina</Option>
                              <Option Value ='SD'>South Dakota</Option>
                              <Option Value ='TN'>Tennessee</Option>
                              <Option Value ='TX'>Texas</Option>
                              <Option Value ='UT'>Utah</Option>
                              <Option Value ='VT'>Vermont</Option>
                              <Option Value ='VI'>Virgin Islands</Option>
                              <Option Value ='VA'>Virginia</Option>
                              <Option Value ='WA'>Washington</Option>
                              <Option Value ='WV'>West Virginia</Option>
                              <Option Value ='WI'>Wisconsin</Option>
                              <Option Value ='WY'>Wyoming</Option>
                              <Option Value ='YT'>Yukon Territory</Option>
                        </Select></TD>
                      </TR>
                      <TR>
                            <TD align = right>Company</TD>
                            <TD><Select Name = 'numCompanies'>
                              <Option Value = ''></Option>
                              <Option Value ='7'>Alberici</Option>
                              <Option Value ='6'>Alberici</Option>
                              <Option Value ='5'>Alberici</Option>
                              <Option Value ='67'>Archer Western</Option>
                              <Option Value ='22'>Aristeo</Option>
                              <Option Value ='20'>Aristeo</Option>
                              <Option Value ='21'>Aristeo</Option>
                              <Option Value ='24'>Barton Malow</Option>
                              <Option Value ='25'>Barton Malow</Option>
                              <Option Value ='23'>Barton Malow</Option>
                              <Option Value ='44'>Beers Skanska</Option>
                              <Option Value ='68'>Bovis Lend Lease</Option>
                              <Option Value ='70'>Branch & Associates, Inc.</Option>
                              <Option Value ='69'>Branch & Associates, Inc.</Option>
                              <Option Value ='27'>Campbell-Manix</Option>
                              <Option Value ='26'>Campbell-Manix</Option>
                              <Option Value ='61'>Centennial</Option>
                              <Option Value ='65'>Centex</Option>
                              <Option Value ='53'>Charles E. Smith</Option>
                              <Option Value ='18'>Christman</Option>
                              <Option Value ='17'>Christman</Option>
                              <Option Value ='46'>Clancy & Theys Const Co</Option>
                              <Option Value ='9'>Clark</Option>
                              <Option Value ='12'>CSM Group</Option>
                              <Option Value ='13'>D&D Building</Option>
                              <Option Value ='28'>DeMaria Building</Option>
                              <Option Value ='47'>Dick Corporation</Option>
                              <Option Value ='63'>Donohoe</Option>
                              <Option Value ='64'>DPR</Option>
                              <Option Value ='52'>E.E. Reed</Option>
                              <Option Value ='29'>Ellis Don</Option>
                              <Option Value ='14'>Elzinga & Volkers</Option>
                              <Option Value ='42'>Erland Const Co</Option>
                              <Option Value ='40'>Erland Const Co</Option>
                              <Option Value ='16'>Etkin-Skanska</Option>
                              <Option Value ='33'>Etkin-Skanska</Option>
                              <Option Value ='32'>Etkin-Skanska</Option>
                              <Option Value ='31'>Etkin-Skanska</Option>
                              <Option Value ='30'>Etkin-Skanska</Option>
                              <Option Value ='15'>Etkin-Skanska</Option>
                              <Option Value ='57'>Falls Church Const Co</Option>
                              <Option Value ='19'>Granger</Option>
                              <Option Value ='39'>Granger</Option>
                              <Option Value ='48'>Hansel Phelps Const Co.</Option>
                              <Option Value ='66'>Hitt Contracting</Option>
                              <Option Value ='49'>Hourigan</Option>
                              <Option Value ='34'>J.M. Olson</Option>
                              <Option Value ='50'>Jacobs Facilities</Option>
                              <Option Value ='56'>Kfoury</Option>
                              <Option Value ='41'>Kraft Const Co</Option>
                              <Option Value ='62'>Manhattan</Option>
                              <Option Value ='35'>Pumford Construction</Option>
                              <Option Value ='51'>Rector Construction</Option>
                              <Option Value ='11'>Rockford Construction</Option>
                              <Option Value ='60'>S.R. Smoot</Option>
                              <Option Value ='58'>Scott-Long</Option>
                              <Option Value ='45'>Shockey Bros.</Option>
                              <Option Value ='10'>Skillman</Option>
                              <Option Value ='4'>Suffolk Const Co</Option>
                              <Option Value ='1'>Suffolk Const Co</Option>
                              <Option Value ='3'>Suffolk Const Co</Option>
                              <Option Value ='43'>Suffolk Const Co</Option>
                              <Option Value ='2'>Suffolk Const Co SPD</Option>
                              <Option Value ='8'>Triangle</Option>
                              <Option Value ='59'>Turner Construction</Option>
                              <Option Value ='37'>Walbridge</Option>
                              <Option Value ='38'>Walbridge</Option>
                              <Option Value ='36'>Walsh Group</Option>
                              <Option Value ='55'>Whiting-Turner</Option>
                              <Option Value ='54'>Whiting-Turner</Option>
                        </Select></TD>
                      </TR>
                      <TR>
                            <TD align = right>Resume Code</TD>
                            <TD><INPUT type=text size=25 name=strResume value=''></TD>
                      </TR>
                      <TR>
                            <TD colspan = 2 align = center>
                                  <hr>
                                  <INPUT type="submit" value="View Report" id=submit1 name=submit1>
                                  <INPUT type="reset" value="Reset" id=reset1 name=reset1>
                                  <hr>
                            </TD>
                        </TR>
                        </FORM>
                  </table>
           </td>
     </TR>
</table>


</BODY>
</HTML>





0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 7159562
Any reason for the grade of "B"? Did this not do what you needed it to?

Fritz the Blank
0
 

Author Comment

by:binhex
ID: 7159730
I didn't use it, but you had put a lot of work into it.
Plus it may come in handy later on.

Thanks
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 7159799
Okay, then. I 'll post a note to community support to request a change, then.

Thank you,

Fritz the Blank
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7159921
binhex

Fritz the Blank asked me to chenge this grade to 'A'. He spend time on this solution and apparently it is workin gevenn if you don't use it ...

** Mindphaser - Community Support Moderator **
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now