Begrænset udtræk fra DB
Håber på lidt hjælp med dette her:Jeg skal hente poster fra min db som skal være bestem af en bestemt dato rækkefølge.
Jeg bruger dette til at selecte dato, hvor der vælges startdato og slutdato:
<form method="POST" action="tekniker.asp">
<table border="0" width="100%">
<tr>
<td width="17%"><select size="1" name="fradato">
<option value="1.">1.</option>
<option value="2.">2.</option>
<option value="3.">3.</option>
<option value="4.">4.</option>
<option value="5.">5.</option>
<option value="6.">6.</option>
<option value="7.">7.</option>
<option value="8.">8.</option>
<option value="9.">9.</option>
<option value="10.">10.</option>
<option value="11.">11.</option>
<option value="12.">12.</option>
<option value="13.">13.</option>
<option value="14.">14.</option>
<option value="15.">15.</option>
<option value="16.">16.</option>
<option value="17.">17.</option>
<option value="18.">18.</option>
<option value="19.">19.</option>
<option value="20.">20.</option>
<option value="21.">21.</option>
<option value="22.">22.</option>
<option value="23.">23.</option>
<option value="24.">24.</option>
<option value="25.">25.</option>
<option value="26.">26.</option>
<option value="27.">27.</option>
<option value="28.">28.</option>
<option value="29.">29.</option>
<option value="30.">30.</option>
<option value="31.">31.</option>
</select></td>
<td width="17%"><select size="1" name="framaaned">
<option value="januar">januar</option>
<option value="februar">februar</option>
<option value="marts">marts</option>
<option value="april">april</option>
<option value="maj">maj</option>
<option value="juni">juni</option>
<option value="juli">juli</option>
<option value="august">august</option>
<option value="september">september</option>
<option value="oktober">oktober</option>
<option value="november">november</option>
<option value="december">december</option>
</select></td>
<td width="17%"><select size="1" name="fraaar">
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
</select></td>
<td width="17%"><select size="1" name="tildato">
<option value="1.">1.</option>
<option value="2.">2.</option>
<option value="3.">3.</option>
<option value="4.">4.</option>
<option value="5.">5.</option>
<option value="6.">6.</option>
<option value="7.">7.</option>
<option value="8.">8.</option>
<option value="9.">9.</option>
<option value="10.">10.</option>
<option value="11.">11.</option>
<option value="12.">12.</option>
<option value="13.">13.</option>
<option value="14.">14.</option>
<option value="15.">15.</option>
<option value="16.">16.</option>
<option value="17.">17.</option>
<option value="18.">18.</option>
<option value="19.">19.</option>
<option value="20.">20.</option>
<option value="21.">21.</option>
<option value="22.">22.</option>
<option value="23.">23.</option>
<option value="24.">24.</option>
<option value="25.">25.</option>
<option value="26.">26.</option>
<option value="27.">27.</option>
<option value="28.">28.</option>
<option value="29.">29.</option>
<option value="30.">30.</option>
<option value="31.">31.</option>
</select></td>
<td width="16%"><select size="1" name="tilmaaned">
<option value="januar">januar</option>
<option value="februar">februar</option>
<option value="marts">marts</option>
<option value="april">april</option>
<option value="maj">maj</option>
<option value="juni">juni</option>
<option value="juli">juli</option>
<option value="august">august</option>
<option value="september">september</option>
<option value="oktober">oktober</option>
<option value="november">november</option>
<option value="december">december</option>
</select></td>
<td width="16%"><select size="1" name="tilaar">
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
</select></td>
</tr>
</table>
<p> </p>
<p><input type="submit" value="Send" name="retter"></p>
</form>
Hvordan ændrer jeg min asp så der KUN hentes indenfor den angivne dato ?
asp'en herunder henter fra alle i reparb.
Mit datofelt i db'en hedder 'dato'
<%Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=c:\websider\service.dk\db\database.mdb"
Conn.Open DSN
set objRS = Conn.Execute ("SELECT sum(reparb) as arbusgmic FROM database where tekniker='"&("Michael Nielsen")&"'")
usg=objRS("arbusgmic")
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=d:\websider\global\comgrosinfo.dk\comgrosinfo.dk\db\comgrosreg.mdb"
Conn.Open DSN
set objRS = Conn.Execute ("SELECT sum(arb) as arbcommic FROM reparationer where tekniker='"&("Michael Nielsen")&"'")
com=objRS("arbcommic")
micarb=usg+com
response.write Round(micarb)
%>
