Solved

ADODB.Connection error '800a0bb9' - Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Posted on 2016-08-09
3
73 Views
Last Modified: 2016-08-10
Hi all, getting this error, however unsure why it would come up...

Set ItemBookings=oConn.Execute("SELECT * FROM enq_items,supplier_status WHERE item_status<>10 AND enq_ID="&Request.QueryString("enqview")&" AND supplier_land=item_status AND (Len(air_ID)>0 OR Len(land_ID)>0) ORDER BY item_depdate,item_deptime,item_type")
If Not ItemBookings.EOF Then
	Do Until ItemBookings.EOF
	If ItemBookings("item_type")=35 Then
		Set PackagePrice=oConn.Execite("SELECT * FROM enq_items WHERE enq_ID="&Request.QueryString("enqview")&" AND item_status<>10 AND item_package="&ItemBookings("item_ID"))
		If Not PackagePrice.EOF Then
			PPrice=0
			Do Until PackagePrice.EOF
				PPrice=PPrice+ItemBookings("item_gross")
			PackagePrice.MoveNext
				Loop
		End If
	End If
	ItemBookings.MoveNext
		Loop
End If

Open in new window


Error Line
Set PackagePrice=oConn.Execite("SELECT * FROM enq_items WHERE enq_ID="&Request.QueryString("enqview")&" AND item_status<>10 AND item_package="&ItemBookings("item_ID"))

Open in new window

0
Comment
Question by:Graeme
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
Manuel Flores earned 500 total points
ID: 41749379
Do you mean oConn.Execute ?
0
 

Author Closing Comment

by:Graeme
ID: 41749824
OMG yes! haha! how terrible

Thanks!
0
 
LVL 5

Expert Comment

by:Manuel Flores
ID: 41749928
Sometimes happens!!... thank you!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Call a function within the ASP code 4 31
Html value of radio 14 53
ASP and Looping Thru a XML Document 4 45
GitHub 1 36
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

737 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