Re: An interesting programming challenge

2015-04-10 Thread Geoff Canyon
On Fri, Apr 10, 2015 at 12:02 PM, Peter Haworth p...@lcsql.com wrote: I don't think this is a fair comparison since the end results are totally different. In the array test, the result is a large number of values whereas in the simple variable test you end up with one value. I was emulating

Re: Database error?

2015-04-10 Thread shawnlc
You're welcome. Yeah, the docs don't make it very clear that once you create a database, you assign a user with a password to the database. This is what you use in the connection string, since A) that it's not a good idea to use your root password B) use the same username and password on each

Re: Database error?

2015-04-10 Thread J. Landman Gay
On 4/10/2015 3:36 PM, shawnlc wrote: In case A if your account was compromised then they'd have access to everything in your account. In case B if compromised they'd have access to all of your databases. All this talk got me curious. I have an app that connects to a database. It currently

Re: Database error?

2015-04-10 Thread Peter Haworth
I'm kinda curious about this too. I assume the major risk is being subject to SQL injection attacks but I'm under the impression that if you use the variable name option in the rev database functions instead of including data values in an SQL statement, you're protected against injection attacks.

RE: Database error?

2015-04-10 Thread Ralph DiMola
The MySQL DB option in revOpenDatabase supports SSL encryption. This will work if: 1) SSL is enabled on the MySQL server. 2) The servers firewall opens the appropriate ports. 3) SSL certificate is installed on the server. 4) revOpenDatabase SSL parameter is true. 5) Encryption externals are

Re: Database error?

2015-04-10 Thread Peter Haworth
Thanks Ralph, off to add this to my dictionary notes. Pete lcSQL Software http://www.lcsql.com Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and SQLiteAdmin http://www.lcsql.com/sqliteadmin.html On Fri, Apr 10, 2015 at 5:03 PM, Ralph DiMola rdim...@evergreeninfo.net wrote:

no stack revMenuBar in standalones?

2015-04-10 Thread Dr. Hawkins
My standalones are choking on the line set the defaultMenuBar to the long id of grp revMenuBar of stack revMenubar A check found that exists() denies that there is any such objects. Is this one of those stacks that gets loaded late, or is there some ohter equivalent? Do I need to copy that

Re: no stack revMenuBar in standalones?

2015-04-10 Thread J. Landman Gay
On 4/10/2015 7:42 PM, Dr. Hawkins wrote: My standalones are choking on the line set the defaultMenuBar to the long id of grp revMenuBar of stack revMenubar A check found that exists() denies that there is any such objects. Is this one of those stacks that gets loaded late, or is there

Re: Database error?

2015-04-10 Thread J. Landman Gay
On 4/10/2015 7:03 PM, Ralph DiMola wrote: The MySQL DB option in revOpenDatabase supports SSL encryption. This will work if: 1) SSL is enabled on the MySQL server. 2) The servers firewall opens the appropriate ports. 3) SSL certificate is installed on the server. 4) revOpenDatabase SSL

Re: Database error?

2015-04-10 Thread Peter Haworth
On Fri, Apr 10, 2015 at 6:14 PM, J. Landman Gay jac...@hyperactivesw.com wrote: I'm not quite sure what Pete meant by using the variable name option in the rev database functions though. (I am so not a database person.) Well you opened the door by asking :-) As an example, revDataFromQuery's

Lest anyone else go mad

2015-04-10 Thread J. Landman Gay
I wasted an afternoon going crazy, so to spare anyone else the pain: If you do not include an (unspecified) number of icons when building an iOS app, the app will not install. If you try it with my AirLaunch utility via Dropbox, Dropbox will ask if you want to install, try to install, and

Re: Lest anyone else go mad

2015-04-10 Thread Jerry Jensen
On Apr 10, 2015, at 6:43 PM, J. Landman Gay jac...@hyperactivesw.com wrote: I wasted an afternoon going crazy It usually takes me much less time. Practice, practice, practice! ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit

Re: Database error?

2015-04-10 Thread J. Landman Gay
I freeze up with this stuff, just like I do with math. But...but...won't an intruder be likely to send their own queries, regardless of how the app is doing it? If they include raw values, the database will still respond, right? So why would it matter how the app is doing it? On 4/10/2015

Re: Lest anyone else go mad

2015-04-10 Thread J. Landman Gay
On 4/10/2015 8:49 PM, Jerry Jensen wrote: On Apr 10, 2015, at 6:43 PM, J. Landman Gay jac...@hyperactivesw.com wrote: I wasted an afternoon going crazy It usually takes me much less time. Practice, practice, practice! I was too stupid to know when to give up. I did practice some colorful

Re: An interesting programming challenge

2015-04-10 Thread Jerry Jensen
On Apr 10, 2015, at 8:04 AM, Colin Holgate colinholg...@gmail.com wrote: I tried using Jerry’s approach under ActionScript, slightly modified to use arrays instead of strings, and it took just over 300 mS. Tried as Javascript too, and that seemed to be under 2 milliseconds! Wow! That