{"action":"created","issue":{"url":"https://api.github.com/repos/unix4you2/practico/issues/28","labels_url":"https://api.github.com/repos/unix4you2/practico/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/unix4you2/practico/issues/28/comments","events_url":"https://api.github.com/repos/unix4you2/practico/issues/28/events","html_url":"https://github.com/unix4you2/practico/issues/28","id":55220020,"number":28,"title":"Error en Informes","user":{"login":"robisagi","id":10660617,"avatar_url":"https://avatars.githubusercontent.com/u/10660617?v=3","gravatar_id":"","url":"https://api.github.com/users/robisagi","html_url":"https://github.com/robisagi","followers_url":"https://api.github.com/users/robisagi/followers","following_url":"https://api.github.com/users/robisagi/following{/other_user}","gists_url":"https://api.github.com/users/robisagi/gists{/gist_id}","starred_url":"https://api.github.com/users/robisagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robisagi/subscriptions","organizations_url":"https://api.github.com/users/robisagi/orgs","repos_url":"https://api.github.com/users/robisagi/repos","events_url":"https://api.github.com/users/robisagi/events{/privacy}","received_events_url":"https://api.github.com/users/robisagi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/unix4you2/practico/labels/ayuda!","name":"ayuda!","color":"159818"},{"url":"https://api.github.com/repos/unix4you2/practico/labels/pregunta","name":"pregunta","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-22T22:43:46Z","updated_at":"2015-01-23T16:56:42Z","closed_at":"2015-01-23T14:07:21Z","body":"En la parte  \"Agregar un nuevo campo al informe\" \r\nEspecíficamente en el campo de Alias, Permite poner caracteres especiales tildes, eñes, pero al ver la vista Previa o el formulario en el usuario genera el siguiente error.\r\nVersión 15.1 Act 14 \r\nEj:\r\n\"Error en tiempo de ejecucion\r\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�o FROM app_usuario,core_usuario WHERE app_usuario.identificacion = core_usuar' at line 1\r\nDetalles: SELECT app_usuario.identificacion as Identificacion,app_usuario.nombres as Nombres,app_usuario.apellidos as Apellidos,app_usuario.telefono_fijo as niño FROM app_usuario,core_usuario WHERE app_usuario.identificacion = core_usuario.login\""},"comment":{"url":"https://api.github.com/repos/unix4you2/practico/issues/comments/71224973","html_url":"https://github.com/unix4you2/practico/issues/28#issuecomment-71224973","issue_url":"https://api.github.com/repos/unix4you2/practico/issues/28","id":71224973,"user":{"login":"robisagi","id":10660617,"avatar_url":"https://avatars.githubusercontent.com/u/10660617?v=3","gravatar_id":"","url":"https://api.github.com/users/robisagi","html_url":"https://github.com/robisagi","followers_url":"https://api.github.com/users/robisagi/followers","following_url":"https://api.github.com/users/robisagi/following{/other_user}","gists_url":"https://api.github.com/users/robisagi/gists{/gist_id}","starred_url":"https://api.github.com/users/robisagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robisagi/subscriptions","organizations_url":"https://api.github.com/users/robisagi/orgs","repos_url":"https://api.github.com/users/robisagi/repos","events_url":"https://api.github.com/users/robisagi/events{/privacy}","received_events_url":"https://api.github.com/users/robisagi/received_events","type":"User","site_admin":false},"created_at":"2015-01-23T16:56:42Z","updated_at":"2015-01-23T16:56:42Z","body":"Si, es muy claro.\r\n\r\nLa otra seria un proceso en el cual tu pongas los alias controlados y al retornar la consulta al informe ponerle la que el usuario pidió.\r\nej\r\nSELECT app_usuario.identificacion as tmp1,\r\napp_usuario.nombres as tmp2,\r\napp_usuario.apellidos as tmp3,\r\napp_usuario.telefono_fijo as tmp4\r\nFROM app_usuario,core_usuario \r\nWHERE app_usuario.identificacion = core_usuario.login"}}