[Glass] System performOnServer to get MySQL data

BrunoBB via Glass glass at lists.gemtalksystems.com
Fri Oct 16 10:52:17 PDT 2015


Dale,

Thanks for the answer. The linux command is like:
System performOnServer:
'mysql -h 192.168.29.129 -u orbeon -ppwd -N -B -e "select xml from (SELECT
xml FROM orbeon.orbeon_form_data where xml is not null and app=''orbeon''
and form=''builder'' and document_id =
''a3ec41f08d058b4021a75c1689c8451daf1cc1fd'' order by last_modified_time
desc) lastDef limit 1; " '

The answer is:
<xh:head>\n        <xh:title>Migration 1</xh:title>\n        <xf:model
id="fr-form-model" xxf:expose-xpath-types="true">\n\n            \n

Inside linux and mysql:
mysql -u orbeon -ppwd

If i execute the same sql sentence i do not see the "\n".

Regards,
Bruno



--
View this message in context: http://forum.world.st/System-performOnServer-to-get-MySQL-data-tp4856061p4856073.html
Sent from the GLASS mailing list archive at Nabble.com.


More information about the Glass mailing list