Thanks, Mark. On Wed, Mar 25, 2015 at 1:27 AM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote:
> Can you confirm that the MySQL syntax you see in the message box is the > same as what you entered in Sequel Pro? > In Sequel Pro, I wrapped the time period in double quotes. When we tried that in LiveCode, it posted the quotes to the field, and the times were still adjusted. (I mistyped the 10... it's set at 20). > > What are the collations of the database and the time field? > Sequel Pro is displaying 'latin1_swedish_ci' as the default for the VARCHAR fields. -- White Feather Software www.whitefeather.com Cell: 408-391-1480 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
