Great, glad you figured it out.
On Wed, Mar 25, 2015 at 1:35 PM Paul Foraker wrote:
> On Wed, Mar 25, 2015 at 8:08 AM, Peter Haworth wrote:
>
> > Have you tried selecting the data with Livecode (revDataFromQuery)?
>
>
>
> Well, thank you very much. When I checked with revDataFromQuery, I saw t
On Wed, Mar 25, 2015 at 8:08 AM, Peter Haworth wrote:
> Have you tried selecting the data with Livecode (revDataFromQuery)?
Well, thank you very much. When I checked with revDataFromQuery, I saw the
same problem we're seeing in Sequel Pro. That was a clue! Sure enough, our
function for determ
As Mark said, it's hard to believe mySQL is doing this. The other element
is Sequel Pro - not likely but maybe it's doing the time conversion?
Have you tried selecting the data with Livecode (revDataFromQuery)?
On Wed, Mar 25, 2015, 7:18 AM Paul Foraker wrote:
> Thanks, Mark.
>
> On Wed, Mar 25
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 tri
Hi Paul,
MySQL definitely doesn't guess that your string consists of two times
and definitely doesn't guess that it should be converted depending on
time zone.
MySQL doesn't interprete a string as a date if the field for that string
isn't defined as a date. Your field is defined as VARCHAR a
Now that I think about this, is this a 'feature' of revExecuteSQL ? A
string that looks like a time gets coerced by the command into a time and
adjusted for time zone without regard to the field type of the destination
database field. Can that be what's happening?
On Tue, Mar 24, 2015 at 9:48 PM,
In a table in a MySQL database, I need a field displaying a time period
corresponding to the half hour period during which a record was posted. The
period is in the form "HH:MM-HH:MM AM|PM". I have set the field type to
VARCHAR(10) and LiveCode is passing the string to the query handler. MySQL
is
