[Glass] System performOnServer to get MySQL data

[Dale Henrichs via Glass]

Oh good, I'm glad we've got that straightened out!

Dale

On 10/16/2015 12:01 PM, BrunoBB via Glass wrote:
> Dale,
>
> I think "\n" are inserted by Bash.
>
> System performOnServer:
>   'mysql -h 192.168.29.129 -u orbeon -ppwd -N -B -e "select TRIM(TRAILING
> ''\n'' FROM xml) as field 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 limit 1; " | tr ''\\n'' '' '' '
>
> Here "\n" is removed :)
>
> But i will use the Smalltalk workaround because of MySQL
> SET GLOBAL sql_mode = 'NO_BACKSLASH_ESCAPES';
> if set "\\n" is correct
> if not set "\n" is correct
>
> Regards,
> Bruno
>
>
>
> --
> View this message in context: http://forum.world.st/System-performOnServer-to-get-MySQL-data-tp4856061p4856089.html
> Sent from the GLASS mailing list archive at Nabble.com.
> _______________________________________________
> Glass mailing list
> Glass at lists.gemtalksystems.com
> http://lists.gemtalksystems.com/mailman/listinfo/glass