[thelist] ASP Database Problem. Any Ideas?

Bailey, Dan dbailey2 at healthaxis.com
Mon Sep 25 11:07:02 CDT 2000

Okay, here's my code:

LU = Request.Form ("URL")
LN = Request.Form ("prefix")
LB = Request.Form ("blurb")
LDA = Date

Set Connect = Server.CreateObject ("ADODB.Connection")
Connect.Open "Fonto"

SequelFunction = "INSERT INTO Links (LinkURL, LinkName, LinkBlurb,
DateAdded) VALUES (LU, LN, LB, LDA)"

Connect.Execute SequelFunction

And for some reason, it ain't working.  There's a 5th field in the database,
which is an AutoNumber, but here's the error message I'm getting:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

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

/addlink.asp, line 20 

Ideas, anyone?

More information about the thelist mailing list