OMAR
|
Posted: 02/04/2002, 4:40 PM |
|
I need to do a search on range of records using Beg_date and End_date parameters.
I am using ASP, Access
thx
|
|
|
Nicole
|
Posted: 02/05/2002, 2:51 AM |
|
Omar,
Refer to CC tutorial "Building Database-Driven Event Management Website Using CodeCharge" available at: http://support.codecharge.com/tutorials.asp
There you'll find detailed description for search on date range.
|
|
|
OMAR
|
Posted: 02/05/2002, 12:50 PM |
|
Nicole,
I have done "almost" everything as in the event tutorial, however, i keep receiving an error from the DB driver; error msgs are:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/E_Quest/Common.asp, line 34 "
if you can point put what is I am doing wrong I would appriciate it
thx
|
|
|
Nicole
|
Posted: 02/06/2002, 1:09 AM |
|
Omar,
open generated code and put print sql code right after the line
sSQl = sSQL & sWhere & sOrder
response.write sSQL
Post here printed sql.
|
|
|
OMAR
|
Posted: 02/06/2002, 6:25 AM |
|
Ok Nicole,
I have figured out some of the problems thx 4 your help,however, I still continue to have a problem with the part where if dates are not entered then default to Create_Date >= date(), I inserted the line of code respond.write for sql and this is what i got:
select t.Create_Date as t_Create_Date, t.Requirement_ID as t_Requirement_ID, t.Short_Desc as t_Short_Desc from tblCR t AND Create_Date >= Date()
note: if Itake out the following lines, the error msg goes away
:
if getParam("start_date") & getParam("end_date") = "" then
sWhere = sWhere & "AND Create_Date >= Date()"
end if
|
|
|
|