Search found 47 matches

by paulalsmith1000
Sat Mar 28, 2020 10:29 am
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 955

Re: converting an sql query into an array

Thanks v much for all the answers everyone. I went round the houses trying the various suggestions above, but in the end I used the stack from Fourthworld, because I still couldn't get the SQL syntax to work (I've now bought 'SQL Queries for mere mortals' to try and swot up). So, for any NOOBs like ...
by paulalsmith1000
Fri Mar 27, 2020 7:30 pm
Forum: Android Deployment
Topic: psu notification icon
Replies: 2
Views: 130

psu notification icon

Evening All Does anyone know how/if you can change the push notification icon from the default LC one to one of your choice? Also as an aside one of the livecode guides says your application icon should be in incs format, but when you try to select this file from the folder it only shows png formats...
by paulalsmith1000
Fri Mar 20, 2020 2:06 pm
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 955

Re: converting an sql query into an array

Again, thank you for all the replies and offers of help to check my stack However, I have changed tack a bit as I realized what I was doing was a bit convoluted, as in doubling up unnecessarily on what was already on my db. All I need to do is populate a field in my sql db with the push keys of what...
by paulalsmith1000
Thu Mar 19, 2020 12:40 am
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 955

Re: converting an sql query into an array

wow thanks for all the answers I went with the array in the end, which worked fine as far as displaying the data, but retrieving what I actually need is still eluding me:- I have the array as suggested- key -id name info i want 1 paul xxxxxxxx(push key) I can select all the names and put them in a l...
by paulalsmith1000
Wed Mar 18, 2020 12:34 am
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 955

converting an sql query into an array

Evening everyone Could one of you clever people answer the following:- I'm making a very simple database query which returns the info from 2 columns for a number of entries e.g the result is john smith eastbourne ben brown brighton etc, etc.. What I'd like to do is convert the result into an array (...
by paulalsmith1000
Sun Mar 08, 2020 4:55 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: convert list to string
Replies: 7
Views: 518

Re: convert list to string

thanks v much as ever

kind regards

Paul
by paulalsmith1000
Sat Mar 07, 2020 2:18 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: convert list to string
Replies: 7
Views: 518

convert list to string

Hi there (me again) This really is straight forward, but its late and I'm stumped??!! so any help appreciated. I have a list field where you can select more than one line (containing names), if I put the selected text from the field into a variable and put it, I can see that each entry is on a separ...
by paulalsmith1000
Sun Mar 01, 2020 4:27 pm
Forum: Internet
Topic: http request problem
Replies: 5
Views: 362

Re: http request problem

Thank you very much for your help. It turns out I was being a div anyway! I'd removed the space before, because I thought it might be the problem, but it had no affect. It's only the last post that made me look back through it (I thought if it worked in the browser, it would work in LC). stupidly th...
by paulalsmith1000
Sun Mar 01, 2020 11:45 am
Forum: Internet
Topic: http request problem
Replies: 5
Views: 362

Re: http request problem

Hi There I have tested the resulting URL in the browser and it works fine (it returns the json response as expected), so the variables and the key work. if I 'put' the result with the variable URL, I get this back???? Kind regards Paul <!DOCTYPE html> <html lang=en> <meta charset=utf-8> <meta name=v...
by paulalsmith1000
Sun Mar 01, 2020 1:48 am
Forum: Internet
Topic: http request problem
Replies: 5
Views: 362

http request problem

Hi There I've just come back to livecode after a while and something I'd already done doesn't seem to work? I've formed htto requests before without any problems, but now this happens:- GET url ("https://www.googleapis.com/youtube/v3/search?part=snippet&q=little simz, offence&key=AIzaSyC-k5IU6jr9eHx...
by paulalsmith1000
Sat Jan 04, 2020 1:27 am
Forum: Internet
Topic: api call not working on android
Replies: 5
Views: 633

api call not working on android

Evening livecoders Well I'm here again, its heading towards 1 in the morning and I'm stumped again. As ever any help would be very much appreciated: I am making an api call to google distance matrix, it works fine on the desktop, but not on android. As far as I can tell nothing is returned??!!!! The...
by paulalsmith1000
Fri Jan 03, 2020 7:35 am
Forum: Internet
Topic: parsing json
Replies: 2
Views: 532

Re: parsing json

Hi Klaus

What can I say - perfect! thank you; 5 hours to 5 minutes.

Kind regards

Paul
by paulalsmith1000
Thu Jan 02, 2020 8:32 pm
Forum: Internet
Topic: parsing json
Replies: 2
Views: 532

parsing json

Evening Livecoders I wonder if anyone could help me with the following:- I've previously had some success importing the json response from something and then extracting the info I wanted. However, this time, to many hours has got me nowhere, so here I am again. The request is a variation on this- ht...
by paulalsmith1000
Sat Dec 21, 2019 12:07 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using a variable with seconds
Replies: 3
Views: 1224

Re: Using a variable with seconds

Hi Klaus

Thanks v much.

You are a fountain of knowledge as ever.

Kind regards

Paul.
by paulalsmith1000
Fri Dec 20, 2019 11:06 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using a variable with seconds
Replies: 3
Views: 1224

Using a variable with seconds

Evening anyone, I'm not sure this is the right section, but I couldnt see anything similar on the other topics: Could someone tell me if I can use a variable with seconds? Ie instead of 'send command to me in 10 seconds,' I wanted to write 'send command to me in variable seconds. This is because the...

Go to advanced search