Re: Array Looping to Insert into Database

2013-05-14 Thread Graham Pearson
I have total control over the XML Data as I have been trying to use the same XML Data that I used in creating the Adobe Air Application which I have used for the past 3 years. Now with LC as an Open Source, I have gotten fired up and been working day-in day-out to convert all of my Adobe Air Applic

Re: Array Looping to Insert into Database

2013-05-14 Thread Peter Haworth
On Tue, May 14, 2013 at 2:30 PM, Graham Pearson wrote: > repeat for each line L in tKeys > answer info > gAvailableMarketReceiveTowerDataArray[ReceiveTowers][L]["ID"] with "OK" > end repeat > Hi Graham, I think you missed [@attributes] as a key between [L] and [ID]. I'm guessing you don;t have

Re: Array Looping to Insert into Database

2013-05-14 Thread Graham Pearson
Now my next array question is a bit different and trying to use the knowledge from the array listed below to solve for this array which has not worked as of yet (But still trying as I write this). New Array: gAvailableMarketReceiveTowerDataArray ReceiveTowers Market[10] @attributes

Re: Array Looping to Insert into Database

2013-05-08 Thread Graham Pearson
Pete, Thanks on the reply. I have the XML stuff all working as this is the same data which my Adobe Air application uses on a daily basis. I am just wanting to convert it to Livecode so that I can use the same code base for desktop, tablet and mobile devices. Made some great progress today. On 5

Re: Array Looping to Insert into Database

2013-05-08 Thread Peter Haworth
Can't help with the XML stuff but it doesn't seem to difficult to use the array. put the keys of gAvailableMarketDataArray[AvailableMarkets] into tKeys sort tKeys -- if you care repeat for each line L in tKeys end repeat If you're inserting/updating stuff into an sqlite database, don;t forget

Array Looping to Insert into Database

2013-05-08 Thread Graham Pearson
Array Experts In my application that I am converting from Adobe Air, I have come to a section where Google has let me down. I have converted my XML File to an Array and can see it within the Debugger and parts of the array is listed below. gAvailableMarketDataArray AvailableMarkets Ma