ANN: Spreadlib - Excel Import Beta

2012-05-08 Thread Curry Kenworthy
Howdy Folks, As some of you have been expecting, here's a beta version of SpreadLib addon library, offering Excel xlsx spreadsheet import via htmlText (a whole worksheet into a field) or array access (lookup data per cell). It demonstrates a substantial subset of the features that the 1.0

Re: [OT] Gatekeeper

2012-05-08 Thread Andrew Henshaw
As far as I was aware all you need to do is sign your apps, if you publish an app to the Mac App Store it already has to be signed. To do this you need the $ 99/year Apple Developer Program, and then you can use a few simple terminal commands to sign an app. It should not affect Livecode at

getting the path of a DVD drive

2012-05-08 Thread Tiemo Hollmann TB
Hello, if I want to read from a CD with a known label foo I just check if foo is in the drives to check if the CD is inserted. Then I add /Volumes/ hard coded before foo, so that I get the full path /Volumes/foo/ What I would like to know is, if this name convention /Volumes/. is mandatory

Re: getting the path of a DVD drive

2012-05-08 Thread Mark Schonewille
Hi Tiemo, Yes, /volumes is mandatory on all Macs. You can even use put shell(ls /volumes) to get all drives. /volumes/drivename is the right way to address a drive on Mac. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com

AW: getting the path of a DVD drive

2012-05-08 Thread Tiemo Hollmann TB
Hi Mark, thanks for the helpful answer Tiemo -Ursprüngliche Nachricht- Von: use-livecode-boun...@lists.runrev.com [mailto:use-livecode- boun...@lists.runrev.com] Im Auftrag von Mark Schonewille Gesendet: Dienstag, 8. Mai 2012 12:08 An: How to use LiveCode Betreff: Re: getting the

Re: PayPal IPN LC - and Beef Stew

2012-05-08 Thread Ben Rubinstein
On 04/05/2012 04:05, J. Landman Gay wrote: On 5/3/12 9:41 PM, Mark Wieder wrote: See bug reports 3157 and 8305. :) I'd seen Jeanne's but I didn't know you'd put your foot in too. I'd like to see the above list added as well but I'm afraid RR would take away our access. Be careful what you

Re: Umlaute get corrupted when transfering livecode from Win to Mac

2012-05-08 Thread Mark Schonewille
Hi Tiemo, I have seen this problem in two different cases. I don't know the cause and have no solution but you could check the charSet property of the stack when you open the stack. If you move the stack from Mac to Windows and the charSet property returns ISO before you save the stack for the

Is LC a non-Unicode program?

2012-05-08 Thread Nicolas Cueto
Hello All, For maybe a decade, the copyright symbol on the RunRev/LC splash screen has actually appeared garbled. A minor annoyance that I learnt to ignore. That is, until LC 5.5.0, when, there she was!, the copyright symbol. Not for long, though. With 5.5.1-dp1 and dp2 (damn that prefs bug!),

AW: Umlaute get corrupted when transfering livecode from Win to Mac

2012-05-08 Thread Tiemo Hollmann TB
Ok thank for the hint, I'll check and report it Tiemo -Ursprüngliche Nachricht- Von: use-livecode-boun...@lists.runrev.com [mailto:use-livecode- boun...@lists.runrev.com] Im Auftrag von Mark Schonewille Gesendet: Dienstag, 8. Mai 2012 13:06 An: How to use LiveCode Betreff: Re:

AW: Umlaute get corrupted when transfering livecode from Win to Mac

2012-05-08 Thread Tiemo Hollmann TB
A quick test showed the wrong charset today everytime in every file I copied from Mac to Win and vice versa with corrupted umlaute in the standalone settings, but not in the scripts. (LC 4.6.4) The docs say, that the charset indicates, on which platform the stack was last saved, so the bug doesn't

Re: PayPal IPN LC - Scripts are posted

2012-05-08 Thread Peter M. Brigham, MD
On May 7, 2012, at 12:18 PM, Bob Sneidar wrote: If a developer doesn't descends into a crazed sputtering rage from time to time, they probably should not be developing software. ;-) PROGRAM, tr.v. To engage in a pastime similar to banging one's head against a wall, but with fewer

Re: ANN: Spreadlib - Excel Import Beta

2012-05-08 Thread Bob Sneidar
Out of curiosity, does spreadLib create a datagrid, or does it use a table field? Bob ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread William de Smet
Hi there, Can anyone help me shorten this script? Eventually there will be 100 graphics (d1 to d100) and 200 lines of text in field in Each graphic uses two lines of follow up numbers (correct English?) of fld in set the backgroundcolor of grc d1 to the text of line 1 of fld in set

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Bob Sneidar
repeat with i = 1 to 200 step 2 set the backgroundcolor of grc d1 to the text of line i of fld in set the foregroundcolor of grc d1 to the text of line i+1 of fld in end repeat Bob On May 8, 2012, at 11:21 AM, William de Smet wrote: Hi there, Can anyone help me shorten this script?

