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.

Re: Mysql query is erratic 80 80

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

Re: Mysql query is erratic 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.