Search found 326 matches

by ghettocottage
Sun Mar 29, 2020 1:59 am
Forum: Databases
Topic: Join
Replies: 5
Views: 214

Re: Join

..it occurs to me that you might be trying to do a many-to-many relationship in your database: where ideally there should be one peter, and one Football, you might be trying to do something like having many Footballs for all of the people (Football/Person_id.Ben, Football/Person_id.Peter, etc) One s...
by ghettocottage
Sat Mar 28, 2020 7:24 pm
Forum: Databases
Topic: Join
Replies: 5
Views: 214

Re: Join

Maybe something like this:

Code: Select all

SELECT  PERSONS.ID,PERSONS.Name, PERSONS.Age, SPORTS.Sport
FROM PERSONS
INNER JOIN  SPORTS ON PERSONS.id=SPORTS.Persons_id
WHERE PERSONS.Name = "Peter";
by ghettocottage
Tue Mar 03, 2020 4:38 am
Forum: Converting to LiveCode
Topic: Moving a CRM project from FileMaker to LC?
Replies: 19
Views: 1016

Re: Moving a CRM project from FileMaker to LC?

I like this idea. But in some cases could be a problem (large stack, internet problems). Personally, I use the launcher method.... but with a local file. It's only when there is an update available (I use a MySQL table for that, in which I store a simple version number that will be compared to the ...
by ghettocottage
Mon Mar 02, 2020 4:03 pm
Forum: Converting to LiveCode
Topic: Moving a CRM project from FileMaker to LC?
Replies: 19
Views: 1016

Re: Moving a CRM project from FileMaker to LC?

If you have a VPS or local office-server to use as a web/mysql/livecode server, there are some things you can do that will solve much of your requirements: ##Updates This is a big one that LC can do in conjunction with using a server, and I am surprised it is not discussed more. Basically, you can d...
by ghettocottage
Thu Feb 27, 2020 3:58 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 1734

Re: How to deal with database files for an app?

never really tried Cobian - but on Windows "robocopy" is an extremely powerful cmd line tool for such tasks. For those who love cmd line tools with gazillions of parameters. Try "robocopy -?" and shudder ;-) I used it for some tasks where basic copy/ xcopy didn't work well (loooong filepaths, over ...
by ghettocottage
Wed Feb 26, 2020 5:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 1734

Re: How to deal with database files for an app?

I wanted to chime-in here on backups: For backups for a small office/home business a basic set-up I do (and is generally the first order of business when I am setting up an office): two 2tb hard-drives (or two 4tb hard drives if you can afford them or have huge amounts of files) rsync for linux or m...
by ghettocottage
Sun Feb 09, 2020 8:24 pm
Forum: CGIs and the Server
Topic: LC Server returns 'lscgid: execve():/home/myapp/sites/api.myapp.com/cgi-bin/livecode-server: No such file or Directory
Replies: 1
Views: 466

Re: LC Server returns 'lscgid: execve():/home/myapp/sites/api.myapp.com/cgi-bin/livecode-server: No such file or Directo

did you:
chmod +x /home/myapp/sites/api.myapp.com/cgi-bin/livecode-server

Who is the new server with? Is it shared hosting or a VPS?
by ghettocottage
Mon Jan 27, 2020 3:04 am
Forum: CGIs and the Server
Topic: POLL: LiveCode Server deployment
Replies: 63
Views: 26844

Re: POLL: LiveCode Server deployment

Like @TorstenHolmer I have used LCS for writing API's (amongst other things) and I find it especially quick and easy to work with. This past month I have been working on a Weather Station running on a Raspberry Pi out in a field. Rather than doing much on the rpi, I am just sending the bare-bones da...
by ghettocottage
Sat Dec 21, 2019 6:28 pm
Forum: Databases
Topic: Creating accounts for multiple users of a MySQL database
Replies: 2
Views: 723

Re: Creating accounts for multiple users of a MySQL database

do you need separate user accounts? you said that this will be on the LAN; will all of the users only be using it on the LAN? As with everything, there are several approaches to this, but from what you described so far, my thinking is that it would be better to have one MySQL user that is for the ap...
by ghettocottage
Wed Dec 11, 2019 11:08 pm
Forum: Databases
Topic: Which remote DB Host are you using?
Replies: 2
Views: 515

Re: Which remote DB server are you using?

Using a VPS from Linode, Contabo, or DigitalOcean is only $5.00/month and I can also run Apache WebServer, install Livecode Server, and use OpenVPN for a secure connection with my own Livecode API.
by ghettocottage
Wed Nov 06, 2019 4:40 pm
Forum: CGIs and the Server
Topic: Sessions on XAMPP no go, Live ok.[Headache]
Replies: 23
Views: 3181

Re: Sessions on XAMPP no go, Live ok.

Would a raspberry be faster then the VPS i now run?
Most likely, with the added benefit of being an always-on local server that could be used for other various tasks or projects (plex server, file server, etc)
by ghettocottage
Wed Nov 06, 2019 4:07 am
Forum: CGIs and the Server
Topic: Sessions on XAMPP no go, Live ok.[Headache]
Replies: 23
Views: 3181

Re: Sessions on XAMPP no go, Live ok.

A raspberry pi with Ubuntu 18.04 server would make a nice little LC Server Development Box:
https://www.adafruit.com/product/4295?src=raspberrypi
by ghettocottage
Sun Nov 03, 2019 11:29 pm
Forum: CGIs and the Server
Topic: Sessions on XAMPP no go, Live ok.[Headache]
Replies: 23
Views: 3181

Re: Sessions on XAMPP no go, Live ok.

have you tried (just for debugging) to set the folder permissions to 777, or whatever the windows equivalent of the is (writable by everyone)
by ghettocottage
Thu Oct 31, 2019 8:03 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Call Script from within script on server
Replies: 2
Views: 553

Re: Call Script from within script on server

Yep. You can make your page a regular webpage unless there is something specific is posted to it. Something like: <?lc --if this is a db connection request, get it and exit put $_POST["INSTRUCTION"] into t_instruction if t_instruction is not empty then include "connect/dbconnect.lc" quit else --if t...
by ghettocottage
Wed Sep 18, 2019 3:28 pm
Forum: Feature Proposals
Topic: Toolbar and KDE
Replies: 19
Views: 2567

Re: Toolbar and KDE

Although I have since switched to using Unity rather than KDE, I had a functioning solution, which was when working with LC to have a separate desktop for working with Livecode and only Livecode. In fact, I seem to recall that KDE allows you to name your desktops so I had development, office, etc.

Go to advanced search