|
| |
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
 |
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
|
|
|
|
ginnie
Posts: 527
From: St. Louis MO USA
Status: offline
|
RE: More Problems, ugh... - 12/15/2001 16:47:36
In your SQL statements, you have "DateExpries" instead of "DateExpires" (typo error)
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
