|
 |
access_asp thread: Too Few Parameters
Message #1 by jmendez@k... on Tue, 14 May 2002 21:50:20
|
|
Hopefully someone can help me with this one. I think that the solution is
probably pretty simple.
Thanks,
Jeff
Trying to process the code below and keep getting the following error on
the SET Subdv = Connect2.Execute command down below.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/detailSubdiv.asp, line 25
Coding Sample:
<HTML>
<BODY bgcolor="#FFFFFF" vlink=black>
<!-- #include file="SubdivHeader.inc" -->
<% ShowHeader("Subdivision Information") %>
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -
->
<%
Dim Connect2, Subdv, ItemNum
Dim strnum, strnam, strsfx, address
Dim lname, fname, fullname, ctr, objRS
Dim Connect3, Subdv2, NoResults, CheckNum
Set Connect2 = Server.CreateObject("ADODB.Connection")
Connect2.Open "Subdivision"
ItemNum = Trim(Request("Item"))
CheckNum = ItemNum
If ItemNum = "" Then
Response.Write "No Subdivision Number was sent.<p>"
Else
Set Subdv = Connect2.Execute("SELECT * FROM Subdivisions WHERE
SubdivisionNO=" & ItemNum)
ShowItem Subdv("SubdivisionNo"),Subdv("TMK"),Subdv("TMK2"),Subdv
("TMK3"),_
Subdv("WaterSystem"),Subdv("SubNameLocation"),Subdv
("AreaOwner"),Subdv("Surveyor")
Message #2 by "Jonathan Branam" <sspeare@y...> on Wed, 15 May 2002 01:58:16
|
|
Basically, you made an error in your SQL statement.
It might be: SubdivisionNo instead of SubdivisionNO
Because you use the lowercase one a few lines later.
-Jonathan
Message #3 by "Ken Schaefer" <ken@a...> on Wed, 15 May 2002 11:09:04 +1000
|
|
www.adopenstatic.com/faq/80040e10.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <jmendez@k...>
Subject: [access_asp] Too Few Parameters
: Hopefully someone can help me with this one. I think that the solution is
: probably pretty simple.
:
: Thanks,
: Jeff
:
: Trying to process the code below and keep getting the following error on
: the SET Subdv = Connect2.Execute command down below.
:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
: /detailSubdiv.asp, line 25
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
