Too few parameters. Expected 1.

isaac2004 · Feb 19, 2006

hi am getting this error about a wrong field name in my database and it
all seems right to me

<%@ Language=VBScript %>
<% Option Explicit %>


<html>
<head><title>Product Page</title></head>
<table











<% Dim strSQL, objRS, intBookID, strItemType

'sql statement for individual books
strSQL = "SELECT tblBookDescription.ISBN,
tblBookDescription.strTitle, tblBookDescription.strDescription,
tblBookDescription.strPublisher, tblBookDescription.decPrice " & _
"FROM tblBookDescription; "

response.write("strSQL = " & strSQL)

Set objRS = Server.CreateObject("ADODB.Recordset")

---------------------------------------------------Too few parameters.
Expected 1.
objRS.open strSQL, objConn
-----------------------------------------------------------------
'response.write("strSQL = " & strSQL)

objRS.close
Set objRS = nothing
objConn.close
Set objRS = nothing

%>



</body></html>

that is all of the page that loads up, i got the SQL statement from
Access which is right and the syntax looks right, can somebody help me
please. thank you

Paxton · Feb 19, 2006

isaac2004 said:
hi am getting this error about a wrong field name in my database and it
all seems right to me

<%@ Language=VBScript %>
<% Option Explicit %>


<html>
<head><title>Product Page</title></head>
<table











<% Dim strSQL, objRS, intBookID, strItemType

'sql statement for individual books
strSQL = "SELECT tblBookDescription.ISBN,
tblBookDescription.strTitle, tblBookDescription.strDescription,
tblBookDescription.strPublisher, tblBookDescription.decPrice " & _
"FROM tblBookDescription; "

response.write("strSQL = " & strSQL)

Set objRS = Server.CreateObject("ADODB.Recordset")

---------------------------------------------------Too few parameters.
Expected 1.
objRS.open strSQL, objConn
-----------------------------------------------------------------
'response.write("strSQL = " & strSQL)

objRS.close
Set objRS = nothing
objConn.close
Set objRS = nothing

%>



</body></html>

that is all of the page that loads up, i got the SQL statement from
Access which is right and the syntax looks right, can somebody help me
please. thank you

Copy whatever strSQL produces in your browser, then go to the Queries
tab in Access, switch to SQL view and paste, then run the query. If you
get a dialogue box prompting for input, you need to check the column
names in your code against the database. You have probably mispelled
one or more of them.

/P.

Paxton · Feb 19, 2006

isaac2004 said:
hi am getting this error about a wrong field name in my database and it
all seems right to me

<%@ Language=VBScript %>
<% Option Explicit %>


<html>
<head><title>Product Page</title></head>
<table











<% Dim strSQL, objRS, intBookID, strItemType

'sql statement for individual books
strSQL = "SELECT tblBookDescription.ISBN,
tblBookDescription.strTitle, tblBookDescription.strDescription,
tblBookDescription.strPublisher, tblBookDescription.decPrice " & _
"FROM tblBookDescription; "

response.write("strSQL = " & strSQL)

Set objRS = Server.CreateObject("ADODB.Recordset")

---------------------------------------------------Too few parameters.
Expected 1.
objRS.open strSQL, objConn
-----------------------------------------------------------------
'response.write("strSQL = " & strSQL)

objRS.close
Set objRS = nothing
objConn.close
Set objRS = nothing

%>



</body></html>

that is all of the page that loads up, i got the SQL statement from
Access which is right and the syntax looks right, can somebody help me
please. thank you

On unrelated matters, you will get more errors when you've fixed the
field name one:

You've declared option explicit, and then dimmed two variables that
don't seem to be used in this code - intBookID, strItemType

and you've set the recordset to nothing twice. The second will
produce an object required error.

/P.

help type mismatch	6	Feb 17, 2006
error '80020009' help	2	Feb 27, 2006
help with using shopping cart totals	7	Feb 24, 2006
Syntax error (missing operator) in query expression	2	Feb 21, 2006
Characters found after end of SQL statement	5	Feb 20, 2006
Too few parameters. Expected 1.	9	Oct 20, 2004
help with database driven cart	3	Mar 7, 2006
html message help	2	Mar 12, 2006

Too few parameters. Expected 1.

isaac2004

Paxton

Paxton

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads