Txtdb-sample6

(:if equal {$txtdb_Edit} '':)
(:txtdbPageVar:)
(:lang: english :)
(:txtdbSet id3 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id3 "SELECT keyword,{$:lang} FROM action WHERE keyword IN
(Edit,Save,Delete,Read)":)
(:txtdbDraw id3 pagevar prefix=txtdb :)
(:txtdbPageVarEnd:)
(:ifend:)

(:input form {$Name}:)
(:input hidden dbpage 'Cookbook.Txtdb-locale':)
(:input hidden dbname Language :)
(:input select query "SELECT keyword,english FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" English:)
(:input select query "SELECT keyword,french FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" French:)
(:input select query "SELECT keyword,german FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" German:)
(:input select query "SELECT keyword,spanish FROM action WHERE keyword IN
(Edit,Save,Delete,Read)" Spanish:)
(:input hidden txtdbFrmId TxtDbId1:)(:input submit txtdbSubmit
value="View":)
(:input end:)
(:txtdbDrawVar TxtDbId1 sessionvar prefix=txtdb :)

||border=1
|| EDIT || SAVE || DELETE || READ ||
|| "{$txtdb_Edit}" || "{$txtdb_Save}" || "{$txtdb_Delete}" ||
"{$txtdb_Read}" ||

(:txtdbSet id2 'Cookbook.Txtdb-locale' Language:)
(:txtdbQuery id2 "SELECT * FROM action WHERE keyword IN
(Edit,Save,Delete,Read)":)
(:txtdbDraw id2 wikitable sortable id=id100:)
(:sortable:)