Jump to content

bairdb

Members
 View Profile  See their activity

  • Posts

    40

  • Joined

  • Last visited

 Content Type 

Everything posted by bairdb

  1. bairdb
    Is there anyway populate the array with values from a database?
  2. bairdb
    <body><form method="get" action="Test.asp">Region <select name="regn_nm" onchange="submit();"><option>GREAT LAKES REGION <option>MIDLAND REGION <option>MOUNTAIN REGION <option>NORTHWEST REGION <option>VALLEY REGION </select>Sales St<select name="sales_st_nm" onchange="submit();"><option>ARIZONA NORTH <option>ARIZONA SOUTH <option>MIDLAND CENTRAL <option>MIDLAND EAST <option>MIDLAND NORTH <option>MIDLAND WEST </select></form></body></html> This is what the html looks like after I make a selection. the first dropdown value starts as Great Lakes Region when a page loads. If I select an option in the Region box it will create the second dropdown with the Sales States that correspond with the region that was selected, but after the Sales States dropdown loads, the region dropdown value goes back to Great Lakes Region even if I selected something different. I just want the Region dropdown to keep the value I selected after the Sales State dropdown loads.
  3. bairdb
    I tryed that fix but it didn't keep the first selection after the page refreshed.
  4. bairdb
    The problem I am having is, when you select the first dropdown box and the second dropdown populates from depending first selection, the first dropdown doesn't keep the selection that was made it goes back to the first option in the dropdown. I am looking for a way to keep each selection that is made.
  5. bairdb
    I have put together the code below to create dependant dropdown boxes. Can anyone help me with some javascript so the page works the same but doesn't refresh every time a dropdown box changes? I am relatively new to javascript so the more spefic the better. ThanksBairdb <%set object=Server.CreateObject("ADODB.recordset")sql="SELECT DISTINCT REGN_NM FROM 2005_SSP ORDER BY REGN_NM"object.Open sql,connREGN_NM=Trim(request("regn_nm"))%><a href="Test.asp">Refresh</a><form method="get" action="Test.asp">Region <select name="regn_nm" onchange="submit();"><% do until object.EOF response.Write("<option") If object.fields("regn_nm") = regn_nm then response.write(" selected") end if response.Write(">") response.Write(object.fields("Regn_NM")) object.Movenextloopobject.Closeset object=Nothing%> </select><%If regn_nm<>"" thensql="SELECT DISTINCT SALES_ST_NM FROM 2005_SSP WHERE REGN_NM='"& regn_nm &"' ORDER BY SALES_ST_NM"set object=Server.CreateObject("ADODB.Recordset")object.Open sql,connSALES_ST_NM=Trim(request("sales_st_nm"))%>Sales St<select name="sales_st_nm" onchange="submit();"><% do until object.EOF response.Write("<option") If object.fields("sales_st_nm") = sales_st_nm then response.write(" selected") end if response.Write(">") response.Write(object.fields("sales_st_nm")) object.Movenextloopobject.Closeset object=Nothing%></select><%End If%><%If sales_st_nm<>"" thensql="SELECT DISTINCT DST_CD FROM 2005_SSP WHERE SALES_ST_NM='"& sales_st_nm &"' ORDER BY DST_CD"set object=Server.CreateObject("ADODB.Recordset")object.Open sql,connDST_CD=Trim(request("dst_cd"))%>Distict <select name="dst_cd" onchange="submit();"><% do until object.EOF response.Write("<option") If object.fields("dst_cd") = dst_cd then response.write(" selected") end if response.Write(">") response.Write(object.fields("dst_cd")) object.Movenextloopobject.Closeset object=Nothing%></select><%End If%></form><%If dst_cd<>"" thensql="TRANSFORM Sum([2005_SSP].PREMIUM_TOTAL) AS SumOfPREMIUM_TOTAL SELECT [2005_SSP].REGN_NM, [2005_SSP].SALES_ST_NM, [2005_SSP].DST_CD, [2005_SSP].LGCY_LINE_TYP_DESC FROM 2005_SSP WHERE Dst_Cd='"& dst_cd &"' GROUP BY [2005_SSP].REGN_NM, [2005_SSP].SALES_ST_NM, [2005_SSP].DST_CD, [2005_SSP].LGCY_LINE_TYP_DESC PIVOT [2005_SSP].YR_MO;"set object=Server.CreateObject("ADODB.Recordset")object.Open sql,conn%><table width="100%"><tr><th>Region</th><th>Sales State</th><th>District</th><th>Line</th><th>Jan</th><th>Feb</th><th>Mar</td><th>Apr</td><th>May</td><th>Jun</td><th>Jul</td><th>Aug</td><th>Sep</td></tr><%do until object.EOF%><tr><%for each x in object.Fields%><td><%Response.Write Ucase(x.value)%></td><%nextobject.MoveNext%></tr><%loopobject.close%></table>
  6. bairdb
    How do you create links in an access database that can be used when displayed on an asp page?
  7. bairdb
    What I am trying to do is I have a database that has percentages for the values. And when I display the data if the number from the database is greater than 100% I want it to turn red and if it is less than 100% I want it to turn green. Is it even possible?
  8. bairdb
    Is it possible to make the condition something other than characters? Say I want it to be greater than 100%?
  9. bairdb
    Is it possible to conditionally format data that is being displayed in an html table from and access database? example: if a cell is greater than 100 the text turns red.ThanksBaird
  10. bairdb

    Linking combo boxes

    bairdb posted a topic in ASP

    I was wondering if anyone knows how to link combo boxes, that are populated from an access database, so if you click on a choice in one combo box it will display the associated data in the second combo box.
×
×
  • Create New...