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

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

Graemewebber4technologiesAsked:
Who is Participating?
 
Manuel FloresConnect With a Mentor Commented:
Do you mean oConn.Execute ?
0
 
Graemewebber4technologiesAuthor Commented:
OMG yes! haha! how terrible

Thanks!
0
 
Manuel FloresCommented:
Sometimes happens!!... thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.