Welcome Guest, Not a member yet? Register   Sign In
active record error
#1

please help im trying to convert sql code to active record and its giving null value while in sql its working ci3 
Code:
SELECT
motorvehicletyperevenuepointchrage.IncomeTypeID,
motorvehicletyperevenuepointchrage.FeesID,
motorvehicletyperevenuepointchrage.ChargeID,
motorvehicletyperevenuepointchrage.AgencyID,
motorvehicletyperevenuepointchrage.RevenuePointID,
motorvehicle.MotorVehicleTypeEntryID,
motorvehiclecharge.Description,
motorvehiclecharge.AccountNumber,
officeunitbookaccount.OfficeUnitID
FROM
motorvehicle
INNER JOIN
motorvehicletyperevenuepointchrage
ON
motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID
INNER JOIN
motorvehiclecharge
ON
motorvehicletyperevenuepointchrage.ChargeID = motorvehiclecharge.ChargeID
INNER JOIN
officeunitbookaccount
ON
motorvehiclecharge.AccountNumber = officeunitbookaccount.AccountNumber
WHERE
motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID AND
motorvehicle.AgencyID = motorvehicletyperevenuepointchrage.AgencyID AND
motorvehicle.RevenuePointID = motorvehicletyperevenuepointchrage.RevenuePointID AND
motorvehicle.UVN = '1901/1907-04946'
Reply
#2

I'm not sure this is correct or not.
https://sql-to-ci-builder.herokuapp.com/

Code:
$this->db->select('motorvehicletyperevenuepointchrage.IncomeTypeID,motorvehicletyperevenuepointchrage.FeesID,motorvehicletyperevenuepointchrage.ChargeID,motorvehicletyperevenuepointchrage.AgencyID,motorvehicletyperevenuepointchrage.RevenuePointID,motorvehicle.MotorVehicleTypeEntryID,motorvehiclecharge.Description,motorvehiclecharge.AccountNumber,officeunitbookaccount.OfficeUnitID')
->from('motorvehicle')
->join('motorvehicletyperevenuepointchrage', 'motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID')
->join('motorvehiclecharge', 'motorvehicletyperevenuepointchrage.ChargeID = motorvehiclecharge.ChargeID')
->join('officeunitbookaccount', 'motorvehiclecharge.AccountNumber = officeunitbookaccount.AccountNumber')
->where('motorvehicle.MotorVehicleTypeEntryID', 'motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID', FALSE)
->where('motorvehicle.AgencyID', 'motorvehicletyperevenuepointchrage.AgencyID', FALSE)
->where('motorvehicle.RevenuePointID', 'motorvehicletyperevenuepointchrage.RevenuePointID', FALSE)
->where('motorvehicle.UVN', '1901/1907-04946')
->get();
Reply




Theme © iAndrew 2016 - Forum software by © MyBB