|
 |
asp_databases thread: Form Passed Parameters/Variables
Message #1 by "Jeffrey Ciesla" <JCiesla@o...> on Tue, 25 Apr 2000 12:22:17 -0400
|
|
I have a problem, I'm getting this error when passing information from a
form to an ASP page
with an update statement:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too
few parameters. Expected 8.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
I want to display the parameters on a page to make sure that the variables
are being passed correctly.
Is there a command either in VBScript or with ASP that will let me display
all the parameters that have
been passed from the pervious page to this one??
Thanks,
Jeffrey P. Ciesla
Information Technology
Oglebay Norton Company
http://www.oglebaynorton.com
Message #2 by "Pat Waddington" <paw@s...> on Tue, 25 Apr 2000 22:14:54 +0100
|
|
After you have built your sql statement for the UPDATE, use Response.Write
to display it. It's quite easy to spot what's wrong usually. If the syntax
is OK. look for ,, which indicates that you've got no data in the field,
which really upsets sql. 'Expected 8' probably means that the problem has
arisen in the eigth parameter in the list.
Chances are the root of the problem is in your form (no data entered in the
input field) or a hidden field being set up wrongly.
Good luck
Pat
----- Original Message -----
From: Jeffrey Ciesla
To: ASP Databases <asp_databases@p...>
Sent: Tuesday, April 25, 2000 5:22 PM
Subject: [asp_databases] Form Passed Parameters/Variables
I have a problem, I'm getting this error when passing information from a
form to an ASP page
with an update statement:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 8.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
I want to display the parameters on a page to make sure that the variables
are being passed correctly.
Is there a command either in VBScript or with ASP that will let me display
all the parameters that have
been passed from the pervious page to this one??
Thanks,
Jeffrey P. Ciesla
Information Technology
Oglebay Norton Company
http://www.oglebaynorton.com
Message #3 by "Ken Schaefer" <ken.s@a...> on Wed, 26 Apr 2000 11:14:59 +1000
|
|
<% For Each x In Request.Form %>
Request.Form( <%= x %> ) = <%= Request.Form(x) %> <BR>
<% Next %>
will look through the Request.Form collection and iterate all items. Replace
.form with .querystring if you want to access the Querystring collection.
Alternatively you could write in your own form elements if you just want to
check those, eg if you have text fields called t1, t2 and t3 on page1.asp
then on page2.asp you could do this:
t1 = <% =Request.Form("t1")%><br>
t2 = <% =Request.Form("t2")%><br>
t3 = <% =Request.Form("t3")%><br>
HTH
Cheers
Ken
----- Original Message -----
From: Jeffrey Ciesla
To: ASP Databases <asp_databases@p...>
Sent: Wednesday, April 26, 2000 2:22 AM
Subject: [asp_databases] Form Passed Parameters/Variables
I have a problem, I'm getting this error when passing information from a
form to an ASP page
with an update statement:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 8.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
I want to display the parameters on a page to make sure that the variables
are being passed correctly.
Is there a command either in VBScript or with ASP that will let me display
all the parameters that have
been passed from the pervious page to this one??
Thanks,
Jeffrey P. Ciesla
Information Technology
Oglebay Norton Company
http://www.oglebaynorton.com
Message #4 by "Stephen" <savoy6@e...> on Tue, 25 Apr 2000 21:40:16 -0500
|
|
Jeffrey,
Can you give a snippet of the code with the update statement?
Steve...
=====================================================
Jeffrey Ciesla wrote in message <2141@a..._databases>...
I have a problem, I'm getting this error when passing information from a
form to an ASP page
with an update statement:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 8.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
I want to display the parameters on a page to make sure that the variables
are being passed correctly.
Is there a command either in VBScript or with ASP that will let me display
all the parameters that have
been passed from the pervious page to this one??
Thanks,
Jeffrey P. Ciesla
Information Technology
Oglebay Norton Company
http://www.oglebaynorton.com
|
|
|
View Cart
