Solved

What error is this??

Posted on 2001-06-13
16
202 Views
Last Modified: 2008-02-01
Hello,
 I am trying to make a small application.I have the main screen on which a form is displayed with a drop down box and a radio button.
 Once the user select the number from the drop down and clicks the radio button and submit, the  following script is to be executed.
 Now this refers to an access query where i am to pass two parameters.However when i execute the script with the following code:

<html>
<head>
 <title> Auction Details</title>
</head>

<body>
<%

 dim conn,rs,comm
 set comm=server.createobject("adodb.command")
 set conn=server.createobject("adodb.connection")
 set rs=server.createobject("adodb.recordset")

 conn.open "DSN=mydbase"

 comm.activeconnection=conn
 comm.commandtext="details"
 comm.commandtype=2

 comm.Parameters.Append comm.createparameter ("abc",adInteger,adparameterinput)

comm.parameters.append comm.createparameter("xyz",advarchar,adparameterinput)
comm.parameters(0).value=request.querystring("number")
comm.parameters(1).value=request.querystring("radio")
set rs=comm.execute

(PS this is just part of the script and i strongly feel that the error is coming from here.)

When i execute the script i get the following error:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/man/list.asp, line 26

Please help me resolve this problem
The datatypes in the database are
integer and text


0
Comment
Question by:smash81
  • 6
  • 6
  • 3
  • +1
16 Comments
 
LVL 20

Expert Comment

by:Silvers5
Comment Utility
1at.. if it's an access database you shouldn't pass parameters, besides what are you trying to do here?

do it this way

StrSQL = "INSERT INTO [Table name] (Fielad1,Field2) values(" & request.querystring("number")
 & ",'" & request.querystring("radio")
 & '")

conn.execute(StrSQL)

or StrSQL = "Select * From [TABLENAme] where [Numeric Field/ Numeric Column Name]=" & request.querystring("number") & " AND [Text Field/ Text Column Name]='" & request.querystring("radio") & "'"
Set rs = conn.Execute(StrSQL)



0
 
LVL 3

Expert Comment

by:dragosh
Comment Utility
if you are trying to execute a stored procedure you must set CommandType to adCmdStoredProc(=4)

and i think the names of your procedure's parameters are wrong : "abc" , "xyz" .. should be "@abc" and "@xyz"

and one more thing , method CreateParameter has 5 parameters :

command.CreateParameter (Name, Type, Direction, Size, Value)

0
 
LVL 20

Expert Comment

by:Silvers5
Comment Utility
Access doesn't support stored procedures..

0
 
LVL 3

Expert Comment

by:dragosh
Comment Utility
i know .. who is talking about Access ???
0
 
LVL 20

Expert Comment

by:Silvers5
Comment Utility
>Now this refers to an access query where i am to pass two parameters
0
 
LVL 3

Expert Comment

by:dragosh
Comment Utility
oh ... my mistake , next time i must read with more attention :)
0
 
LVL 3

Expert Comment

by:nigelrowe
Comment Utility
>Now this refers to an access query...

But does it mean MS Access, or, access in general?
0
 

Author Comment

by:smash81
Comment Utility
Yes it is an acess database.Does acess have some problems when you pass parameters?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 20

Expert Comment

by:Silvers5
Comment Utility
to what you're passing parameters? a macro?
0
 

Author Comment

by:smash81
Comment Utility
Yes it is an acess database.Does acess have some problems when you pass parameters?
0
 

Author Comment

by:smash81
Comment Utility
Its a query.
0
 

Author Comment

by:smash81
Comment Utility
Its a query.
0
 

Author Comment

by:smash81
Comment Utility
Its a query.
0
 
LVL 20

Accepted Solution

by:
Silvers5 earned 30 total points
Comment Utility
a view.. you want to fetch records from the query then do as I typed..

your way is to pass parameters to an SQL stored procedure!

what's the query name? details

then

StrSQL = "Select * From details where abc =" & request.querystring("number")
& " AND xyz='" & request.querystring("radio") & "'"
Set rs = conn.Execute(StrSQL)

I supposed abc is the numeric field in the query and xyz the text field
0
 

Author Comment

by:smash81
Comment Utility
Now i have tried using the command.parameters.refresh command and i am getting the following error


Microsoft OLE DB Provider for ODBC Drivers error '80040e51'

Provider cannot derive parameter information and SetParameterInfo has not been called


Now what is this????
0
 
LVL 20

Expert Comment

by:Silvers5
Comment Utility
:o/
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now