LiveCode Forums

Thank you very much Klaus, that worked as intended. Though how does the use of CR fix the issue?

I have been trying to import rows from a database into a table in order to create a scoreboard. I have managed to import the data but it only gets displayed in one row of the table rather than two rows even though I specified a return after the data. I have a field (Searchvalues) that contains the s...

Thank you very much, everything works fine now

put "SELECT COUNT(*) FROM scores" into tSQL
revExecuteSQL gConnectionID, tSQL
if the result is a number then
put it into temp
put "00000" + temp into ScoreID
else
answer"nope"
end if
answer ScoreID

I am using MAMP in order to connect to an SQL database. I can connect just fine but the problem arises when I try to execute my query. I am trying to perform a count(*) query on a table and return the value but every time I run it the result is "OK" which apparently counts as a number because it cau...