Get data from table POSTE
Posted: 21 Nov 2012 14:34
Hi guys!
I have this code:
cdmao;(echo "SELECT nulog FROM POSTE WHERE numan='5512204';"|cuser|grep "\--"|grep -v nulog|cut -c5-11;)|while read poste_id;do echo "SELECT key_id,genrtou,chiftp, sonsurson, mnemo, order_mla, key_mla FROM KEYBOARD WHERE poste_id='$poste_id';"|cuser|grep -v key_id|grep -v mnemo|grep -v Hit|tr -s ' ';done
with this show all keyboard from 1 mcdu, but i want 1 line x register, how to do ???
thank you!!
I have this code:
cdmao;(echo "SELECT nulog FROM POSTE WHERE numan='5512204';"|cuser|grep "\--"|grep -v nulog|cut -c5-11;)|while read poste_id;do echo "SELECT key_id,genrtou,chiftp, sonsurson, mnemo, order_mla, key_mla FROM KEYBOARD WHERE poste_id='$poste_id';"|cuser|grep -v key_id|grep -v mnemo|grep -v Hit|tr -s ' ';done
with this show all keyboard from 1 mcdu, but i want 1 line x register, how to do ???
thank you!!