Jim,
I had tried building my own statement, as you see, as well as creating a
statement using the plugin command
mySQL Set DateTime in SQL
That is how I originally started and was failing because I figured myConnect
would be taking care of these formatting issues.
When that failed, I switched to trying to build my own statement so that could
actually see what the SQL was that was being executed.
But that failed too.
For now, I’m just letting the web programmer time the links out himself. If
someone tries to use an expired link, he lets them know and clears out the old
one.
In essence, I gave up an went with his more expedient solution.
Randy
----------------------------------------------------------------------
Randy Jaynes
Senior Programmer and Customer Support
http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane •
Palisades, NY 10964
> On Nov 6, 2016, at 7:12 PM, Jim Labos - infobase <[email protected]> wrote:
>
> in your statement:
>
> $statement:="SELECT contactLogin FROM Contacts WHERE
> reset_password_token_created_at<='2016-11-02 17:09:46’;”
>
>
> The end of the date time is .....46’ the last single quote is not same as
> first quote ( ' vs ’ ). I've had problems in the past where the quote
> character breaks the statement depending on what it is. Worth a try at
> least.
>
> Have you got sql errors on? myConnect is not as forgiving as Sequel Pro is.
>
> Cheers
>
> Jim Labos - infobase
>
>
>
> -----
> Jim Labos - infobase
> --
> View this message in context:
> http://4d.1045681.n5.nabble.com/my-Connect-plugin-help-tp5748349p5748436.html
> Sent from the 4D Tech mailing list archive at Nabble.com.
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ: http://lists.4d.com/faqnug.html
> Archive: http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:[email protected]
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
