Tutorial for Livecode Server log in system

2024-03-25 Thread Tim Selander via use-livecode
Hi all. As a hobbiest/amateur I continue to plunk away with Livecode, mostly the server product in my on-rev account. Can anyone point me to a tutorial or sample of an online log in system (username, email and password) for a website using Livecode? I've found some php tutorials, and

Re: FindIndex question

2024-03-25 Thread Bob Sneidar via use-livecode
This is the code with a couple of dependencies. I think that’s all the fiddlybits. If I missed something let me know. Bob S function filterArray pArrayDataA, pConditions put the defaultFolder & "/" & "tempdatabase.db" into tDBName put arrayToSQLite(pArrayDataA, tDBName, "arraydata")

Re: FindIndex question

2024-03-25 Thread Alex Tweedly via use-livecode
Bob - I think you've mentioned these functions (and posted code, or a pointer to code, for them) before (but I couldn't find it). Any chance you could re-post (or just send to me, or ...) Mike - I couldn't see in the thread *why* you want to use a dg ather than a pg ? Is there a missing

Re: FindIndex question

2024-03-25 Thread Mike Kerner via use-livecode
i guess what i'm wondering is how quickly or slowly the dg will render, if the dgArray is large. it seems to be slower, when the array is larger. On Mon, Mar 25, 2024 at 2:48 PM Mike Kerner wrote: > i never heard of it called an "elevator". I anyways heard "thumb" > > On Mon, Mar 25, 2024 at

Re: FindIndex question

2024-03-25 Thread Mike Kerner via use-livecode
i never heard of it called an "elevator". I anyways heard "thumb" On Mon, Mar 25, 2024 at 2:08 PM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > I’ve thought about that. A temporary memory database would not appear to > the user to be faster, as the initial query for a

Re: FindIndex question

2024-03-25 Thread Bob Sneidar via use-livecode
I’ve thought about that. A temporary memory database would not appear to the user to be faster, as the initial query for a large dataset will happen all at once during which Livecode would be unresponsive. And if you page the queries from the live database, re-storing the data in a memory

Re: FindIndex question

2024-03-25 Thread Mike Kerner via use-livecode
i would be curious to know if an in-memory sqlite db increases scroll speed with dg's. basically, you would live load the dg with pages from the db. i can't imagine that the dg is faster than the pg. everything i've tried with the pg is faster than the dg. just one more reason to resurrect the

Re: FindIndex question

2024-03-25 Thread Bob Sneidar via use-livecode
I wrote a findInArray() function that will convert an array to a memory based SQL database, and one of the arguments is the SQL query statement to use on the database. I have another called FilterArray() which simply iterates through the keys to output those matching a criteria. Bob S > On