error 800a000d

[Kwan]

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'count'

/niddkweb/table_stat_result.asp, line 75

I get this error when i give the following sql statement
mydb.dbSQL = " SELECT " & count(cond) &"from " & Session("Ti&#34

where cond = field that should be counted. For ex: cond may be empno,deptno which is generated depending on the table that the user choose to see the number of records.
Session("Ti&#34 = tablename which is imported here.

Any help is highly appreciated.
Thanks,
Kwan

[Oli Smith]

One error probably is because there is no space after count(cond) and before from. Why not just use "Select Count(*) from " & Session("Ti&#34



------------
Kwan at 4/19/00 11:18:06 AM

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'count'

/niddkweb/table_stat_result.asp, line 75

I get this error when i give the following sql statement
mydb.dbSQL = " SELECT " & count(cond) &"from " & Session("Ti&#34

where cond = field that should be counted. For ex: cond may be empno,deptno which is generated depending on the table that the user choose to see the number of records.
Session("Ti&#34 = tablename which is imported here.

Any help is highly appreciated.
Thanks,
Kwan