[Glass] System performOnServer to get MySQL data

[BrunoBB via Glass]

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.