Re: [Pharo-users] Help with Garage and sanitized strings

2017-09-19 Thread casimiro barreto
Problem solved. Question marks shouldn´t be inside apostrophes 'SELECT * FROM chaves_de_encriptacao WHERE numero_funcional = ?' and not: 'SELECT * FROM chaves_de_encriptacao WHERE numero_funcional = ''?''' 2017-09-18 20:11 GMT-03:00 Casimiro de Almeida Barreto < casimiro.barr...@gmail.com>: >

[Pharo-users] Help with Garage and sanitized strings

2017-09-19 Thread Casimiro de Almeida Barreto
By the way, the following script fails with the same Exception (mysql_stmt_send_long_data): | db str sttmt |     db := GADriver                 connectToConnectionString: 'mysql://localhost:3306/leaincertezas?user=learoot&password=welcomeLEA'.     str := 'INSERT INTO chaves_de_encriptacao (num

[Pharo-users] Help with Garage and sanitized strings...

2017-09-19 Thread Casimiro de Almeida Barreto
Good evening, I was trying to sanitize statements, but something went awkward. The following non sanitized codelet works ok:     str := 'INSERT INTO chaves_de_encriptacao (                     numero_funcional,