|
xterradane -> More Problems, ugh... (12/15/2001 16:21:24)
|
I am still having problems, this is my error message: Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/webpub/JobSearchResultsAdd.asp, line 38
This is my script, error is on the open line.
<%
Dim strState, strJobType
strState = Request("State")
strJobType = Request("JobType")
Dim rsJob
Set rsJob = Server.CreateObject("ADODB.Recordset")
If Request("JobType") = "Any" AND Request("State") = "Any" Then
strSQL="SELECT * FROM Job WHERE DateExpries>= Date() ORDER BY DatePosted DESC;"
End If
If Request("JobType") <> "Any" AND Request("State") = "Any" Then
strSQL="SELECT * FROM Job WHERE DateExpries>= Date() AND JobType='" & strJobType & "' ORDER BY DatePosted DESC;"
End If
If Request("JobType") = "Any" AND Request("State") <> "Any" Then
strSQL="SELECT * FROM Job WHERE DateExpries>= Date() AND State='" & strState & "' ORDER BY DatePosted DESC;"
End If
If Request("JobType") <> "Any" AND Request("State") <> "Any" Then
strSQL="SELECT * FROM Job WHERE DateExpries>= Date() AND JobType='" & strJobType & "' AND State='" & strState & "' ORDER BY DatePosted DESC;"
End If
rsJob.Open strSQL, objConn
Thanks,
Gail
|
|
|
|
