My SQL Statment

This is my SQL Query, but I get the error message

Item cannot be found in the collection corresponding to the requested name or ordinal.

/spmanagerdownload/downloadadmin.asp, line 444

	strSQL = "SELECT tblUsers.username, tblUsers.userType, tblUsers.Timestamp, tblUsers.Email, tblUsers.ID FROM tblUsers WHERE tblUsers.userType = 'Trial v3' AND tblUsers.username like '"&request.querystring("letter")& "%' ORDER BY username"

Code (markup):

 

check the spelling of all of your variables. Look particularly at line 444, this error doesnt necessarily refer to your sql statement - this variable means that you are trying to call a variable that doesn't exist in your collection on line 444, which could be anything.

VG

 

most probably you're confused variables or table and field names. if check it again , you understand. it's a common mistake of everyone.

 

You my try it by replaceing '"Trial v3"'

. Did it solve your problem

 

I don't think that would be it, please provide the code where you reference the resultset, remember, it is case sensitive(column name)

 

This error message usually means the fieldname you specified in your SQL query doesnt exist in the table you're selecting data from. So make sure you have the following in tblUsers:

username, userType, Timestamp, Email and ID as fieldnames