ADODB.Fields error '800a0cc1'

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

/favourites/dynamic_pages/register_ok.asp, line 26

This apears when i try and test my register page...see the code that follows...:

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/connfavourites.asp" -->
<%
Dim rsSubmitConfirm__strUserName
rsSubmitConfirm__strUserName = "xyz"
if (Session("svUserName" <> "" then rsSubmitConfirm__strUserName = Session("svUserName"
%>
<%
set rsSubmitConfirm = Server.CreateObject("ADODB.Recordset"
rsSubmitConfirm.ActiveConnection = MM_connfavourites_STRING
rsSubmitConfirm.Source = "SELECT * FROM FavesMembers WHERE UserName = '" + Replace(rsSubmitConfirm__strUserName, "'", "''" + "'"
rsSubmitConfirm.CursorType = 0
rsSubmitConfirm.CursorLocation = 2
rsSubmitConfirm.LockType = 3
rsSubmitConfirm.Open()
rsSubmitConfirm_numRows = 0
%>
<%
Dim strRecipient
Dim strFirstName
Dim strLastNmae
Dim strUserNmae
Dim strPassword

strRecipient = rsSubmitConfirm.Fields.Item("Email".Value
strFirstName = rsSubmitConfirm.Fields.Item("FisrtName".Value
strLastName = rsSubmitConfirm.Fields.Item("LastName".Value
strUserName = rsSubmitConfirm.Fields.Item("UserName".Value
strPassword = rsSubmitConfirm.Fields.Item("Password".Value
%>

<%
Set JMail = Server.CreateObject("JMail.SMTPMail"

JMail.ServerAddress = "mail.favouritesonline.com"
JMail.ContentType = "text/html"
JMail.Sender = " "
JMail.subject = "Favouritesonline.com Registration"
JMail.AddRecipient strRecipient
JMail.Body = "<font face='arial' size ='3'>" &_
"Hello!" & strFirstName &""& strstrLastName &_
"<br>" &_
"Email conformation from favouritesonline.com" &_
"<br>" &_
"Here are your registration details:" &_
"<br>" &_
"Username:" & strUserName &_
"<br>" &_
"Password:" & strPassword &_
"<p>" &_
"Go to <a href='www.favouritesonline.com'>favouritesonline.com</a> to log in and get started..." &_
"<p>" &_
"Cheers," &_
"<br>" &_
"Admin Staff" &_
"<br>" &_
"Favouritesonline.com" &_
"</font>"

JMail.addHeader "Originating-IP",Request.ServerVariables("REMOTE_ADDR"
JMail.Execute
%>

Cheers ben

you get that error when you mistype one of your fields... just by glancing through your code, it might be this one:

strRecipient = rsSubmitConfirm.Fields.Item("Email".Value
strFirstName = rsSubmitConfirm.Fields.Item("<b>FisrtName</b>".Value
strLastName = rsSubmitConfirm.Fields.Item("LastName".Value

Joel Martinez

----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"

Joel Martinez...

Thanks a million...

Did the same thing with a actionscript in flash and it took another forum to point it out to me...what do u do?...lol

Thanks again,
Ben