Graeme McGilvray
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...
Error Line
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
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"))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sometimes happens!!... thank you!
ASKER
Thanks!