求助 count

显示全部楼层 · 2006-2-11 01:55:47

统计shifouchuli=1记录的条数
用的是Access做数据库
其它查询、修改、删除都可以执行唯独这条显示为以下内容：
select count(id) a from x_xx where shifouchuli=1
Microsoft VBScript 编译器错误错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp，行242
Microsoft JET Database Engine 错误 '80040e14'
语法错误 (操作符丢失) 在查询表达式 'count(id) a' 中。
/test.asp，行102

请高手指点。

千问 · 2006-2-11 01:55:47

没人看吗？

千问 · 2006-2-11 01:55:47

select count(id) a from x_xx where shifouchuli=1 怎麽多了一個“a”?

千问 · 2006-2-11 01:55:47

那应该怎么写?

千问 · 2006-2-11 01:55:47

You can use cookies as below:

Welcome! This is the first time you are visiting this Web page.
You have visited this Web pagetimes before

千问 · 2006-2-11 01:55:47

You can also text file:

This page has been visited times.

--------------------------------------------------------------------------------------------------------------
This example reads a number from a file, adds 1 to the number, and writes the number back to the file.