Member Avatar for KE50

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
  • 136 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by KE50

Recommended Answers

All 2 Replies

Member Avatar for rch1231

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

Member Avatar for KE50

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

Edited by KE50 because: No completed typing
Be a part of the DaniWeb community

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