[Glass] System performOnServer to get MySQL data

Dale Henrichs via Glass glass at lists.gemtalksystems.com
Fri Oct 16 11:15:08 PDT 2015



On 10/16/2015 10:52 AM, BrunoBB via Glass wrote:
> 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".
>

I've talked to our vm guy and the #performOnServer: is not replacing 
linefeeds with the string '\n', , so the '\n' is coming from somewhere 
else .... either the `mysql ....` is detecting that you are not running 
in an interactive shell or something else ... but the #performOnServer: 
is not the source of the '\n' characters ...

Dale


More information about the Glass mailing list