Using ODBC with bind

I ran into this last week, and the Google was failing me, so here's the reason why you sometimes get "Required token $zone$ not found." when debugging why bind won't start with ODBC. The answer is: because the DLZ documentation is slightly wrong. It delimits "zone" and "record" with % instead of $. That is, the directions show:

{select zone from dns_records where zone = '%zone%'}

But really, it should be:

{select zone from dns_records where zone = '$zone$'}

There you go. That's where that error comes from. Now hopefully the next person who hits this will be able to find an actual useful answer when they search for the error.

source: http://ubuntulinuxtipstricks.blogspot.com/2010/10/using-odbc-with-bind.html