-2147217904

Paul,
what is the full error description?
Sergey Kornilov

Edit record [CD-ID: ARRAV0002]
--------------------------------------------------------------------------------
ASP error happened
Technical information

Error number -2147217904

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

URL /archivecd/tblMain_edit.asp

SQL query select [CD-ID],[CD-ID] ,ClientName ,DateArchived ,ArchiveType ,Volume ,VolumeTotal ,JobNumber ,Office ,OfficeAbv ,BusinessUnit ,BUAbv ,IDNumber from [tblMain] where [CD-ID]=ARRAV0002

Figured this one out.
I changed my field name from CD-ID to DiskID

I assume the hyphen was throwing it off.
Paul

Make sure the code for the "Create New" and "Edit" is creating the correct SQL statements on the edit page for each action. Somehow mine was pulling in a extra field for the create new action. I could edit and delete, but the new one would not work. I updated the code that ASPRunner made, taking out the extra field and it worked.
That extra field was from another table I was using in the same project.
Hope this helps.
RD

Sorry -- I registered after that last post. This has my e-mail.
RD

RD,
could you zip and send me your asp files along with sample database?

Just send it to support AT xlinesoft.com.
Best regards,

Sergey Kornilov

I have the same problem. The SQL statement has too many parameters because the code generated uses the fields from the wrong table. The generator window viewer looks OK though.
Has there been a fix on this?
James

James,
you can get more help if you post your error message and actual SQL query here.