Unanswered: Need to use a Yes/No field in DB to filter recordset...
Dev tool: Dreamweaver MX
DB: Access 2000
Technology: ASP 2.0
OS: Win 2000
Language: VB Script
My Skill Level: Beginner
I'm writing a Timesheet Application that integrates QuickBooks 2002 with Access 2000. The Employees log-in online, fill out their timesheets, and that information is stored in Access. Once a week, the administrator runs a program that copies the timesheet info to QB, which is running on his desktop. At that time, it resets a flag in each record of the timesheets table that tells us it has been Processed (The Processed field stores a simple Yes/No).
So far, all this works without a hitch.
I'm having trouble with something simple. I need to create two different pages: one that returns all the new timesheet entries (Processed = "False") and another page that returns all the old timesheet entries for the past 31 days (Processed = "True" and DateTaught = "CurrentDate -31" or something like that).
Can someone take a look at this code (generated by Dreamweaver MX) and help me tweak it to return the ranges I need?
<!--#include file="../Connections/myConnection.asp" -->
RecsetTimesheets__MMColParam = "1"
If (Request.QueryString("CustomerTutorID") <> "") Then
RecsetTimesheets__MMColParam = Request.QueryString("CustomerTutorID")
Set RecsetTimesheets = Server.CreateObject("ADODB.Recordset")
RecsetTimesheets.ActiveConnection = MM_myConnection_STRING
RecsetTimesheets.Source = "SELECT * FROM Timesheets WHERE Tutor_CustomerTutorID = " + Replace(RecsetTimesheets__MMColParam, "'", "''") + " ORDER BY DateTaught ASC"
RecsetTimesheets.CursorType = 0
RecsetTimesheets.CursorLocation = 2
RecsetTimesheets.LockType = 1
RecsetTimesheets_numRows = 0
<table width="500" border="0" cellspacing="0" cellpadding="3">
<td class="formLabels"><p><span class="bigText">Current Timesheet</span></p>
<p> These items have not yet been processed, but will appear on your next
<td class="formLabels"> </td>