I am trying to use 'check if record exists' function in ASPRunner 6.2 build 5242 with MySQL
The user enters their ref (AMCA_No) at login as their user name.
I need to check if they have completed registration before they join an event.
However when I try to get the data from the field AMCA_No I get the following error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'values'
The code I am using to test the function is below and I would appreciate any assistance.
'** Check if specific record exists ****
dim rsExists
set dal_table=dal.Table("Register")
set rsExists = dal_table.Query("AMCA_Number='90909'","")
if not rsExists.eof then
Response.Write "Yes'" & values("AMCA_No") & "'"
else
Response.Write "no"
end if
rsExists.Close : set rsExists = Nothing
