Search found 77 matches

by Not a lot of thought
Thu Dec 08, 2016 4:07 pm
Forum: Internet
Topic: Web Scraping
Replies: 3
Views: 3387

Web Scraping

I'm working on a project and would like to incorporate automated web scraping capabilities based on certain triggers to compile information on certain topics from the web. I've not been able to find any web scraping applications that incorporate livecode. Does anyone have any suggestions? I mean can...
by Not a lot of thought
Fri May 27, 2016 5:03 pm
Forum: Talking LiveCode
Topic: Running Concurrent Animations
Replies: 5
Views: 1159

Re: Running Concurrent Animations

Thanks Craig! That helps for the progress bars. I'll just have to write an if to pass over one if it is finished and the other not. However, I have several hundred items to update at one time and I think it would be difficult to write a repeat statement that satisfies all of the objects. Could expla...
by Not a lot of thought
Fri May 27, 2016 1:56 pm
Forum: Talking LiveCode
Topic: Running Concurrent Animations
Replies: 5
Views: 1159

Running Concurrent Animations

I've tried searching this topic and haven't had much luck. Perhaps I am not using the right terminology. I would like to run multiple animations at once. Example: say I have two progress bars that once the card is open begin expanding to give the user the actual status of something. I want one to st...
by Not a lot of thought
Sun May 08, 2016 10:09 pm
Forum: Databases
Topic: Strftime() Function
Replies: 1
Views: 1282

Strftime() Function

Currently using YYYY-MM-DD string for date format, but the strftime function when using a modifier isn't returning a value. "SELECT strftime('%W', 'Week'), Week, Sum(CRED) FROM Temp_Table GROUP BY Week;" Put revDataFromQuery(tab, return, gDatabaseID, tSQL) into field I've not been able to figure out...
by Not a lot of thought
Sat May 07, 2016 10:12 pm
Forum: Databases
Topic: Optimizing SQLite Insert Statements
Replies: 4
Views: 2672

Re: Optimizing SQLite Insert Statements

Would that look like:

loop
BEGIN TRANSACTION;
INSERT;
END TRANSACTION;
end loop

or
BEGIN TRANSACTION;
loop
INSERT;
end loop
END TRANSACTION;
by Not a lot of thought
Sat May 07, 2016 7:57 pm
Forum: Databases
Topic: Optimizing SQLite Insert Statements
Replies: 4
Views: 2672

Optimizing SQLite Insert Statements

Does anyone have any suggestions or good links for optimizing a bulk SQLITE insert statement from a .csv? I've not really found anything overly helpful. What I have works but I want it to go faster. Currently I'm using something like the following with a loop to loop through each entry: Put "INSERT ...
by Not a lot of thought
Tue Dec 08, 2015 1:44 am
Forum: Databases
Topic: Using Wildcards in Variables in SQLITE queries
Replies: 4
Views: 1963

Re: Using Wildcards in Variables in SQLITE queries

Yep...that was the problem...I'm a moron. Thanks for the help Klaus. Sorry, for being the most annoying member. :oops:


Thanks
Chris
by Not a lot of thought
Tue Dec 08, 2015 12:27 am
Forum: Databases
Topic: Using Wildcards in Variables in SQLITE queries
Replies: 4
Views: 1963

Re: Using Wildcards in Variables in SQLITE queries

Initiatally of course, but the above would allow for me to override the wildcard variable when the user clicked on any given portion of the UI with a more specific query. I suppose I wasn't overly clear, but I'd like whenever the person clicks on a section of the UI associated with a specific depart...
by Not a lot of thought
Mon Dec 07, 2015 9:22 pm
Forum: Databases
Topic: Using Wildcards in Variables in SQLITE queries
Replies: 4
Views: 1963

Using Wildcards in Variables in SQLITE queries

I am creating a programming in which I would like the UI to be almost entirely interactive. So if you click on something it sends the ID of that item to a variable to be included in the WHERE clause of the SQL statements updating the card. For example: you might have several items in different class...
by Not a lot of thought
Fri Dec 04, 2015 3:37 am
Forum: Databases
Topic: How To Protect Against SQL Injection Attack?
Replies: 17
Views: 9948

Re: How To Protect Against SQL Injection Attack?

Can someone explain to me in lamen's terms what the difference is between the two different sql statements? As in what is actually going on in the background when you use the :1 in lieu of the &variable. I've been trying to find something on this for a few weeks but I haven't really understood what'...
by Not a lot of thought
Sun Nov 29, 2015 4:14 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Loop Pause/wait/stop for user input
Replies: 1
Views: 687

Loop Pause/wait/stop for user input

I have an instance where I'm running a loop, but if a certain condition exists then I need the user to confirm information before the loop continues. I'd like to pause the loop and wait for a user response then either move to the next iteration or run through the current. The only thing I'm struggli...
by Not a lot of thought
Sun Oct 18, 2015 8:46 pm
Forum: Databases
Topic: Variables and Table Names
Replies: 5
Views: 2287

Re: Variables and Table Names

...of course as soon as I post this I figure out the problem. Please disregard.
by Not a lot of thought
Sun Oct 18, 2015 8:33 pm
Forum: Databases
Topic: Variables and Table Names
Replies: 5
Views: 2287

Variables and Table Names

I'm having fits trying to create a table using a variable for its name. I have several truncated layers of storage in my app and need the program to generate unique names for each table, but I'm struggling to get it to work. I can get them to run if I define the table names, but if I set the same na...
by Not a lot of thought
Sat Oct 17, 2015 7:35 pm
Forum: Internet
Topic: Stand-alone app to web/cloud stored data native app
Replies: 4
Views: 2231

Re: Stand-alone app to web/cloud stored data native app

It was really late when I was creating my profile and it fit the moment well. :P You actually end up on a LOT of my posts as the main answerer. Thank you for all the help, btw. It is definitely appreciated. So just to be clear, essentially the only difference between a standalone native application ...
by Not a lot of thought
Sat Oct 17, 2015 11:49 am
Forum: Internet
Topic: Stand-alone app to web/cloud stored data native app
Replies: 4
Views: 2231

Stand-alone app to web/cloud stored data native app

So I'm about 40% complete with a project as a standalone version, which will be my initial pilot for beta testing. The pilot has a database feature that stores the information on the machine on which it is running. Eventually I need this application to store its data on an online server farm. Can I ...

Go to advanced search