Mar 18
Pier Kuipers MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 19:56
Pier Kuipers
MySQL Stored Procedures and Lasso 8.6.3
Hi All,
Having tried everything, I'm now completely at a loss when trying to get a
MySQL stored procedure to run in Lasso 8.6.3 - MySQL client and server are
version 5.6.
The stored procedure is quite complex, but the problem appears to be with
declaring any kind of procedure, e.g.
DELIMITER //
CREATE PROCEDURE GetAllDefinitions()
BEGIN
SELECT * FROM file_definitions;
END //
DELIMITER ;
If I run the above query in MySQL directly (or in Navicat) everything is
fine - same with the complex procedure I'm trying to use.
Runing the same query in Lasso results in an error, however - even when
using the SQL utility in Lasso Admin:
Error: 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
'DELIMITER // CREATE PROCEDURE GetAllDefinitions() BEGIN SELECT * FROM
file_' at line 1 (1064)
I have tried all sorts of line endings (\r, \n, \r\n), but Lasso's Mysql
error keeps talking about "line 1", seemingly ignoring carriage returns
completely.
Has anyone got any idea what I could be doing wrong?
Cheers
--
Pier Kuipers
Mobile: +353 87 294 3063
Blog: http://www.pierkuipers.com
Facebook: http://www.facebook.com/pier.kuipers
Twitter: @pkvisualid
AIM: pkvisualid
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Mar 18
Steve Piercy - Website Builder Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 13:23
Steve Piercy - Website Builder
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Pier Kuipers Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 20:28
Pier Kuipers
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Steffan Cline Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 13:49
Steffan Cline
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Pier Kuipers Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 21:07
Pier Kuipers
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Steve Piercy - Website Builder Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 14:28
Steve Piercy - Website Builder
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 19
Wade Maxfield Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 19, 2016; 10:34
Wade Maxfield
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Steffan Cline Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 14:38
Steffan Cline
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Pier Kuipers Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 23:45
Pier Kuipers
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18
Steffan Cline Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 18, 2016; 16:48
Steffan Cline
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 19
Pier Kuipers Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 19, 2016; 01:02
Pier Kuipers
Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 24
Cory Robin Re: MySQL Stored Procedures and Lasso 8.6.3
Mar 24, 2016; 16:30
Cory Robin
Re: MySQL Stored Procedures and Lasso 8.6.3