LiveCode Forums

So to close this off, yes it was a bug recognised by Livecode folks, but because Community version is no longer, will not be fixed!

That code works for me. The order of parameters should not matter, moving the filter to the end just made it easier to adjust, and focus on the part of the query when "answering" while testing. It's certainly a valid construction. My apologies, yes it did work - fat fingers. Still doesn't explain w...

Did you try the code I showed which worked for me on Android built with LC Community? I assume you are referring to: get url (tQuery) answer the result Yes I did, but did not work. I also tried:- put "filters=%7B%22" & "postcode" & "%22%3A%22" & "2103" & "%22%7D" into tFilter put "https://data.nsw....

Now I have seen on a computer rather than phone, I can spot that you are using json data in the GET url. This I think must be a limitation of the libUrl equivalent on Android. I have made a few quick trials with urlEncoded filters and substituting html entities but not successfully. Is there a meth...

Try get url (tQuery) answer the result and see if there is any error message returned. Also is that really a colon in the filter string? It might be that the Android libUrl library handles special characters differently - what happens if you urlEncode the filters before putting into tQuery? Nope, t...

This is the offending bit of code:- put "filters={" & quote & "postcode" & quote & ":" & quote & "2103" & quote & "}" & "&" into tFilter put "https://data.nsw.gov.au/data/api/3/action/datastore_search?" & tFilter & "limit=100000&fields=postcode,lga_name19,notification_date,likely_source_of_infection...

If this were the case, how would I be able to retrieve any data. As indicated above, the first time thru, it works.

How would I know if it is coded for tsNet? I assume by using 'ts' commands? Sorry for the dumb question.

Can you say what it is that does not work when you build in the Community version? If it shows the cards but not working when (say) you try to submit data to a webform, then we can try to narrow it down to (say) implementation of POST commands, etc. Or does it just not open at all? The app is has 2...

I have checked and compared all Standalone Application Build Settings and all are identical. Definitely some sort of disconnect between Community and Indy products!

Umm, I have downloaded a trial version of Indy. Works perfectly!

I developed my first app about a year ago using Indy (probably version 9.6). Worked fine both on PC and when ported to an Android phone. I have dropped Indy and now only using Community version (9.6.3). The code now works fine running on the PC, however when running on an emulator or ported to a And...

Can anyone explain why this (1):- put url "https://data.nsw.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT%20count(notification_date)%20as%20numberofrecords%20from%20%222776dbb8-f807-4fb2-b1ed-184a6fc2c8aa%22%20WHERE%20notification_date%20between%20%272020-06-01%27%20and%20%272020-06-30%27...

jacque wrote: ↑

Thu Jun 25, 2020 5:22 pm

AxWald wrote: ↑

Thu Jun 25, 2020 8:47 am

you may want to search the dictionary for "month". You'll find "function monthNames".

Code: Select all

   put line 2 of the monthNames
   --> "February"

Or:

Code: Select all

put lineOffset(tMonth, the monthNames) into tMonth

Perfect, thx.

Thx Craig, this is exactly what I thought I would need to do. Was just hoping there was a function that I could not find that would do the job

Is there any function to convert a month in text format to a month number? I have a date stored in the format - "DD MMMMMMMM YYYY" e.g. "22 June 2020" and need to convert to a system date. The days and years are fine, however not sure if there is a function to convert the month.