SQL Statement Issue 1

[MMund]

I'm trying to get some information out of a couple of Access tables using a SQL statement, to wit:

' Retrieve all data from the Form
UUserID = Request.Form("XUserID")
UProjNo = Request.Form("XProjNo")
UProjName = Request.Form("XProjName")
UProjDesc = Request.Form("XProjDesc")
UProjCompDate = Request.Form("XProjCompDate") 
UCompApprovedBy = Request.Form("XCompApprovedBy") 
UStatusCode = Request.Form("XStatusCode") 
UProjRemarks = Request.Form("XProjRemarks")

mysql = "SELECT tblProjects.ProjectNo, tblProjects.ProjectName, tblUserValidation.strName, "
mysql = mysql & "tblUserValidation.StrEmail "
mysql = mysql & "FROM tblProjects INNER JOIN tblUserValidation ON tblProjects.Manager = tblUserValidation.UserID "
mysql = mysql & "WHERE tblProjects.ProjectNo = "& cint(UProjNo) 
'response.Write mysql
'response.End
rcset.Open mysql, objconn

The "U" variable values were all pulled from the previous page.

When I try to run this, I get the Object Required error with a '"' on the end

What am I doing wrong?

 

[gmmastros]

Try this...

'response.Write mysql
'response.End
[!]Set rcset = Server.CreateObject("ADODB.Recordset")[/!]
rcset.Open mysql, objconn

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MMund]

Thanks, that got me past that problem.