This content has been marked as final. Show 9 replies
Replace in(choosenBoxes) with parseListToString(choosenBoxes)
Thanks i have tried that but it does not seem to work is this what my code should now look like? I traced the output to the message window and it said error message 1 which in the xtra i am using means a sql error.
This should be how it would look. Notice the separate handler and that the handler call is not within the string statements quotes.
What Xtra are you using? Looks a little like Arca perhaps?
Thank you it works fine now, yes it is Arca
Glad to hear it. I love Arca. Great product!
I have one quick question instead of starting a new thread ill ask here, i want to be able to use the result of the sql statement on another frame will i need a global string? and then need a way to get rid of everything in the err string that the sql returns? for example in the err its
err = [#rowschanged: 0, #columns: ["Title", "Takings"], #columntype: [<Void>, "float"], #rows: [["live and let", 126400000], ["the man with", 97600000]], #errorMsg: 0]
Then will i need something like you did above to get rid of everything but the title and takings?
Yes, it will need to a global variable to be used elsewhere.
global err -- place at very top of scripts you want to use it in
The second part of your question is going to be very simple. The data you see in err is actually a list. Thus you can access the data via...
myVar = err.rows
This sets myVar = "live and let"
So i will have a scirpt on the frame i want to do this on which will have global err at the top then i will need some sort of loop to go around and get all the rows out correct?
Yeah, something like this...
repeat with n = 1 to err.rows.count()