RE: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread John Dixon
that won't work... repeat with i = 1 to 200 step 2 set the backgroundcolor of grc d1 to the text of line i of fld in set the foregroundcolor of grc d1 to the text of line i+1 of fld in end repeat Bob On May 8, 2012, at 11:21 AM, William de Smet wrote: Hi there, Can

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Mark Schonewille
Hi William, This should work: repeat with x = 1 to 100 set the backgroundColor of grc (d x) to line 2*x-1 of fld in set the foregroundColor of grc (d x) to line 2*x of fld in end repeat -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage:

Re: [OT] Gatekeeper

2012-05-08 Thread Peter Haworth
While we're on the topic of signing, how do you do the equivalent for Windows apps to get rid of the Unknown Publisher message? Pete lcSQL Software http://www.lcsql.com On Tue, May 8, 2012 at 2:22 AM, Andrew Henshaw hens...@me.com wrote: As far as I was aware all you need to do is sign your

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Dar Scott
I'm not sure what you intended with the text of object expression, so I made an assumption. That can be modified to fit your real need. Perhaps something like this (untested): put field in into colorLines repeat with n = 1 to 100 get d n set the backgroundColor of graphic it

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Paul Dupuis
repeat with i = 1 to 200 step 2 put di into tObjectName set the backgroundcolor of grc tObjectName to the text of line i of fld in set the foregroundcolor of grc tObjectName to the text of line i+1 of fld in end repeat On 5/8/2012 2:32 PM, John Dixon wrote: repeat with i = 1 to 200 step

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Bob Sneidar
That won't work either. See my updated repeat loop using div Bob On May 8, 2012, at 11:38 AM, Paul Dupuis wrote: repeat with i = 1 to 200 step 2 put di into tObjectName set the backgroundcolor of grc tObjectName to the text of line i of fld in set the foregroundcolor of grc tObjectName

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Dar Scott
Yeah. The d subscript needs to be calculated based on i. (Or the loop changed so the line subscript is is based on the d subscript. (In my version, I cheated and just deleted lines as I used them.) Dar On May 8, 2012, at 12:32 PM, John Dixon wrote: that won't work... repeat with i =

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Bob Sneidar
Yeah just figured that out. I set the grc name to d i div 2 +1 in my new script. Bob On May 8, 2012, at 11:32 AM, John Dixon wrote: that won't work... repeat with i = 1 to 200 step 2 set the backgroundcolor of grc d1 to the text of line i of fld in set the foregroundcolor of grc

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Bob Sneidar
stupid Apple Mail changes sender on Send Again! Belay that just noticed multiple graphics. repeat with i = 1 to 200 step 2 put d i div 2 +1 into theGrcName set the backgroundcolor of grc theGrcName to the text of line i of fld in set the foregroundcolor of grc theGrcName to the text of line

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Bob Sneidar
This will only set every other odd numbered graphic. Bob On May 8, 2012, at 11:38 AM, Paul Dupuis wrote: repeat with i = 1 to 200 step 2 put di into tObjectName set the backgroundcolor of grc tObjectName to the text of line i of fld in set the foregroundcolor of grc tObjectName to the

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Dar Scott
Whoops. Still not right. The line number has to go up twice as fast as the object number. This can be done with a separate loop variable or doing some math on the repeat loop variable. It might be easiest to count graphic objects and then calculate the lines as (2*i-1) and (2*i) Dar On

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Dar Scott
This came in late into my mailbox. Of the index calculation methods, this one works. -- Dar On May 8, 2012, at 12:35 PM, Mark Schonewille wrote: Hi William, This should work: repeat with x = 1 to 100 set the backgroundColor of grc (d x) to line 2*x-1 of fld in set the

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread William de Smet
Thanks everyone for the contribution! I first tried Mark Schonewille's script and that one works immediately. My app is almost finished now. Now searching the forum for a way to use AirPrint (but that one seems sort of impossible at the moment). greetings, William 2012/5/8 Dar Scott

Re: ANN: Spreadlib - Excel Import Beta

2012-05-08 Thread Curry Kenworthy
Out of curiosity, does spreadLib create a datagrid, or does it use a table field? Bob Howdy, It returns the whole sheet as htmlText which is handy for a single field. It also stores all cells in an array which is handy for just about any setup! Closer to 1.0 I'll be evaluating other

[TO] HTML5

2012-05-08 Thread Richmond
Probably a goofy question, but then, again . . . My website is NOT written in HTML5. Does anybody know if the time to change to HTML5 is now, and whether older browsers will cope with it? By older browsers I mean things like TenFourFox: http://www.floodgap.com/software/tenfourfox/ Richmond.

Re: [TO] HTML5

2012-05-08 Thread William de Smet
Hi Richmond, Basic HTML5 is OK in most modern browsers (even Internet Explorer). If you want to use CSS3 'tricks' then IE still has lots of trouble with it. Latest versions of Safari and Firefox are the best. greetings, William 2012/5/8 Richmond richmondmathew...@gmail.com: Probably a goofy

Re: [TO] HTML5

2012-05-08 Thread Richmond
On 05/08/2012 10:12 PM, William de Smet wrote: Hi Richmond, Basic HTML5 is OK in most modern browsers (even Internet Explorer). If you want to use CSS3 'tricks' then IE still has lots of trouble with it. Latest versions of Safari and Firefox are the best. To be quite honest, I am perfectly

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Thomas McGrath III
To print using AirPrint you can use the rreHardCopy external from Livecode which is included with you external examples: Together with a script like this: on AirPrint if not rreHardcopyIsAvailable() then answer Printing is not available at this time. titled Printing Error

Re: [TO] HTML5

2012-05-08 Thread stephen barncard
Nah, standards-based HTML 4 will have to be recognized for some time to come. HTML5 is a lot more media friendly though, and I plan to make all my custom pages be able to be validated as such. It is the future. On Tue, May 8, 2012 at 12:17 PM, Richmond richmondmathew...@gmail.comwrote: On

Re: [TO] HTML5

2012-05-08 Thread Bob Sneidar
Off the top of my head, I would say that the time to retool is when all modern browsers support HTML5 (which is probably now) and there is a definite advantage to doing so (which only you can answer). If you never need to, and your web site functions fine in all the latest browsers, there is no

Counting days from a past date

2012-05-08 Thread dfepstein
I want to count the number of days between some past date and today. I tried this (using Rev 3.0):   on mouseUp   put March 12, 2012 into a   convert a to seconds -- LC should understand this as midnight   get the date   convert it to seconds -- should also be midnight   put (it

Re: Is there a way to shorten this script? (100 graphics and 200 lines of text)

2012-05-08 Thread Monte Goulding
Hi William You can use rreHardcopy or mergDoc for AirPrint. mergDoc allows printing via the document preview which will also allow your users to send to other apps etc. if you just want print then rreHardcopy is the way to go. Cheers -- Monte Goulding On 09/05/2012, at 4:57 AM, William de

Re: Umlaute get corrupted when transfering livecode from Win to Mac

2012-05-08 Thread Malte Brill
Hi Tiemo, Umlauts break as soon as custom properties are involved. Custom properties are stored as binary, thus the automatic translation to a different charset do not happen. This causes problems with Umlauts in the standalone settings, as liveCode uses cProps to store those. It could explain

Re: Counting days from a past date

2012-05-08 Thread Colin Holgate
That was the night the clocks changed: (58*24 + 1)/24 = 57958333 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Counting days from a past date

2012-05-08 Thread Bob Sneidar
Not only is it not an integer, even if you strip the modulus, 57 is the wrong answer for scenario 2. I suspect it will be wrong for every date prior to that. This is where the julian date comes in handy. We really need julian in the convert parameters. If you have access to a mySQL database,

Re: Counting days from a past date

2012-05-08 Thread Bob Sneidar
Sarah Reichelt has a DateTime stack which can convert to Julian at: http://www.troz.net/rev/index.irev?category=Library#stacks I haven't tried it but you might want to give that a shot too. Bob On May 8, 2012, at 1:32 PM, dfepst...@comcast.net wrote: I want to count the number of

Re: Counting days from a past date

2012-05-08 Thread Bob Sneidar
Also, it seems you can use the julianday function in sqLite, which is embedded in Livecode. select julianday('2012-05-08') - julianday('2012-03-12') as day I have not tested this though. Bob On May 8, 2012, at 2:18 PM, Bob Sneidar wrote: Not only is it not an integer, even if you strip

Breakpoints being ignored

2012-05-08 Thread Mark Powell
Breakpoints are not being recognized all of a sudden. Something do doubt is corrupted and I'd be interested in knowing if there is a clean fix. Test case: I create a brand new stack, with a button scripted on mouseup answer 1 breakpoint answer 2 end mouseup I get the two answer dialogs,

Re: Breakpoints being ignored

2012-05-08 Thread Colin Holgate
When you're next in the script editor, look at the bottom of the Debug menu. Is Script Debug Mode checked? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

Re: Breakpoints being ignored

2012-05-08 Thread Mark Powell
Yep, that be it. I guess I unchecked it somehow sometime. Thanks very much! On Tue, May 8, 2012 at 3:39 PM, Colin Holgate co...@verizon.net wrote: When you're next in the script editor, look at the bottom of the Debug menu. Is Script Debug Mode checked?

Re: [TO] HTML5

2012-05-08 Thread Kay C Lan
On Wed, May 9, 2012 at 3:17 AM, Richmond richmondmathew...@gmail.comwrote: My question might have been better phrased, something like this: * When will the fact that my website is NOT written in HTML5 will browsers be unable to cope with it? * And that is probably an unanswerable question.

Re: [OT] Gatekeeper

2012-05-08 Thread Bill Vlahos
Pete, Here are some links that were instrumental to me for code signing InfoWallet and one of them has a link to a $49 commercial application to help make is easier. I haven't looked at it (doing it the hard way myself) but if it is half as good as they describe it would be worth it. Code

Re: [TO] HTML5

2012-05-08 Thread Richmond
On 05/09/2012 05:23 AM, Kay C Lan wrote: On Wed, May 9, 2012 at 3:17 AM, Richmond richmondmathew...@gmail.comwrote: My question might have been better phrased, something like this: * When will the fact that my website is NOT written in HTML5 will browsers be unable to cope with it? * And