error '80004005'
Unspecified error
/nhd/view1.asp, line 18
That is what I'm getting when trying to run a query from a database. The query runs fine in Access, I just import it out to ASP and call it my strSQL and now it's giving me this error. Here is my strSQL, please tell me what I'm doing wrong. Thanks.
Thanks for any help.Code:strSQL = "SELECT Evaluations.RecordID, Evaluator.Evaluator, Member.Member, Title.Title, Evaluations.Evaluation_Date, Evaluations.Greeting, Evaluations.Verification, Evaluations.Probing, Evaluations.Control, Evaluations.Language, Evaluations.Courtesy, Evaluations.Accuracy, Evaluations.Problem, Evaluations.Transition, Evaluations.Retention, Evaluations.Ethics, Evaluations.Explain, Evaluations.Score" strSQL = strSQL & " FROM Title RIGHT JOIN (Member RIGHT JOIN (Evaluator RIGHT JOIN Evaluations ON Evaluator.EvaluatorID = Evaluations.Evaluator) ON Member.MemberID = Evaluations.Member) ON Title.TitleID = Evaluations.Title" strSQL = strSQL & " WHERE Evaluations.RecordID = " & Request.QueryString("Record")




Reply With Quote