kindly please check this expression

[ne3ro0]

good day,

kindly please check whats the problem with this SQL expression..

<%

sYear = request("year")

OpenDB sConnStats
sSQL = "SELECT Sum(TopIpsPerDay.Total) AS Ips, Sum(TopPageViewsPerDay.Total) AS Views, Format([TopIpsPerDay].[Date],'m') AS MonthNumber FROM TopIpsPerDay INNER JOIN TopPageViewsPerDay ON TopIpsPerDay.Date = TopPageViewsPerDay.Date GROUP BY Format([TopIpsPerDay].[Date],'m'), Format([topIpsPerDay].[Date],'yyyy') HAVING (((Format([topIpsPerDay].[Date],'yyyy'))="&sYear&"))"

rs.Open sSQL,,,adCmdTable

do while not rs.eof
%>

im getting this error:

Microsoft JET Database Engine error '80040e14'

Extra ) in query expression '(((Format([topIpsPerDay].[Date],'yyyy'))=))'.


i've been taking this for a day... please help...thanks...

[candelbc]

Are you sure that you're passing it the Year? It would appear that your sYear variable is blank.

I would Try "HAVING Year([topIpsPerDay].[Date]) =" & sYear & "))"

Let me know if that helps..

[edurran]

If you download MySQLcc you can paste the query into it directly and it should report your error.

Obviously you would have to replace your variables with values.

[ne3ro0]

Are you sure that you're passing it the Year? It would appear that your sYear variable is blank.

I would Try "HAVING Year([topIpsPerDay].[Date]) =" & sYear & "))"

Let me know if that helps..

i got same error.. the Extra (...etc...

[candelbc]

Instead of executing your SQL code, try doing a

Response.Write sYear

It sort of appears from the error above that the Variable contains no data or is Null.