9.9.9 Codetable samples

Posted by admin on 17th September 2015

Each code can be described with some text and a lookup to the actual codetable. Here’s some samples for the formating of the lookup:

Format 1
This sample uses the full sql syntax of the wordpress shortcode is_showtable:
sql=”SELECT code as Code, text as Explanation from code_naceĀ  Limit 0,6″
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace “]
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace”]

Format 2
This sample uses the simple format of is_showtable: table=”code_nace”

[is_showtable table=”code_nace” fields=””]

Format 3
This sample uses the “table and fields” format of is_showtable: table=”code_db7″ fields=”code”

[is_showtable table=”code_db7″ fields=”code”]
[is_downtable table=”” sql=”SELECT TOP 10 code as Code, text as Explanation from code_nace”]