[thelist] ASP Database Problem. Any Ideas?

Tab Alleman talleman at autobex.com
Mon Sep 25 11:23:30 CDT 2000

Check the actual field names in your database and make sure they really are:
LinkURL, LinkName, LinkBlurb, DateAdded

This error usually means you got a misspelled field name.

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Bailey, Dan
Sent: Monday, September 25, 2000 11:45 AM
To: 'thelist at lists.evolt.org'
Subject: [thelist] ASP Database Problem. Any Ideas?

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?

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list