Hi,
I started with lasso 3.x & FMP, jumped to lasso 8.5 with SQLlite (and loved
it), now need to work with MySQL and Laso 8.6 (on Mac mini with Snow Leopard
server 10.6.7 ). I am not a programmer but quite familiar with the traditional
encoding when using lasso. Now the question:
I created the DB on MySQL 5.0x that came with the server and can access it
using ODBC and FMP for example ; no problems in creating records etc. BUT when
using the traditional code of Lasso [inline][/inline] to simply add a single
simple record it returned this:
(error code) 1064
(error message) HY000 [Actual][MySQL] 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 '"DMPPRuser") VALUES ('MYNAME')' at line 1
The dead simple code I used is (mysql is on another machine):
[var:'Vuser'=(form_param:'somefield')]
[inline:
-Host=(Array:-Datasource='odbc', -Name='whatever', -Username='xxx',
-Password='yyy'),
-database='DBname', -table='DBtable', 'fieldname'=$Vuser, -add]
then I found this from Fletcher
(http://lasso.2283332.n4.nabble.com/What-s-wrong-with-my-sql-INSERT-syntax-td3107790.html
) [OK, that was back in 2006]:
{ ..... Or, you can use a traditional inline to do the same thing. Lasso
handles the quoting and encoding for you.
[inline: -database='...', -table='events', -add, 'e_date'=$e_date,
'e_time'=$e_time, 'eventname'=$event_name, 'place'=$place, 'agenda'=$agenda,
'contact'=$contact, 'email'=$email, 'phone'=$phone, 'calendar'=$calendar,
'details'=$details]
[/inline]
....}
Now I checked with another lasso user but running Lasso version 8.1.0 and he is
using the same 'traditional' approach with no problems. But I am using the
mysql that came with Snow Leopard Server 10.6.7 with Lasso 8.6 , it looks like
the MySQL is version 5.0x .
I need to keep it simple, and am looking for a plain traditional approach ...
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
