[Help] Database Error

[djharbi2]

Hi, I want to print the matching value but I can't 

Can you help, thank you ...

server.Lua

local vehDB = dbConnect( 'sqlite', 'vehicle.db' )
dbExec(vehDB,' CREATE TABLE IF NOT EXISTS `vehicle_base` (pAcc, vehicleID, vehicleName, vehiclePrice, vehicleStatus, vehicleHP)')

function dategetV()
local results = dbPoll(dbQuery(vehDB, "SELECT * FROM `vehicle_base` WHERE vehicleID=? AND pAcc=?",520,getAccountName(getPlayerAccount(source))), -1) 
 if results then 
            for k,v in ipairs ( results ) do 
            outputDebugString(tostring(v['vehicleHP']))
        end 
    end 
end
addEvent("dategetV", true)
addEventHandler("dategetV", getRootElement(getThisResource()), dategetV)

Edited July 30, 2019 by djharbi2

[djharbi2]

no help, I think

[HassoN]

@djharbi2

What do you mean by the matching value? Explain your issue better so we can assist you.

[djharbi2]

want to pull the vehicleHP value of the matching person

For example:
djharbi, 520, infernus, 100, good,1000 (This is a sample data)

The data I want > 1000 (vehicleHP)
 

[HassoN]

3 hours ago, djharbi2 said:

want to pull the vehicleHP value of the matching person

For example:
djharbi, 520, infernus, 100, good,1000 (This is a sample data)

The data I want > 1000 (vehicleHP)
 

That's exactly what your code does. So what's your issue? Nothing prints out even if the value exists in the database?

[djharbi2]

yes that's exactly the problem

[HassoN]

1 hour ago, djharbi2 said:

yes that's exactly the problem

At line 5, use tostring(520) instead of 520.

[djharbi2]

problem persists

[HassoN]

2 minutes ago, djharbi2 said:

problem persists

Your code seems fine to me. Try to install DB browser to check if all the values really exist in your database.

[djharbi2]

If you recreate the above code, I would be glad, you can do it

[HassoN]

19 minutes ago, djharbi2 said:

If you recreate the above code, I would be glad, you can do it

local vehDB = dbConnect("sqlite", "vehicle.db")
dbExec(vehDB, "CREATE TABLE IF NOT EXISTS vehicle_base (pAcc TEXT, vehicleID TEXT, vehicleName TEXT, vehiclePrice TEXT, vehicleStatus TEXT, vehicleHP TEXT)")

function dateGetV()
	local accName = getAccountName(getPlayerAccount(source))
	local qh = dbQuery(vehDB, "SELECT * FROM vehicle_base WHERE vehicleID=? AND pAcc=?", "520", accName)
	local result = dbPoll(qh, -1)
	if result then
		for _, row in ipairs(result) do 
			outputDebugString(row["vehicleHP"])
        end 
    end 
end
addEvent("dategetV", true)
addEventHandler("dategetV", root, dateGetV)

I'd do like this.

Edited July 31, 2019 by HassoN

[djharbi2]

thanks bro, problem solved