Link to home
Start Free TrialLog in
Avatar of Graeme McGilvray
Graeme McGilvrayFlag for Australia

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of Manuel Flores
Manuel Flores
Flag of Spain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Graeme McGilvray

ASKER

OMG yes! haha! how terrible

Thanks!
Sometimes happens!!... thank you!