Hi There,
Have this bit of code here:
which seems to be producing the following error in conjuection with the last recordSet execute statement (have included the previous statement so you know where im getting the data from):
The 'key' field in the 'contestants' table is an AutoNumber and the 'key' field in the 'tempWin' table is a number. I know that when variables are created in ASP they are not assigned a variable type (Dim winKey), so when this error first started being thrown, i cast it as an integer as seen in code above.
Have even tried setting the last dbQuery1 to the following:
This had the same error.
Help anyone, please?
Cheers
ShotoCon
Have this bit of code here:
Code:
dbQuery1 = "SELECT key FROM tempWin"
Set recordSet = dbConnection.execute(dbQuery1)
Dim winKey
winKey=Cint(recordSet("key"))
dbQuery1 = "SELECT * FROM contestants WHERE key = '"&winKey&"'"
Set recordSet = dbConnection.execute(dbQuery1)
which seems to be producing the following error in conjuection with the last recordSet execute statement (have included the previous statement so you know where im getting the data from):
Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
The 'key' field in the 'contestants' table is an AutoNumber and the 'key' field in the 'tempWin' table is a number. I know that when variables are created in ASP they are not assigned a variable type (Dim winKey), so when this error first started being thrown, i cast it as an integer as seen in code above.
Have even tried setting the last dbQuery1 to the following:
Code:
SELECT * FROM contestants WHERE key = '"&recordSet("key")&"'
This had the same error.
Help anyone, please?
Cheers
ShotoCon