0

Hello all,

I am new to MYSQL programming, although i have been working with MSSQL for a while now.
I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it

Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight,
BLTariffAmount, BLFuelLevy, BLVAT, BLInsurance,
BLTariffAmountUSD, BLFuelLevyUSD, BLVATUSD, BLInsuranceUSD, RCity,
BLLinehaul
From BLOutbound
where BLAccount = :BLAccount and BLShipmentType = :BLShipmentType and BLProcessed = 0 and
BLLinehaulEntered=1

If I remove the part " and BLLinehaulEntered=1", the query works

Just do not know what is wrong with this

Am using MySQL client version: 5.1.41

Please assist.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by KE50
0

It is not easy to tell what is wrong with out the information on the table you are pulling from however your query shows a field called BLLinehaul but you don't reference one called BLLinehaulEntered

0

Thanks for the reply, but there was nothing wrong with the query, just the values passed to the parameters.

Edited by KE50: No completed typing

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.