[thelist] ASP Database Problem. Any Ideas?

Bailey, Dan dbailey2 at healthaxis.com
Mon Sep 25 11:37:21 CDT 2000


Yeah, they are.  The question is: do they have to be in the order they're in
in the database?

-----Original Message-----
From: Tab Alleman [mailto:talleman at autobex.com]
Sent: Monday, September 25, 2000 12:04 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] ASP Database Problem. Any Ideas?


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 !


---------------------------------------
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