[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