Hi guys, i'm having this problem with COUNT.
Error Message : Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/newasiasalsa/dstudentcourse2.asp, line 17, column 28
rs.Open "SELECT COUNT(*)as "males" FROM studentOnCourse WHERE courseID = "& courseID &" AND gender = "Male"", conn, 3, 3
---------------------------^
this is my coding:
<%
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("db/db.mdb")
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open "SELECT COUNT(*)as "males" FROM studentOnCourse WHERE courseID = "& courseID &" AND gender = "Male"", conn, 3, 3
set rs=nothing
set conn=nothing
%>
i'm trying to input the count value into a table using this:
<td width="17%"><% Response.Write (males) %> </td>
please help. thanx alot in advance
Error Message : Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/newasiasalsa/dstudentcourse2.asp, line 17, column 28
rs.Open "SELECT COUNT(*)as "males" FROM studentOnCourse WHERE courseID = "& courseID &" AND gender = "Male"", conn, 3, 3
---------------------------^
this is my coding:
<%
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("db/db.mdb")
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open "SELECT COUNT(*)as "males" FROM studentOnCourse WHERE courseID = "& courseID &" AND gender = "Male"", conn, 3, 3
set rs=nothing
set conn=nothing
%>
i'm trying to input the count value into a table using this:
<td width="17%"><% Response.Write (males) %> </td>
please help. thanx alot in advance