A quick question on format for App Tables function versus SQL Function

return results[0]

When you return a single row, you cannot then use a for loop on the client to process it.

m = anvil.server.call('locationQuery',self.location)
fmt = 'Location {} Rating Area:{} Rating:{}'
data = (self.location, m['Location'], m['LocationPercent'])
print(fmt.format(*data))

Just use the row directly.

2 Likes