Too few parameters. Expected 6.

Guest_imported · Jun 14, 2000

Could someone take a look at this code and possibly tell me what is wrong? <% Dim DataConn Dim SQL1 Dim MYSQL PN = request.form("project_name&quot

UR = request.form("url&quot

CAT = request.form("category_id&quot

DUE = request.form("Due_Date&quot

Stat = request.form("status&quot

Note = request.form("notes&quot

Set DataConn = Server.CreateObject("ADODB.Connection&quot

Set SQL = Server.CreateObject("ADODB.Recordset&quot

DataConn.Open "DBQ=" & Server.Mappath("/Secure Employee DataBase/SecureEDB.mdb&quot

& ";Driver={Microsoft Access Driver (*.mdb)};" MYSQL = "INSERT INTO Projects (Project, URL, Category, DueDate, Status, Notes) VALUES (PN,UR,CAT,DUE,Stat,Note)" SQL.Open MYSQL, DataConn    %> This is the Error Message I recieve when I run this. ----------------------------------------------------------- Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 6. /Project.asp, line 44 ----------------------------------------------------------- P.S.> Why does it always report my error on a line (like line 44) that eithor doesn't exist or is a long way from where the actual code error occures, just wondering... John Vogel <a href=mailto:johnvogel@computerwiz.net>johnvogel@computerwiz.net</a> <a href=

http://johnvogel.homepage.com>My

Home Page</a> Check out

http://witness4christ.computerwiz.net

NickBulka · Jun 14, 2000

This error usually means you spelled field names wrong. nick bulka <a href=mailto: > </a> <a href= > </a>

vinodgk · Jun 14, 2000

Or this error means u have not filled up the compulsory feilds in ur Access database..try up with Nicks Soln..chk up ur fields name..or else change the compulsory fields..to non-compulsory.[i.e required->no] Regards Vinod

PMD · Jun 19, 2000

Check the field names in your database Check the variable name in your form page Then check them all again. I get this all the time 'coz I dont check things as I work through. PMD

Guest_imported · Jun 19, 2000

I am still not sure what the problem is, as I have tried all suggestions, looked at my table structure made sure there were no compulsory fields, checked, double checked then triple checked my fields, and nothing worked... so instead of using the UPDATE query I used the objRecordset.AddNew method, and it worked fine, so I don't have to worry about it now, just wondering what might have been the culprit. ASP, sheesh! John Vogel <a href=mailto:johnvogel@computerwiz.net>johnvogel@computerwiz.net</a> <a href=

http://johnvogel.homepage.com>My

Home Page</a> Jesus is the Way, the Truth, and the Life: 
Without the Way there is no going; 
Without the Truth there is no knowing; 
Without the Life there is no living. —Anon.

palbano · Jun 19, 2000

Dear John, The first thing I see is that you are calling the ADODB.Recordset object's 'Open' method with a SQL 'INSERT' query. This is not appropriate since an INSERT query does not return a rowset. You should use the connection objects 'Execute' method to run executable SQL statements. The next thing I see is the SQL statement, i.e.: >MYSQL = "INSERT INTO Projects (Project, URL, Category, DueDate, Status, Notes) VALUES (PN,UR,CAT,DUE,Stat,Note)" Then you use it like this: >SQL.Open MYSQL, DataConn The SQL statement is incorrect and will fail regardless of the application environment. You put your variables into the 'VALUES' clause of your SQL statement as though you expect them to be automatically expanded for you. Please notice that you just made a string value in a variable named 'MYSQL'. That string value is not going to be changed and is what is sent to the database engine. What you really need to have is something like this: "VALUES('" + PN + "'," + UR + "',".... etc, Text values are quoted and numeric values are not so if CAT is a number it would look like this: "VALUES('" + PN + "'," + UR + "'," + CAT + ",".... etc. Whatever the value of of 'MYSQL' is at the time you call open, you should be able to take that text and put it in a MS Accesss Query window and run it. The text you assign to 'MYSQL' above will not run in MS Access, so therefore it will not run in ADO and certainly does not have anything to do >ASP, sheesh! with ASP. I normally check all SQL statements in either Oracle, SQL Server or MS Access native environments prior to trying to code them in a development environment (C++, Java, ASP) so that I know what the SQL statement needs to contain before I tackle application development. Hope this helps -pete

wduty · Jun 22, 2000

Those variables are not being written into the string. You are sending the NAMES of the variables to the driver rather than their VALUES. Also SQL uses single quotes around strings and no quotes around numeric values, date objects and booleans. Try concatenating the string like this: MYSQL = "INSERT INTO Projects (Project, URL, Category, DueDate, Status, Notes) VALUES ('"&PN&"','"&UR&"',"&CAT&","&DUE&",'"&Stat&"','"&Note"&')" so that what the driver sees is: INSERT INTO Projects (Project, URL, Category, DueDate, Status, Notes) VALUES ('somevalue','somevalue',15,dateobject,'somevalue','somevalue') Again which values have single quotes depends on what the database fields are set as (that can be confusing especially with date objects. I you need a script which creates a valid ODBC dateobject format email me). Also as Pete pointed out above, you don't need a recordset because you're not reading anything. Just open the connection like you have it, set up your string, then try: DataConn.execute(MYSQL) -Will Duty

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Too few parameters. Expected 6.

Guest_imported

New member

NickBulka

Programmer

vinodgk

Programmer

PMD

Programmer

Guest_imported

New member

palbano

Programmer

wduty

Programmer

Similar threads

Part and Inventory Search

Sponsor