[AnicoJoe]

I'm running javascript client side over a Lan. I want to run write the results from a form into an Access 97 db.

I am currently getting the following error: "No Value given for one or more required parameters." However, I added an alert message to confirm sql statement and its values were correctly being sent.

I'm now starting to think there is something wrong with my 'rst.open' statement. I'm rather new to this and learning as I go. Can someone plz tell me what I am missing?

Code:

<SCRIPT type=text/javascript>

function CheckPassword(){
var polnum
var appnam
var relshp
var rst
var conn
var sql

polnum = document.main.PWD1.value;
appnam = document.main.appnam.value;
relshp = document.main.relshp.value;

rst = new ActiveXObject("ADODB.Recordset");
conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\server\\folder\\TESTDB.mdb");
sql = "INSERT INTO TBL_REFERRALS (REFNO, APPNAME, UWRTR) VALUES (" + polnum + ", " + appnam + ", " + relshp + ")";
alert(sql);

rst.Open (sql, conn, 1, 3);

alert("It worked!!");

rst.Close;
conn.Close;
}

</SCRIPT>

[jfulton]

I've never really worked with ActiveXObjects via Javascript before, but that error makes it sound like it is either a malformed sql statement, or there is a required field in your database table that is not getting a value. Make sure that everything is in the proper format (strings are quoted, etc. - at least I think they have to be in Access, right?) and that you are not missing any required fields from your query.

[TwoD]

I've not seen this error before with that object...
Check out the MSDN Library, maybe it will have the answer..
Threre might be somehting about this near "Win32 and COM Development > Data Access and Storage > Microsoft ActiveX Data Objects (ADO) > ADO Programmer's Reference > ADO API Reference > ADO Objects and Interfaces"
Or try searching for "ADODB.Recordset"