PCMech Forums - View Single Post - ASP

artsapimp · 01-16-2001, 01:04 PM

I know I have done this before when running some tutorial but I can't remember what I'm missing. I'm trying to find the number of records in a table where for a specific rep.

Code:

Dim intRecords

strSQL = "SELECT Count(*) AS intRecords, TicketNumber, Rep"
strSQL = strSQL = " WHERE Rep = " & Request.Form("Rep")

Thanks

01-16-2001, 01:04 PM	#1
artsapimp Member (10 bit) Join Date: May 1999 Location: Orlando, FL Posts: 975	I know I have done this before when running some tutorial but I can't remember what I'm missing. I'm trying to find the number of records in a table where for a specific rep. Code: Dim intRecords strSQL = "SELECT Count(*) AS intRecords, TicketNumber, Rep" strSQL = strSQL = " WHERE Rep = " & Request.Form("Rep") Thanks