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/mysql?unsub=arch...@jab.org