Goede morgen, and thank you for your suggestion. I am actually wondering if the difference between lasso 8.1 and 8.6 is so big that traditional lasso code can not be used when connecting w/ MySQL ?
You mentioned "... This can be done in the server configuration, so no alterations are necessary ...". Do you mean one of the mode that came with lasso (Server, site) to resume may I ask you to confirm: the simple code [inline:-add, -database=..., -table=..., field=value] can not be used anymore w/ MySQL, or can it? Alvast Bedankt --- On Wed, 7/6/11, Rik Wasmus <[email protected]> wrote: > From: Rik Wasmus <[email protected]> > Subject: Re: dumb question? > To: [email protected] > Date: Wednesday, July 6, 2011, 10:27 PM > On Wed, 2011-07-06 at 07:15 -0700, XL > Cordemans wrote: > > (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 > > You'll need to enable ANSI_QUOTES to be able the use '"' as > an > identifier quote character rather then MySQL's default > '`'. > > See: > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes > > This can be done in the server configuration, so no > client/lasso > alterations are necessary. > -- > Rik > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
