how to do SQL query for rowcount in JSP
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   nadia_naz
Posted On:   Thursday, July 17, 2003 01:03 AM

how do i do an sql query to get the total rowcount for a certain column? for example: WHERE Comment = 0 in which i am suppose to get 4. i am using Microsoft Access database. then table name is Question currently i use this. SELECT Count(*) FROM Question WHERE (((Question.Comment)="0")); but i keep gettin tis error message SELECT Count(*) FROM Question WHERE (((Question.Comment)="0")); : null i hope u all can help me.Do icq me 172989538    More>>

how do i do an sql query to get the total rowcount for a certain column?
for example:

WHERE Comment = 0

in which i am suppose to get 4.

i am using Microsoft Access database.
then table name is Question

currently i use this.


SELECT Count(*)
FROM Question
WHERE (((Question.Comment)="0"));





but i keep gettin tis error message

SELECT Count(*) FROM Question WHERE (((Question.Comment)="0")); : null

i hope u all can help me.Do icq me


172989538

   <<Less
About | Sitemap | Contact