I want to search a DataBlaze table.
From will get ICAO code (VIA formtext), (this is a unique key)
Select would return NAME.
It works, however, the data set is over 75,000 rows. Only searches the first several hundred rows.
Tried with LIMIT = 80000 and without LIMIT in the SELECT.
Is there another limit to searches?
SNIP___
ICAO: {formtext: name=icao}
{dbselect: SELECT name FROM World Airports
WHERE ident = @icao LIMIT 80000; space=7gYWcz1kN4GysgT1nyYxcI; menu=no}
ICAO: {formtext: name=icao; formatter=icao -> upper(icao)}
NAME: {formtext: name=name; formatter=name -> proper(name)}