Hello there can anyone help me with ASP?

Question

Hi there, i am developing a database system using ASP and MS Access as database.One of the pages is showing error like this when i try to link it with another page:

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/fidelio/edit_buyer_product_form.asp, line 13

Browser Type:

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)

Page:

GET /fidelio/edit_buyer_product_form.asp

Can anyone help me?

Answer 1

Could be for various reasons. The most probable and common problem is that you have misspelled something... a column name for example.

Review the generated query that causes this problem:

* Check for spelling mistakes.

* Enclose special words e.g. order, date, int inside square brackets

e.g.

SELECT [Order] FROM [Table]

* Also make sure you single-quote the strings properly

e.g.

WHERE Field1 = 'Value1' is correct

WHERE Field1 = Value1 is incorrect and will generate the above error

Answer 2

Java tutorials-http://aboutjava.org/