Unanswered: "Arguments are of the wrong type, are out of acceptable range...etc"
I'm relatively new to ASP work, I've been teaching myself from scratch for about 2 days now, and I've been able to do a lot of work with databses because of it, but now I am working on a web-interface to add in the data through forms instead of offline then uploading a very large DB to my server every few days.
However, when I submit my data, every time this error occurs:
"ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/addrelease.asp, line 41"
These are lines 39-41:
Line 40: Set rs = Server.CreateObject("ADODB.Recordset")
Line 41: rs.Open strSQLQuery, conn, 3, 3
I was basically copying another script I had found, and I thought all would be well. I converted intGameSize to a long int earlier in the code, so it fits the format used in the database. For a while I thought it might be because I sent "intGameSize" with ' at the beginning and end, but that was obviously wrong (used to working with C code, so it was worth a shot).
Can anybody give me a suggestion to what I'm doing wrong? I've tried having the code spit out exactly what is being sent, and this is the exact value of strSQLQuery:
INSERT INTO games (strName, strLink, intSize, strGenre) VALUES (Name of Game, edk2://, 5000, Arcade Classic)
Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard http://www.genericdb.com and then click on the Tips link to see an example