syntax error near '='

sinapra · August 31st, 2004, 12:49 AM

Hi everyone

I am getting syntax error near '=' while running this query :

SELECT People.People, People.Name, Sum((ProjectStatusReport.Week),0,((ProjectStatusRe port.Week) = "1/1/2003",1,0))
AS Created, Sum((ProjectStatusReport.Week),0,(ProjectStatusRep ort.Week = "1/1/2004",(ProjectStatusReport.Accomplishments)
Or (ProjectStatusReport.Plans),0,1,0)) AS Complete, People.email FROM Register INNER JOIN SR_Status
ON Register.SR_Status = SR_Status.SR_Status LEFT JOIN ProjectStatusReport ON
Register.Register = ProjectStatusReport.Project INNER JOIN StakeHolders ON Register.Register = StakeHolders.Register
INNER JOIN People ON StakeHolders.People = People.People WHERE SR_Status.Status="Active"
AND StakeHolders.Status = "Yes" GROUP BY People.People, People.Name, People.email
HAVING Sum(ProjectStatusReport.Week),0,(ProjectStatusRepo rt.Week = "1/1/2003",1,0)>0 AND
Sum(ProjectStatusReport.Week),0,((ProjectStatusRep ort.Week) = "1/1/2004",(ProjectStatusReport.Accomplishments)
Or (ProjectStatusReport.Plans),0,1,0)>0 ORDER BY People.People

Can anyone help me
Regards

sinapra

qazi_nomi · August 31st, 2004, 01:05 AM

Could you tel us that on which = there is an error because in this code alot of = signs and one cannot find that where is the error

(*_*)

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

sinapra · August 31st, 2004, 01:10 AM

its at the first line,

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '='.

sinapra

charul_shukla · August 31st, 2004, 01:26 AM

Just try to replace all the double quotes (") with a single quote ('), if you were not using any ASP variable with in the query string, otherwise use the following syntax

strSQL1 = "SELECT imgurl, unitsale FROM bookstable where title LIKE '%" & keyword & "%' OR publisher LIKE '%" & keyword & "%' AND isbnno is not null AND status NOT LIKE '0' order by status ASC"

Charul Shukla

sinapra · August 31st, 2004, 01:37 AM

not helping in either way

sinapra

qazi_nomi · August 31st, 2004, 02:45 AM

Try to use this

SELECT People.People, People.Name,
Sum((ProjectStatusReport.Week),0,'(ProjectStatusRe port.Week) = "1/1/2003",1,0)')

(*_*)

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

sinapra · August 31st, 2004, 02:50 AM

Tried, it returned :
The Sum function requires 1 arguments.
Its taking it as single input i believe,

Regards

sinapra

happygv · September 3rd, 2004, 02:53 PM

Hi sinapra,

= is used in WHERE CLAUSE or in SELECT list only when defining aliases to user defined columns. Also I have never seen SUM function taking so many arguments as you have in there.

Can you explain on what you are trying to do here?

Sum((ProjectStatusReport.Week),0,((ProjectStatusRe port.Week)= "1/1/2003",1,0)) AS Created, Sum((ProjectStatusReport.Week),0,(ProjectStatusRep ort.Week = "1/1/2004",(ProjectStatusReport.Accomplishments)

Cheers!

_________________________
- Vijay G
Strive for Perfection