# Asp count()

**URL:** <https://forum.kirupa.com/t/asp-count/181317>\
**Category:** Uncategorized\
**Created:** [March 8, 2006, 9:36am UTC](https://forum.kirupa.com/t/asp-count/181317 "2006-03-08T09:36:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pucca](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@pucca](https://forum.kirupa.com/u/pucca)\
**Post date:** [March 8, 2006, 9:36am UTC](https://forum.kirupa.com/t/asp-count/181317/1 "2006-03-08T09:36:29Z")

</div>

Hi, I need to check a database for double entry on name and surname… For example, the same person can’t enter the competition. This is my code… Whats wrong?

```auto
rstotal.Open "Select COUNT(*) as total from comptbl WHERE cname='" & Request("name") & "' and csurname='" & Request("surname"), conn

```

Please help.  
Thanks!  
Its actually a sql question… oops. sorry…